One Stop Order Processing allows any view to be exported. To allow easy data conversion to the target system you can also define your own values. These can either contain a single value for all orders, or a different value for each order. These values can be defaulted from any other field and can include calculations based on other fields. For more information see Selecting Display Fields.

To export all the orders (or selected orders) select the Export Orders menu option (under File->Import and Export) or click on Export Orders button ( ).

You can define how you want to export the information displayed on the screen. Only the fields (columns of data) that are marked for export are exported. The columns shown in the Export order details dialog are those that will be exported.

Orders to include
You can either export all the orders displayed shown in the main window or those that you have ticked.

Include header line
If you require information at the start of the file add any text here.

Include footer line
If you require information at the end of the file add any text here.

The header and footer lines can include the following macros. These are replaced when the information is exported.

[%TIME%]   The current date and time.
[%FILENAME%]  The filename exported to.
[%NUM_EXPORTED%]  Number of orders exported
[%NEW_LINE%]   Start a new line. This can be used to put several blank lines (with or without data in) at the start or end of the export file.
[%TAB%] Use a tab character.

Include column headers before data
Some 3rd party products want the names of the fields that the information relates to. You can change the names of the columns in the Select fields dialog.

Include column totals after data
You can include the totals of any columns defined in the view as totals required.

Quote field information
If you are using the separator in your main text you may want to use quoted fields. For example, some applications (e.g. Microsoft Excel) allow the comma separator to be used as field text as long as all the fields are quoted. You can use any character(s) to put around the export field information.

Field separator, to use a tab enter \t
This is the character (or characters) to use between each value. If you need a Tab Separated file (tsv) type in \t.

File to export to
This is the file that will be used to save the information to. This file will be overwritten each time an export is done.