I recently migrated from file based configuration to a UI based configuration. I’ve been enjoying a lot of the UI benefits but wanted to address one specific downside, it’s not easy to manage items, things or rules in bulk (cleanup work in tags, labels). Also modelling the semantics requires a lot of clicking in the UI.
Therefor I’ve created an Excel file that talks to the Openhab API to get a list of items, things and rules. I’ve included a bit of vba to allow changing some of the fields in the spreadsheet and make them change in Openhab as well.
- Tags (as a comma seperated list)
- GroupNames (as a comma seperated list)
It’s not possible to delete objects with the file. Maybe I’ll implement that later but for now I don’t like the thought of accidently cleaning up a bit to much
I wanted to share my file with the community but at the same time advise caution in using it. Even though I have tested and used it on my installation, I might have missed something important for your installation. As always, take a backup of your configuration.
You can find the file here:
Download the file, open it and accept the security warning:
In openhab, create an API token ( openHAB API tokens | openHAB).
Fill in your Openhab host information and the newly created token in the settings tab.
Then refresh the data sources and the different tabs should get populated with your data.
Set the privacy level for all queries to ‘Public’ or choose “Ignore privacy”