Using Excel to Export and Import Schema - Integration - Update 44 - Help - Hexagon

Integration Help

Language
English
Product
Integration
Search by Category
Help
Smart 3D Version
12.1 (2019)
Smart Construction Version
2019(7.0)
SmartPlant Foundation / SDx Version
10
Smart Electrical Version
2019 (9.0)
Smart Materials/Smart Reference Data Version
2020 (10.0)
Smart P&ID Version
9 (2019)
Smart Review Version
2020 (15.0)
Smart Engineering Manager Version
10 (2019)
Smart Interop Publisher Version
13.1 (2019 R1)
Smart Isometrics Version
7.0(2019)
Spoolgen Version
9.0(2019)

You can export schema data from Schema Editor to Microsoft Excel to make changes. You can import the edited schema from Excel to Schema Editor.

The following data can be exported to Excel:

  • Any schema displayed in a tabular view

  • Pseudo file configuration (CMF)

  • Schema container (XML file or CMF active configuration)

Schema Editor does not support exporting tool map schema to Microsoft Excel for modifications and importing back.

File Generated by Export Commands

For every container, pseudo file configuration, or view that is exported, two files will be generated:

  • .xlsm file – Excel file containing the exported objects

  • .UIDs file – Text file containing the UID for every object and relationship that is exported