XML to XML Mapping Tool

Srinivas-Miriyala

Rate me:

3.26/5 (7 votes)

9 May 2007CPOL2 min read

107.3K

5.6K

XML2XML is a mapping tool to transform XML data from one XML format to any another XML format.

Download source code - 366 KB

Introduction

XML2XML is a mapping tool to transform XML data from one XML format to any another XML format. This tool is simple to use, just drag and drop the source XML node on the target XML node and see the generated XSL and output XML. That's easy!

Make sure your source XML does not have repeating XML elements. The source XML structure should look like the XML schema to get better results. The generated XSLT can be used to generate XML data from your source XML. This tool doesn't give a visual representation of the mapping nodes but at least show you which source and target XML nodes are mapped. If the node icon is violet, that means the node has mapped to something. Okay, looks good. How do we know which target node was mapped to which source node? Wait, here it is, simply click on the target tree node. If it is mapped to a node in the source XML, then a node on the source tree should be highlighted (grayed node). Well, mappings are done and if you save the mappings for future use, we can save the current mappings using the File menu. When you open the mapping file again, make sure the XML files are on the same location when you saved the mapping.

That is it, your mapping file (XSLT) is ready to use.

Screenshot - xml2xml.jpg

Sample Files

Source XML:

XML

<?xml version='1.0'?>
<bookstore>
  <book>
    <title>The Autobiography of Benjamin Franklin</title>
    <author>
      <first-name>Benjamin</first-name>
      <last-name>Franklin</last-name>
    </author>
    <price>8.99</price>
  </book>
</bookstore>

Target XML:

XML

<?xml version='1.0'?>
<myLibrary>
  <book>
    <title></title>
    <authorFirstName></authorFirstName>
    <authorLastName></authorLastName>
    <value></value>
  </book>
</myLibrary>

How to Use

Open the source XML file.
Open the target XML file.
Drag the source tree node and drop on the target tree node.
Continue step 3 to map the source XML nodes.
Click on the XSL tab to view the generated XSL.
Click on the Output tab to view the transformed XML.
Save the mappings if you want to update in future.
To remove mapping from a single node, right click on the target tree node and click on the "Remove Mapping" context menu.
To remove all the mappings, right click on the target tree node and click on the "Remove All Mappings" context menu.

History

5/2/2007: Created.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Srinivas-Miriyala

Software Developer (Senior)

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

<?xml version="1.0" encoding="UTF-8"?> <Export BatchNo="18288"> <Invoices> <Invoice> <AgencyName>DPTI</AgencyName> <TransDescription>Campaign Items for North-South Corridor Briefing [4393442]</TransDescription> <CampaignName>North-South Corridor Briefing [4393442]</CampaignName> <AgencyNo>22903</AgencyNo> <TransactionNo>3048263</TransactionNo> <CampaignNo>4393442</CampaignNo> <PurchaseOrderNo>Sandy Edson</PurchaseOrderNo> <CampaignAccountCode></CampaignAccountCode> <CampaignType>Public Notice</CampaignType> <InvoiceDate>2014-06-24</InvoiceDate> <ExTaxTotal>4582.38</ExTaxTotal> <IncTaxTotal>5040.61</IncTaxTotal> <Agent>Kathleen Baird</Agent> <AgentAccCode>TRANDT,5KATBA</AgentAccCode> <CoAgent></CoAgent> <CoAgentAccCode></CoAgentAccCode> <Items> <Item> <OrderItemNo>11088850-2</OrderItemNo> <Description>Despatch: 14/06/2014 Electronic Despatch Qty: 2 - Previous Invoice(s): $0.00 (11088850-2)</Description> <SaleCode>Despatch</SaleCode> <SupplierNo>104274</SupplierNo> <SupplierName>Starcom SA</SupplierName> <PublicationName></PublicationName> <PublicationAdSizeDescription>Electronic Despatch</PublicationAdSizeDescription> <PublicationAdSizeFixedX>0.00</PublicationAdSizeFixedX> <PublicationAdSizeFixedY>0.00</PublicationAdSizeFixedY> <ArtworkType/><Date>2014-06-14</Date> <Qty>1</Qty> <PriceExcGST>80.00</PriceExcGST> <PriceIncGST>88.00</PriceIncGST> <MediaRebateExcGST>0.00</MediaRebateExcGST> <MediaRebateIncGST>0.00</MediaRebateIncGST> </Item> </Items> </Invoice> </Invoices> </Export>

<?xml version="1.0" encoding="UTF-8"?> <Export BatchNo="18288"> <Invoices> <Invoice> <AgencyName></AgencyName> <TransDescription></TransDescription> <CampaignName></CampaignName> <AgencyNo></AgencyNo> <TransactionNo></TransactionNo> <CampaignNo></CampaignNo> <PurchaseOrderNo></PurchaseOrderNo> <CampaignAccountCode></CampaignAccountCode> <CampaignType></CampaignType> <InvoiceDate></InvoiceDate> <ExTaxTotal></ExTaxTotal> <IncTaxTotal></IncTaxTotal> <Agent></Agent> <AgentAccCode></AgentAccCode> <CoAgent></CoAgent> <CoAgentAccCode></CoAgentAccCode> <Items> <Item> <OrderItemNo></OrderItemNo> <Description></Description> <SaleCode></SaleCode> <SupplierNo></SupplierNo> <SupplierName></SupplierName> <PublicationName></PublicationName> <PublicationAdSizeDescription></PublicationAdSizeDescription> <PublicationAdSizeFixedX></PublicationAdSizeFixedX> <PublicationAdSizeFixedY></PublicationAdSizeFixedY> <ArtworkType></ArtworkType> <Date></Date> <Qty></Qty> <PriceExcGST></PriceExcGST> <PriceIncGST></PriceIncGST> <MediaRebateExcGST></MediaRebateExcGST> <MediaRebateIncGST></MediaRebateIncGST> </Item> </Items> </Invoice> </Invoices> </Export>

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.