Entering future data

[oley]

Hi,

I work with future data, such as:
– next-day energy prices
– future power constraints
The data is available in a database, and I retrieve it in real time using DrvDbImport.
Is it possible to save future data for some channels?

[manjey73]

– Will you have yesterday’s soup?
– Yes, of course.
– Then come back tomorrow. 🙂

In order to write into the future, this future probably needs to be created. You can’t do this with scripts like that. It also doesn’t seem to be possible to read database data using scripts. But is it possible to rewrite the channel data all the time so that these values will be relevant tomorrow?

[oley]

Hi,

My example isn’t made up: the energy exchange publishes prices for the entire next 24 hours. I already have tomorrow’s prices and am entering them into the database:
0:00-1:00 100
1:00-1:00 500
…
23:00-24:00 333

Now I’m querying the database constantly, comparing the time to the current time, but the simplest solution would be to once enter data with future times into the channel.
I wouldn’t burden the system with queries, and I’d see future data in the table.

[Mikhail]

Hi,

As a first step, try writing historical data to the future using ScadaTestClient.
If data successfully saved and displayed, then we can think how to read them by a driver.

• This reply was modified 1 day, 6 hours ago by Mikhail.

[Author]

Posts