LinuxMCE Forums
General => Users => Topic started by: brononius on August 14, 2012, 08:03:44 am
-
I'm having a lot of switches in my home (light bulb, power outlets, switches...). And of course, i can add them one by one. But this would take hours. So I'm wondering if there isn't a way to import them in bulk into linuxmce.
Can i insert them 'simply' in the database from fe a csv? Or are their different places that are impacted? ???
An example of a csv could be:description | template | controlled | location | channel |
Light kitchen | 37 | EIBD | Kitchen | 1/1/1|1/2/1 |
Light bedroom | 37 | EIBD | Bedroom | 1/1/3|1/2/2 |
Light office | 37 | EIBD | Office | 1/1/3|1/2/3 |
Lightswitch kitchen 1x | 1624 | EIBD | Kitchen | 2/1/1 |
Lightswitch kitchen 2x | 1624 | EIBD | Kitchen | 2/1/2 |
Lightswitch kitchen 3x | 1624 | EIBD | Kitchen | 2/1/3 |
Lightswitch kitchen 4x | 1624 | EIBD | Kitchen | 2/1/4 |
Lightswitch bedroom 1x | 1624 | EIBD | Bedroom | 2/1/5 |
-
Devices are created across multiple tables, so a simple injection of a CSV into a single table is not possible.
An import utility would need to be written in the Web Admin to do this (and I thought we had one at one point?)
-Thom
-
Add the KNX devices one by one. OR, create an import utility after you looked at how the devices are currently added. iirc, I've added over 100 GAs already to my system.
-
the backup/restore child devices function in the web admin can be abused to achieve that
-
oh yeah, forgot about that!
the file that comes back can be modified, and subsequently restored to produce more devices.
-Thom