Problem Description

In the Plantsight environment, the issue can be seen that after exporting the excel from PlantSight, editing the excel file & importing back the same. Attached the error message below

This wiki article explains the steps on how to import the excel after doing changes in exported excel sheet.

Solution

1. Open the exported excel file & do the changes as desired. Refer the attached image below
   
   
   
   Please note that you can only edit the Properties & not the tag properties. In a simpler way, you can only edit the streams which is not in bold.
   
   
2. On the bottom of the sheet, right-click on the file name & click on unhide as shown
   
   
   
   
3. Click ok. Notice that EDM-MAPPING is selected as shown
   
   
   
   
4. The new document/sheet has been created named EDM-MAPPING in the same sheet.
   
   
5. Notice that, in that sheet, the i-Model ID is mentioned & along with it whatever the new changes have been edited in step-1. Delete all the changes from the same sheet. Refer the attached image below
   
   
   
   
6. Save the file.
   
   
7. Go to PlantSight Project & import the saved file.
   
   
   
   
8. Select the excel file from the location.
   
   
   
   
9. Notice that this time file is been successfully imported without any error message as shown
   
   
   
   
10. It’ll now move to unsaved changes.
    
    
11.  Save the unsaved changes & one can see the edited changes imported in the PlantSight successfully.
    
    
    

See Also

Still a Problem?

If above problem still persists, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround