There is no "command line" interface directly available from Within Sawmill, when we talk about running things from the command line it's from either a Windows Command prompt window, or from a terminal window in linux/Unix/Mac OS X.We've been meaning to post a FAQ to detail usage of Sawmll at the command line, the documenation was correct, however, it does not give a "HOWTO" it's more about the syntax, sorry for the confusion.. Anyhow, on to the answer to your question.
Example for Windows:
Here's what you'd need to do, first navigate to the Sawmill installation directory from the command line, or command prompt window by doing the following:
Click on the Windows "Start" -> All Programs -> Accessories -> Command Prompt
This will open a Windows command prompt window, next you will need to move to the Sawmill install directory, In the example I assume you've installed Sawmill in the default location:
C:\Program Files\Documents and Settings\username> cd "\Program Files\Sawmill 7"
Now you can run a "usage" for this command by typing:
C:\Program Files\Sawmill 7> SawmillCL.exe --help
Usage: SawmillCL.exe (options)
Any configuration option can be used on the command line. For a complete
list of configuration options, see the Options chapter in the online
documentation.
Some common usages are shown below. profilename is the name of a profile.
TO BUILD THE DATABASE FOR profilename:
SawmillCL.exe -p profilename -a bd
TO UPDATE THE DATABASE FOR profilename:
SawmillCL.exe -p profilename -a ud
TO SEND EMAIL FOR profilename, WITH DEFAULT EMAIL OPTIONS:
SawmillCL.exe -p profilename -a srbe
TO SEND EMAIL FOR profilename:
SawmillCL.exe -p profilename -a srbe -ss smtpserver
-rca recipientaddress -rna returnaddress -rn reportname
TO EXPORT A REPORT reportname FROM profilename AS CSV
SawmillCL.exe -p profilename -a ect -rn reportname
TO EXPORT A REPORT reportname FROM profilename AS HTML
SawmillCL.exe -p profilename -a grf -rn reportname -ghtd dirname
TO EXPORT A REPORT ALL REPORTS FROM profilename AS HTML
SawmillCL.exe -p profilename -a garf -ghtd dirname
TO RUN ANY TASKS SCHEDULED FOR THIS MINUTE:
SawmillCL.exe -scheduler
I believe the option you'd like to run is this:
TO EXPORT A REPORT reportname FROM profilename AS HTML
SawmillCL.exe -p profilename -a grf -rn reportname -ghtd dirname
So you'd substitute the "profilename" for your profile name, the "reportname" with the report name you'd like to export, and specify a directory name in the "dirname", if the directory does not exist Sawmill will create it.
I hope that answers your question, and in enough time.
To get a list of profiles from the command line you can run:
SawmillCL.exe -a lp
To get a list of available reports for a profile, you can type
SawmillCL.exe -p profilename -a lr
From within Sawmill's GUI, you can also use the Scheduler to export a report as HTML, if you log in as a user with administrative permissions to Sawmill, by adding a new scheduled event. To set up an event, you'll see a link for "scheduler" under the Admin tab in the left menu, click this link and you will have access to the Sawmill Scheduler from the Scheduler link.
David
Sawmill Product Support Team
support@flowerfire.com