I'm trying to work out if I can perform an XSL transformation on an XML file from Dexterity.
A sister company uses a different language and they can call msxsl.exe directly, does anyone know if I can do this via Dex or whether there is an alternative in the MSXML2 COM library?
You can add MSXML2 COM library in your dex code and use it's objects.
Ever used any library in dex before?
Instead of directly using COM library in dex, I would suggest to to create separate small application in VB6 or .NET and call it's exe in dexterity. It will save your time.
Thanks for the replies almas. I've used an Excel library once but that is it. Is there any good documentation on the MSXML2 COM library, the manual in Dex seems a little light on information.
Regarding the alternative, my background is as a Cobol developer so I've not touched on anything modern or fancy like .NET or VB. Out of curiosity, how do you call an exe from Dex?
that's easy..by using run application function.
You are welcome :)
btw for what you use excel?
We have an XML import routine which allows data from one GP company to be imported into another. This is being extended to import data from another appliation. The XML file currently consistsof table nams and columns and uses a SQL stored procedure to import the data into a tale before the Dexterity code then processes it. The data I am getting from this other application needs converted into the format that the existing import will accept which is why I need to do this XSL transformation.
XML import routine to import data from external application sounds fine but why you bother to use XML routine to import data from one GP company to another GP company. you can simply do it by calling your stored procedures in dexterity.
The XML Import functionality was all written before my arrival with the company but it needs Dexterity code as there is a lot of logic that goes long with it, it is not quite a direct copy of the data. It is data related to our 3rd party application and for example, a buy contract in one company can be created in the new company with a different contract number or even converted to a sales contract.