Data Exporting

[KeanoC]

Good morning, Soon I will be setting up a MySQL database for our company to automatically export data into a pivot table on excel so we can keep track of our electrical use more efficiently.

However I’ve been wondering how far back can you go in terms of data. One of the previouse posts I read said rapid only saves the previouse 24 hours. Would it then be possible to export the data automatically every 24 hours to our database and then import it into our excel spreadsheet to better look at the data?

[Mikhail]

Hello,
You can store data for any time dept.
Consider using PostgreSQL instead of MySQL, because Rapid SCADA includes native support of PostgreSQL. Export to MySQL also supported, but more features are available for PostgreSQL.

[Mikhail]

You can use both MySQL and PostgreSQL in parallel to compare.

[KeanoC]

Ok great thanks. I appreciate the help.

[KeanoC]

Good afternoon I have setup my database now on MySql Workbench and linked it to the export module but my data does not seem to be exporting, how can I set it up to automatically export to mySQL table?

[Mikhail]

Hello,
Please provide screenshots of the module settings and logs.

[KeanoC]

Where can I find the settings logs?

Here is my PostgreSQL setup
https://imgur.com/a/rqYdt01
https://imgur.com/a/DNvDMp9 (Removed the password to the db)

And here is my mySQL setup
https://imgur.com/a/YgCN7ub
https://imgur.com/a/LKLlTFS

Greetings
Keano

[Mikhail]

Take the correct scripts from here.
All logs can be viewed in the Administrator apps. Click the drop down list and select Modules logs.

[KeanoC]

Good Morning

Please let me know if this is what your looking for ?
Logs File

[KeanoC]

Also must I paste that script in the sql queries area in the administrator program or does that script go directly into postgreSQL?

[Mikhail]

Hello,
The required logs are https://ibb.co/NC0PZ49
Paste the SQL scripts using the module configuration interface that is available in the Administrator app.

[Mikhail]

Module UI https://ibb.co/yRFTPCx

[KeanoC]

I dont have that in my program.
https://imgur.com/a/0OT0Q2S this is how mine looks

[Mikhail]

Navigate to Instances – Default – Server – Modules – ModDbExport.
ModDbExport should be activated.

[KeanoC]

It is active right over here
https://imgur.com/a/FpvCADF
I think their might be something wrong with my connection am I supposed to do something on the postgre side of things to get the connection correct? Ive only made the database and the password and those kinda things and looked at the connection details ofc.

[Author]

Posts