XML Timport issue

d.chandek.stark · Post by **d.chandek.stark** » Mon May 12, 2003 3:10 pm

I am having trouble importing an XML file using timport. The XML file is structured as follows: <dataroot> is the root element; each database record is contained in an <oaaa> element. Texis reads the schema file OK, but does not import the data (no error). I'm wondering whether it's because not every element in the schema is present in every record.

Here's the schema file:

xml
field oaaa_id int dataroot/oaaa/id ''
field coll_name varchar dataroot/oaaa/coll_name ''
field db_number varchar dataroot/oaaa/db_number ''
field oaaa_cat varchar dataroot/oaaa/oaaa_cat ''
field comp_name varchar dataroot/oaaa/comp_name ''
field prod_brand varchar dataroot/oaaa/prod_brand ''
field ad_date varchar dataroot/oaaa/ad_date ''
field headline varchar dataroot/oaaa/headline ''
field img_type varchar dataroot/oaaa/img_type ''
field post_comp varchar dataroot/oaaa/post_comp ''
field ad_type varchar dataroot/oaaa/ad_type ''
field img_color varchar dataroot/oaaa/img_color ''
field rural_city varchar dataroot/oaaa/rural_city ''
field women varchar dataroot/oaaa/women ''
field children varchar dataroot/oaaa/children ''
field ethnic varchar dataroot/oaaa/ethnic ''
field famous varchar dataroot/oaaa/famous ''
field city varchar dataroot/oaaa/city ''
field state varchar dataroot/oaaa/state ''
field awd_winner varchar dataroot/oaaa/awd_winner ''
field non_ad_img varchar dataroot/oaaa/non_ad_img ''
field notes varchar dataroot/oaaa/notes ''

Here's a typical record:

<dataroot>
...
<oaaa>
<id>3</id>
<coll_name>R. C. Maxwell Co.</coll_name>
<db_number>XXX0435a</db_number>
<oaaa_cat>Consumer Goods & Services (see list in handout)</oaaa_cat>
<comp_name>Columbia</comp_name>
<prod_brand>Columbia Baths</prod_brand>
<date>1920 May 02</date>
<headline>Columbia Baths Bathing Suits to Hire</headline>
<img_type>Photograph</img_type>
<ad_type>Billboard</ad_type>
<img_color>Black & White</img_color>
<rural_city>City Scene</rural_city>
<city>Atlantic City</city>
<state>NJ</state>
<notes>located on boardwalk | [1053B]</notes>
</oaaa>
...
</dataroot>

Commercial Version 4.00.1020139637 of Apr 30, 2002 (sparc-sun-solaris2.5.1-32)

Post by **mark** » Mon May 12, 2003 5:12 pm

2 problems. Your data has "&" which is not valid xml. It should be "&" and you have "''" as a default value for an "int" field which is not a valid number. You probably want "0" instead.

d.chandek.stark · Post by **d.chandek.stark** » Fri May 16, 2003 1:48 pm

That did it. Thanks.

bart · Post by **bart** » Mon Sep 26, 2005 7:37 am

I am aware that timport can do XML, but can find no docs for it.

Searched Thunderstone for "xml timport" and "xml schema".

Where are the docs?

Post by **mark** » Mon Sep 26, 2005 10:49 am

See http://thunderstone.master.com/texis/ma ... =39f468b13