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
