November 13, 2023 at 7:26 am #13624
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?November 13, 2023 at 9:35 am #13627
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.November 13, 2023 at 9:36 am #13628
You can use both MySQL and PostgreSQL in parallel to compare.November 13, 2023 at 9:51 am #13629
Ok great thanks. I appreciate the help.November 15, 2023 at 1:35 pm #13641
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?November 16, 2023 at 12:11 pm #13645
Please provide screenshots of the module settings and logs.November 17, 2023 at 11:45 am #13658November 17, 2023 at 1:39 pm #13659
Take the correct scripts from here.
All logs can be viewed in the Administrator apps. Click the drop down list and select Modules logs.November 20, 2023 at 5:59 am #13665November 20, 2023 at 6:20 am #13666
Also must I paste that script in the sql queries area in the administrator program or does that script go directly into postgreSQL?November 20, 2023 at 11:39 am #13672
The required logs are https://ibb.co/NC0PZ49
Paste the SQL scripts using the module configuration interface that is available in the Administrator app.November 20, 2023 at 11:41 am #13673November 21, 2023 at 6:06 am #13683
I dont have that in my program.
https://imgur.com/a/0OT0Q2S this is how mine looksNovember 21, 2023 at 11:28 am #13684
Navigate to Instances – Default – Server – Modules – ModDbExport.
ModDbExport should be activated.November 21, 2023 at 12:19 pm #13693
It is active right over here
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.
- You must be logged in to reply to this topic.