Material Lists - Export

Export - CSV

If a material list is opened for editing, the CSV export can be invoked using the 'List - Export - *.CSV' function. A dialog box appears with the following elements:

Directory In the directory element the target directory for the export file can be selected. If necessary, a new directory can also be created there. The current project directory is suggested.

Filename The project number with the list number is suggested. The name can be changed according to the rules for forming file names. The file extension *.csv is assigned automatically.

Settings Here the setting for the export can be selected. It influences the selection of data fields and the labeling of the column headers. In the user settings the number of data fields and field labels may vary accordingly. With <Standard> an export is chosen in which the number of data fields and their labels are specified by the program.

CSV Separator The data field separator can be selected. This should be coordinated with the recipient. In the <Standard> export the CSV separator is fixed to '~ Tilde'.

Decimal Separator The decimal separator can be selected. This should be coordinated with the recipient. It must be different from the CSV separator. A thousands separator is not assigned. In the <Standard> export the decimal separator is fixed to '. Period'.

Description Export file

- A file is generated in ANSI character format.

- The data field separator is set during export. The following can be selected: Tabulator, Period, Comma, Semicolon, Space, Tilde, Forward slash and Backslash. In the <Standard> export the data field separator is fixed to '~ Tilde'.

- The record separator is the line break.

- The first line always contains the designation of the data fields.

- All lines from the second line onward are records.

- The decimal separator is set during export. The following can be selected: Period and Comma. In the <Standard> export the decimal separator is fixed to '. Period'.

User-defined settings

If user-defined settings are used for the export, only the data fields that are displayed on the screen in the list editing will be exported. The designations of the data fields will be those specified by the user in the list settings.

This provides the option to generate an export according to specific requirements.

<Standard> setting

If it must be ensured that the export contains as consistent a number of data fields as possible, each always with the same designation, the <Standard> setting, which is independent of user settings, is recommended. In this case all existing data fields are exported. The number and the designation of the data fields are specified by the program. However, the designations of the data fields depend on the selected language. If export files from different languages are to be imported, the following order of data fields can be assumed for <Standard>. If data fields are added in later versions, they will always be appended at the end of the record. The order of the existing data fields therefore always remains unchanged.

In the <Standard> CSV export the tilde (~) is always automatically used as the data field separator. The decimal separator is the period.

Field designation

[No. (in German) Description]{.underline}

1) Pkt (alphanumeric) Package number. The materials can be grouped into packages.

2) GebEl (alphanumeric) Building element. The material belongs to this building element. Building elements are specified with their floor or roof. The building element consists of: Roof/Floor + Roof/Floor number + Building element type + Building element number. [Examples:]{.underline} OG 1 W 3 1st upper floor, Wall 3 D 2 F 23 2nd roof, Roof surface 23 EG D 4 Ground floor, Ceiling field 4 In the German-language version, for the level Roof/Floor the following exist: FK = Free construction, UG = Basement, EG = Ground floor, OG = Upper floor, DG = Attic floor, D = Roof. For the level Building element type: W = Wall, D = Ceiling field, F = Roof surface, L = Roof line

3) ZNr (integer) Line number. Line number in the material list as it was sorted and displayed on the screen.

4) HNr (alphanumeric) Raw body or timber list number. This is the number after sorting the raw bodies, i.e. only distinguishing by designation, identification number (cutting class), length, width and height. This number is generally sufficient for differentiation at the sawmill.

5) LNr (alphanumeric) Running number. Sorting also distinguishes by processing. Components that have the same raw body number may have different running numbers due to different processing.

6) IdentNr. (alphanumeric) Identification number. Unique identification number for internal marking. If components with the same order number must be distinguished for internal reasons, they receive different identification numbers. E.g. S10 planed and S10 unplaned.

7) Identbez. (alphanumeric) Identification designation. Long text for the identification number.

8) Stabart (integer) Rod type. Unique number for the function of a rod. Has no further significance for the export.

9) Bezeichnung (alphanumeric) Designation. Textual designation of the component, usually determined by its function, e.g. 'purlin'.

10) Beschreibung (alphanumeric) Description. Further textual description of the component. May also contain processing instructions: [ ] = Processing: Hx: H1, H2, H3, H4 = Planing one-, two-, three-, four-sided [Hx:1.20] Planing to length 1.20, [Hx:L] = Planing to full length

11) Bestnr (alphanumeric) Order number. Order number for ordering from other companies or departments. For sawmills the cutting class is usually indicated here.

12) B (decimal) Width in meters [m]. Largest dimension in the direction of width: Rods, profile rods: Cross-section width Panels: Panel thickness

13) H (decimal) Height in meters [m]. Largest dimension in the direction of height: Rods, profile rods: Cross-section height Panels: Panel width

14) L (decimal) Length in meters [m]. Largest dimension in the direction of length: Rods, profile rods: Length Panels: Panel length

15) Anz (integer / decimal) Quantity / amount. For rods, profile rods, panels, etc. the quantity is recorded here. For simple items the amount according to the billing unit (field 18 'Einh.').

16) BzGw (alphanumeric) Reference weight. Indicates for which unit the relative weight specification Gw/Bz is given. The following combinations can be used: kg/1000pcs, kg/100pcs, kg/10pcs, kg/cbm, kg/kg, kg/m, kg/sqm, kg/pcs, lbs/bf, lbs/cft, lbs/lbs, lbs/lnft, lbs/pcs, lbs/qft

17) Gw/Bz (decimal) Weight per reference. Specifies the relative weight according to the reference weight. There are materials whose relative weight has a range, e.g. construction timber 400 - 600 kg/m³. In the construction data program, when generating the timber list, it can be set which value is used: lower weight, average weight or higher weight. Only this value is then stored in the list and exported.

18) Einh. (alphanumeric) Unit. The billing unit to which the price refers. For simple items this is also the unit in which the quantity (field 15 'Anz.') is specified. Possible units: bf (board feet), cbm (cubic meter), ccm (cubic centimeter), cdm (cubic decimeter, liter), cft (cubic feet), cin (cubic inch), cm (centimeter), cmm (cubic millimeter), d (day), ft (feet), h (hour), in (inch), kg (kilogram), lbs (pound), m (meter), min (minutes), mm (millimeter), oz (ounce), qcm (square centimeter), qft (square feet), qin (square inch), qm (square meter), qmm (square millimeter), s (seconds), sq (square), stck (piece)

19) Pr/Einh (decimal) Price per unit.

20) LO (alphanumeric) Delivery location. W = Workshop, M = Assembly

21) BA (alphanumeric) Source type. B = Ordered goods, L = Stock goods

22) Laufm (decimal) Running meters in meters [m]. Sum of the running meters for this record, e.g. running length of the individual rod times the quantity of rods.

23) Oberfl (decimal) Surface area in square meters [sqm]. Sum of the surface area for this record, e.g. surface area of the individual rod times the quantity of rods. For rods surface area, for panels the panel area.

24) Volum (decimal) Volume in cubic meters [cbm]. Volume of this record, e.g. volume of the individual rod times the quantity of rods.

25) Gewi (decimal) Weight in kilograms [kg]. Weight of this record, e.g. weight of the individual rod times the quantity of rods.

26) Preis (decimal) Price in the configured primary currency. Price of this record.

27) KstNr. (alphanumeric) Cost center number. Transferred only for measurement item lists. For other list types the field remains empty.

Export HTML

Material lists can be exported in HTML format:

HTML: The HTML format is a special format for the Internet. HTML files can be read by Internet browsers. The table with the currently enabled columns is written out.

During export the target directory and file name for the export file can be specified.