Import Terminations from Excel

Terminations can be established by importing their details from an Excel spreadsheet.

The Excel spreadsheet must be in a simple tabular format (columns and rows) and the first row should contain unique column names (headings) so that AVEVA Instrumentation can identify the column's data. The column names are user definable but must not be duplicated. AVEVA Instrumentation will only import column data that contains a heading,

The Excel file must contain the following columns: Cable Number, Core Marking, Parent Equipment Number, Equipment Number, Terminal Marking, Terminal Description, and Left or Right.

Once an Excel spreadsheet is selected for import, you must 'map' each Excel column name (heading) to an AVEVA Instrumentation database field using the AVEVA Instrumentation import utility. Data can then be imported into AVEVA Instrumentation. The import utility will check if the identity column field exists in mappings.

While processing records to be imported, if a record already exists in the database AVEVA Instrumentation will show the differences between the imported data and the AVEVA Instrumentation data, allowing you to accept/reject the proposed changes on a record-by-record (and field-by-field) basis. If the record does not exist in AVEVA Instrumentation and you accept the importation of the record, AVEVA Instrumentation will create a new record for that drawing or catalog item.