question

jsmvanwyk avatar image
jsmvanwyk asked

Missing data when downloading VRM data

Good day

I've noticed since the system now when you download multiple months of kWh data from the portal that it splits the files into different files. I've noticed also that it appears to lose one "timestamp" consistently. If the previous file would end in say 21:00 then the new file should begin in 21:15, but every new file begins 21:30, thus is the data missing of 21:15. And each subsequent file has the same line missing.





vrm advanced
1 comment
2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

Thanks for the bug report @jsmvanwyk - I’ll pass it on to the VRM team.
0 Likes 0 ·
2 Answers
lucian avatar image
lucian answered ·

Hi, I'm from the VRM team.

Could you please provide me with the VRM url of the installation and the period that you tried exporting?

Kind regards,
Lucian

2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

jochenku avatar image
jochenku answered ·

Dear VRM team,

I'd like to revive this old thread for a question.

When exporting data from VRM the system generates a line in the file for every 15 minutes of data, but only if at least any of the applicable columns contains any data. If for example during the night there is no consumption, production, etc. during any one 15 minute periode, the line is missing in the export.

This is quite problematic for further use of this data as it leads to inconsistent length of data set. A regular day would consist of 24*4 = 96 lines, but unevitably some days wil have 92, other 89 and so on.

It would be far more useful to have lines only containing zeroews (or even blank cells) than missing lines.

Is there any specific reason you chose to omit the lines?

Thanks a lot and best regards, Jochen

2 |3000

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

Related Resources

Additional resources still need to be added for this topic