Export Tool Mapping to a Spreadsheet - 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)
  1. Open the two tool map schemas for which you want to export mapping. For more information about opening tool map schemas, see the Open a Tool Map Schema.

    • If you have checked the SmartPlant schema CMF file out of the Desktop Client, launched the Schema Editor, synchronized the tool map schema and the tool metadata, and are working with the tool's metadata adapter to define mapping, the authoring tool map schema is already open in the Schema Editor.

    • Before you can open a tool map schema, you must open a schema file.

      You can also open a file configuration or session file that contains the SmartPlant schema and the tool map schema files that you want to view.

    • The tool map schema file for each authoring tool is installed with the authoring tool. For more information about authoring tool map files and their locations, see your authoring tool documentation.

  2. Click Tools > Another Tool Schema and then click the type of mapping that you want to export. For example, to export enumerated list mapping, click Tools > Another Tool Schema > Show Mapping Between Enum Lists.

    SHARED Tip You can also click the Another Tool Schema File button in the Workflows dialog box to view and export mapping between tools.

  3. Under From, select the tool map schema from which you want to see mapping and the class definition, UoM list, or enumerated list for which you want to export mapping.

  4. If the selected class definition, UoM, or enumerated list maps to multiple class definitions in the SmartPlant schema, click the SmartPlant object for which you want to view mapping in the Class definition list.

    SHARED Tip If the selected object only maps to a single class definition in the SmartPlant schema, the class definition is automatically selected by default in the Class definition list.

  5. Under To, select the tool map schema and the class definition, UoM list, or enumerated list that you want to see how the selected schema maps to.

  6. In the Name spreadsheet using list, select the type of object that you want to use to name the mapping spreadsheet. For example, for a class definition spreadsheet, you can choose to name the spreadsheet using the class definition name in the SmartPlant schema, the class definition you are viewing mapping from, or the class definition you are viewing mapping to.

  7. Click Create Spreadsheet.

  8. In the Update Spreadsheet File dialog box, type the name of a new Excel workbook or browse to an existing workbook, and click Open.

    SHARED Tip If you select an existing Excel workbook, the new mapping spreadsheet is added as a new tab in the existing workbook.

  9. To view the spreadsheet, browse to the location where you saved the workbook, and double-click the file to open it in Excel.

    SHARED Tip The columns in the spreadsheet correspond to the columns in the table in the Show Mapping Between Classes, Show Mapping Between UoMs, and Show Mapping Between Enumerated Lists windows. For more information, see View Tool-to-Tool Mapping for Classes and Properties, View Tool-to-Tool Mapping for Units of Measure, or View Tool-to-Tool Mapping for Enumerated Lists.

See Also

Viewing Authoring Tool Mapping