Types of data that can be exported from runs
Runs / Summaries can be exported to the following formats.
ASCII
XLS
XLSX
Pattern
ASCII
Each report is exported to a separate file based on the run number and report code. The extension is EXD. The files are placed in the directory given by the System parameter: Path for Export data. For example:-
10023C.EXD - file for pattern summary
10023D.EXD - file for part summary
MDB
Each report is a table in an Access 2000 format MDB database. If there is more than one run in the batch the MDB file includes all the runs. Each 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).
Fractional inch values are stored as text.
Each line in the run based tables has a run index field. This can be used to create Access queries on a run by run basis.
Data between tables is NOT linked
Reports which have material sub-headings (Board, Distribution, Material, Offcut, Part, Sundry part, Pattern, Saw Loading) also have a material index field.
- Job costing, Management Summary and Input summary contain different data on different rows and cannot be exported to a table.
Line types
The different elements of the exported data are separated into categories (often called bricks or 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.
Summary title - %1
Filenames - %1
Column headings - %1
Sub headings - %2
Data - %3
Subtotals - %4
Totals - %4
Information boxes - %5
The type of data exported can be set by the Review runs parameter: Export lines
XLS/XLSX
These are the standard Excel spread sheet formats. This is a common format that can be accessed by many spread sheet programs.
Pattern
This is only used for exporting pattern images to a bit map file.
Setup
As well as the choices on Export the export format can also be adjusted via 'Review runs - Settings'
