Export contents of a stock report to a file or database
At the Main screen:-
● Select: Print - (select a report)
● Select: File - Export
● Select the type of Export: ASCII, MDB, XLS or XLSX
The program prompts with a directory dialog. The default location for an exported file is the directory set by the System parameters as the: File for Export data. Adjust the file choice as necessary
● Select OK to export
The file name is based on the date and time and the Order title. For example:-
2015-08-12 1617 Orders by material.txt
2015-08-12 1621 Orders by material.mdb
Notes
- The format of the exported data is set by the option: Settings - Export settings. The format and content can be different for each report.
ASCII Export
The different elements of the exported data are separated into categories (often called lines) so that each type of data can be recognised. These are identified by a token (e.g. %3) at the start of each line.
Header lines - %1
Sub headings - %2
Item line - %3
Totals - %4
An example of the ASCII export is shown below. Values are comma separated.
%1,DEMO USER 1,Modular,20 July 2015
%1,Orders by material
%1,Order,Order Qty,Date,Board,Length mm,Width mm,Stock,Res,Area m2,Volume m3,Cost m2,Order Cost
%2,BLUE-LAM-1MM Blue Laminate 1mm Thickness 1.0 Grain Y Book 10
%3,BSR-STKORD-09,110,05/06/06,BLUE-LAM-1MM/01,2440.0,1220.0,142,0,327.45,0.33,1.787,585.15
%4,,110,,,,,,,327.45,0.33,,585.15
MDB export
Data is sent to an Access 2000 format MDB database with one table per report. The table name matches the report name.
The table contains only the text headings and the data (the other line types are not exported). The table names and column headings are based on the current report values.
The data elements and format are the same as those set in each report (for export).
Field names in MDB files cannot contain full stops, exclamation marks or square brackets. These are replaced during export with a 'space' character when setting up the field names.
Fractional inch values are stored as text.
Reports which have material sub-headings also have a material index field.
An example of MDB export is shown below.
Stock valuation
Material Index Board Length mm Width mm Qty Area m2 Costm2 Total Cost
1 CHIPBOARD-18MM/01 2440 1220 380 56.56 2.95 166.85
2 EBONY-LAM-1MM/01* 3050 1525 58 116.28 5.3 616.29
3 MED-DEN-FIBRE-18MM/01 3050 1525 1072 18.61 4.5 83.72
4 MEL-CHIP-15MM/02 2440 1220 680 5.95 2.56 15.24
5 TEAK-LAM-1MM/01 2440 1220 782 29.77 5.93 176.52
XLS/XLSX
These are the standard Excel spread sheet formats. This is a common format that can be accessed by many spread sheet programs.
