| Author |
|
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: November 13 2004 at 18:34 | IP Logged
|
|
|
Dave, I just started working on an app to translate an exported macro into more of a form that resembles what you see in PH, but, then had a thought. Is this something that would be trivial for you to do? Just wondering so I don't go off spending a bunch of unnecessary time. 
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: November 15 2004 at 09:46 | IP Logged
|
|
|
Hmmm...Interpreting the exported macro would be kind of a pain (especially if you're trying to work with SQL code). You can have your choice of export formats (CSV would be easier than SQL) by using SQL report (select * from macrodetail where id = 'ID') and then going to File->Export.
Are you looking for a printable report type of format detailing a macro? If so, then that would be pretty easy.
Let me know a little more what you had in mind and I'll look into it. Depending upon what you want, it may be fairly trivial and just something that I add to the reports menu.
Dave.
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: November 15 2004 at 19:07 | IP Logged
|
|
|
The exported CSV idea is a good start.
For example:
insert into macroheader values ('BYE EXPIRE','BYE TIMER EXPIRE',0,0,1);
insert into macrodetail values ('BYE EXPIRE',1,9,'',NULL,'"Shutting down"',0);
insert into macrodetail values ('BYE EXPIRE',2,10,'BYE FLAG',NULL,'1',0);
insert into macrodetail values ('BYE EXPIRE',3,12,'C',2,'',0);
insert into macrodetail values ('BYE EXPIRE',4,12,'C',3,'',0);
insert into macrodetail values ('BYE EXPIRE',5,12,'C',4,'',0);
insert into macrodetail values ('BYE EXPIRE',6,12,'C',7,'',0);
insert into macrodetail values ('BYE EXPIRE',7,12,'C',103,'',0);
insert into macrodetail values ('BYE EXPIRE',8,12,'B',2,'',0);
insert into macrodetail values ('BYE EXPIRE',9,12,'B',3,'',0);
insert into macrodetail values ('BYE EXPIRE',10,12,'B',4,'',0);
insert into macrodetail values ('BYE EXPIRE',11,12,'B',7,'',0);
insert into macrodetail values ('BYE EXPIRE',12,12,'B',103,'',0);
insert into macrodetail values ('BYE EXPIRE',13,16,'',NULL,'if( {INTERNET FLAG} = 0, 999, 1)',0);
insert into macrodetail values ('BYE EXPIRE',14,1,'SETUP EMAIL-CELL',0,'',0);
insert into macrodetail values ('BYE EXPIRE',15,20,'',NULL,'" House now shut down! " /plus/ "{IP}"',0);
insert into macrodetail values ('BYE EXPIRE',16,1,'SELECT PORCH CAM',1,'',0);
Would look like this...
10 TTS "Shutting down"
20 Set Global BYE FLAG = 1
30 X-10 1 C2
40 X-10 1 C3
50 X-10 1 C4
60 X-10 1 C7
70 X-10 1 C Off
80 X-10 1 B2
90 X-10 1 B3
100 X-10 1 B4
110 X-10 1 B7
120 X-10 1 B Off
130 Jump if( {INTERNET FLAG} = 0, 999, 1)
140 Macro SETUP EMAIL-CELL
150 TTS " House now shut down! " /plus/ "{IP}"
160 Macro SELECT PORCH CAM
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: November 15 2004 at 19:29 | IP Logged
|
|
|
Tony,
Are you wanting the final result to be printable, or cut and pasteable?
Also, would this be something that would be generated within PowerHome directly from an existing macro or would this need to interpret the raw SQL insert statements?
Dave.
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: November 15 2004 at 20:16 | IP Logged
|
|
|
Dave,
Either printable or cut/paste would be fine.
Being able to do this within PH would be perfect. My thought is for a human-readable macro format for swapping, etc.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: November 17 2004 at 10:35 | IP Logged
|
|
|
Ok, that helps. I'll see what I can come up with.
Dave.
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: November 18 2004 at 18:27 | IP Logged
|
|
|
Tanx!
|
| Back to Top |
|
| |
|
|
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome Programming
Topic: Macro Conversion
