Import Signals from Excel

Signal numbers for terminal strip, device and I/O module terminals can be created or updated by importing them 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: Area Path, Area, Parent Equipment Number, Terminal Number, Terminal Description, Left or Right, and Signal Number.

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.

Notes: If a terminal is included in the spreadsheet with a blank signal number cell, this will result in the signal number associated with that terminal (if there is one) being deleted by the import.

If it is not intended that the signal number associated with a terminal is to be created or changed, it should be not be included in the import source spreadsheet.