Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki How to Resolve the error while Importing the Excel back after editing in PlantSight Project.
    • Sign In
    • -OpenPlant | AutoPLANT Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • +OpenPlant Project Administrator CONNECT
        • -OpenPlant CONNECT Edition-PlantSight Integration
          • Fundamental of Tag Management using PlantSight Portal for OpenPlant CONNECT Update 9
          • [FAQ] - PlantSight
          • How to Convert IFC Format in PlantSight
          • How to Add New Associated Item Class for OpenPlant PID CONNECT Edition-PlantSight Integrated WorkSet
          • How to add PlantSight equipment Tag for MicroStation graphics
          • How to Change Measurement Unit in PlantSight Visualizer used in Measuring Element.
          • How to Clear Reserved Tags from OpenPlant in EDM
          • How to Create a new Role in the Project & Assign it to the User/Client.
          • How to create display rules for specified class in PlantSight Visualizer
          • How to Create Issue for Specified Component in Plantsight Visualizer
          • How to create saved view in PlantSight.
          • How to Enable Release Tag Services for PlantSight User
          • How to Fetch iModel Information Details for a PlantSight Integrated Workspace in OpenPlant Modeler Update 8
          • How to Generate Equipment Data-Sheet for Equipment in Engineering Data Manager
          • How to Perform Selective Check-in into OpenPlant Modeler CONNECT Edition
          • How to Place a Tag for Custom Equipment created in OpenPlant Modeler with reference to OpenPlant P&ID & Plantsight.
          • How to Push New Schema Changes to Already Provisioned PlantSight WorkSet for OpenPlant Modeler CONNECT Edition
          • How to Put Filter on Properties in Tag Browser Of Tag Management in Data Manger in PlantSight
          • How to Reference out the components by Volume OpenPlant Modeler
          • How to Resolve the error while Importing the Excel back after editing in PlantSight Project.
          • How to Resolve the issue of Miscellaneous Equipment in OpenPlant PID, which is not able to Check-in to Plantsight.
          • How to Show/Enlist Newly Added Derived Class in PlantSight Tag Management Portal
          • How to Solve the Error when the Tag is not able to Browse in OpenPlant Modeler/PID from Plantsight / Engineering Data Manager.
          • How to Turn-Off PlantSight Differences Dialog Upon Check-in OpenPlant 3D Model to PlantSight
          • How to Update Component Properties from Process Drawing to 3D Components in OpenPlant Modeler CONNECT Edition
          • How to Update Existing Schema Changes to Already Provisioned PlantSight Workset for OpenPlant Modeler CONNECT
          • How To Upload .pod File Format of Reality Data into iModel and view into it in PlantSight
          • How to use Bentley Template when creating PlantSight Project
          • To Fix Issue of OPPID Dgn throwing Work Offline Dialog box Eventhough Workset Associated to PlantSight
          • How to Create Folder in PlantSight Project Shared Files
          • How to hardcode UOM of properties in Advanced Query EDM
          • How to Integrate OpenPlant PID with OpenPlant Modeler Using PlantSight
          • How to Sync i.dgn to PlantSight
          • To Customize Query Results in Engineering Data Manager
          • To Show Tie-in in PlantSight Viewer
        • +OpenPlant Modeler v8i
        • +OpenPlant Isometrics Manager v8i
        • +OpenPlant Project Administrator v8i
        • +OpenPlant PID v8i
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • +OpenPlant Reporting v8i
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
        • How to get list of installed applications/programs on Windows Machine using Command Prompt.
        • How to get list of Windows Updates installed on the machine using Command Prompt.
        • How to Package WorkSpace to be Shareable to Users for OpenPlant Projects
        • How to find iModel.dgn file of another domain in PlantSight
        • To Clean Residual Files After Uninstalling OpenPlant
        • To Fix Dialog not Showing After Disconnecting Multiple Monitor Display
        • To Fix Error "A required privilege is not held by the client" When Generating External Reports
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
      • Your Feedback is important to us!
    • Learning Content for OpenPlant

     
     Questions about this article, topic, or product? Click here. 

    How to Resolve the error while Importing the Excel back after editing in PlantSight Project.


    Applies To 
    Product(s):  PlantSight
    Version(s):

    PS 5

    Environment:  Windows 8.1/10 (64-bit)
    Area:  Tag Management
    Subarea:  Import/Export Excel sheet.
    Original Author: Shubham Sawant, Bentley Product Advantage Group

    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

    How to Add Dimensional Unit to Added Property in OpenPlant Modeler CONNECT Edition
    Applies To Product(s): OpenPlant Modeler CONNECT Edition Version(s): 10.04.00.30+ Environment: Windows 7/8.1/10 (64-bit) Area: Customization Subarea: Pipeline…
    Last edited over 1 year ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki

    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

    • Excel
    • import
    • Export
    • error
    • Share
    • History
    • More
    • Cancel
    • Shubham Sawant Created by Bentley Colleague Shubham Sawant
    • When: Tue, Jul 27 2021 4:13 AM
    • Rahul Kumar Last revision by Bentley Colleague Rahul Kumar
    • When: Thu, Sep 1 2022 2:03 PM
    • Revisions: 2
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies