Persistence needed to be exported to excel

Hello:
OH2.4M8 in a docker container
Ubuntu 18.0.4 Server

I am using rrdj4 persistences for my Novelan heatpump. Displaying the values in graphs and so on is working. For further calculations which I want to do in Excel I would need to have the values exported to an Excel compatible form (CSV etc)

All my research is always leading to hints to use persistence instead of an excel export. But this is in my case not a solution.

Thanks for any help which is highly appreciated

You can try to use the rest api to read the rrd4j database. But not all data is saved, it will be compress. Maybe this Thread can give you a hint.

Hmm ok …
Is this addon somewhere on github? Maybe I can get an idea how to extract data from heatpump and do not take the detour through rrdj4 …

You can install the REST API docs from the Misc tab in PaoerUI. From there you can query rrd4j which will give you the values in JSON format. From there you will need to write your own script to convert the JSON to CSV. There is no CSV export built into OH or rrd4j.

Thanks rlkoshak

so far the best hint (at least for me)
Is it possible to ask more than one itemnames at once in one request?
In which format is the time displayed in json output?

No.

If it’s formatted it’s probably ISO 8601. If it’s just a big number it’s probably epoch.

Thanks rlkoshak,

after some hours of coding I wrote a python script which is doing the job!

Thanks