Background

The option to persist project data inside an iModel in PlantSight as an alternative to a SQL Server database is available which provides the following benefits:

• Facilitates distributed engineering workflows making it possible for users from different offices to easily collaborate and perform cable routing on the same project.
• No SQL Server database is required which means less IT maintenance to administrate projects.

Steps to Accomplish

1. In the OpenPlant Project Administrator CONNECT Edition, Create a New WorkSet.
   Enable Bentley Raceway and Cable Management for the WorkSet under Product Name in the OpenPlant WorkSet Creation Wizard dialog.
   
   
2. In the OpenPlant Project Administrator CONNECT Edition go to CONNECT Services Tab and click PlantSight.
   
   The PlantSight Projects Portal webpage opens where you can launch PlantSight Essentials Projects.
   
3. (Optional) If you don't already have connected Project, click Register. The Register a project webpage opens where you need to fill in all the Project Information
   
   
4. (Optional) Click Next.
   

   The Pick Template Tab opens where you need to select the Project Template. If the Project Template is already selected, click Skip and Register to proceed.

   The Project is registered successfully.

5. If you already have a Project created, then select the existing Project.
   
   
6. Go to OpenPlant Project Administrator CONNECT Edition, select your created WorkSet and then click Associate on the CONNECT Services ribbon Tab.
   
   The Select CONNECT Project to Associate dialog opens.
   
   
   
7. Select the Project and click Associate
   
   
8. Enter the below configuration variables in the BRCM.cfg file at the WorkSets level C:\ProgramData\Bentley\OpenPlant CONNECT Edition\Configuration\WorkSpaces\OpenPlantExample\WorkSets\(WorkSet Name)\Standards\OpenPlant\BRCM and save the file.
   • BRCM_DB_TYPE=iTwin
   • BRCM_ITWIN_IMODLE_NAME= iModelName
   • BRCM_ITWIN_CACHE_PATH=D:/BRCMiModelCache
     
     
9. Launch Bentley Raceway and Cable Management and select the above created WorkSet.
   
   
10. Click New File, enter File Name, and then click Save.
    The newly created file opens.
    
    
11. Place few raceways and then click Update Database on ribbon.
    
    
    
12. In the iModel Console, select your Project from Listing all Contexts, iModel from Listing iModels from Project, and the named version from Listing named versions from iModel.
    
    
13. Enter the command in the textbox and click Run.
    For example, Enter the following command select * from racewaycablingdb.raceway to see the database table. Similarly, you can see other database tables.
    
    You can check the record numbers by entering the following command select * from racewayscablingdb.userinfo in the textbox.
    

Note: Different record values are assigned to different users.

Comments or Corrections?

Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!