Understanding the data exchange between Rapid Scada and MySQL

[TDE]

Hi,

Can you please tell me in details how to do the communication between Rapid Scada and MySQL?

Thanks.

[Mikhail]

Hi,
Please follow the manual.
In something is not clear, ask particular questions.

[TDE]

Hi,

I’m trying to be familiar with the functionality of the Export DB module with MySQL target. Actually I success to export data (as Input channel Query) from the rapid Scada to the MySQL DB but if I want to add another Input channel Query it does not work (Please see the screenshots links).
– https://sm.ms/image/rjcmi3tfvHKpdge
– https://s2.loli.net/2023/04/21/wZigCavME9IuASB.jpg

=============================================
=============================================

My goal is to create a button in a scheme for use it to give the command for beginning exporting data to the mySQL DB

Can you please help me with these issues.

Thanks.

[Mikhail]

Hi,
If you need to write data to DB on button click, probably, you should try DB Import Driver (instead of DB Export Module). That driver can write data on command.
The driver library is DrvDbImport.dll

[Mikhail]

If the module does not work as expected, check the module log file.

[hethongscada62]

Dear Mr.Mikhail,
My testing Rapid Scada project for 1 subject is running perfectly. Now i will build a project for more 5 subjects. For example: 1 center office + 5 warehouses. These subjects are located in difference places. The structure of this project will be created:
– One servers will need where installs a main instance
– 5 communicators where will install 5 communicator
Could you advise me more in detail to build it?
Thanks and best regards
Han Hoang

[Mikhail]

Dear Mr. Han,

Please create a new topic to discuss your question, because the current topic is about MySQL data exchange.

[hethongscada62]

Dear Mr.Mikhail,
How to create a new topic?
Thanks

[Mikhail]

Navigate to a subforum, for example, this one. Scroll the page down to find a text field.

[TDE]

Hi Mikhail,
I tried to export dat and this what I got in the log file.
– https://drive.google.com/file/d/1gi_JjMaGDyFrxh_K-FtEKdV9mQ91AJ5K/view?usp=share_link
– https://drive.google.com/file/d/1EEkZAHTkq6wNCpMeZE2RerU91Y4x0S0-/view?usp=share_link
– https://drive.google.com/file/d/1x66CKndARGgKq5mDKDFpcEVlBGn-sFtt/view?usp=share_link
– https://drive.google.com/file/d/1aOcc5lbmhFD5DNOb0uFhOB4iIEFWfOwt/view?usp=share_link

Can u tell me how to solve this problem please.

Thanks

[Mikhail]

Hi,

This error means that the events already exist in the database. For some reason you have exported the same events again.

[Author]

Posts