The 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 include:

• A column containing the Equipment Number.

• For major equipment it must also include Area Path, Area Number and Equipment Type columns.

• For components in must also include Parent Equipment Number, DIN Rail Number, Equipment Type, Catalog Number and Sequence columns.

• For terminals it must also include Parent Equipment Number, Marking and Sequence columns.

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 the user 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 the user accepts the importation of the record, AVEVA Instrumentation will create a new record for that drawing or catalog item.