PlantStruxure PES [V3.1 + SP1]: Store & Restore Parameter Values from SCADA
Goals and Symptoms
How to store and restore parameter values from SCADA in StruxureWare PE.
Facts and Changes
For General Purpose Libraries (GPL) in PES V3.1, values of the parameters like alarm, setpoints, PID controllers are filled from Supervision rather than from PES editors.
The parameters are filled from their genies by a user having proper level of privilege. The values will then rely into the Controller in the RAM memory.
PES GPL library is providing a native solution to manage those values in a Database. With this solution, user will be able to store, restore them from a database.
Causes and Fixes
GPL is providing a Genie (sgc_param) connected to some cicode. This genie which allow to display several lists of parameters with their actual value and stored values (in the Database). The
user is then able to download or upload these values from the controllers. Through the Genie it is then possible to store the current value of a parameter into a Database or to restore it into the Controller.
Step by Step Implementation through an example:
Example overview
Create a simple PES System having one temperature transmitter. Its value is alarmed on High, High Hgh, Low, Low Low threshold. Now, Create a Backup/Restore solution for the threshold setpoints using GPL native capability.
I. Step 1: Create the System Example
1. Create a simple system with one temperature transmitter. In the application explorer of your system, instantiate one $AnalogInput1 template. Name it TT01.
2. Check that the Analog Alarms option is selected. Result is below.
2. Check that the Analog Alarms option is selected. Result is below.
3. Create a Control Project ( Modicon Quantum or M340)
4. Assign your TT01 template in a section of your project
5. Generate the Control project. Result is below
4. Assign your TT01 template in a section of your project
5. Generate the Control project. Result is below
6. Create a Supervision project.
7. Assign TT01 template in the Supervision Project.
8. Create a page, edit and assign one of the TT01 genie inside.
9. Refine Global Supervision project and create a user role and profile (ex: maintenance) with privilege from 1 to 8.
10. Generate the Supervision project.
7. Assign TT01 template in the Supervision Project.
8. Create a page, edit and assign one of the TT01 genie inside.
9. Refine Global Supervision project and create a user role and profile (ex: maintenance) with privilege from 1 to 8.
10. Generate the Supervision project.
11. Create a topology we can use to test our solution. In our case we have created one station Node having one NIC (127.0.0.1 IP address) and including Vijeo Citect, Open Factory Server (OFS) and the Unity simulator.
12. In the project editor, add one executable to existing Control project and map it to the station node created.
Build the control project and add one executable to your existing Supervision project and map it to the station node.
Now, build the Supervision project, download it to hard drive and restore it in Vijeo Citect (VJC) 7.3.
Build the control project and add one executable to your existing Supervision project and map it to the station node.
Now, build the Supervision project, download it to hard drive and restore it in Vijeo Citect (VJC) 7.3.
II. Step 2: Create Database Content
1. The database used to store and retrieve data may be from a lot of different format like SQL, Excel.
This case is explained with Excel file format.
The advantage of excel file format is that it is easy to create and maintain.
The limitation is that Only one user can access at one time.
2. The database used to store the parameters must contains 3 tables with following fields
This case is explained with Excel file format.
The advantage of excel file format is that it is easy to create and maintain.
The limitation is that Only one user can access at one time.
2. The database used to store the parameters must contains 3 tables with following fields
3. Let’s start from the template given in the attachments: "Database ParametersTemplate.xls".
Notice that in the Excel file, Database tables are referring to 3 sheets (in the excel file).
Fields are referring to columns in each sheet.
Notice that in the Excel file, Database tables are referring to 3 sheets (in the excel file).
Fields are referring to columns in each sheet.
4. The purpose is now to fill the Excel file template with the parameters that user may want to manage in the database.
5. First ,organize the required parameters into different Lists.
In this case, the High Alarm and Low alarm parameter from the analog input are Medium severity level, while High High and Low Low alarm are High severity level.
It’s better to separate these two lists in order to ease the management for the user.
For that purpose, create two lists in the Database by creating them in the "definitions" table as shown below.
5. First ,organize the required parameters into different Lists.
In this case, the High Alarm and Low alarm parameter from the analog input are Medium severity level, while High High and Low Low alarm are High severity level.
It’s better to separate these two lists in order to ease the management for the user.
For that purpose, create two lists in the Database by creating them in the "definitions" table as shown below.
6. Notice that ,only, the NameID field and ShownName field are field in the example.
NameID: refers to the Name Identifier that will be associated to the Supervision Tags we want to store or retrieve
ShownName: refers to the name that will be displayed when you will select the different lists
7. Create the list of Tags, that user wants to manage in the database and fill their associated parameters.
For that purpose, open the Vijeo Citect dbf file having the tags or work into the Vijeo Citect editor.
The objective is to copy and paste the tag name and associated parameters in your excel file into "Parameterlist" sheet.
NameID: refers to the Name Identifier that will be associated to the Supervision Tags we want to store or retrieve
ShownName: refers to the name that will be displayed when you will select the different lists
7. Create the list of Tags, that user wants to manage in the database and fill their associated parameters.
For that purpose, open the Vijeo Citect dbf file having the tags or work into the Vijeo Citect editor.
The objective is to copy and paste the tag name and associated parameters in your excel file into "Parameterlist" sheet.
8. Below are the tags and associated parameters for the four alarm threshold set points taken in the example.
The following fields are used
NameID: NameId List that was created previously in "definitions" table
Tag name: Tag name of the variable coming from Vijeo Citect
Description: Description that will be displayed for this variable in the list
Tag value: Refers to the value stored in the database
Scalable: Indicates whether the value is scaled in the uploading and downloading process.
0: Not scalable and 1: Scalable.
Max: Maximum value that the parameter can take on.
Min: Minimum value that the parameter can take on.
EU: Engineering units that is shown when the display format is applied.
Now the database content is now ready to be used.
Tag name: Tag name of the variable coming from Vijeo Citect
Description: Description that will be displayed for this variable in the list
Tag value: Refers to the value stored in the database
Scalable: Indicates whether the value is scaled in the uploading and downloading process.
0: Not scalable and 1: Scalable.
Max: Maximum value that the parameter can take on.
Min: Minimum value that the parameter can take on.
EU: Engineering units that is shown when the display format is applied.
Now the database content is now ready to be used.
III. Step3: Connect Database to your supervision project
1.Below is a drawing summarizing the interaction between the genie (sgc_param coming from GPL library) managing the parameters list in PES through Cicode functions (Contained in sgc_parameter from the GPL library include project) and the Excel Database managed through an Excel ODBC driver.
2. User can now copy the created Excel file (Database) in the final desired location. In the example, the stored location is C:\Data.
3. Now create a connection between the Cicode function managing SQL request to the Excel file, using Excel ODBC driver.
4. Open the Control Panel from Windows (Start->• Control Panel).
In control Panel open Administrative tool.
The following dialog box appear
The following dialog box appear
5.Select Data Sources (ODBC). The following dialog box appear.
6. Select User DSN tab and click on the Add button to create our connection.
7. In the driver list select a Microsoft Excel driver.
The Data source name must be DSNParams. It is the one that the Cicode function will call to get access to the Database.
8. Click on the "Select Workbook" button and select the Excel file in the "C:\Data" location.
9. Select the Options button and untick the "Read Only" option.
IV.Step 4 : Deploy your System and use your Parameter Database.
Configuration of Excel file and ODBC driver is done. Now user can use the parameter lists.
1. From PES, deploy your Control project in the Unity simulator.
2. From Vijeo Citect run your supervision project and open the page that has been built.
This page has been built using the PES default template coming from the GPL library project (SGC_Include2).
3. User can open the parameter list Genie by selecting "Parameters" icon on"Tools" tab from the Menu at the top of the page.
4. Now check that the two recently created list are existing and containing the tags that user has defined.
5. If there is a need to perform actions like Upload, Download, save to disk and user have to log into the SCADA with proper privilege.
This example has been created with maintenance user and its possible to log into the SCADA using this identifier and execute all actions.
You will be then able to execute all these actions.
1. From PES, deploy your Control project in the Unity simulator.
2. From Vijeo Citect run your supervision project and open the page that has been built.
This page has been built using the PES default template coming from the GPL library project (SGC_Include2).
3. User can open the parameter list Genie by selecting "Parameters" icon on"Tools" tab from the Menu at the top of the page.
4. Now check that the two recently created list are existing and containing the tags that user has defined.
5. If there is a need to perform actions like Upload, Download, save to disk and user have to log into the SCADA with proper privilege.
This example has been created with maintenance user and its possible to log into the SCADA using this identifier and execute all actions.
You will be then able to execute all these actions.
Udgivet til: Schneider Electric Danmark
Brug for hjælp?
Produktvælger
Find hurtigt og nemt de rette produkter og det rette tilbehør til dine anvendelser.
Få et tilbud
Start din salgsforespørgsel online, så vil du blive kontaktet af en ekspert.
Find forhandler
Find den nærmeste Schneider Electric-distributør.
Hjælpecenter
Find supportressourcer til alle dine behov på ét sted.