Material Lists - Export

Export - CSV

If a bill of materials is opened for editing, the function 'List - Export - *. CSV' of the CSV export. A dialog box will appear with the following elements:

Tree Element In the tree 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 proposed.

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

Settings Here you can select the setting for export. It influences the selection of data fields and the designation of the column headers. In the user settings, the number of data fields and field names fluctuates accordingly. With <Standard> an export is selected in which the number of data fields and their name is 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 divider for groups of thousands will not be assigned. In the <standard> export, the decimal separator is fixed on '. period'.

Description Export File

- A file in ANSI character format is created.

- The data field separator is set during export. The following can be selected: tab, period, comma, semicolon, space, tilde, forward slash and backstroke. In the <standard> export, the data field separator is fixed to '~ tilde'.

- The record separator is the line break.

- The first row always contains the name of the data fields.

- All rows from the second row onwards are records.

- The decimal separator is set during export. You can select: period and comma. In the <standard> export, the decimal separator is fixed on '. period'.

User-defined settings

If user-defined settings are used during the export, only the data fields that are displayed on the screen in the list edit are exported. The names of the data fields are the labels that the application has specified in the list setting.

This allows you to create an export according to certain specifications.

< Default> Setting

If you want to ensure that the export should have as many data fields as possible, each with the same name, we recommend setting <Standard>, which is independent of user settings. All existing data fields are exported. The number and name of the data fields are specified in the program. However, the names of the data fields depend on the language you set. If export files from different languages are to be imported, the following order of the data fields can be assumed in the <standard> case. If data fields are added in later versions, they are always appended to the end of the data 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. Decimal separator is the point.

Field designation

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

1) Point (alphanumeric) parcel number. The materials can be combined 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 + building element number. [Examples:]{.underline} Floor 1 W 3 1st floor, wall 3 D 2 F 23 2nd roof, roof area 23 Ground floor D 4 ground floor, ceiling field 4 In the German-language version, there are for the level roof/floor: FK = free construction, basement = basement, ground floor = ground floor, floor = upper floor, attic = attic, D = roof. For the building elemental level: W = wall, D = ceiling panel, F = roof area, L = roof line

3) ZNr (integer) line number. Line number in the bill of materials as it was sorted on the screen and is displayed.

4) HNr (alphanumeric) blank or wood list number. This is the number after sorting the raw bodies, i.e. only after distinguishing between designation, identification number (cutting class), length, width and height. This number is usually sufficient for differentiation in the sawmill.

5) LNr (alphanumeric) Sequential number. When sorting, a distinction is also made between edits. Components that have the same raw body number can also have different sequence numbers due to different machining.

6) IdentNr. (alphanumeric) Identification number. Unique identification number for internal identification. If components with the same order number have to be differentiated for internal reasons, they are given different identification numbers. E.g. S10 planed and S10 unplaned.

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

8) Bar type (integer) bar type. Unique number for the function of a staff. Has no further significance for export.

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

10) Description (alphanumeric) Description. Further textual description of the component. May also contain hints for editing: [ ] = Edits: Hx: H1, H2, H3, H4 = planing one-, two-, three-, four-sided [Hx:1.20] Planing to length 1.20, [Hx:L] = planing along the entire length

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

12) B (decimal) Width in meters [m]. Largest dimension in the direction of the width: Bars, profile bars: cross-section width Plates: Plate Thickness

13) H (decimal) Height in meters [m]. Largest dimension in the direction of height: Bars, profile bars: cross-section height Plates: Plate width

14) L (decimal) Length in meters [m]. Largest dimension in the direction of length: Bars, profile bars: Length Plates: Plate Length

15) Anz (integer / decimal) number / quantity. In the case of rods, profiled rods, plates, etc., the number is recorded here. In the case of simple articles, the quantity according to the unit of account (Box 18 "Unit").

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

17) Gw/Bz (Dezimalzahl) Gewicht pro Bezug. Gibt das relative Gewicht gemäß Bezug Gewicht an. Es gibt Materialien, deren relatives Gewicht eine Spanne hat, z.B. Bauholz 400 - 600 kg/m³. Im Baudatenprogramm kann beim Erzeugen der Holzliste eingestellt werden, welcher Wert verwendet wird: Unteres Gewicht, mittleres Gewicht oder hohes Gewicht. Nur dieses wird dann in der Liste abgespeichert und dann auch exportiert.

18) Einh. (alphanumerisch) Einheit. Die Verrechnungseinheit auf den sich der Preis bezieht. Für einfache Artikel ist dies auch die Einheit, in der die Menge (Feld 15 'Anz.') angegeben wird. Mögliche Einheiten: bf (board feet), cbm (Kubikmeter), ccm (Kubikzentimeter), cdm (Kubikdezimeter, Liter), cft (cubik feet), cin (cubic inch), cm (Zentimeter), cmm (Kubikmillimeter), d (Tag), ft (feet), h (Stunde), in (inch), kg (Kilogramm), lbs (Pfund), m (Meter), min (Minuten), mm (Millimeter), oz (Unze), qcm (Quadratzentimeter), qft (square feet), qin (square inch), qm (Quadratmeter), qmm (Quadratmillimeter), s (Sekunden), sq (square), stck (Stück)

19) Pr/Einh (Dezimalzahl) Preis pro Einheit.

20) LO (alphanumerisch) Lieferort. W = Werkstatt, M = Montage

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

22) Laufm (decimal) Linear metres in metres [m]. Sum of the linear meters of this data set, e.g. the running length of the individual rod times the number of rods.

23) Surface (decimal) surface in square meters [sqm]. Sum of the surface area of this data set, e.g. surface area of the individual member times number of members. For rods, surface, for plates, the panel area.

24) Volume (decimal) volume in cubic meters [cbm]. Volume of this data set, e.g. volume of the individual member times number of members.

25) Weight (decimal) Weight in kilograms [kg]. Weight of this data set, e.g. weight of the individual member times number of members.

26) Price (decimal) Price in the set first currency. Price of this dataset.

27) Tax No. (alphanumeric) Cost Center Number. Is only passed for measurement article 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 columns that have just been switched on is written out.

When exporting, the destination directory and file name for the export file can be specified.