Forum Replies Created
-
AuthorPosts
-
July 8, 2024 at 6:34 am in reply to: Elastic report different default DateTime format for Excel #14906
kcks66
ParticipantHi Mikhail,
Can I change from short date and time to long date and time in Elastic Report?
July 8, 2024 at 6:32 am in reply to: Elastic report different default DateTime format for Excel #14905kcks66
ParticipantJuly 4, 2024 at 1:25 pm in reply to: Elastic report different default DateTime format for Excel #14885kcks66
ParticipantHi Mikhail,
I change the culture from original en-GB to many such as en-US, en-SG, en-MY, etc. Somehow I can get is [7/2/2024 10:00:00 AM]. I still couldn’t get [Tue, 2 Jul 2024 10:00:00 AM].
If I manually change the DateTime inside Excel Format Cell by using custom code [ddd, d mmm yyyy hh:mm:ss AM/PM], it worked.
Pls advice for can I use something like [ddd, d mmm yyyy hh:mm:ss AM/PM] into Rapid SCADA Administrator application to make it happen?
Thank you.
July 4, 2024 at 3:13 am in reply to: Elastic report different default DateTime format for Excel #14873kcks66
ParticipantHi Mikhail,
Pls advice for which file or location contain the culture or locale setting?
Thank you.kcks66
Participantkcks66
Participantkcks66
Participantkcks66
ParticipantHi Mikhail,
Got it. Thx.
kcks66
ParticipantHi Mikhail,
That’s great. I can read all the Voltage L1, L2 and L3 now.
Thank you.kcks66
ParticipantHi Mikhail,
I have no idea how to count slices. I screen shot as below:
So far around 850 days.
kcks66
ParticipantI try like this but no luck
kcks66
ParticipantHi Mikhail,
Could you give example of how to write in subitems for my case?
kcks66
ParticipantHi Mikhail,
I have 2688 channels.
kcks66
ParticipantHi Mikhail,
So far I had converting historical data from 01/01/2022 to up to date. One thing I noticed id historical data stored in PostgreSql database consumed very high storage size (350GB) compared to its DAT files (55GB)
PostgreSql database size:
https://ibb.co/93vtwPyDAT files size:
https://ibb.co/8dMxV05Is this normal?
Thank you.kcks66
ParticipantHi Mikhail,
After I several test and retest, I found out data lost is due to weak wifi signal from PC with RapidGate. I move the PC next to router and use LAN cable instead of wifi, problem solved.
As for why calculated channels always 0 is due to I enable the formula with 0. I disable the formula and problem solved.
Looks like the “converting DAT files to PostgreSql database” is success. Right now I just need to keep perform the uploading command and wait patiently until all done.
Thanks you for the support.
-
AuthorPosts