Use the GenerateMapping tool - Intergraph Smart Interop Publisher - Help

Intergraph Smart Interop Publisher Help

Language
English
Product
Intergraph Smart Interop Publisher
Search by Category
Help
Smart Interop Publisher Version
17

Use the GenerateMapping tool, delivered with Smart Interop Publisher, to generate the required mapping and schema files. The generated mapping file is named GenericToR3DMapping.xlsx and lists source classes and their properties. You can specify additional information for mapping, such as target class, target interface, and target property, after the file is generated. The generated schema file is named GenericSchema.xlsx. It lists the class names and their properties.

If you have previously used this tool to generate a GenericToR3DMapping.xlsx file, you must save the file in Excel as a .xlsx file format,and then run the GenerateMapping tool.

For mapping updates, run the GenerateMapping tool using the GenericToR3DMapping.xlsx file to append any new classes and properties from the input .drv files. The GenericSchema.xlsx file is regenerated every time you use the GenerateMapping tool and contains all class names and properties from the GenericToR3DMapping.xlsx mapping file.

The GenerateMapping tool is delivered in the Smart Interop Publisher install folder. The default location is [drive]:\Program Files\SmartPlant\Interop Publisher.

Before You Begin

For generic mapping, you must have the Microsoft Access Database Engine (32-bit) software installed on your system; even if you already have a 64-bit version installed. Smart Interop Publisher provides the Microsoft Access Database Engine (32- and 64-bit) redistributables on the delivery media..

Run the executable (AccessDBEngine_x86.exe) to install the Microsoft Access Database Engine 64-bit redistributable.
-OR-
Follow the steps below to install the 32-bit version if you already have a 64-bit version installed.

If you already have a 64-bit version of Microsoft Access Database Engine, you cannot install the 32-bit software of the same version number. You must install a lower version of the 32-bit software. For example, if you have Microsoft Access Database Engine 2016 64-bit already installed on your system, then you cannot install the Microsoft Access Database Engine 2016 32-bit version. Install either the Microsoft Access Database Engine 2013 or Microsoft Access Database Engine 2010 Redistributable.

  1. Open a command prompt in Administrator mode.

  2. From the Smart Interop Publisher delivery media, enter the Microsoft Access .exe file (AccessDBEngine_x86.exe) and /passive as shown in the example below:

    "[drive]:\Tools\AccessDBEngine_x86.exe" /passive

Run GenerateMapping

The GenerateMappingTool can handle a maximum of 16383 rows in any mapping sheet.

  1. Start the application to open the GenerateMappingTool dialog.

  2. Specify the Class identifying label, which is the property name in the .drv file that corresponds to the class names.

    In the example .drv file contents below, you would enter Object type in the Class identifying label field. The class identifying label is case sensitive.

    lbl{0 5 21 8 text {Comp no: PAAAAAWAAA
    NPD: 6" 6"
    Sch/thk: S-STD S-STD
    Length: 186
    Line no: WC380401-6"-2C0032-P
    Object type: Piping Component
    Construction status:
    Nor oper press: 100 psig
    Nor oper temp: 60 degF
    Steam out temp: 0 degF
    Heat tracing: N
    Insulation: 1 "
    Cleaning: }}

  3. Type the input folder location, or click Browse to navigate to the input folder that contains the .drv files. You can use multiple .drv files to generate the GenericSchema.xlsx mapping file.

  4. Type the output folder location, or click Browse to navigate to the output folder, where the mapping and schema files are generated.

  5. Click Generate.

    The status bar of the tool shows the state of the generating process.

  6. After the files are generated, click Open Map to display the mapping file.

  7. Edit the mapping file to provide additional information for mapping such as target class, target interface, and target property.

  8. Click Open Schema to display the schema file.

  9. To set properties in your mapping file, continue to Add classes and properties to the generic mapping file.