Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Electrical

TABLE OF CONTENTS

Import Cables from Excel

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedAug 08, 2025
  • 5 minute read

Electrical Wiring Manager supports importing of Cables into the Electrical 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.

The Excel Spreadsheet

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

  • Since Electrical Wiring Manager Cables have several user properties (including user defined property fields) users 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 Catalogue Number (its catalogue definition) already exists in the Electrical Wiring Manager Cable Catalogue since the catalogue defines physical properties such as the core arrangement (number of cores, pairs etc. including shielding, core size, core markings/colours etc.). In addition a cable cannot be imported if its 'From' and 'To' end Equipment Numbers/Tag Nos do not exist in the Electrical Wiring Manager Equipment List.

  • 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 Electrical Wiring Manager can identify the column's data to enable 'mapping' to Electrical Wiring Manager database fields.

  • The column names are user definable but must not be duplicated. Electrical 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 Catalogue No, From and To.

  • Once an Excel Worksheet is selected for import, users must 'map' each Excel column name (heading) to an Wiring Manager database field using the Electrical Wiring Manager import utility. Then data can be imported into Electrical 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 Electrical Wiring Manager will show the differences between the imported data and the Electrical Wiring Manager data, allowing the user to accept/reject the proposed changes on a record by record (and field by field) basis. If the Cable does not exist in Electrical Wiring Manager and the user accepts to import, Electrical Wiring Manager will create a new cable in the cable schedule including all its Catalogue properties including core configuration and core markings/colours based on the Catalogue No specified in the Excel data.

The Import Procedure

  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.

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

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

  6. To map an Excel Column to an AVEVA Electrical database field click in the AVEVA Electrical Field field adjacent to the relevant Excel Column Name field, and select the required AVEVA Electrical field from a drop-down list. 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 Electrical automatically checks each Excel Column Name from the first row in the Excel worksheet against fields names in AVEVA Electrical Database (if not found then field Captions - as set in the Grid Manager). If a match is found then the application automatically adds the Field Name to the mapping list. The user can select a different field from the mapping list if required.

  7. Sets of column-field mappings can be saved and re-used for future imports. Define the required mappings as described above, then select the New command button. The Mapping Name and Description fields are then displayed and the New button is replaced by a Save button.

  8. Once the name and description for the mapping has been entered, click Save and the mappings will be saved and added to the Saved Mappings drop down.

  9. Data can also be imported by just clicking on the Import button. However it may save time to save the mappings if an import with those mappings is to be performed again.

  10. Once the mappings have been set up, click Next >.

  11. The import wizard will then perform data validation for the cables/data found in the Excel file. If a Catalogue Number in the Excel data does not exist in Wiring Manager, then the next wizard screen will list these and the cables associated with them in the file.

  12. The wizard will then list cables with valid catalogue numbers:

  13. If cables are invalid for importing because of other reasons, these reasons will be displayed in the Invalid Reason column.

  14. Select the (valid) cables to be imported by clicking their Select checkboxes (use the Select all checkbox if required), click Next.

  15. The import wizard will perform data validation for the cable ends ('From' and 'To') as defined in the Excel file. If there are any issues with the data validation, for example an Equipment Number in the Excel data does not exist in Electrical Wiring Manager, then the next wizard screen will show a list of issues. If there are no issues the wizard will show a list of valid cables ready for import once again.

  16. Click Import.

  17. The import wizard will then add any new Cables to the project, and update any existing cables as required.

Related Links
TitleResults for “How to create a CRG?”Also Available in