Problem Description

In OpenPlant PID, user wants to modify tag numbers in exported Excel sheet and import it back to the Data Manager. In this article, steps are defined on How to import EXCEL modified tags in Data Manager.

Step to Resolve

1. Launch Data Manager.
   
   
2. Expand Views and select any View. Here, Equipment list View.
   
   
   
   
3. Go to File-> Export, select Access , Excel and click OK.
   
   
   
   
   
   
4. Save your Excel Worksheet. (You can define path location to save this file), Here, we are saving it in Plant V8i.
   
   
   
   
5. Select View from the list. Here, Equipment List, click OK and minimize Data Manager.
   
   
   
   
   
   
6. Open saved excel sheet (EQUIP.xls)
   
   
   
   
7. Make changes in required field. Here we are defining changes in Description (EDESC) and save the file.
   
   
   
   Note: Column name from Excel sheet should match with Data Manager Field
   
   
8. Open Data Manager, go to File -> Import ->Tagged data and select Access, Excel
   
   
   
   
   
   
9. Select EQUIP.xls from the location, select Open and click OK
   
   
   
   
   
   
10. Verify Description in Equipment List.
    
    

See Also:

How to define color for Manual Annotation same as Default Annotation

Applies To Product(s): OpenPlant PID Version(s): 08.11.10.xxx (SS5) | 08.11.11.xxx(SS6) Environment: Windows 7/8.1/10 (64 bit) Area: Customization Subarea: Dgnlib…

Last edited over 5 years ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki