simple timport and xml

barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

simple timport and xml

Post 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.
User avatar
jason112
Site Admin
Posts: 347
Joined: Tue Oct 26, 2004 5:35 pm

simple timport and xml

Post 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?
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

simple timport and xml

Post 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.
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

simple timport and xml

Post by John »

You would need to upgrade to a more current version of Texis that supports more types of XML.
John Turnbull
Thunderstone Software
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

simple timport and xml

Post 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.
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

simple timport and xml

Post by mark »

barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

simple timport and xml

Post by barry.marcus »

So what *is* the latest version of Texis?
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

simple timport and xml

Post by John »

The 20040720 in the version is the date. The current version would have a 200612xx date.
John Turnbull
Thunderstone Software
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

simple timport and xml

Post by barry.marcus »

Thanks
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

simple timport and xml

Post by barry.marcus »

What is the latest version I should upgrade to?
Post Reply