10.07.00.32+
In OpenPlant Modeler CONNECT Edition, requirement is to populate properties field via external database file.
In OpenPlant Modeler CONNECT Edition, we have provision to fetch data from external database & populate against the properties of a class. In this wiki article, we will learn
For example, below provided image shows column name of database as PICK_LIST. In this exercise we will select SupportCode values & based on selection Area, TYPE and Ranking value should show against DISCIPLINE, TYPE & SEQ properties respectively for support class.
Data connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source= File Name of database: SupportList.mdbThis is the name of database file, in this exercise database file name is SupportList.mdbPath Location of database: _USTN_WORKSETROOTThis ask to point to location of database file, in this exercise database file is located as workset location, refer image below.Note: Make sure there is no space before _USTN_WORKSETROOT. SQL Select Statement: SELECT SupportCode,Area,TYPE,Ranking FROM PICK_LIST WHERE [Area] = 'Support' AND [TYPE] = 'Stock' ORDER BY [Ranking]
Property Mapping [0]Table Field Name: SupportCode EC Property Name: DEVICE_TYPE_CODEProperty Mapping [1]Table Field Name: AreaEC Property Name: DISCIPLINE
Property Mapping [2] Table Field Name: TYPE EC Property Name: TYPE
Property Mapping [3] Table Field Name: Ranking EC Property Name: SEQ
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