Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome Programming
 PowerHome Messageboard : PowerHome Programming
Subject Topic: Macro Conversion Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: November 13 2004 at 18:34 | IP Logged Quote TonyNo
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 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: November 15 2004 at 09:46 | IP Logged Quote dhoward
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 View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: November 15 2004 at 19:07 | IP Logged Quote TonyNo
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 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: November 15 2004 at 19:29 | IP Logged Quote dhoward
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 View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: November 15 2004 at 20:16 | IP Logged Quote TonyNo
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 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: November 17 2004 at 10:35 | IP Logged Quote dhoward
Ok, that helps. I'll see what I can come up with.

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

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: November 18 2004 at 18:27 | IP Logged Quote TonyNo
Tanx!
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo'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