Bulk import

[brononius]

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

[tschak909]

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

[posde]

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.

[hari]

the backup/restore child devices function in the web admin can be abused to achieve that

[tschak909]

oh yeah, forgot about that!

the file that comes back can be modified, and subsequently restored to produce more devices.

-Thom