Forum Home › Forums › Understanding the Software › Export data to XML
- This topic has 16 replies, 2 voices, and was last updated 6 months ago by
Mikhail.
-
AuthorPosts
-
March 10, 2023 at 9:34 am #12203
feltduck
ParticipantHi,
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 #12224Mikhail
ModeratorHi,
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 #12226feltduck
ParticipantOk, thank you. And how can I export the data to a db every 15 minutes?
March 14, 2023 at 9:18 am #12228Mikhail
ModeratorIn 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 runMarch 14, 2023 at 10:43 am #12230feltduck
ParticipantThanks, and is it possible do it with mysql?
March 15, 2023 at 8:32 am #12235Mikhail
ModeratorTo 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 #12251feltduck
ParticipantThank 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 #12256Mikhail
ModeratorYou 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 #12257Mikhail
ModeratorPostgreSQL is the main DBMS for Rapid SCADA. Therefore, there are special features for this database.
March 17, 2023 at 10:31 am #12258Mikhail
ModeratorAnd my last question
Ask as many questions as needed.
March 21, 2023 at 7:38 am #12272feltduck
ParticipantHi,
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 #12273Mikhail
ModeratorHi,
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 #12274Mikhail
ModeratorSee the examples:
https://ibb.co/yyKJqH1
https://ibb.co/Qv69sbr
https://ibb.co/0YLTsS4March 22, 2023 at 8:19 am #12281feltduck
ParticipantHi,
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 #12283Mikhail
ModeratorHi,
It depends on the error. -
AuthorPosts
- You must be logged in to reply to this topic.