Everything E3D

Integration with AVEVA ERM

Save PDF

Integration with AVEVA ERM

Save PDF

Last UpdatedApr 30, 2026
4 minute read

For more detailed information about setting up AVEVA ERM integration, the notification mechanism and workflows for catalogue and part list integration, refer to the AVEVA ERM-Design Integration User Guide located at: C:\Programs(x86)\AVEVA\Everything3D2.10\ERMIntegration\AVEVAERMIntegrationUserGuide.pdf

Material Category Mapping

Use the functionality available from the Material Category Mappings window to create a mapping between the material type in AVEVA Catalogue™ and AVEVA ERM.

File Menu

New	Use to create a new file in which to store the material category mappings.
Open	Use to open a material category mappings file.
Save	Use to save a material category mappings file.
Save As	Use to save a material category mappings file to another location.
Export to Excel	Use to export a material category mappings file to Excel for use in AVEVA ERM.

The location of the file from where the mappings are currently loaded is displayed. The Material Category Mappings window is populated with all the mappings available in the file at that location.

Find	Use to find an ERM Material Type, first enter the required ERM Material Type in the field.
Edit	Use to edit the currently selected mapping in the Material Category Mappings window.
Delete	Use to delete the currently selected mapping in the Material Category Mappings window.
Copy	Use to copy the currently selected mapping in the Material Category Mappings window.
Select BLTA	Use to import the bolt table from AVEVA ERM at the specified location.
Auto Generate Mapping	Use to generate the mappings automatically. For each CATE or PRTELE, one ERM Material Type is generated and the Material Type is set. Also, CATE or PRTELE are flagged with M/NM (mapped, not mapped). Further, based on the value entered in the Material Type Auto Generate PML field from the Import & Material Mappings Settings tab, the ERM Material Type names are created.

Material Mapping

Use the Material Mappings functionality to manually define a mapping then add it to the file and Material Category Mapping grid.

ERM Material Type	The name of the material type in AVEVA ERM
Material Description	The description of the ERM material type
GTYPE	The GTYPE of the ERM material type
CATA	The name of the catalogue to which the component belongs
SECT/STSE	The section or the steel section of the ERM material type
CATE/STCA	Enter the category or the steel category of the ERM material type
PRTWLD	The part world of the ERM material type
PRTELE	The part element of the ERM material type
CMPW	The component weight of the ERM material type
CMPT	The component type of the ERM material type
Read Attributes	PML function used for collecting the attributes of the component while importing from AVEVA ERM
Write Attributes	PML function used for setting the attributes of the component while importing from AVEVA ERM

Note: When a new standard material is transferred from AVEVA ERM, the category for the standard material is found by looking up the transferred field Material Type in the mapping table. When searching for new or modified standard materials to be transferred to AVEVA ERM, all categories defined in the mapping table are looked up.

Settings

The functionality available from the Settings window is identical to that previously described with the exception of the functionality available from the Import & Material Mappings Settings tab.

Select fields to be protected from ERM	Use the functionality to specify which attributes are not modified by any updates from AVEVA ERM.
Fully Validated Status	If any value other than [Not in Use] is selected the components with that status cannot be updated by AVEVA ERM. For AVEVA ERM to update the components, select the value [Not in Use]. The following values are available in the list of values (LoV): /preliminary, /valid.
Material Mapping Settings	Use to specify the settings for creating material category mappings.
Material Type Max Length	Use to restrict the character length of AVEVA ERM Material Type to the specified number while creating mappings. The default value is 50 characters.
Material Type Auto Generate PML	Use to select the file used for specifying the names of ERM Material Type during the auto-generation of material mappings in the Material Category Mapping window. Note: If no value is provided, the PML function ermgetmaterialtype.pmlfnc is used by default.
Import from AVEVA Catalogue Manager	Use the functionality to specify the locations for imported data from AVEVA Catalogue Manager.
Import Descriptions at	Use to specify the location for imported descriptions. Descriptions can be imported only to a top-level CATA element under the Catalogue World. Click CE to add the current element.
Import Weights at	Use to specify the location for imported weights. Weights can be imported only to a top-level PROP element under the Property World. Click CE to add the current element.
Import Bolts at	Use to specify the location for imported bolts. Bolts can be imported only to a top-level CATA element under the Catalogue World. Click CE to add the current element.
Import Specifications at	Use to specify the location for imported specifications. Specifications can be imported only to a top-level SPWL element under the Catalogue World. Click CE to add the current element.

Everything E3D