Search the Community

Thanks for looking into this issue. I am not sure, whether this is the right forum to post this thread. If not, let me know the right forum to post this thread. I have wellformed XML message. I want to produce a list/report as 1) All Xpath of XML message 2) Xpath , data content for this XPATH Here is an example (Input XML Message) <?xml version="1.0"?><PARTS><TITLE>Computer Parts</TITLE><PART><ITEM>Motherboard</ITEM><MANUFACTURER>ASUS</MANUFACTURER><MODEL>P3B-F</MODEL><COST> 123.00</COST></PART><PART><ITEM>Video Card</ITEM><MANUFACTURER>ATI</MANUFACTURER><MODEL>All-in-Wonder Pro</MODEL><COST> 160.00</COST></PART><PART><ITEM>Sound Card</ITEM><MANUFACTURER>Creative Labs</MANUFACTURER><MODEL>Sound Blaster Live</MODEL><COST> 80.00</COST></PART><PART><ITEM>inch Monitor</ITEM><MANUFACTURER>LG Electronics</MANUFACTURER><MODEL> 995E</MODEL><COST> 290.00</COST></PART></PARTS> The desired output --> I created the following XML list manually /PARTS/TITLE Computer Parts/PARTS/PART[1]/ITEM Motherboard/PARTS/PART[1]/MANUFACTURER ASUS/PARTS/PART[1]/MODEL P3B-F/PARTS/PART[1]/COST 123.00/PARTS/PART[2]/ITEM Video Card/PARTS/PART[2]/MANUFACTURER ATI............................................................... I have XMLSPY, and I do not have additional tools kit associated with XMLSPY. I tried with xml_grep in linux. It need the XPATH as input to get me the data content. I am not able to use xml_grep to extract attributes of XML message. Are there any open source product to produce such report for XML Message? What are the ways to extract XPATHs/XPATH, data content? Thanks for helping.

I have a XSD that looks something like this: <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified" version="1.02"> <xs:include schemaLocation="Basic_Types.xsd"/> <xs:element name="MyElement"> <xs:complexType mixed="true"> <xs:sequence> <xs:element name="data"> <xs:complexType> <xs:sequence> <xs:element name="timeStamp" type="specialtime"/> <xs:element name="DeviceClass"> <xs:complexType> <xs:sequence> <xs:element name="MaxAmount" type="Amount"/> <xs:element name="MaxVolume" type="Volume"/> </xs:sequence> <xs:attribute name="Type" type="Type" use="required" fixed="FP"/> <xs:attribute name="DeviceID" type="DeviceID" use="required"/> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> <xs:attribute name="ApplicationSender" type="ApplicationSender" use="required"/> <xs:attribute name="WorkstationID" type="WorkstationID" use="required"/> </xs:complexType> </xs:element> </xs:schema> I want to change it to look something like this: <?xml version="1.0" encoding="utf-8"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified" version="1.02"> <xs:include schemaLocation="Basic_Types.xsd"/> <xs:complexType name="DeviceClass"> <xs:sequence> <xs:element name="MaxAmount" type="Amount"/> <xs:element name="MaxVolume" type="Volume"/> </xs:sequence> <xs:attribute name="Type" type="Type" use="required" fixed="FP"/> <xs:attribute name="DeviceID" type="DeviceID" use="required"/> </xs:complexType> <xs:complexType name="data"> <xs:sequence> <xs:element name="timeStamp" type="specialtime"/> <xs:element name="DeviceClass" type ="DeviceClass"/> </xs:sequence> </xs:complexType> <xs:complexType mixed ="true" name ="MyElement"> <xs:sequence> <xs:element name="data" type ="data"> </xs:element> </xs:sequence> <xs:attribute name="ApplicationSender" type="ApplicationSender" use="required"/> <xs:attribute name="WorkstationID" type="WorkstationID