March 7, 2021 at 1:20 pm #8431
I have Modbus devices currently connected to RapidScada server and things seems to work fine where I can receiving data on Input channels and stored in the local db of the server.
Now we are trying to store the database current records to external MySQL database and for that I enabled the ModDBExport.dll module and set it up. So far I can manually export the data of the Current Data using the blue Up Arrow only.
How to let this current data auto written to the MySQL db without manual export?
I’m using the SQL statement from the Current Data template as described in RS documentation.
The MySQL log file .log and .txt of RS is indicating that the connection is fine to the DB and export is succeeding when performing manual insert.
What I’m missing here?
March 8, 2021 at 9:33 am #8438
- This topic was modified 1 month, 1 week ago by Mikhail.
SQL requests defined in the module settings are executed when new data are passed from Communicator to Server app.
Please provide links to the screenshots of the module settings and copy logs here. I can check them.March 9, 2021 at 5:49 am #8447
I attached to you all the screenshots of the current setup in this link:
Some facts about our setup:
– I’m just reading input registers from the modbus device, so only input channels are configured, hence not output channels or commands.
– When I do manual export to the data from the ModDBExport.dll properties, I got the current data dumped to the MySQL db on the cnldata table.
– I’m using root user on mysql db and the db is living on the same RapidScada machine.
Appreciate your support
Best.March 9, 2021 at 1:40 pm #8454
You settings look correct. If you clean up the DB and restart SCADA, what do you get in ModDBExport.log and ModDBExport.txt ?March 9, 2021 at 1:42 pm #8455
If you did not create output channels, all the records you have in MySQL were created automatically, not because of manual export.March 9, 2021 at 1:53 pm #8457
Here is the content of the ModDBExport.log
2021-03-09 16:47:19 Module ModDBExport is stopped
2021-03-09 16:47:22 Start ModDBExport module
2021-03-09 16:49:07 Module ModDBExport is stopped
2021-03-09 16:49:10 Start ModDBExport module
Export Data Module
1. MySQL – 127.0.0.1; state: normal; in queue cur/arc/ev: 0/0/0; exported cur/arc/ev: 9/0/0; skipped cur/arc/ev: 0/0/0
And you are right, without the output channel after I restarted the service, data is dumped to the DB.
But still not real time input to the db.
What do you think?March 9, 2021 at 1:54 pm #8458
I mean the data is dumped to the db and datetime is the same for all records and never get updated or new data inserted.March 10, 2021 at 11:28 am #8473
Open your project in Administrator and find the Calculator. Send some values manually. Then check ModDBExport.txt: exported cur/arc/ev: 9/0/0; and check the database. Are there new data?March 10, 2021 at 11:42 am #8478
Open your project in Administrator and find the Calculator.
Sorry I’m new to RapidScada. I didn’t understand what is a Calculator? How to find it?
Do you mean generator? If yes, I found it, but I don’t see Channel in the list. Note that I have 9 input channels and 0 output channels in the Configuration Database -> System.March 11, 2021 at 2:23 pm #8489
Sorry, I mean Generator.
I don’t see Channel in the list
You can type any channel number.
- You must be logged in to reply to this topic.