CFXML Parse
$30-100 USD
Paid on delivery
I need? a XML structure parsed in coldfusion and the variables inserted into a SQL database.? Below is the DTD. The XML is passed to my page so I need to parse to find the fields on the bottom.
<!DOCTYPE ownershipEvent [
<!ELEMENT ownershipEvent ( #PCDATA | ownerIdentifier |? purchaseDate |? productIdentifier |? instanceIdentifier |? purchaseActivityIdentifier |? minIdentifier |? sequenceNumber |? reasonCode |? reasonMessage |? vendorPurchaseIdentifier )* >
<!ATTLIST ownershipEvent effective CDATA #IMPLIED
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? timestamp CDATA #REQUIRED
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? type CDATA #REQUIRED
>?
<!ELEMENT instanceIdentifier ( #PCDATA ) >
<!ELEMENT minIdentifier ( #PCDATA ) >
<!ELEMENT ownerIdentifier ( #PCDATA ) >
<!ELEMENT productIdentifier ( #PCDATA ) >
<!ELEMENT purchaseActivityIdentifier ( #PCDATA ) >
<!ELEMENT purchaseDate ( #PCDATA ) >
<!ELEMENT sequenceNumber ( #PCDATA ) >
<!ELEMENT reasonCode ( #PCDATA ) >
<!ELEMENT reasonMessage ( #PCDATA ) >
<!ELEMENT vendorPurchaseIdentifier ( #PCDATA ) >
]>
?
ownerIdentifier? = SUBID
minIdentified = Mobile number (MIN)
productIdentifier = The product type, which is an amalgamation of 4 fields, product type, product category, product rate and one other that slips my mind.
instanceIdentifier = The Instance ID that was purchased.
Project ID: #3516115