Exporter - CSV
The screen shown in Fig 1 is where you define the options for exporting data to XML file(s).
Select or type a directory path where you want the file(s) saved.
Open document after export
If selected the file(s) will be opened after they are created, the application used to open the file(s) is dependant on which application is associated with *.csv files on your computer.
Select or type the character you want to use as the delimiter for the CSV, you can select the options:
Semi Colon (;)
or you can type any other character you like into the field.
Specify the character to use as the text qualifier, any field value that contains the delimiter character is enclosed in text qualifier characters to avoid that field value being confused as multiple field values.
If selected all field values will be enclosed in the text qualifier characters.
When a field value contains an instance of the text qualifier character it is necessary to escape that text qualifier instance so that any application that uses the CSV data knows its not the end of the field value and that that text qualifier instance is actually part of the field value.
There a two common methods of escaping characters in CSV data and the option you choose will be dependant on the application used to access the data later.
1.Doubled, this mode will escape the text qualifier instance with another text qualifier character, for example when using " as the text qualifier the field value 3.5" Floppy Disk would be changed to 3.5"" Floppy Disk
2.Backslash, this mode will escape the text qualifier instance with a backslash character, for example when using " as the text qualifier the field value 3.5" Floppy Disk would be changed to 3.5\" Floppy Disk
Hierarchal File Format
This can be used to output the CSV in a hierarchal structure for exports containing multiple tables and relations, for example you can export invoice and invoice items keeping the parent and child data together within the file.
Exclude Related Column From Child Data
If your using the hierarchal structure this can be used to exclude the related child columns data from the child CSV rows, for example Invoice table linked to Invoice Items on the INVOICE_NUMBER columns will default to outputting the INVOICE_NUMBER in both the parent and child rows, you may not want this value added to the child rows.
As you change the options the sample will update to show a simple example of how the CSV will be formatted.