Import I/O Allocations from Excel

Wiring Manager supports the importing of I/O Allocations (tag to channel assignment) from an Excel spreadsheet.

Important: Tags cannot be assigned to an I/O Module through importing unless the Tag No already exists in the Engineer Instrument List.

Prior to importing, the Excel Worksheet must be in a simple tabular format (columns and rows) and the first row should contain unique column names (headings) so that Wiring Manager can identify the column's data to enable 'mapping' to Wiring Manager database fields. The column names are user-definable but must not be duplicated. Wiring Manager will only import column data that contains a heading. Furthermore, the Excel file must contain the mandatory columns/data: Cabinet Name, I/O Module Name (or Tag), I/O module catalog number, Channel No and Tag No.

Since Wiring Manager I/O Modules have several user-definable property fields, you can also import additional data such as Rack, Slot, System, Chassis into those I/O module property fields by including that data in the Excel file being imported.

If the I/O Module Tag/Name does not exist Wiring Manager, will automatically create an I/O module with that Tag/Name in the Cabinet listed in the Excel workbook.

1. To import Excel I/O data, with any grid or view open, click I/O Allocations in the Import section of the Manage tab.

   The I/O Allocation Import window is then displayed:

   

2. Click Browse and locate the Excel Workbook file.

3. Click Next.

   The import wizard will display the following:

   

   In this screen of the wizard, you must map field in the Excel spreadsheet to AVEVA Instrumentation fields.

   Note: To minimize the possibility that data currently being worked on by another user may be affected by an import, a list of the users working on the current project is available from the UserCount link. The number of current users is displayed next to the link. This total includes the user performing the import.

4. Select an existing Field Mapping (if one for this Import type exists) from saved mappings drop down or use the automatic mappings created by AVEVA Instrumentation and make changes to these mappings (if required).

   The Excel Column Name fields display the names of the columns in the spreadsheet. The AVEVA Instrumentation Field fields displays the Instrumentation fields they are mapped to.

5. To map an Excel Column to an AVEVA Instrumentation database field, click in the AVEVA Instrumentation Field field adjacent to the relevant Excel Column Name field, and select the required AVEVA Instrumentation field from a drop-down list.

6. To exclude a field from the import, click Clear button in the grid against the field to be excluded, or select the blank entry from the mapping drop-down list.

   Note: AVEVA Instrumentation automatically checks each Excel Column Name from the first row in the Excel worksheet against fields names in AVEVA Instrumentation Database (if not found then field Captions, as set in the Grid Manager). If a match is found then AVEVA Instrumentation automatically adds the Field Name to the mapping list. The user can select a different field from the mapping list if required.