Forum Home › Forums › Understanding the Software › Export data to XML
- This topic has 16 replies, 2 voices, and was last updated 2 months, 2 weeks ago by Mikhail.
March 10, 2023 at 9:34 am #12203
How can I export the data to XML? I want to have all the data that provides the scada on my pc.March 13, 2023 at 8:59 am #12224
To export historical data from Rapid SCADA to XML, a converter application should be developed. Another method is export PostgreSQL archive as written here.March 13, 2023 at 11:40 am #12226
Ok, thank you. And how can I export the data to a db every 15 minutes?March 14, 2023 at 9:18 am #12228
– 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 runMarch 14, 2023 at 10:43 am #12230
Thanks, and is it possible do it with mysql?March 15, 2023 at 8:32 am #12235
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.March 17, 2023 at 8:30 am #12251
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.March 17, 2023 at 10:28 am #12256
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.March 17, 2023 at 10:29 am #12257
PostgreSQL is the main DBMS for Rapid SCADA. Therefore, there are special features for this database.March 17, 2023 at 10:31 am #12258
And my last question
Ask as many questions as needed.March 21, 2023 at 7:38 am #12272
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.March 21, 2023 at 8:23 am #12273
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.March 21, 2023 at 8:26 am #12274
See the examples:
https://ibb.co/0YLTsS4March 22, 2023 at 8:19 am #12281
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?March 22, 2023 at 1:25 pm #12283
It depends on the error.
- You must be logged in to reply to this topic.