Steve, Maybe it's trying to create a column name from a reserved word, or it's trying to create a column with a column name already in your database, but with a different data definition. Is there an XSL file available, to define the data you are importing from?
Bill Can you open the XML without error MS Internet Explorer? If so, then look at the xml schema for reserved word problems. If you can't open it in IE, then there's something not conforming to XML standards in the file. On Fri, May 1, 2009 at 12:17 PM, Wills, Steve <[email protected]> wrote: > Bill, thanks for the suggestion. However, something isn’t working. I > suspect it has something to do with the XML statements(?). > > > > Here is what I get: > > > > R>GATEWAY IMPORT XML > C:\tERA\ACIM_RAMS_Stuff\NHCOMP_Data\protocols\MandrellT_tmandrel.xml CREATE > XMLimportTable > > -ERROR- Table constraints must follow column constraints (2777) > > -ERROR- XMLimportTable is an undefined table. (2038) > > -ERROR- XMLimportTable is an undefined table. (2038) > > > > > > > > Steve > > > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Bill > Downall > *Sent:* Friday, May 01, 2009 9:38am 09:38 > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Re: Importing XML Data with Heterogeneous > Nodes/Records ... > > > > Steve, > > > > It also doesn't have to be a separate non-R:BASE program which you write to > parse and convert. You can import your XML like this: > > > > GATEWAY IMPORT XML xmlfolder\xmlfile.xml CREATE XMLimportTable > > > > and then add an autonumber column or other primary key, and start with all > your PROJECTS or INSERTS with GROUP BYS or CURSORS or whatever to > re-normalize the mess. > > > > Bill > > On Fri, May 1, 2009 at 10:27 AM, Wills, Steve <[email protected]> wrote: > > Larry, thanks. > > > > On both points, agreed, and, alas, agreed. > > > > Steve > > > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Lawrence > Lustig > *Sent:* Friday, May 01, 2009 9:24am 09:24 > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Re: Importing XML Data with Heterogeneous > Nodes/Records ... > > > > << > > Does anyone have any experience, tips, etc., about importing XML files > containing data from different but related record structures? > > >> > > > > Unfortunately, there's a substantial logic gap between relational databases > and XML files (at least, when the XML file wasn't simply created from > relational data). > > > > If the data is hierarchal but otherwise very regular you might (might) be > able to find a tool that will split it and allow you to load it as CSV > files. Otherwise, you'll have to write a separate (non-RBase) application > to parse and convert the data. > > -- > > Larry > > > > >
