Comvita (NZ Medical Honey company) use a third party fulfillment system in Hong Kong to fill orders and required an automated way to get the data from their QAD picking/invoicing systems to the third party.  After discussion with TCG we designed a form to pass the data to the third party computer fulfillment system using Separated Files produced from FormTrap. 

You can output a CSV file using the Associated File command, like this:



Here we construct Associated File lines with all of the fields required, starting with the ; (semi-colon) separator (so this is strictly a semi-colon separated file).  The same is done for the initial "Header" portion and for each of the Detail and Comment lines as well.  The Red items are missing the initial #, hence print and are used for checking the output during testing.  These are taken out for production (subsequent provision in FTDesign to look at the Associated File now makes the red lines redundant).

This is the output.

Spaces etc, can be removed if required by masking and there is no “maximum length” on the output.

Please note these two items:

1. Headings are best done on the Trailer label (i.e. you get one record per input document).  Details will be produced as they occur so are in sequence.  This document has no "trailer" so the Associated File records for Header and Trailer are duplicated further down.
2. The first character in the “detail” section must be the separator.