A few weeks ago, I spent quite a bit of time crafting the XML to load data into the databases. I have a tool that will do all of the heavy lifting. It is pretty self explanatory, you create a list of application types, instances where you associate it with the particular application type, create the IDXrefs and then create the elements. Here you choose the IDXref it’s associated Application Instance and the the CommonID and the AppID. Then to make sure you don’t over write another set of documents, you give it a base name, choose the folder, and the folder you want to save it in, and it will generate all of the files for you, including the setup.xml file. If there are duplicates on either the CommonID or AppID it will add a period to the end of the data.

Here are some screen shots of what it does:

Which results in the following in the xml files in the directory specified

C:\sample\example.listOfAppType.xml

C:\sample\example.listOfAppInstance.xml

C:\sample\example.listOfAppIDXRef.xml

C:\sample\example.listOfIDXRefData.xml

And the best part:

C:\sample\example.setup.xml

If you would like this application, click this:

  10 Responses to “XRef XML Creation Tool”

  1. This is NOT an EDI or HL7 tool, this is just an example that you can cross reference data and I used HL7 and HIPAA (EDI) data to show this, but it can be used for ANY cross referencing data (customer numbers, SKU, etc, that need to have a cross reference table to look up the corresponding information)

  2. Hi i am not an expert in biztalk and i have to use cross referencing in my project. would you be so kind to please send me this tool of cross referencing ?

  3. On it’s way…

  4. I’m pretty new to doing cross referencing and have gone through the recipes book on how to do it. I would love a copy of this tool.

  5. Hi Eric
    I noticed your tool is specific to the ID XRef functions, you wouldn’t happen to have a version for the Value XREf functions? Figured I would ask before building one.

  6. No I did not build one for that, as there is no API to programatically update the information. You can essentially get everything you want from this tool. Did not see a reason to build more functionality for something that has better accessibility elsewhere.

  7. Hi Eric,

    Could you please send me this tool. I would like to try

  8. uild more functionality for something that has better accessibility elsewhere.

    Read more: http://blog.biztalk-info.com/archive/2007/04/02/XRef_XML_Creation_Tool.aspx#ixzz1N8jdVXOY

  9. to build more functionality for something that has better accessibility elsewhere.

    Read more: http://blog.biztalk-info.com/archive/2007/02/12/XRef_XML_Creation_Tool.aspx#ixzz1NFVLo0iA

   
© 2014 BizTalk Blog Suffusion theme by Sayontan Sinha