Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Printing Macros etc Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
nadler
Super User
Super User


Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
Posted: July 12 2006 at 09:07 | IP Logged Quote nadler

I'm at a point where I want to print out all my macros, triggers, timed events etc. Just in case my computer crashes I want to be able to recreate everything. Screen printing doesn't work well because, of course, it just prints the screen, not everything in the macro. Is there a better way?

Second question, when I'm backing up PH, what files should I backup? The entire PowerHome directory? Anything else not in that directory?

Thanks.
Back to Top View nadler's Profile Search for other posts by nadler
 
guerrand
Senior Member
Senior Member
Avatar

Joined: December 18 2005
Location: United States
Online Status: Offline
Posts: 106
Posted: July 12 2006 at 10:40 | IP Logged Quote guerrand

All you would really need to backup is pwrhome.db.
That has all your macros, units, controllers, formulas and everything else stored in it.

What I do is have powerhome automaticlly back it up to a flash drive.

Its a timed event with the following as the formula.

ph_backupdb ('f:\pwrhome.db',1)

you can change the path it saves to to whatever you want. This way you have automatic backups without having to think about it.

If you need to recover, just reinstall powerhome and drop your db back in the c:\program files\powerhome\database folder and you're back.

Edited by guerrand - July 12 2006 at 10:43


__________________
VuMe
Back to Top View guerrand's Profile Search for other posts by guerrand Visit guerrand's Homepage
 
nadler
Super User
Super User


Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
Posted: July 12 2006 at 10:51 | IP Logged Quote nadler

Thanks!

Any insight on printing?
Back to Top View nadler's Profile Search for other posts by nadler
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: July 12 2006 at 13:56 | IP Logged Quote TonyNo

AFAIK, there is no direct printing support yet. For now, you can print the timed events from a browser using the PH Timed Event Maintenance page.

I have also started working on a psp page which lists out selected macros. Using this, you could then print from your browser.
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: July 14 2006 at 21:56 | IP Logged Quote dhoward

You should also backup your pwrhome.ini file. This file contains various settings such as window sizes and positions as well as Webserver settings, preferences, and the like.

There is no "direct" printing support currently. You could connect to the PowerHome database via any SQL enabled application such as Access, Excel, Crystal, etc. and write nicely formatted reports.

You can also use the "Script Editor (SQL)" section of the PowerHome Multi-Editor to select data from the PowerHome database and print from the resulting SQL Query Report. This is raw data though and probably not quite what you're looking for. You can also export data from the resulting SQL Query Report in a variety of formats such as SQL (which has the advantage of being able to be reimported into the database), CSV, Text, Excel, etc.

Also, as Tony posted above, I know he has put together a simple PSP page (I believe the code is on the forum somewhere) which does some formatting of the macros for you.

I'll make a note to add printable reports for this stuff.

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


Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
Posted: July 15 2006 at 08:55 | IP Logged Quote nadler

Thanks. I'll use one of the options suggested.
Back to Top View nadler's Profile Search for other posts by nadler
 

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