I'm trying to recover from a complete system crash (SSD drive is toast)
I had crash plan setup a long time ago to backup everything nightly... well crash plan stopped offering there services and I never updated my disaster recovery process, so for sure this is my fault for not backing up.
I have the homeseer database file the sqlite file dated from January of this year which shouldn't be too out of date and it's what I'm working from to recover my devices and events.
I don't have a backup of the insteon.ini so this is where the problem kicks in.
it appears the Insteon plugin will remove Homeseer devices if they are referenced as an insteon device but it doesn't exist in the Insteon.ini file.
I've tested this a few times and I get messages on HS startup similar to this:
Mar-24 3:06:43 PM Insteon Deleted 35.65.B1:3 because it is was present in the HS database as ours but not actually referenced.
Mar-24 3:06:43 PM Insteon Deleted 35.65.B1:2 because it is was present in the HS database as ours but not actually referenced.
Mar-24 3:06:43 PM Insteon Deleted 42.A7.58:1 because it is was present in the HS database as ours but not actually referenced.
Mar-24 3:06:43 PM Insteon 0 matching HS device records were found and updated for the Insteon group database.
Mar-24 3:06:42 PM Insteon 3 Matching HS device records were found and updated for the Insteon device database.
Mar-24 3:06:42 PM Insteon Trouble converting [] to integer
Mar-24 3:06:42 PM Insteon Reloading 4 Insteon device information tables...
Mar-24 3:06:42 PM Insteon Scheduled polling temporarily stopped.
Mar-24 3:06:42 PM Insteon In CreateDevices
The Insteon plugin goes ahead an removes about 170 homeseer devices (sensors, switches, groups etc.)
Right now my plan is to write something in C# that looks the the .hsd sqlite file, and builds the insteon.ini file.
I've accomplished read the .hsd database and grabbing the name, location, location2, insteon code, as well as a bunch of other information. Inserting the Insteon DeviceID seems to prevent the plugin from deleting the homeseer devices. I think the plugin will even update the DeviceName, DeviceLocation properties also. Once it's loaded I think I could go to each device and poll it for it's links and settings.
What I can't seem to find is the DeviceType... on the few I've tried (all switchlincs) are 0120, but I fear that it's important and I can't recover this without readding the device using the "Add a New Insteon Device" button in the plugin
Is there any other recovery plan you can think of that will restore my Insteon.ini file from the .hsd file, and or the Interface links that are stored in the controller and switches?
I don't mind writing some code to pull all of this information together, I'm just trying to avoid starting from complete scratch.
I had crash plan setup a long time ago to backup everything nightly... well crash plan stopped offering there services and I never updated my disaster recovery process, so for sure this is my fault for not backing up.
I have the homeseer database file the sqlite file dated from January of this year which shouldn't be too out of date and it's what I'm working from to recover my devices and events.
I don't have a backup of the insteon.ini so this is where the problem kicks in.
it appears the Insteon plugin will remove Homeseer devices if they are referenced as an insteon device but it doesn't exist in the Insteon.ini file.
I've tested this a few times and I get messages on HS startup similar to this:
Mar-24 3:06:43 PM Insteon Deleted 35.65.B1:3 because it is was present in the HS database as ours but not actually referenced.
Mar-24 3:06:43 PM Insteon Deleted 35.65.B1:2 because it is was present in the HS database as ours but not actually referenced.
Mar-24 3:06:43 PM Insteon Deleted 42.A7.58:1 because it is was present in the HS database as ours but not actually referenced.
Mar-24 3:06:43 PM Insteon 0 matching HS device records were found and updated for the Insteon group database.
Mar-24 3:06:42 PM Insteon 3 Matching HS device records were found and updated for the Insteon device database.
Mar-24 3:06:42 PM Insteon Trouble converting [] to integer
Mar-24 3:06:42 PM Insteon Reloading 4 Insteon device information tables...
Mar-24 3:06:42 PM Insteon Scheduled polling temporarily stopped.
Mar-24 3:06:42 PM Insteon In CreateDevices
The Insteon plugin goes ahead an removes about 170 homeseer devices (sensors, switches, groups etc.)
Right now my plan is to write something in C# that looks the the .hsd sqlite file, and builds the insteon.ini file.
I've accomplished read the .hsd database and grabbing the name, location, location2, insteon code, as well as a bunch of other information. Inserting the Insteon DeviceID seems to prevent the plugin from deleting the homeseer devices. I think the plugin will even update the DeviceName, DeviceLocation properties also. Once it's loaded I think I could go to each device and poll it for it's links and settings.
What I can't seem to find is the DeviceType... on the few I've tried (all switchlincs) are 0120, but I fear that it's important and I can't recover this without readding the device using the "Add a New Insteon Device" button in the plugin
Is there any other recovery plan you can think of that will restore my Insteon.ini file from the .hsd file, and or the Interface links that are stored in the controller and switches?
I don't mind writing some code to pull all of this information together, I'm just trying to avoid starting from complete scratch.
Comment