I have issue about database import (MYSQL)

[joey]

My project need to import data from mysql but we have a problem. If I fetch data from my database, communication log showed every thing fine no issue but in current data didn’t show anything. How to fix it, please help me. I’m stuck in this issue since last month. Appreciate sir.

[Mikhail]

Hello,
Please make a screenshot of a device data page in Communicator.

[joey]

https://drive.google.com/drive/folders/1uteJd2HU3g5HrylRSmkUUbrYLDCU4Klh?usp=sharing

[joey]

I’m not sure if this is the task you want. If you want more information please contact me again. Thank you so much.

[manjey73]

There is not a single channel on image1 that would read the Communicator, otherwise you would have a table with data in the Device 1 log of this type

[2] Energomera_301
------------------
Драйвер       : DrvIEC61107 6.2.0.5
Статус        : норма
Время сеанса  : 10.09.2024 14:58:00
Время команды : не определено

Сеансы  (всего / ошибок) : 739 / 0
Команды (всего / ошибок) : 0 / 0
Запросы (всего / ошибок) : 9607 / 0

Текущие данные
+-------+----------+-----------------+-----------------+---------+
| Номер | Код      | Наименование    |        Значение |   Канал |
+-------+----------+-----------------+-----------------+---------+
| ****************** Счетчик Энергомера CE301 ****************** |
+-------+----------+-----------------+-----------------+---------+
| 1     | serial   | Serial #        | 008841163127043 | 201-202 |
+-------+----------+-----------------+-----------------+---------+
| 2     | V_L1     | Voltage L1      |         231,241 |     203 |
+-------+----------+-----------------+-----------------+---------+
| 3     | V_L2     | Voltage L2      |         233,418 |     204 |
+-------+----------+-----------------+-----------------+---------+
| 4     | V_L3     | Voltage L3      |         213,466 |     205 |
+-------+----------+-----------------+-----------------+---------+
| 5     | Cur_L1   | Current L1      |          26,860 |     206 |
+-------+----------+-----------------+-----------------+---------+

[joey]

Can you explain, How to set channels so it can read the data in communicator

[manjey73]

Frankly, I do not know, I have never used this driver. You may have missed something in the settings or made them incorrectly.

[joey]

Is there a way for us to import a database from another driver?”

[manjey73]

There is another import driver from the database, but I don’t work with the database and I can’t tell how it works

https://rapidscada.net/store/Module/en/KpDbImportPlus

[joey]

I’ll try. Thank you so much.

[Mikhail]

Don’t forget to specify tags for a query. One tag per line.
It’s in the device properties.

• This reply was modified 1 year ago by Mikhail.

[joey]

Can I have an example of what you mean? I think i fill only sql command. I think i forgot something. Thank you.

[joey]

Do you mean the page in the image4 in the drive I shared? And what should I put in the tag?

• This reply was modified 1 year ago by joey.

[joey]

After I added the tag, I now have the table, but the values still haven’t appeared.

[Mikhail]

Do you mean the page in the image4 in the drive I shared? And what should I put in the tag?

Yes, image4.
Check this example https://ibb.co/ZMBdJBd

[Author]

Posts