Cable Sizing Import

To import cable sizing data from an Excel spreadsheet:

1. With the Cable Schedule list open, click Import from Cable Sizing in the Import section of the Manage tab.

2. The Cable Sizing Import wizard window is then displayed:

   

3. Click Browse to locate the file from which data is to be imported, then click Next >.

4. The wizard will show the following:

   

   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 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:
   The application 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.

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

   

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

   Note:
   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. On completion of mapping, click Next >.

11. If there any cable numbers in the file that are not present in the database, the following is then displayed:

    

12. The cable numbers not in the database are listed. They will not be imported.

13. Click Next >. The following is then displayed:

    

14. Check the checkboxes for the cables to be imported. Click the Select all checkbox to check all the checkboxes.

15. Click Next >. The following is then displayed:

    

16. The wizard lists those cable in the file for which data can be imported.

17. Click Import to carry out the import. The cable sizing data is then imported. The wizard displays details of the results of the import procedure:

    

18. In order to be imported, the details of a cable in the spreadsheet must match a catalogue cable. If the details of a cable in the spreadsheet match those of a different catalogue cable to that in the database, the catalogue cable of the cable in the database will be automatically changed to the one in the spreadsheet.

19. Click Close to exit the wizard.