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="A22C6C5A-A2C3-0FB4-6E68F346CC6EDE91"
type="REPAIR_REQ">
<RepairRequestID>12345</RepairRequestID>
<ModelNumber>EX-50</ModelNumber>
<PurchaseDate>12/14/2004</PurchaseDate>
</Transaction>
<Transaction ID="A22C6C66-F4E4-E317-06F1360B8616476B"
type="REPAIR_ESTIMATE_RESPONSE">
<WorkOrderID>ESS123456</WorkOrderID>
<Response>Approved</Response>
</Transaction>
<Transaction ID="A22C6C7A-B94B-13DF-68DEA7E14A438157"
type="PAYMENTRECEIVED">
<WorkOrderID>ESS1234</WorkOrderID>
<PaymentAmount>90.50</PaymentAmount>
<PaymentMethod>Credit Card</PaymentMethod>
</Transaction>
<Transaction ID="A22C6C8E-F3A2-A33D-632DB2DC71B7D2B3"
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/
