XML made simple   
Home   Support   Contact  

   xml to edi 850
Step 1
Step 2
Step 3
Step 4
   xml schema editor
   xml editor

Step 4: Putting it all together

Running all these transformations at design time is nice, but involves a lot of clicking and manual interventions. In a conversion scenario (usually called B2B) such as this, the real goal is to automate all of this so nothing manual is needed. Using VBScript and the Windows Scheduler, that is exactly what we will do.


VBScript that ties everything together

VBScript tying everything together (as seen in UltraEdit)

The VBScript we will be using performs the following steps:
  • Load the PO.xml into a MSXML DOM object
  • Set the DOM's tranformation to the POto850.xsl
  • Execute the transformation
  • With the result in memory, load the LTM COM Object (LTE) and pass it the new XML message
  • Save the LTE translation
  • Display a confirmation OK dialog indicating all was done. Note that this is a temporary dialog, so you can see the progress if executing manually. You should remove the OK dialog from the script once you're ready to put it on the Windows Scheduler (see below).

We have written the script for you. You can download it here:

POto850.vbs note, you may need to right-click|download

Windows Scheduler

Now that we have a script that pieces everything together, you put this on a schedule to run the translation say once a day, or whenever your schedule is needed.

Windows Scheduler
Use the Windows Scheduler to automate this process

We will not be going into the details of the Windows Scheduler here, since we do not know the schedule you want or need, as well as it is not the goal of this tutorial to detail how the Windows Scheduler works.

And we're done?

For the most part. Continue on to the Conclusion for some final thoughts and where to go from here.