Get data from excel into DAT files

Forum Home Forums Understanding the Software Get data from excel into DAT files

Viewing 15 posts - 1 through 15 (of 21 total)
  • Author
    Posts
  • #7960
    Avatarkcks66
    Participant

    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:
    Screenshot-2021-01-10-at-11-32-03-AM

    Thank you.

    #7965
    MikhailMikhail
    Moderator

    Hi,

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

    #7969
    Avatarkcks66
    Participant

    Hi Mikhail,

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

    Thank you.

    #7987
    MikhailMikhail
    Moderator

    Hi,

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

    #8020
    Avatarkcks66
    Participant

    Hi Mikhail,

    I tried to manual generate value into Archive Data, as below:
    Generate-Data

    I can see the value is generated, as below:
    Archive

    However, I cannot see from the Chart, as below:
    Chart

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

    #8022
    Avatarmanjey73
    Participant

    Status write “2”

    #8026
    MikhailMikhail
    Moderator

    Status write “2”

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

    #8028
    Avatarkcks66
    Participant

    Hi Mikhail & manjey73,

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

    Screenshot-2021-01-15-at-1-43-56-PM

    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.

    #8029
    Avatarmanjey73
    Participant

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

    #8031
    MikhailMikhail
    Moderator

    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.

    #8037
    Avatarkcks66
    Participant

    Hi Mikhail,

    It is worked after I changed the ChartGap to 4,000 sec.
    Screenshot-2021-01-16-at-11-14-35-AM

    Thank you.

    #8038
    Avatarkcks66
    Participant

    Hi Mikhail,

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

    DAT-files

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

    #8041
    Avatarmanjey73
    Participant

    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

    #8046
    MikhailMikhail
    Moderator

    Yes. A new file will be created.

    #8054
    Avatarkcks66
    Participant

    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 1 week, 1 day ago by Avatarkcks66.
Viewing 15 posts - 1 through 15 (of 21 total)
  • You must be logged in to reply to this topic.