en:infra-convert:dev:export:csv
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:infra-convert:dev:export:csv [2019/01/21 13:20] me |
en:infra-convert:dev:export:csv [2023/08/02 12:04] (current) me |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| </WRAP> | </WRAP> | ||
| - | <WRAP group> | ||
| - | <WRAP column 75%> | ||
| ====== CSV test plan format ====== | ====== CSV test plan format ====== | ||
| ---- | ---- | ||
| - | </WRAP> | ||
| - | <WRAP column 20%> | ||
| - | > **Available in**\\ program version 1.1.5 and onwards | ||
| - | </WRAP> | ||
| - | </WRAP> | ||
| 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. | 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 #@IC_HTML@#.\\ \\ You can trigger the export in the start parameter file; see Configuration and Import > Startup Parameter File > [[en:infra-convert:dev:parameter#Prüfpläne und gestempelte Zeichnungen exportieren]]. | + | > **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 #@IC_HTML@#.\\ \\ You can trigger the export in the start parameter file; see Configuration and Import > Startup Parameter File > [[en:infra-convert:dev:parameter#Export quality test plans and stamped drawings]]. |
| + | |||
| + | \\ | ||
| <WRAP noprint> | <WRAP noprint> | ||
| Line 40: | Line 35: | ||
| <WRAP column 40%> | <WRAP column 40%> | ||
| - | Contains data that applies to the entire test plan | + | Contains general test plan data. |
| - | When saving in #@IC_HTML@#, the user will be asked for all values. The parameter names depend on the language version of the software. | + | The values are queried from the user interface during export. With the Pro version (and from program version 2.10.0), the test plan attributes can be defined in advance, saved and thus also exported on triggering via start parameter call. |
| + | |||
| + | The parameter names are output depending on the language set in the program. | ||
| > **See also** | > **See also** | ||
| - | > User manual #@IC_HTML@# > Functions > Export > Export test plan > [[en:infra-convert:user:functions:cplanexport|Workflow]] | + | > User manual #@IC_HTML@# > Functions > Export > Export test plan > [[en:infra-convert:user:functions:cplanexport#Workflow|Workflow]] |
| + | > | ||
| + | > User manual #@IC_HTML@# > Settings > Settings > Administration > [[en:infra-convert:user:config:administration#"Additional attributes for test plan versions" group|"Additional attributes for test plan versions" group]] | ||
| + | > | ||
| + | > Configuration and import > "Settings" Parameter file > List of the settings > [[en:infra-convert:dev:settings#"Settings > Administration" menu|“Settings > Administration” menu]] | ||
| </WRAP> | </WRAP> | ||
| <WRAP column 55%> | <WRAP column 55%> | ||
| - | |< 100% 40% 60% >| | + | |< 100% 5% 35% 60% >| |
| - | ^ Parameter/column ^ Content ^ | + | ^ Column/Parameter ^^ Content ^ |
| - | ^ Part number | Individual string | | + | ^ 1 ^ Part number | Individual string | |
| - | ^ Part name | Individual string | | + | ^ 2 ^ Part description | Individual string | |
| - | ^ Part change status | Individual string | | + | ^ 3 ^ Part amendment status | Individual string | |
| - | ^ Drawing Number Text | Individual string | | + | ^ 4 ^ Drawing number text | Individual string | |
| - | ^ Drawing change | Individual string | | + | ^ 5 ^ Drawing amendment | Individual string | |
| - | ^ Comment | Individual string | | + | ^ 6 ^ Remark | Individual string | |
| </WRAP> | </WRAP> | ||
| </WRAP> | </WRAP> | ||
| Line 68: | Line 68: | ||
| <WRAP column 40%> | <WRAP column 40%> | ||
| - | Contains all of the test plan data in a fixed order. The parameter names depend on the language version of the software. | + | 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 #@IC_OLD_HTML@#. | ||
| + | > 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 | ||
| </WRAP> | </WRAP> | ||
| <WRAP column 55%> | <WRAP column 55%> | ||
| - | |< 100% 40% 60% >| | + | |< 100% 5% 35% 60% >| |
| - | ^ Parameter/column ^ Content ^ | + | ^ Column/Parameter ^^ Content ^ |
| - | ^ StampText | Stamp marking\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 1 ^ Stamp text | Stamp marking\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ Tag | Title\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 2 ^ Label | Title (filtered by or converted to ANSI code characters)\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ Value | Value\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 3 ^ Value | Value (filtered by or converted to ANSI code characters)\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ NominalValue | Nominal value\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 4 ^ Nominal size | Nominal size\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ UpperTolerance | Upper tolerance\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 5 ^ Upper tolerance | Upper tolerance\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ LowerTolerance | Lower tolerance\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 6 ^ Lower tolerance | Lower tolerance\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ UpperLimit | Upper limit value/maximum value, calculated from the nominal value and lower tolerance / upper deviation limit when exporting. | | + | ^ 7 ^ Upper Limit | Upper limit value/maximum value, calculated from the nominal value and lower tolerance / upper deviation limit when exporting | |
| - | ^ LowerLimit | Lower limit value/minimum value, calculated from the nominal value and upper tolerance / lower deviation limit when exporting. | | + | ^ 8 ^ Lower Limit | Lower limit value/minimum value, calculated from the nominal value and upper tolerance / lower deviation limit when exporting | |
| - | ^ CharacteristicType | Type\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 9 ^ Type | Characteristic type (Variable; Attributive)\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ Class | Class\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 10 ^ Characteristic class | Characteristic class\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ Fit | Tolerance class\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 11 ^ Fit | Tolerance class\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ Comment | Comment\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 12 ^ Comment | Comment\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ ToleranceTable | Tolerance table\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 13 ^ Tolerance table | Tolerance table\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ ToleranceTableColumn | Tolerance class or “column”\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 14 ^ Column | Tolerance class or “column”\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ DrawingQuadrant | Field\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 15 ^ Field | Field\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ CharacteristicGraphic | Stamp graphic file name\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 16 ^ Characteristic Graphic | Stamp graphic file name\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ CharacteristicTypeId | Type ID (1 = variable; 0 = attributive).\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 17 ^ Characteristic Type ID | Type ID (1 = variable; 0 = attributive)\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ CharacteristicClassId | ID of the characteristic class as allocated in #@IC_OLD_HTML@#. | | + | ^ 18 ^ Characteristic class ID | ID of the characteristic class as allocated in #@IC_OLD_HTML@# | |
| - | ^ CharacteristicId | Unique GUID for the characteristic. | | + | ^ 19 ^ Characteristic ID | Unique GUID for the characteristic | |
| - | ^ SpecialCategoryId | Category ID\\ \\ **See** More > [[en:infra-convert:user:terms#Category (characteristic-)|Category (characteristic-)]] | | + | ^ 20 ^ Count | Repetitions\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ SpecialCategoryText | Category\\ \\ **See** More > [[en:infra-convert:user:terms#Category (characteristic-)|Category (characteristic-)]] | | + | ^ 21 ^ Characteristic category ID | ID of the category, for reasons of compatibility with the predecessor software, only the values "0" (for "standard feature") and "1" are output for all other categories. The GUID of the category is output with column 32.\\ \\ **See** More > [[en:infra-convert:user:terms#Kategorie (Merkmal-)|Kategorie (Merkmal-)]] | |
| - | ^ Tags | Tags, separated by commas (",")\\ \\ **See** User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] | | + | ^ 22 ^ Characteristic category | Category\\ \\ **See** More > [[en:infra-convert:user:terms#Kategorie (Merkmal-)|Kategorie (Merkmal-)]] | |
| - | ^ Requirement | Requirement\\ \\ **See** Administrator’s Guide > Configuration and Import > Parameter file "CharacteristicClasses” > [[en:infra-convert:dev:characteristicclasses#formatierung_der_exportvariable_forderung|Formatting the “Requirement” export variable]] | | + | ^ 23 ^ Tag | Tags, separated by commas (“,”)\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | |
| - | ^ └ PositionX | X-coordinate of the stamp in pixels on the drawing graphic\\ (Available from program version 1.2.0.25) | | + | ^ 24 ^ Requirement | Requierement\\ \\ **See** Administrator’s Guide > Configuration and Import > Parameter file “CharacteristicClasses” > [[en:infra-convert:dev:characteristicclasses#Formatting the “Requirement” export variable|Formatting the “Requirement” export variable]] | |
| - | ^ └ PositionY | Y-coordinate of the stamp in pixels on the drawing graphic\\ (Available from program version 1.2.0.25) | | + | ^ 25 ^ Position X | X-coordinate of the stamp in pixel | |
| - | ^ └ TargetX | X-coordinate of the reference point (target point, origin point) of the stamp in pixels on the drawing graphic\\ (Available from program version 1.2.0.25) | | + | ^ 26 ^ Position Y | Y-coordinate of the stamp in pixel | |
| - | ^ └ TargetY | Y-coordinate of the reference point of the stamp in pixels on the drawing graphic\\ (Available from program version 1.2.0.21) | | + | ^ 27 ^ Stamp Target X | X-coordinate of the reference point (target point, origin point) of the stamp in pixel | |
| - | ^ └ Radius | Size of the stamp, expressed as radius in pixels on the drawing graphic.\\ (Available from program version 1.2.0.25) | | + | ^ 28 ^ Stamp Target Y | Y-coordinate of the reference point (target point, origin point) of the stamp in pixel | |
| + | ^ 29 ^ Stamp Radius | Size of the stamp, indicated as radius in pixel | | ||
| + | ^ 30 ^ Reference | Reference\\ \\ **See** User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Settings|Settings]] | | ||
| + | ^ 31 ^ Drawing Sheet | File name including file extension of the drawing sheet on which the stamp is located | | ||
| + | ^ 32 ^ Characteristic category GUID | Category GUID\\ \\ **See** More > Terms > [[en:infra-convert:user:terms#category_characteristic|Category (characteristic-)]] | | ||
| + | ^ 33 ^ Unit nominal | ID of the unit of the nominal size\\ \\ **See** User Manual > More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] | | ||
| + | ^ 34 ^ Unit tolerance | ID of the unit for the tolerance values\\ \\ **See** User Manual > More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] | | ||
| + | ^ 35 ^ Class symbol | Graphic symbol or indicator\\ \\ **See** More > Terms > [[en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]] | | ||
| + | ^ 36 ^ MinMax | Limit dimension in one direction (min., max.)\\ \\ **See** Settings > Settings > Characteristics > [[en:infra-convert:user:config:features#limit_values_in_one_direction_min_max_group|“Limit values in one direction (min., max.)” group]] | | ||
| + | ^ 37 ^ Modifiers | Modifiers\\ \\ **See** Terms > More > [[en:infra-convert:user:terms#specification_operators_and_modifiers_iso_gps|Specification operators and modifiers (ISO GPS)]] | | ||
| </WRAP> | </WRAP> | ||
| Line 119: | Line 164: | ||
| **Go to next page**\\ | **Go to next page**\\ | ||
| - | Appendix > [[en:infra-convert:dev:parameter_beispiel|Example Startup parameter file]] | + | Export > [[en:infra-convert:dev:export:graphics|Drawing and stamp graphics]] |
| </WRAP> </WRAP> | </WRAP> </WRAP> | ||
| </WRAP> | </WRAP> | ||
en/infra-convert/dev/export/csv.1548073231.txt.gz · Last modified: 2019/01/21 13:20 by me
Page Tools
