Hello Jeff Don't know if this will help or not. But you mentioned "The only wrinkle in this is that the XML field names will not match the DICT field names" I've been doing some work with UniData's XML via UniObjects. I've found you can override the names assigned in the XML result by using the COL.HDG modifier. So something like
LIST FILENAME FIELDNAME COL.HDG "MY FIELD NAME" TOXML ELEMENTS ... Will give you control over the names in the resulting XML. Victor St. Clair Jenkon Vancouver, WA 360.256.4400 [EMAIL PROTECTED] www.jenkon.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, February 02, 2006 8:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata/XML Newbie I have a need to export a Unidata (6.1.4) file as XML and later populate data in the file from an XML document. For the sake of simplicity, let's assume that every field is single valued at the moment so the XML document is quite simple - no nested fields, etc. The only wrinkle in this is that the XML field names will not match the DICT field names, so something like LIST FILENAME TOXML ELEMENTS ... won't cut it for the export portion. From the discussion here and my reading, it appears that I can go the route of PrepareXML, OpenXMLData, ReadXMLData, CloseXMLData, ReleaseXML. But then I stumbled upon DBOTXML, XMLTODB which seem simpler (at least conceptually). I'm not sure if I'm missing something obvious, and I know at some point I have to create an XML mapping, just not sure which route is the one I should try - so I'm asking those of you actively working with with XML. If anyone can advice on which avenue I should follow (even if it's something I haven't listed above) I'd be grateful. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "Hindsight alone is not wisdom." George W. Bush ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
