Yes, there is. I created it with Excel, WP, or one of the tools - can't seem to recall, now, although I did it in the past 48 hours!
This system was written a number of years back and I don't think it was authored by a "righteous" I/T pro', but a researcher who was trying to help and apparently has (some) knowledge of XML. (I'd be the first to confess that my own knowledge thereof is still meager.) I seem to recall that whatever program I used to create the XSL asked for one, then, when not found, asked to create one from the XML file (data||structure?). Should I visually parse that for any reserved words, etc, as you indicate? Can RB utilize the XSL file, if one exists? Thanks, Steve From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Friday, May 01, 2009 11:23am 11:23 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Importing XML Data with Heterogeneous Nodes/Records ... 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
