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 > > >
