PlantSight Enterprise Help

Creating a Mapping.json File for Imports That Do Not Have an OpenPlant Schema

Precondition:
  • The user has imported a source file without OpenPlant schema.
  • A Mapping.json file is missing.
  • Precondition for creating queries: You have knowledge of SQL and knowledge of the iModel schema.
  1. If the import is completed, in the menu click Data Manager > Queries.
  2. Create a SQL query that returns all relevant 2D or 3D objects from the import that need to be mapped.
  3. Create a mapping.json file for the import.

    Note: You can either copy an existing mapping.json file or create a new one, as long as the file is named "Mapping.json".

  4. Copy the SQL code of the query and paste it into Mapping.json.
  5. In Mapping.json, use the RelationshipsColMap property to create an object relationship. For more information, see Creating Object Relationships Using the User Label.
  6. Optional: Edit the file if necessary.
  7. Save Mapping.json in the same folder as the source files of the import.
  8. Reimport the import with Mapping.json.

The required data is generated in PlantSight. The imported objects can be seen in Data Aggregation, and you can start aggregation.

Parent topic: Mapping.json Configuration