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