Page 1 of 2

simple timport and xml

Posted: Fri Dec 08, 2006 4:29 pm
by barry.marcus
I've got a real newbie question (just a few days of playing and fiddling with this under my belt) and I'm looking for some direction. As a very simple first pass I'm attempting to import data, using the timport command line, into a very simple existing table from an XML source file. Ultimately my tables and source files will be considerably more complex, but for now...

Here is the schema file (schema.scm):

xml
database /data1/texisdb/camp
table patn
field did varchar(8) patn/biblio/pub/docid/docnum NONE
field aid varchar(8) - NONE

Here is the XML file (datasmall.xml):

<?xml version="1.0" encoding="UTF-8"?>
<patn>
<biblio>
<pub>
<docid>
<docnum>D1</docnum>
</docid>
</pub>
<app apptype="design">
<docid>
<docnum>AD1</docnum>
</docid>
</app>
</biblio>
</patn>

Here is my command line:

timport -s schema.scm -v -t datasmall.xml

Here is the output I get:

200 Reading schema schema.scm
800 Inserting default "id" field into table
800 Statement: "insert into patn values(counter,?,?);"
200 Connecting to server
200 Opening database /data1/texisdb/camp
200 Verifying schema
200 Loading data
800 File: "datasmall.xml"
000 Texis daemon (1893) ABEND: signal 11
000 Texis daemon (1893) ABEND: signal 11

Nothing is written to the table. I have no idea what might be causing the ABEND. A kick in the right direction would be appreciated.

simple timport and xml

Posted: Fri Dec 08, 2006 4:52 pm
by jason112
What's the output of "texis -version"?

What happens if you try just writing the results to stdout by running:
timport -D -s schema.scm -v -t datasmall.xml

Does the database or table 'patn' already exist? What're
their schemas if so?

simple timport and xml

Posted: Sun Dec 10, 2006 3:03 pm
by barry.marcus
The output of texis -version is:
Texis Web Script (Vortex) Copyright (c) 1996-2004 Thunderstone - EPI, Inc.
Commercial Version 5.00.1090358162 20040720 (i686-unknown-linux2.4.2-64-32)

For this command:
timport -D -s schema.scm -v -t datasmall.xml

This is the output:
200 Reading schema schema.scm
800 Inserting default "id" field into table
800 Statement: "insert into patn values(counter,?,?);"
200 Loading data
800 File: "datasmall.xml"
Segmentation fault

Thanks for your help.

simple timport and xml

Posted: Mon Dec 11, 2006 10:06 am
by John
You would need to upgrade to a more current version of Texis that supports more types of XML.

simple timport and xml

Posted: Mon Dec 11, 2006 10:51 am
by barry.marcus
Questions: What is the latest version of Texis? What version of XML does my version of Texis support? Are there online documents detailing the compatibility of the various Texis versions and XML versions (e.g., release notes)?

Thanks.

simple timport and xml

Posted: Mon Dec 11, 2006 11:29 am
by mark
Your version would support a simple XML record structure as described at http://thunderstone.master.com/texis/ma ... =39f468b13

The online docs describe the latest version's XML support.
http://www.thunderstone.com/site/texisman/node368.html

simple timport and xml

Posted: Mon Dec 11, 2006 1:06 pm
by barry.marcus
So what *is* the latest version of Texis?

simple timport and xml

Posted: Mon Dec 11, 2006 2:15 pm
by John
The 20040720 in the version is the date. The current version would have a 200612xx date.

simple timport and xml

Posted: Mon Dec 11, 2006 3:30 pm
by barry.marcus
Thanks

simple timport and xml

Posted: Tue Dec 12, 2006 1:05 pm
by barry.marcus
What is the latest version I should upgrade to?