I have just realised that most of my rrd4j databases have a “LAST” consolidation function. This is normal as they were created when the items were numeric type (without quantity).
Is it possible to modify the consolidation function using AVERAGE? Of course the old consolidations will have an incorrect value but at least the new ones will be correct.
If possible automatically for all quantity type items.
According to the docs, plain number items use LAST but Items with dimensions use AVERAGE.
When you added dimensions to the Items, that should have moved those items to the default_quantifiable config.
If it didn’t change the function when you changed the item type I’m guessing you have your answer and it’s “no”. You’d have to delete the old file and have rrd4j recreate it, but you’ll lose your old data off course.
If rrd4j inspector won’t let you do it, there is almost certainly a technical reason chasing it is not supported.
As for importing, there are several scripts and tutorials posted around the OH 3.0 release time frame showing how to migrate data from InfluxDB to rrd4j using OH’s REST API. You could use that but you’ll have to create a new Item with a different name to migrate the data to.
I’ll also not that your old data will already be kind of wing anyway. It might be better to start over instead of keeping the wing data around. Wrong can be worse than no data in most cases.
I have seen a few tools during my research on the forum but none of them really suited my needs and I know almost nothing about java programming. But with oh api I should get out of it.
I’m still surprised not to find any tools to export/import a rrd4j database.