Imports - Intergraph Smart Completions - Intergraph Smart Completions Update 16 - Help - Hexagon

Intergraph Smart Completions Help (5.3.16)

Language
English
Product
Intergraph Smart Completions
Search by Category
Help
Smart Completions Version
5.3.16

The Imports manager bulk uploads engineering, plant and project information. The Imports Manager contains a list of pre-defined Import Types. They are identified by the Manager View, Name, and Description of the relevant Manager. An Import Log houses all import activity and associated files. Therefore, users can ensure

If Smart Completions is being used to manage multiple projects, make sure to add the project name as additional column. A project name must have {Project Name} – {Description} such as "1000 – Concentrator Expansion" and that project must already exist in the database.

Import file must meet the following criteria:

  • First row is the column headers

  • There is only one tab/ worksheet that contains data

  • Every asset tag should be given a discipline

  • Cells that have merged value + engineering unit (eu) must be separated into 2 separate columns

  • Cells that have multiple drawing numbers (i.e. 100-pid-100, 100-pid-101) must be comma separated when a list is requested

  • Save as (.xls) file not 2010 (.xlsx). The newer version hides cell formatting that can stop an import. Non-XML based excel files (.xls) are more importable

  • Importing with Microsoft Excel (.xls, .xlsx) format. We recommend using values only. Formulas and formatting can cause import errors.

  • Some fields require a "Summary Field," which is the combination of a field name and description.

Switchboard Navigation: Configuration > Imports

Imports1

Determine Collision behavior:

Collision behavior determines what will occur for records that previously exist in the database.

  1. Preserve: Inserts data into empty database fields and leaves existing data unchanged.

    • It Inserts database field only if field is empty and spreadsheet cell contains data.

    • It does not update if spreadsheet cell data matches database field.

    • It removes a record if the import view contains "date removed" and database field is empty.

    • It does not gets updated if the database triggers created data including inserts.

  2. Overwrite: Inserts data into empty database fields and updates existing data.

    • It does not update database field if spreadsheet cell is empty (must have NULL to remove existing data) Updates database field if there is spreadsheet data (empty cells are NULLs and are ignored).

    • It does not update if imported spreadsheet cell data matches database field.

    • It clears data only if NULL is typed in a cell (empty cells are rejected).

    • It removes a record if the import view contains "date removed" and database field is empty. If field is populated it will only update date removed.

    • Data that is created in the database by triggers can be overwritten, such as work flow state date and persons.

  3. Concatenate: Appends the existing data.

    • This option is not available for the majority of fields, you can use it for comments.

    • If you need to add additional statements to a comment field, Concatenate will leave the existing data and add the new comments after a comma.

  4. Numbers with Engineering Units (EU)

    • Numbers (data type) are expected.

    • If number and EU are included in cell, they are split and a new column gets added automatically.

    • NULL string clears numbers if collision behavior is Overwrite.

Imports2

Finish the Import:

If you have chosen to Validate the Data, an additional tab appears. It provides a file and a brief overview of the data to be imported. Red fields will fail to import. Purple fields indicate a database column that expects differently structured data. For instance, if a date field is expected when the files contains only text, the field shows as purple.

Clicking Finish begins the import. The size of the file and the complexity of the fields importing will determine the processing time. If it is a large file, and other users are active in the system, it will take longer to import. The system will provide an overview of what was imported. If all Affected Roles: 0 (as below), then the import has failed. Remember that some rows may show different totals, when there are empty fields included in the import.

Imports3