simple timport and xml

barry.marcus · Post by **barry.marcus** » Fri Dec 08, 2006 4:29 pm

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.

Post by **jason112** » Fri Dec 08, 2006 4:52 pm

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?

barry.marcus · Post by **barry.marcus** » Sun Dec 10, 2006 3:03 pm

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.

Post by **John** » Mon Dec 11, 2006 10:06 am

You would need to upgrade to a more current version of Texis that supports more types of XML.

barry.marcus · Post by **barry.marcus** » Mon Dec 11, 2006 10:51 am

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.

Post by **mark** » Mon Dec 11, 2006 11:29 am

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

barry.marcus · Post by **barry.marcus** » Mon Dec 11, 2006 1:06 pm

So what *is* the latest version of Texis?

Post by **John** » Mon Dec 11, 2006 2:15 pm

The 20040720 in the version is the date. The current version would have a 200612xx date.

barry.marcus · Post by **barry.marcus** » Mon Dec 11, 2006 3:30 pm

Thanks

barry.marcus · Post by **barry.marcus** » Tue Dec 12, 2006 1:05 pm

What is the latest version I should upgrade to?