I have seen something similar and it was to do with the XML in the .EXT file being in upper case
e.g <U2xml_extraction xmlns:U2xml="http://www.ibm.com/U2-xml";> <U2xml:extraction should be <U2XML_extraction xmlns:U2xml="http://www.ibm.com/U2-xml";> <U2XML:extraction On 1/17/06, Burwell, Edward <[EMAIL PROTECTED]> wrote: > Still no worky. :-( > > -----Original Message----- > From: Ross Craig [mailto:[EMAIL PROTECTED] > Sent: Monday, January 16, 2006 7:21 PM > To: [email protected] > Subject: RE: [U2] XML Extraction > > > Try this instead: > > <U2XML-extraction xmlns:U2xml="http://www.informix.com/U2-xml";> > ... > </U2XML-extraction> > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward > Sent: Monday, January 16, 2006 2:29 PM > To: '[email protected]' > Subject: [U2] XML Extraction > > I am on UniData 6.1 (AIX) and I have an XML doc that I would like to > extract > data from and it looks like this: > > <?xml version="1.0"?> > <CasioESSXML> > <Transactions> > <Transaction ID="346CC6EDE91" type="REPAIR_REQ"> > <RepairRequestID>12345</RepairRequestID> > <ModelNumber>EX-50</ModelNumber> > <PurchaseDate>12/14/2004</PurchaseDate> > </Transaction> > <Transaction ID="60B8616476B" type="REPAIR_ESTIMATE_RESPONSE"> > <WorkOrderID>ESS123456</WorkOrderID> > <Response>Approved</Response> > </Transaction> > <Transaction ID="7E14A438157" type="PAYMENTRECEIVED"> > <WorkOrderID>ESS1234</WorkOrderID> > <PaymentAmount>90.50</PaymentAmount> > <PaymentMethod>Credit Card</PaymentMethod> > </Transaction> > <Transaction ID="2DC71B7D2B3" type="MESSAGESENT"> > <WorkOrderID>ESS1345</WorkOrderID> > <Code></Code> > </Transaction> > </Transactions> > </CasioESSXML> > > --------------------------------------------------------------- > > My .EXT file looks like this: (so far) > > <?xml version = "1.0"?> > <U2xml_extraction xmlns:U2xml="http://www.ibm.com/U2-xml";> > <U2xml:extraction > start="/CasioESSXML/Transactions/[EMAIL PROTECTED]'REPAIR_REQ']" > dictionary="ESS.REPAIR.REQ" > null="EMPTY" > /> > <U2xml:field_extraction field="@ID" path="RepairRequestID/text()" /> > <field_extraction > field="ESS.ID" > path="RepairRequestID/text()" > /> > <U2xml:field_extraction > field="MODEL" > path="ModelNumber/text()" > /> > </U2xml_extraction> > > ------------------------------------------------------------- > > I can run: > > PREPARE.XML "_XML_/FROM_ESS" junk_xml > > and it runs ok. I can also run: > > RELEASE.XML junk_xml > > and it runs ok. > > ------------------------------------------------------------- > > But when I run: > > list XMLDATA junk_xml "_XML_/TEST.EXT" ESS.ID > > I get: > > Open XML data file failed. > XMLParser error message: U2XMAP/U2XML_extraction: Illegal U2XMAP file, > missing t > he <U2XMAP>. > > Open file error. > > Any help would be GREATLY appreciated!!!! > > Thanks in advance > > Ed Burwell > 973-361-5400 ext. 1512 > [EMAIL PROTECTED] > > ______________________________________________________________________ > This e-mail has been scanned by MCI Managed Email Content Service, using > Skeptic(tm) technology powered by MessageLabs. For more information on > MCI's Managed Email Content Service, visit http://www.mci.com. > ______________________________________________________________________ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > > ______________________________________________________________________ > This e-mail has been scanned by MCI Managed Email Content Service, using > Skeptic(tm) technology powered by MessageLabs. For more information on MCI's > Managed Email Content Service, visit http://www.mci.com. > ______________________________________________________________________ > > ______________________________________________________________________ > This e-mail has been scanned by MCI Managed Email Content Service, using > Skeptic(tm) technology powered by MessageLabs. For more information on MCI's > Managed Email Content Service, visit http://www.mci.com. > ______________________________________________________________________ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
