Send product library data to an external file
At the Product library screen:-
● Select: File - Export Product list
The library data is exported to a comma separated value file with a fixed name. MPRODLIST.csv (for millimetres) or IPRODLIST.CSV (for inches).
The file is located in the folder set by the System parameter: Path for Export data
See: Import / Export product library
Notes
A line is produced for each product in the library with the fields in the following order:
Code, Description, Height, Width, Depth, Memo1, Memo2, Memo3, Memo4, Memo5,Price,Drawing name,Variable1,default answer1,Variable2,default answer 2...
The drawing name field contains the sketch name, not the plan or elevation names. This field can be blank (empty) but there may still be a product drawing which matches the product name.
The product variables and default answers repeat as many times as required. Default answers are taken from the variables table. If there is no default answer, the answer field is blank (e.g. @variable1@,,@variable2@...). Global variables will appear in the list against each product.
If a product contains parts / machine drawings which have variables, these variables will also appear in the list. This also applies to variables which occur in formulae or look-ups which occur in the product, parts or machine drawings.
Sub-assemblies and accessories are not exported. The list of parts that comprise a product are also not exported.
For details of the format refer to the: Interface guide
