Get data from excel into DAT files

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

Viewing 10 posts - 16 through 25 (of 25 total)
  • Author
    Posts
  • #8056
    kcks66
    Participant

    Hi Manjey73,

    Can you explain more about the API.
    Thank you.

    #8057
    manjey73
    Participant

    For some reason, the English site does not have this section or it is located in another place.

    https://rapidscada.ru/integration-with-rapid-scada/

    Use an online translator. Perhaps this will help you solve the problem of writing data from exel to Scada databases.

    • This reply was modified 3 years, 2 months ago by manjey73.
    #8065
    Mikhail
    Moderator

    Hi,

    In English website the same articles are located at https://rapidscada.org/category/articles/

    #8079
    kcks66
    Participant

    Hi Mikhail & Manjey73,

    I have no knowledge on the “Integration with Rapid SCADA” parts. However, I managed to manual generate value in new Achieve files.

    The setting is from the Saving Parameters. I increased the default 365 days to more, then it worked.

    https://ibb.co/bF7zmyX

    https://ibb.co/qmXqgkq

    • This reply was modified 3 years, 2 months ago by kcks66.
    #8088
    Mikhail
    Moderator

    Hi,
    Good. Does this solve your issue?

    #8091
    kcks66
    Participant

    Hi Mikhail,

    Yes. Thank you.

    #8980
    kcks66
    Participant

    Hi Mikhail,

    Previously I manually insert every month data (one month one data, from 2017 – 2020) into ArchiveDAT\Hour by using Generator. So far this method served me well.

    However, my project is getting more complicated as needed now; I need to import old data (one minute one data and one hour one data, from 2017 – 2020). I don’t think I can still use the manually insert by Generator way anymore.

    I remember you mention about an utility should be developed for this kind of massive job. I would like to explore now.

    Pls advice for how shall we start talking about the development of the utility.
    Thank you.

    • This reply was modified 2 years, 10 months ago by kcks66.
    #8983
    Mikhail
    Moderator

    Hi,

    It’s possible to develop a utility for a fee. Could you provide an example of your Excel file here or by email?

    #8985
    kcks66
    Participant

    Hi Mikhail,

    I forward the excel sample to your email.

    #9051
    Mikhail
    Moderator

    Hi,

    Great thanks for sponsorship the development of the utility that imports data from CSV to DAT! It is available for the community by this link.

Viewing 10 posts - 16 through 25 (of 25 total)
  • You must be logged in to reply to this topic.