Export data to XML

[feltduck]

Hi,
How can I export the data to XML? I want to have all the data that provides the scada on my pc.

[Mikhail]

Hi,
To export historical data from Rapid SCADA to XML, a converter application should be developed. Another method is export PostgreSQL archive as written here.

[feltduck]

Ok, thank you. And how can I export the data to a db every 15 minutes?

[Mikhail]

In Administrator:
– Open Server – Archives
– Activate the MinCopy archive and configure its options
– Install PostgreSQL and create a database rapid_scada with user postgres and password postgres. You can change password in Config\ScadaInstanceConfig.xml
– Upload the project to run

[feltduck]

Thanks, and is it possible do it with mysql?

[Mikhail]

To export data to MySQL, use the Export DB module, located in Server – Modules.
I don’t know if MySQL supports XML functions like Postgres.

[feltduck]

Thank you. And my last question is how can I configure the data that I want to store?
By default the SCADA is storing channel number, timesamp, value and status and I want to store the code and name too.

[Mikhail]

You should create your own stored procedures that fill code and name and use them in the Export to DB module. However, it is not optimal.
In case of using PostgreSQL, you can upload the project to the database, so you can find channel code and name by its ID.

[Mikhail]

PostgreSQL is the main DBMS for Rapid SCADA. Therefore, there are special features for this database.

[Mikhail]

And my last question

Ask as many questions as needed.

[feltduck]

Hi,
I’m using PostgreSQL and I’m having the same problem. I don’t know how to configure the data that I want to store. As i said before, by default is storing all the channel numbers, timestamp, values and status. I would like to choose the channels, and create some new rows.

[Mikhail]

Hi,
If you use PostgreSQL archive that is configured on Server – Archives form in the Administrator app, database tables are created automatically. You can define archive mask for channels to store only required channels. To get channel properties and other entities in the database, configure a deployment profile based on PostgreSQL, and upload the configuration database to PostgreSQL.

If you need to use your own database model, you should choose Export to DB module with the supported database (PostgreSQL, MySQL, MSSQL or Oracle). The available variables are specified on the module configuration form.

[Mikhail]

See the examples:
https://ibb.co/yyKJqH1
https://ibb.co/Qv69sbr
https://ibb.co/0YLTsS4

[feltduck]

Hi,
I’m having an issue when I try to connect to a PostgreSQL remote server.
Do i have to modify Config\ScadaInstanceConfig.xml with my configuration?

[Mikhail]

Hi,
It depends on the error.

[Author]

Posts