infra CONVERT
blue DAT • infra DAT
mdm TOOL
Sidebar
en:infra-convert:dev:export:csv
This is an old revision of the document!
CSV test plan format
Available in
program version 1.1.5 and onwards
CSV is a file format with a simple structure. Values are assigned to parameters in columns. Semicolons (“;”) are used as delimiters to separate the values.
Note We recommend the JSONV1 format over the DFD format for connecting with your software package. It includes more transferable information and supports all features of infra CONVERT.
You can trigger the export in the start parameter file; see Configuration and Import > Startup Parameter File > Prüfpläne und gestempelte Zeichnungen exportieren.
Title line
Contains data that applies to the entire test plan. When saving in infra CONVERT, the user will be asked for all values. The parameter names depend on the language version of the software.
| Column/Parameter | Content | |
|---|---|---|
| 1 | Part number | Individual string |
| 2 | Part name | Individual string |
| 3 | Part change status | Individual string |
| 4 | Drawing Number Text | Individual string |
| 5 | Drawing change | Individual string |
| 6 | Comment | Individual string |
Characteristic data
Contains all of the test plan data in a fixed order.
Chagnes
From program version 1.3.4.1 there are two important changes. These are necessary to make the export compatible to the CSV export from infra - CONVERT.
1) Column 13 (“Count”) is exported as column 19 now.
2) The parameter names are output depending on the language set in the program.
Columns available up to Version 1.3.3.5:
1 StampText
2 Label
3 Value
4 NominalValue
5 UpperTolerance
6 LowerTolerance
7 UpperLimit
8 LowerLimit
9 CharacteristicType
10 Class
11 Fit
12 Comment
13 ToleranceTable
14 ToleranceTableColumn
15 DrawingQuadrant
16 CharacteristicGraphic
17 CharacteristicTypeId
18 CharacteristicClassId
19 CharacteristicId
20 SpecialCategoryId
21 SpecialCategoryText
22 Tags
23 Requirement
24 PositionX
25 PositionY
26 TargetX
27 TargetY
28 Radius
| Column/Parameter | Content | |
|---|---|---|
| 1 | Stamp text | Stempelbeschriftung See User interface > Function windows > Characteristic properties > Settings |
| 2 | Label | Titel (gefiltert nach oder konvertiert in ANSI-Code-Zeichen) See User interface > Function windows > Characteristic properties > Settings |
| 3 | Value | Wert (gefiltert nach oder konvertiert in ANSI-Code-Zeichen) See User interface > Function windows > Characteristic properties > Settings |
| 4 | Nominal size | Nennmaß See User interface > Function windows > Characteristic properties > Settings |
| 5 | Obere ToleranzUpper tolerance | Obere Toleranz See User interface > Function windows > Characteristic properties > Settings |
| 6 | Lower tolerance | Untere Toleranz See User interface > Function windows > Characteristic properties > Settings |
| 7 | Upper Limit | Oberer Grenzwert/Höchstmaß, beim Export berechnet aus dem Nennmaß und der unteren Toleranz/dem oberen Abmaß |
| 8 | Lower Limit | Unterer Grenzwert/Mindestmaß, beim Export berechnet aus dem Nennmaß und der oberen Toleranz/dem unteren Abmaß |
| 9 | Type | Typ See User interface > Function windows > Characteristic properties > Settings |
| 10 | Characteristic class | Klasse See User interface > Function windows > Characteristic properties > Settings |
| 11 | Fit | Toleranzklasse See User interface > Function windows > Characteristic properties > Settings |
| 12 | Comment | Bemerkung See User interface > Function windows > Characteristic properties > Settings |
| 13 | Tolerance table | Toleranztabelle See User interface > Function windows > Characteristic properties > Settings |
| 14 | Column | Toleranzklasse bzw. -reihe (“Spalte”) See User interface > Function windows > Characteristic properties > Settings |
| 15 | Field | Feld See User interface > Function windows > Characteristic properties > Settings |
| 16 | Characteristic Graphic | Dateiname der Stempelgrafik See User interface > Function windows > Characteristic properties > Settings |
| 17 | Characteristic Type ID | ID des Typs (1 = Variabel; 0 = Attributiv). See User interface > Function windows > Characteristic properties > Settings |
| 18 | Characteristic class ID | ID der Merkmalklasse, wie sie in infra - CONVERT vergeben wurde. |
| 19 | Characteristic ID | Eindeutige GUID für das Merkmal. |
| 20 | Repetitions | Wiederholungen See User interface > Function windows > Characteristic properties > Settings |
| 21 | Characteristic category ID | ID der Kategorie See Weiteres > Kategorie (Merkmal-) |
| 22 | Characteristic category | Kategorie See Weiteres > Kategorie (Merkmal-) |
| 23 | Tag | Kennzeichnungen, getrennt durch Kommas (“,”) See User interface > Function windows > Characteristic properties > Settings |
| 24 | Requirement | Forderung See Administratorhandbuch > Konfiguration und Import > Parameterdatei “CharacteristicClasses” > Formatierung der Exportvariable "Forderung" |
| 25 | Position X | X-Koordinate des Stempels in Pixeln auf der Zeichnungsgrafik (Available from program version 1.2.0.25) |
| 26 | Position Y | Y-Koordinate des Stempels in Pixeln auf der Zeichnungsgrafik (Available from program version 1.2.0.25) |
| 27 | Stamp Target X | X-Koordinate des Bezugspunkts (Zielpunkt, Ursprungspunkt) des Stempels in Pixeln auf der Zeichnungsgrafik (Available from program version 1.2.0.25) |
| 28 | Stamp Target Y | Y-Koordinate des Bezugspunkts des Stempels in Pixeln auf der Zeichnungsgrafik (Available from program version 1.2.0.25) |
| 29 | Stamp Radius | Größe des Stempels, angegeben als Radius in Pixeln auf der Zeichnungsgrafik (Available from program version 1.2.0.25) |
| 30 | Reference | Bezug (Available from program version 1.3.4.1) See User interface > Function windows > Characteristic properties > Settings |
| 31 | Drawing Sheet | Dateiname inklusive Dateiendung des Zeichnungsblatts, auf welchem sich der Stempel befindet (Available from program version 1.3.4.1) |
en/infra-convert/dev/export/csv.1558698462.txt.gz · Last modified: 2019/05/24 13:47 by me
