Import grids

Use to import Grids and DB-views into a database. The imported DTL file contains all relevant information related to the grid elements and their associated database views.

Pre-requisites for a successful import:

• Include all required attributes; for example, discipline, reference, has-part, and have-part in the target project.

• Define the data model in the target project, using the necessary classes and attributes that match those in the data being imported. For example, if the import file contains the attributes Name, Desc, and HasPartNozzle, but the target project only includes Name and Desc, the import will fail due to this mismatch.

Import grids

1. On the Grids tab, in the Grids group, select Import to display the Import Grids window.

   

2. Use the Import Grids window to perform the following actions:

   • Select the Dictionary DB to import the DB-views.

   • Select the Engineering DB to import the grids.

   • Browse and select the DTL file to import.

     

     Note:
     To import multiple grids, select the entire folder.
     To import only specific grids, select folders individually.

3. Select Import.

   Note: The Import option is enabled only after all fields are selected.

   The import process identifies subfolders that contain DB-view and Grid DTL files.

After the import, a log file is created, indicating the Grid Import Status, Date Timestamp, and Status.

You can view your imported data in the Grids Explorer.

Reference handling after import

The import process maintains relationships and connections between the grids and their corresponding database views.

Importing grids restores:

• Link to DB-view

• Fields

• Row ID column

• Layout including grouped columns

• Header color

• Header font color

• Pinned columns

• Row/column sizes

• Unit-sets (if they share the same name)

• Sorting pattern

• Sub grids relationships

Importing DB-views restores:

• Element types

• Filters

• Columns for attributes and expressions

• Data sources

Similarly, during export, these properties are exported into the target project.

Validation and adaptive importing

Before importing, the process verifies the existence of a World and a Group for both DB-views and Grids.

• If a World and a Group exist, the grid and view are imported under the existing structure.

• If a World and a Group do not exist, the files are processed to automatically create the required World and Group in the target database.