Forum Home › Forums › Understanding the Software › Get data from excel into DAT files
- This topic has 24 replies, 3 voices, and was last updated 4 years, 7 months ago by
Mikhail.
-
AuthorPosts
-
January 18, 2021 at 3:41 am #8056
kcks66
ParticipantHi Manjey73,
Can you explain more about the API.
Thank you.January 18, 2021 at 7:30 am #8057
manjey73ParticipantFor 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 4 years, 12 months ago by
manjey73.
January 18, 2021 at 9:45 am #8065
MikhailModeratorHi,
In English website the same articles are located at https://rapidscada.org/category/articles/
January 19, 2021 at 3:16 am #8079kcks66
ParticipantHi 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.
-
This reply was modified 4 years, 12 months ago by
kcks66.
January 19, 2021 at 1:13 pm #8088
MikhailModeratorHi,
Good. Does this solve your issue?January 19, 2021 at 1:21 pm #8091kcks66
ParticipantHi Mikhail,
Yes. Thank you.
May 21, 2021 at 10:36 am #8980kcks66
ParticipantHi 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 4 years, 7 months ago by
kcks66.
May 21, 2021 at 1:07 pm #8983
MikhailModeratorHi,
It’s possible to develop a utility for a fee. Could you provide an example of your Excel file here or by email?
May 21, 2021 at 1:27 pm #8985kcks66
ParticipantHi Mikhail,
I forward the excel sample to your email.
June 7, 2021 at 9:28 am #9051 -
This reply was modified 4 years, 12 months ago by
-
AuthorPosts
- You must be logged in to reply to this topic.