Import Catalog Cables from Excel

Catalog cables can be imported 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 an identity column containing the Catalog Number or Catalog Id of each cable. It must also include Group Type, Number of Groups, Group Screen Required, Overall Screen Required and Earth Core 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 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.

1. Open the Cable Catalog. Select From Excel in the Import section of the Manage tab.

   The Cable Catalog Import window is then opened:

   

2. Click Browse and select the Excel file from which data is to be imported.

3. Click Next.

   

   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.

   The window shows all the columns in the Excel spreadsheet to be imported.

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).

   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 that needs 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. You can select a different field from the mapping list if required.