How do I download VRM energy data reporting

Question

question

P.H.J. Sibbing asked Jun 1, '23

How do I download VRM energy data reporting

statusreportlastmonth 5-2023-A.pdfdownload1-6-2023.pdf statusreportlastmonth 5-2023-A.pdfIn the VRM console there is a function of creating a report with the data collected/stored by Victron.

The only report i can generate is a currency and only as PDF.

What about energy values, KWH/Year-Month-Day-Hour per mesure point?

On the main panel you can chose/select a period, but the data can not be extracted from the site in a format, that can be used in other apllications.

FIMER (successor of Power-one and ABB), has a identical dashboard. The data which is visualised, can be exported in CSV format and stored and/or copied in another spreadsheet for further analysis.

Another FIMER option is to “generate “ a report for which a Http-Link is send each end-of-the-month for to be downloaded.

vrm advanced

clipboard01.jpg (328.4 KiB)

download1-6-2023.pdf (13.2 KiB)

statusreportlastmonth-5-2023-a.pdf (100.7 KiB)

2 |3000

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

Modifications Space

Node Red Space

Answer 1 · 2023-06-01T14:41:46Z

Guy Stewart (Victron Community Manager) answered · Jun 01, 2023 at 02:41 PM

Hi @P.H.J. Sibbing

It is possible to download every datapoint in VRM from the advanced page using the cloud download button.

img-5685.jpeg (351.1 KiB)

2

2 |3000

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

adu-prosper commented · May 10 at 03:06 AM

Hi @Guy Stewart (Victron Community Manager) , Suppose I have 50 sites on VRM, and I need to download a daily production report (with daily measurement points) for all sites in xlsx format. How can I do this?

1 ·

Guy Stewart (Victron Community Manager) ♦♦ adu-prosper commented · 6 days ago

Hi @Adu Prosper,

The answer to this depends on exactly what kind of data you want.

The most straight forward way is with this download feature on the installation overview page

You can then select a date range, and get the production data in an .XLS file.

This method is not (yet) an automated process. You will need to go into VRM and click buttons, OR set up an automated script on your end.

There is an open VRM feature request to schedule this automatically as part of the VRM interface, but there is no timeline to deliver that yet, and it is still very early so I would not expect it in 2024.

If you need something that is automated, then I would suggest the next best method would be via the VRM API.

The documentation for the VRM API is here. This method will require development effort on your side though, support from Victron is limited, and best accessed via the Modifications Community.

1 ·

cleanshot-2024-05-11-at-111540.jpg (175.3 KiB)

cleanshot-2024-05-11-at-111327.jpg (1.1 MiB)

Answer 2 · 2023-06-01T18:28:58Z

P.H.J. Sibbing answered · Jun 01, 2023 at 06:28 PM

With your answer, you can delete my question

2 |3000

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

Answer 3 · 2023-06-02T08:43:46Z

P.H.J. Sibbing answered · Jun 02, 2023 at 08:43 AM

Is there a manual ? or instruction video, because you have( i Think) to make custom widgets to extrac the relevant data as the amount given ( last month) is TOOO much to make a usefull analyses.

it's more for tracking a failure or error.

2 |3000

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

question