Source CSV file
- Last UpdatedJan 23, 2023
- 2 minute read
The source CSV file is of the form:
COMMENT;CATREF;SPREF;EXTERNAL;STANDARD;SHAPE
#;EU_BF100x7;EU-BF100x7;;EU;21
;EU_CF_CHS101.6x2.0;EU-CF-CHS101.6x2.0;=CHS{1}*{2};EU;7
;EU_CF_CHS101.6x2.5;EU-CF-CHS101.6x2.5;=CHS{1}*{2};EU;7
;EU_CF_CHS101.6x3.0;EU-CF-CHS101.6x3.0;EU-CF-CHS101.6x3.0;EU;7
In the example above, the ';' character is used as a field separator. The converter also allows ',' and the tab character. To manage the file in a spreadsheet program, you will have to tell it which character to use.
There are 6 columns:
|
COMMENT |
If the field in this column begins with a '#' the whole record is ignored. After conversion, a .map.csv file is produced which is re-convertible, but which may contain error messages in this column. |
|
CATREF |
This contains the PDMS/AVEVA E3D 2.1™ Catalogue component name. |
|
SPREF |
This contains the PDMS/AVEVA E3D 2.1™ Specification component name. |
|
EXTERNAL |
This contains the name, or formula, of the profile in the target external system. |
|
STANDARD |
This is the abbreviation chosen to indicate to which standard the profile is related |
|
SHAPE |
This defined the profile shape. |
The top line of the file must contain these headings, or precisely 6 fields which are taken to be column names.
By using a = in front of the external profile name, the name will be interpreted as a formula that defines value substitution. This means that the formula will be interpreted by replacing the {n} by the n'th group of number of the name contained in second column. Up to 9 substitutions are allowed. The characters that are considered as a number are: 0123456789 and '-' and '/'. The characters '-' and '/' should be enclosed by at least one digit on each side to be consider as part of a number group.
For example:
|
EPPKORE/508~D12.7 |
=TUBE{1}*{2} |
|
EPPKORE/L45x45x4x4 |
=L{1}*{3} |
|
EPPKORE/L50x30x3x3 |
=L{1}*{2}*{3} |
|
EPPKORE/H496x199x9x14 |
=JPH{1}*{2}*{3}*{4} |
|
EPPAISC/HSS4-1/2x4-1/2x1/8 |
=USHSS{1}*{2}*{3} |
|
EPPAISC/14.000~D.625 |
=TUBE{1}"*{2}" |
The new csv file will have the formulas interpreted, in the example:
|
EPPKORE/508~D12.7 |
TUBE508*12.7 |
|
EPPKORE/L45x45x4x4 |
L45*4 |
|
EPPKORE/L50x30x3x3 |
L50*30*3 |
|
EPPKORE/H496x199x9x14 |
JPH496*199*9*14 |
|
EPPAISC/HSS4-1/2x4-1/2x1/8 |
JSHSS4-1/2*4-1/2*1/8 |
|
EPPAISC/14.000~D.625 |
TUBE14.000"*.625" |