The ADODB COM Object allowed for BOTH the reading and writing to an XML file in the same fashion as we do with DBF. The difference was that with the reading of a single record into a Variant (datatype that can hold ANY datatype) is that the record is received in a fashion that mandated unwinding the record on the client side, by either naming conventions of the columns or by index#.
Likely NOT that useful in the R:Base paradigm and I only did it back then as an exercise anyway cause I had never used it. As I mentioned before I just used in in place of an INI file, which has it's own API available that can likely be manipulated from R:Base using DLCall. On Thursday, February 25, 2021 at 4:21:57 PM UTC-5 A. Razzak Memon wrote: > Mike, > > Here's how ... > > The XML file may be imported into R:BASE using the GATEWAY command or > File Gateway utility. > > Specific to XML (and JSON) import formats is the NODE_PATH option > parameter to specify the full path of the target node (e.g. Books\Fantasy). > > GATEWAY IMPORT XML D:\DataStore\Contacts.XML + > CREATE ContactsImport + > OPTION NODE_PATH Level\Contact > > The NODE_PATH value is case sensitive. > > If an unexpected format is detected, an "XML To Data Packet" utility > will be displayed. The valid node must be selected which contains the > collection of rows. > > See attached image for details. > > Have fun! > > Very Best R:egards, > > Razzak > > > At 10:12 AM 2/24/2021, [email protected] wrote: > > >Greetings: > > > >I am tasked with importing a large amount of data in the XML format > >into R:BASE. > > > >I haven't worked with the XML format much yet. > > > >I would appreciate any suggestions on good learning resources that > >anyone in R:BASE World has used to enhance their XML skills. > > > >Thank you in advance. > > > >Have a safe and healthy day! > > > >Mike Ramsour > >AK Steel Coshocton Works > >Quality Department > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0dfa9b3f-40ed-4475-800a-b1a0bfabd891n%40googlegroups.com.
