Menu

Command Line – Scheduling with Windows Task Manager

​This video shows how to use the Sharperlight command lines to save reports created in Publisher or Excel in various formats like pdf, csv, xml or html etc. The reports can be then be periodically emailed where the details and conditions are stored in Windows Task Scheduler. One example shows the conditional emailing of attachments only when a balance in a Sharperlight Query exceeds a specified amount by using an Expression to raise Windows Event Log entries. The Event Log entries are then used trigger Windows Task Scheduler jobs.​

Note: Sharperlight Scheduler in version 4 and above now covers all of this type of functionality without the use of command lines.  Please refer to Sharperlight Scheduler if you would prefer to handle this type of functionality via a simple intergrated User Interface  .

Download Examples

MyTasks.zip

​Related Article – Command Line Options

Save Excel as PDF

md.Applications.exe /ExcelExport “C:\MyTasks\Reports\Gantt1.xlsx” “C:\MyTasks\Output\Gannt1.pdf” “project”
md.Applications.exe /ExcelExport “C:\MyTasks\Reports\MonthlyBudget.xlsx” “C:\MyTasks\Output\MonthlyBudget.pdf” “Budget”
md.Applications.exe /ExcelExport “C:\MyTasks\Reports\CustomerAged.xlsx” “C:\MyTasks\Output\CustomerAged_TWO.pdf” “<ALL>” “guest” “” “Company=TWO”
md.Applications.exe /ExcelExport “C:\MyTasks\Reports\CustomerAged.xlsx” “C:\MyTasks\Output\CustomerAged_TYZ.pdf” “<ALL>” “” “” “Company=TYZ”
md.Applications.exe /ExcelExport “C:\MyTasks\Reports\CustomerAged.xlsx” “C:\MyTasks\Output\CustomerAged_TYZ.pdf” “<ALL>” “guest” “” “Territory Sales!C7=TYZ”
md.Applications.exe /QueryExecute “publisher:ACCT.AccntCat” “C:\MyTasks\Output\AccntCat.pdf”​


Save Excel as HTML

md.Applications.exe /ExcelExport ^
 “C:MyTasksReportsGantt1.xlsx” ^
 “C:MyTasksOutputCache_XL_Gannt1.html” “project”
 
md.Applications.exe /ExcelExport “C:\MyTasks\Reports\MonthlyBudgetX.xlsx” “C:\MyTasks\Output\Cache_XL_MonthlyBudget.html” “Budget”
 

md.Applications.exe /QueryExecute “publisher:ACCT.AccntCat” “C:\MyTasks\Output\AccntCat.pdf”

 

Email Command Line Example

rem sendEmail can be downloaded from http://caspian.dotconf.net/menu/Software/SendEmail/
 
c:\MyTasks\sendEmail ^
 -o tls=yes ^
 -f from@staging-sharperlight-com.stackstaging.comgmail.com ^
 -t to@staging-sharperlight-com.stackstaging.comhotmail.com ^
 -s smtp.gmail.com:587 ^
 -xu emailAccount@staging-sharperlight-com.stackstaging.comgmail.com ^
 -xp emailPassword ^
 -u “Budget Report” ^
 -o “message-file=C:\MyTasks\BudgetMessage.html” ^
 -a “C:MyTasksOutputGannt1.pdf” ^
 -a “C:MyTasksOutputMonthlyBudget.pdf” ^

 > “C:MyTasksOutputemailStatus.txt”

 

Email Message File BudgetMessage.html

<html> 
<body>
 
Hi Everyone</br></br>
 
Please see the details for the 2015 Budget attached  </br></br>
 
<a href=’http://sharperlight-pc/mdService1Rest/Report/?query=Train.SCHED_T1A’>Budget Report 2015</a></br></br>
 
Regards</br></br>
 
Sharperlight</br>
</body>
</html>
 
 

 

Category: Video
Published: 2/11/2015 7:42 PM

Related Posts