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 5 months ago by Mikhail.

[oley]

Let me get back to the topic. I tried using ScadaTestClient to enter a future value, and it works – the value appears in the table. However, once that specific time point is reached, it gets overwritten with a zero.

Another problem I’m having is with the channels showing the exchange price of energy, which are sometimes published with a delay – for example, the price for 12:00 is 100, but I receive that data at 12:05. SCADA records the data with the actual time – can I enter both the value and the time (12:00, 100) directly in SCADA?

[Mikhail]

You should check the historical archive options.
I suppose, it is possible to disable auto recoding data, so it will not be overwritten. And there is an option to pull timestamps to the period.

[Author]

Posts