Alternate Output XML Format Files
FormTrap Solutions offers a number of different solution to the issue of producing a different format of XML file to third parties where the reasons for doing might include:
entry to a customer or supplier accounting system for reconciliation of payments
entry to fulfilment systems
entry to freight systems
Three different solutions are available:
Associated File to XML which converts Associated File entries to XML (written for FTDesign forms, works for FTForm Plus forms)
XML Style Sheet transformation from Associated File to XML (written for FTForm Plus forms, works for FTDesign forms)
XML Style Sheet transformation from FormTrap XML (converts from FormTrap XML to standard XML).
Note: Software is supplied with three months warranty and with no ongoing support or charges. There is no Linux version. Software is restricted to running with FormTrap Enterprise Server or FormTrap Small Business Edition, for the one company or organization. ALL advise and assistance with implementation is charged at our current consulting rates.
Associated File to XML (function af2xml.exe)
FormTrap Server generates Associated Files from (V8) Delivery tags and (V7) Associated File objects on the form. The standards for XML files required by transport companies decree these restrictions on field content:
For Version 8 (FTForm Plus) form designs, Delivery tags must have no embedded spaces or special characters.
For Version 7 (FTDesign) forms, Associated File entries must have no internal spaces or special characters.
Command line may be used Windows CMD for preliminary testing.
af2xml.exe
affilename xmlfilename
Copy af2xml.exe to the %fthome% folder, under sub-folder \programs (highlighted in the screen shot). For optional programs, it is simpler to keep away from the Windows program folders. Also copy the batch (.bat) file, content as below:
af2xml.exe %~dpn1.af %2.xml
Set up the .bat file under Setup, Applications sample shown below:
Run as an Application (via a batch file) :
Invoke via Queues, Applications
tab to process. This is the .bat file which converts in the
incoming file name to the .af file, and executes the function:
Microsoft function msxsl.exe (no charge)
This is a no charge utility from Microsoft where FormTrap has
designed two style sheets (which we do charge for).
- transform-delivery.xslt transforms from the Associated File format to XML in much the same way as af2xml.exe.
- transform-master.xslt transforms from FormTrap's standard XML format to XML, allowing all of the FormTrap fields to be accessed.
Standard instructions are provided with the program and style sheets.