[quintelosky]

Finally I created a program csv2postgres.exe to upload the data with timestamp because I don’t know with scada

[quintelosky]

Ok, I can read in demo mode, but I don’t understand

I can’t put the Timestamp (only 2001-01-01).

I have a meter in a water depot. A program, only one time per day, send the data like this:
2025-02-20 00:57:00,1.54
2025-02-20 00:58:00,1.33
2025-02-20 00:59:00,1.12
2025-02-20 01:00:00,1.23
2025-02-20 01:01:00,1.45
2025-02-20 01:01:00,1.67
2025-02-20 01:02:00,1.88
2025-02-20 01:03:00,1.93
2025-02-20 01:04:00,2.01
2025-02-20 01:05:00,2.08
…

If I can’t read timestamp, how I can send to postgre the data with the time? I want read the first line, upload the data to the database with the time, second line, …

I am very confused. I think the scada can’t do it

Other option is create a program to do that

[quintelosky]

Ok, solved, in real time you need add a new line in your .csv

Now I’m testing demo mode but nothing

[quintelosky]

Hi

I don’t know the problem:
https://ibb.co/qFdQXGYz

[quintelosky]

Hi
Can you show me how to do it?
I use moddbexport, but it is associated to a command.
I want a script that detect a new xxx.csv, load the data, and write the data in postgresql.
Thanks

[quintelosky]

Works fine 🙂

Many thanks, you are a genius

[quintelosky]

One question

In ‘Daily archive copy’ (I have associated to postgresql), How can I do to save the value at 11:00am? Always save at 00:00, and I want save 11:00am

Thanks

[quintelosky]

Hi

Not exactly.

I only need: when I press a button, launch a sql for a determinate cnl written values from other channel.

With that works for me:
https://ibb.co/4YKJ94J

I don’t know if exists other method to do the same

Many thanks

[quintelosky]

Hi

Sorry for the delay

The problem was I didn’t activate ‘Event archive’ in Archives

Now works fine

[quintelosky]

Works !!!

You are a genius

Many thanks

[quintelosky]

Hi

Ok, I changed the port but I continue with problems:

https://ibb.co/m4rjt9Y

[quintelosky]

Hi

Well, for the moment, I created a program that read eventsxxxx.dat and check if exists an event with ack requeriment but no ack.

The program create a file with the channel number name and the scada, in a new tag, check if a file with the name exists

With that I can know if an event is ack

https://ibb.co/fQV3v0L
https://ibb.co/yVxPVm4
https://ibb.co/v3KYCBC

[quintelosky]

Hi

I created a script to force channel status
https://ibb.co/hsf4K0b
https://ibb.co/LDwh6sP

And nothing. Is it possible that tag data type affect?
https://ibb.co/0sC86FC

If I create a new tag ‘calculated’ with formula Val(10436) and limits, works fine the new tag

Thanks

[quintelosky]

Hi

I don’t have the knowledge (and I don’t have time either)

Can you put this in the wish list? I think a function to check if a cnl have ack event (Where I can view the progress of the wish list?)

Many thanks Mikhail

[quintelosky]

If you need to check all existing events associated with a channel, it’s possible, but may slow down the performance.

And How can I do that?

Many thanks

[Author]

Posts