[U2] [UD] XML levels question
I have a Purchase Order XML file that I need to load into UniData, the problem is that it has 4 levels to it. I can read it to the SVM level (3) with the extraction file, but what do I do about level 4? I tried using two extraction files, one for the 'Header' information. And one for the 'Detail' (line item) information, this way it only goes to 3 levels. But, it won't create a separate record ID for each (multiple) Line Number in the UniData file. Is this possible? If not I'm still stuck back at 4 levels. Here's my system info/versions: Hardware : IBM Operating system : AIX O.S. version : 4.3.3 UniData version : 6.0.8 Thanks, in advance. -Arthur Arthur E. Metherall Sr. Programmer Analyst Courier Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] XML levels question
Doesn't U2 XML support SAX or DOM access to the document? I'm sure I remember reading something of that nature. IMHO, any direct XML parser that limits itself to 3 levels of nodes is not worth the memory and disk it takes to store it. :P Most of the live data formats I've worked with require atleast 4 levels, with some going beyond 10. --- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] --- www.allspec.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Metherall, Arthur Sent: Wednesday, June 28, 2006 9:12 AM To: u2-users@listserver.u2ug.org Cc: Metherall, Arthur Subject: [U2] [UD] XML levels question I have a Purchase Order XML file that I need to load into UniData, the problem is that it has 4 levels to it. I can read it to the SVM level (3) with the extraction file, but what do I do about level 4? I tried using two extraction files, one for the 'Header' information. And one for the 'Detail' (line item) information, this way it only goes to 3 levels. But, it won't create a separate record ID for each (multiple) Line Number in the UniData file. Is this possible? If not I'm still stuck back at 4 levels. Here's my system info/versions: Hardware : IBM Operating system : AIX O.S. version : 4.3.3 UniData version : 6.0.8 Thanks, in advance. -Arthur Arthur E. Metherall Sr. Programmer Analyst Courier Corporation --- 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/
Re: [U2] [UD] XML levels question
The xml parser handles any number of levels - it is when you want to map that data back into a record, we are limited to attributes, values and subvalues. I have used the approach you mention of having two EXT files to solve this and have had it working fine. If you are not getting seperate records for your detail items maybe the starting node for your detail xml needs to be one level lower ? Alternately there is the XDOM api, which is a bit more effort, but allows you to navigate through any number of levels to extract the data you need. rgds Symeon. On 28/06/06, Glen Batchelor [EMAIL PROTECTED] wrote: Doesn't U2 XML support SAX or DOM access to the document? I'm sure I remember reading something of that nature. IMHO, any direct XML parser that limits itself to 3 levels of nodes is not worth the memory and disk it takes to store it. :P Most of the live data formats I've worked with require atleast 4 levels, with some going beyond 10. --- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] --- www.allspec.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Metherall, Arthur Sent: Wednesday, June 28, 2006 9:12 AM To: u2-users@listserver.u2ug.org Cc: Metherall, Arthur Subject: [U2] [UD] XML levels question I have a Purchase Order XML file that I need to load into UniData, the problem is that it has 4 levels to it. I can read it to the SVM level (3) with the extraction file, but what do I do about level 4? I tried using two extraction files, one for the 'Header' information. And one for the 'Detail' (line item) information, this way it only goes to 3 levels. But, it won't create a separate record ID for each (multiple) Line Number in the UniData file. Is this possible? If not I'm still stuck back at 4 levels. Here's my system info/versions: Hardware : IBM Operating system : AIX O.S. version : 4.3.3 UniData version : 6.0.8 Thanks, in advance. -Arthur Arthur E. Metherall Sr. Programmer Analyst Courier Corporation --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] XML levels question
Arthur, I have a Purchase Order XML file that I need to load into UniData, the problem is that it has 4 levels to it. I can read it to the SVM level (3) with the extraction file, but what do I do about level 4? I tried using two extraction files, one for the 'Header' information. And one for the 'Detail' (line item) information, this way it only goes to 3 levels. But, it won't create a separate record ID for each (multiple) Line Number in the UniData file. Is this possible? If not I'm still stuck back at 4 levels. Have you looked at writing an XSL transformation that turns the XML into something which the UV utilities can access more easily. regards, Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/