XRef XML Creation Tool

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:

posted @ Monday, February 12, 2007 12:00 PM

Print

Comments on this entry:

 re: XRef XML Creation Tool

Left by Eric Stott at 5/31/2007 10:33 PM
Gravatar

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)

 re: XRef XML Creation Tool

Left by dEVEN bHATT at 1/6/2008 11:58 PM
Gravatar

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 ?

# re: XRef XML Creation Tool

Left by Eric at 1/14/2008 9:59 AM
Gravatar

On it's way...

 re: XRef XML Creation Tool

Left by Chris R at 2/7/2008 12:13 PM
Gravatar

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.

 re: XRef XML Creation Tool

Left by David R at 3/2/2009 12:06 PM
Gravatar

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.

# re: XRef XML Creation Tool

Left by Eric at 3/23/2009 11:39 AM
Gravatar

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.

Your comment:



 (will not be displayed)


 
 
 
Please add 2 and 2 and type the answer here:
 

Live Comment Preview:

 
«March»
SunMonTueWedThuFriSat
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910