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 from Excel

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

The following can be imported from an Excel spreadsheet using the same procedure.

In Electrical Designer:

  • Drawings

  • Installation Detail Drawings Data

  • Installation Detail Item Catalogue Data

In Electrical Wiring Manager:

  • Cable Gland Catalogue Data

  • Cable Gland Adaptor Catalogue Data

Note that other data can be imported from Excel spreadsheets, but the procedures in these cases are different from that described in this topic. Refer to the appropriate module documentation for details.

Note:
A grid cannot be imported into by more than one user a time. The grid will be locked to other users during the import process. However, if an import process is interrupted unexpectedly, for example, by a server problem, a power cut etc, the grid may remain locked. A facility is therefore provided in Security Manager to unlock grids locked by Excel import processes. Refer to the Security Manager documentation for details.

The 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 Electrical can identify the column's data. The column names are user definable but must not be duplicated. AVEVA Electrical will only import column data that contains a heading.

Furthermore, the Excel file must contain an identity column, e.g. the drawing number column for imports to the Drawing list. Advanced users can also map against a foreign key field, a field in each record that can be a primary key field of each record in the excel file. If mapping using this identity column, the identity column is ignored and records in the database are searched and updated based on the foreign key field.

Once an Excel spreadsheet is selected for import, users must 'map' each Excel column name (heading) to an AVEVA Electrical database field using the AVEVA Electrical import utility. Data can then be imported into AVEVA Electrical. 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 Electrical will show the differences between the imported data and the AVEVA Electrical data, allowing the user to accept/reject the proposed changes on a record by record (and field by field) basis. If the record does not exist in AVEVA Electrical and the user accepts the importation of the record, AVEVA Electrical will create a new record for that drawing or catalogue item.

The Import Procedure

  1. To import, open the appropriate grid. For example, if importing load data in Electrical Designer, open the Drawings grid.

  2. On the Manage Tab, click From Excel in the Import section.

  3. The Select excel workbook to import window is displayed:

  4. Browse for the spreadsheet that data is to be imported from and click Open. The Import Fields window is then displayed:

  5. The 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 Electrical and make changes to these mappings (if required).

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

  7. 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 AVEVA Electrical automatically adds the Field Name to the mapping list. The user can select a different field from the mapping list if required.

  8. Selecting the New button in the previous window displays Mapping Name and Description fields and changes the New button to Save.

  9. Once the details for the mapping have been entered, click Save. The mappings will be saved and Saved Mappings drop down will have the newly added mapping name appended to it.

    Note:
    It is not compulsory to save the mappings to import data, data can also be imported by just clicking on the Import button at any time. However it is useful to save the mappings if an import with those mappings is to be performed multiple times.

  10. To proceed with the import of Excel data, click Import.

  11. The Import Options window is then displayed. This is used to specify whether records are to be imported one by one (Process each Tag and Show Differences one by one) or in a batch (Batch Process all Tags and Show Differences at end).

  12. If the batch option is selected all records are processed together and a differences report is displayed when this process is complete, enabling users to accept or reject each change. If the one by one option is selected, a differences report for each record is displayed before the next record is processed.

  13. If import mapping are being tested, the Process each Tag and Show Differences one by one option is recommended.

  14. Once the required option has been selected, AVEVA Electrical will go ahead and process the data. The Import Differences window is displayed either once for all differences or multiple times for each record, as explained above.:

  15. The Import Differences window shows the differences between AVEVA Electrical data and proposed (imported Excel) data.

  16. To accept the changes either, select individual field data by clicking Accept checkbox for each.

  17. Alternatively, select the Accept All checkbox at the top of this window. All Accept checkboxes will then be checked (individual records may then be unchecked if required).

  18. To save the checked (accepted) data, click Save.

  19. If the Batch Process all Tags and Show Differences at end option was selected, the process is then complete.

  20. If the Process each Tag and Show Differences one by one option was selected, AVEVA Electrical will then proceed to the next tag record to be imported and display the differences in the Import Differences window.

  21. To cancel any import for the current tag record, click Close. AVEVA Electrical will then proceed to the next record to be Imported.

    Note:
    To cancel all further importing, click Stop Import.

  22. Once the import procedure is complete, an Import Log window will be displayed, in which details of the import are displayed (records successfully imported, errors, warning etc.).

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