[manjey73]

The timestamp in the csv file must correspond to UTC time so that the driver accepts this data as new and places the value in the channel.
Next, ModDbExport, seeing the channel change, should send the data to the database.
If I understand this mechanism correctly.

[manjey73]

I want a script that detect a new xxx.csv, load the data, and write the data in postgresql.

I’m not sure if the DrvCsvReader driver is capable of detecting new csv files. In addition, it requires a specific csv file structure.

If you do not know the name of the csv file, you will have to create a script in the system itself, for example, on bash on Linux and call it via crontab. Well, or through the Windows scheduler.
Rewrite or add information to a csv file that DrvCsvReader will understand and write the data to channels that will already be sent to the database using ModDbExport.
You need to understand the architecture of your csv files, how different they are in terms of the dataset, etc.

[manjey73]

Why not use the DbExport module in conjunction with the CSV reader driver?

[manjey73]

As far as we know, only critical bugs are supported for 5.8.4, and the last fix has been around for quite some time.
If possible, upgrade to 6.4 since version 5 is no longer being developed.

[manjey73]

The format must also be specified as a String.

[manjey73]

Are the variables in the PLC textual ?
Or what is it about? some kind of screen or documentation to understand?

[manjey73]

Another option is to create your own web page in which you will collect the necessary data and display it and connect it to the display as a third-party.

[manjey73]

Ah, then you need to develop your own Table plugin. And somehow connecting it is already from the category of development.

[manjey73]

In version 6, the entire default table is added at once – the Simulator example. But you can add individual elements from the device and put together a table from different devices, this is no different from version 5.

TableEditor

[manjey73]

In the input formula of the channel, you can check for an input value greater than 100 example
Cnl > 100 ? double.NaN : Cnl

Or write a more complex formula and add it to the Script tables and call it in the input formula.

Scripts & Formulas Documentation

[manjey73]

Send a channel to the double.NaN and you will see ---

[manjey73]

There are no built-in drivers for working with cameras (RTSP, ONVIF, etc.), but you can output your html page on the mnemonic to the Frame (see the top-up components of the diagrams). And use third-party repeaters of the stream from video cameras on the WEB.

I can give you a link to one Russian product that allows this, but I haven’t tried it myself yet.

[manjey73]

There is no support for IP cameras, you need an intermediate link in the form of a gateway from camera streams to the WEB.
You can display your own web windows in scada.
If that’s what you’re talking about.

[manjey73]

Explain what visibility/invisibility means to understand?
And what exactly did you mean by checking the camera?

You can show it in screenshots, for example, for understanding, if possible.

• This reply was modified 8 months ago by manjey73.

[manjey73]

In version 6.4.0.3, I changed the launch of my programs to tasks instead of threads

Now a logic error leads to the completion of the task without crashing the Server with an exception output to the log.

[Author]

Posts