Get data from excel into DAT files

[kcks66]

Hi Mikhail,

Good day to you. I want to copy/import my historical data from excel into Rapid SCADA newly created real/calculated real channels. Then save into DAT files. Pls advice for how to do this.

My excel historical sample data:
https://ibb.co/rtSkxZ9

Thank you.

[Mikhail]

Hi,

A utility should be developed to import data. Otherwise, only manual input one by one value is available.

[kcks66]

Hi Mikhail,

I could try the manual input one by one value method. Pls advice for how to do it?

Thank you.

[Mikhail]

Hi,

Just find in Administrator – Server – Generator. Using Generator you can set any value of any input channel.

[kcks66]

Hi Mikhail,

I tried to manual generate value into Archive Data, as below:
https://ibb.co/vXMytQh

I can see the value is generated, as below:
https://ibb.co/8rfRVbz

However, I cannot see from the Chart, as below:
https://ibb.co/VMVH7Kn

Is there anything I missed out? Pls advice and thank you.

[manjey73]

Status write “2”

[Mikhail]

Status write “2”

Or any other positive status. All available statuses are listed in the Event types table.

[kcks66]

Hi Mikhail & manjey73,

I succeed generated value and show on Chart after Status wrote 2.

https://ibb.co/bPNCt3w

There were one value generated at 00:00 and another value generated at 01:00. Is there any possibility to join the line in between them?

Thank you.

[manjey73]

Mikhail promised to implement this in the next version of Scada. Now you can try using Grafana for these purposes

[Mikhail]

The is a parameter of Webstation, named Chart Gap. It defined time period that is connected by a line. You should create data points more often than parameter value.

[kcks66]

Hi Mikhail,

It is worked after I changed the ChartGap to 4,000 sec.
https://ibb.co/R2LZXkB

Thank you.

[kcks66]

Hi Mikhail,

I have new question to ask; can I generate value into new DAT file with date earlier than recorded?

https://ibb.co/G0XVw6M

I want to generate value into channels for date 2018 Jan 1 as example.
Thank you.

[manjey73]

If you create the parameter in the same way as you checked this example, the file will be created ? If yes, try using the API

[Mikhail]

Yes. A new file will be created.

[kcks66]

Hi Mikhail,

I retry many times by using the Server Generator. But no new file is created. Pls advice and thank you.

• This reply was modified 4 years, 12 months ago by kcks66.

[Author]

Posts