Updating the Mapping Table

This task shows you how to update the mapping tables necessary for migrating V4 sections to V5. If you have a V4 section but no equivalent section in V5 then you must create it in V5 and place it in the structures sections catalog. See Managing Sections to learn how to create a section.

You will need to update two types of mapping tables. One contains a list of the V4 sections name and the name of the equivalent section in V5. The other contains a list of the V4 materials and the equivalent material code in V5. You may also choose to create or modify mapping tables by standard. Samples of these types of mapping table are included with this application. They are in the directory: ...intel_a\startup\EquipmentandSystems\MigrationDirectory\Dictionary\STRMappingTable
1. The default name of the mapping table that contains section names is V4toV5StructureMapping.csv. Open the file using MS Excel and enter V4 section names and their equivalent in V5. You must save the file as a .csv file.

This table is referenced in the project resource management (PRM) file (StructuresMigrationMappingTable). If you decide to use another table or change its location you must change the entry in the PRM file accordingly. This is usually done by a system administrator.

2. The mapping table that contains material codes is named StructuresMaterialMappingTable. Again, open this file with Excel, make your changes and be sure to save it in .csv format.

This table is referenced in the project resource management (PRM) file (StructuresMaterialMigrationMappingTable). If you decide to use another table or change its location you must change the entry in the PRM file accordingly. This is usually done by a system administrator.