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/
