In OpenPlant PID CONNECT Edition, requirement is to import pipeline lists & its properties from excel file. Below wiki article will explain the procedure & key points to achieve such requirement.
In OpenPlant PID CONNECT Edition, to define a new pipeline we need to enter details (Plant Breakdown Structures & Properties) under Plant Breakdown Structure & Pipeline section of Standard Preference dialog, refer image below.
From OpenPlant PID CONNECT Edition Update 7, new feature as Import Instances has been introduced that allows to import pipeline & its properties from three different mode of database file.Import of instances can be achieved via Excel file (*.xls, *.xlsx), Access file (*.mdb, *.accdb) & SQLite (*.db, *.db3, *. SQLite, *.sqlite3). In this wiki article, we will cover the option via excel file. In OpenPlant PID CONNECT, Import Instances button is not enabled/available by default. We need to add the button to desired group.
To perform import tag instances properly (without any issues), please note below mentioned key-points.
Format: (Click here to download sample format)Header must be properties of PIPING_NETWORK_SYSTEM class. One column as _ECClassFamily has been added that differentiate between the type of pipelines.Sheet Names should be Class Name (PIPING_NETWORK_SYSTEM, PLANT_AREA etc.Reference Image
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.