Backup and lost dynamic dashboards

[Antoinne]

Hi,

I have been using Domoticz for years now. But yesterday I had to re-install it en restore a backup. Now I can't find all the new fancy dynamic dashboards I had created in the past months. My guess I this had something todo with the per-user settings since I would expect the dynamic dashboards to be part of the backup file. Can someone give some pointers on where to find a solution for bringing back dynamic dasboards other then recreating them all?

PS I do see a import/export on the edit dashboard page, so I guess I should have noticed this before to be better prepared for the next re-install. My bad I guess...

Thanks,

Antoinne

[gizmocuz]

Go to your profile (Setup->Profile) and enable it?

[Antoinne]

Yes I did. But I could not see the dashboards I had created before. I have already started to recreate them. My motto is that when you do something for the second time, it always gets better But I would like to know if they are saved in the backup file or that I should export them manually in the future.

[gizmocuz]

They should be in the backup: the dynamic dashboards are stored in the database (table DashboardLayouts) and a database backup is a full copy of it, so a restore brings them back.

Each dashboard belongs to the user that created it, and you only see the dashboards of the user you are logged in with. Without a login (local network), Domoticz uses the first admin user. If that user has no dashboards, a new one is made from your favorites, which looks as if everything is gone.

Could you check:
1. Are you logged in with the same user as before the reinstall?
2. Is the backup you restored newer than your dashboards?
3. If you have sqlite3, on a copy of the restored backup:

Code: Select all

sqlite3 domoticz.db "SELECT userid, name FROM DashboardLayouts;"
sqlite3 domoticz.db "SELECT ID, Username FROM Users;"

If the dashboards are there under another userid than the user you log in with, let us know the result.

An export (Edit > Export / Import, all dashboards) is a nice extra, but it should not be needed for a restore.

[Antoinne]

Thanks, that was the information I was looking for. Your help is much appreciated. After all those years I did experience some problems with the correct admin account, so I messed up those accounts too. But now I have started to recreate the dashboards and this time I will remember the correct account used for the dashboards. Will also check my backup and restore procedure to make sure that I can do a complete restore the next time

PS Really love these dashboards, it's a lot easier to setup and maintain compared to the Dashticz dashboards I used before.

[gizmocuz]

Thank you for the compliments ! Much appreciated!