AVEVA ABSI/SDNF Mapping File Convertor

This is a tool to format the profile mapping files shared by the SDNF and ABSI interfaces and the AVEVA Bocad Steel from CSV files to a format for more streamlined use. It transforms input files, including formulaic entries into a "block" format where we know how big each field is. This makes the reading of the files much faster.

In order to speed up the interface the top line of the mapping file gives details of the field widths in the rest of the file. For example:

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

Goes to

AVEVA BOCAD 5 19 19 19 3 2

EU_CF_CHS101.6x2.0 EU-CF-CHS101.6x2.0 CHS101.6*2.0 EU 7

EU_CF_CHS101.6x2.5 EU-CF-CHS101.6x2.5 CHS101.6*2.5 EU 7

EU_CF_CHS101.6x3.0 EU-CF-CHS101.6x3.0 EU-CF-CHS101.6x3.0 EU 7

The converter does run stand-alone from the AVEVA E3D 2.1™ install folder, but it is also accessible from the Control menus on the Export and Import main dialogs for both SDNF and ABSI interfaces.

The format of the file is as follows…

[PDMS Catref name, PDMS Specref name] [External profile name, country code, shape code]

For example:

EU_CF_CHS101.6x2.0 EU-CF-CHS101.6x2.0 CHS101.6*2.0 EU 7

The shape and country codes are internal to us to help us uniquely identify the profile. At translation time, using a combination of these fields we can build a dictionary for profile mapping between PDMS/AVEVA E3D 2.1™ and Bocad, for example.