Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Insteon import Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
gregoryx
Newbie
Newbie


Joined: September 02 2006
Online Status: Offline
Posts: 9
Posted: September 02 2006 at 19:13 | IP Logged Quote gregoryx
Any way to import a list of Insteon devices with names and such? Discovery is a bummer.
Back to Top View gregoryx's Profile Search for other posts by gregoryx
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: September 02 2006 at 21:29 | IP Logged Quote TonyNo
You could just manually enter them in the Units screen.

Edited by TonyNo - September 02 2006 at 21:33
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
WayneW
Groupie
Groupie


Joined: March 29 2005
Location: United States
Online Status: Offline
Posts: 50
Posted: September 03 2006 at 15:54 | IP Logged Quote WayneW
Yeah, I typed mine in, and it was a pain when I already had them all in a spreadsheet. Is there a way to import the addresses, locations & device types?
Back to Top View WayneW's Profile Search for other posts by WayneW
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: September 03 2006 at 20:51 | IP Logged Quote TonyNo
Heh. I edited my reply above! I went into using some SQL to add them to the database, but deleted it.

Getting the data into something like this should work...

Code:
insert into insteondevices (id, key_desc, address, typeid, location, controller)
values ("Table Lamp", "Table Lamp", "01.D4.2F", 4, "Living Room", "INSTEON-1")


typeid's are...

1     2414U / 2414S - PowerLinc Controller
2     2430 - ControLinc
3     2456D2 - LampLinc 2 pin
4     2456D3 - LampLinc 3 pin
5     2456S3 - ApplianceLinc 3 pin
6     2476D - SwitchLinc Dimmer 600 watt
7     2476DH - SwitchLinc Dimmer 1000 watt
8     2476S - SwitchLinc Relay
9     2486D - KeypadLinc Dimmer 600 watt
10     2876D - Icon Dimmer 300 watt
11     2876S - Icon Relay
12     2476D - SwitchLinc Dimmer 600 watt (Control)
13     2476DH - SwitchLinc Dimmer 1000 watt
14     2476S - SwitchLinc Relay (Control)
15     2876D - Icon Dimmer 300 watt (Control)
16     2876S - Icon Relay (Control)
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: September 16 2006 at 15:31 | IP Logged Quote dhoward
If you've got Excel, then you should be able to connect directly to the PowerHome database using ODBC. You should be able to then import the data in if you've got it structured properly. You can reference this thread for a little more info on connecting via Access or Excel http://www.power-home.com/forum/forum_posts.asp?TID=62

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum