XML to XML Mapping Tool

• 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.

Sample Files

<?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>

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

How to Use

1. Open the source XML file.
2. Open the target XML file.
3. Drag the source tree node and drop on the target tree node.
4. Continue step 3 to map the source XML nodes.
5. Click on the XSL tab to view the generated XSL.
6. Click on the Output tab to view the transformed XML.
7. Save the mappings if you want to update in future.
8. To remove mapping from a single node, right click on the target tree node and click on the "Remove Mapping" context menu.
9. 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.

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