Import Cables from Excel

Wiring Manager supports importing of Cables into the Wiring Manager Cable Schedule from an Excel spreadsheet. New cables can be imported, and existing cables updated in this way.

Note: Cables that are frozen or that are on a locked drum cannot be updated.

To import Cables the Excel file must contain the following information at a minimum: Cable No, Cable Catalog No and 'From' and 'To' end equipment tags.

Since Wiring Manager Cables have several user properties (including user defined property fields) you can also import additional data such as Length, Remarks, Notes into those cable property fields by including that data in the Excel file being imported.

Important: Cables cannot be imported unless the Cable Catalog Number (its catalog definition) already exists in the Wiring Manager Cable Catalog since the catalog defines physical properties such as the core arrangement (number of cores, pairs including shielding, core size, core markings/colors). In addition a cable cannot be imported if its 'From' and 'To' end Equipment Numbers/Tag Nos do not exist in the Wiring Manager Equipment 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 following mandatory columns/data: Cable No, Cable Catalog No, From and To.

Once an Excel Worksheet is formatted accordingly and selected for import, you must 'map' each Excel column name (heading) to an Wiring Manager database field using the Wiring Manager import utility. Then data can be imported into Wiring Manager. The import utility will check if mandatory columns exists in the Excel file and Mappings. While processing cables to be imported, if a Cable No. already exists in the database Wiring Manager will show the differences between the imported data and the Wiring Manager data, allowing you to accept/reject the proposed changes on a record by record (and field by field) basis. If the Cable does not exist in Wiring Manager and you accept to import, Wiring Manager will create a new cable in the cable schedule including all its Catalog properties including core configuration and core markings/colors based on the Catalog No specified in the Excel data.

Import Excel Cable Schedule Data

1. Open the Cable Schedule and click From Excel in the Import section of the Manage tab.

   This displays the Cable Schedule Import window as shown below:

   

2. Click Browse and locate the Excel Workbook file.

3. Click Next.

   The next window shows all the columns in the Excel spreadsheet to be imported. 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).

   

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

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

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