Configuring rpttsk.exe for the Report Email Batches

Rpttsk.exe is a separate software application that is maintained in the EnergyCAP installation folder. It has its own software interface, but can also be executed via a DOS command line. When being used with Report Email Batches, it is typically run as a Windows scheduled task (see Windows documentation for more information on setting up Scheduled Tasks).

1. Open My Computer or Windows Explorer and browse to the EnergyCAP application Folder (usually C:/Program Files/EnergyCAP Enterprise).
2. Double click on rpttsk.exe. The Report Email Setup and Testing window opens. 
   
   
3. Input information in the fields provided, per the notes below.

• SMTP Host: (Simple Mail Transfer Protocol) Input the user domain (such as mail.domain)
• SMTP Port: Input the computer default port for SMTP communication (usually 25; the Port # may be different when SSL is used)
• SMTP User Name: Input the domain User Name (usually the user’s e-mail name)
• SMTP Password: Input the domain User Password (usually the user’s e-mail password)
• SMTP SSL Checkbox: Check if SMTP server supports Secure Socket Layer protocol
• Start TLS Checkbox: Check if SMTP server supports Transport Layer Security protocol
• Test E-mail Address (to:) Input an e-mail address to test current configuration settings. This will only be used when the Test mail Settings button is clicked.
• DataBase: Input the datasource name (the database selected during EnergyCAP logon).
• ECAP User: Input the EnergyCAP Login User Name.
• ECAP Password: Input the EnergyCAP Login User Password.

4. After entering the above information, perform the two tests below:

• Click the Test DB Connection button to test the database connection. If successful, the Connected window will be displayed. Click OK to close the Connected window.
• Click the Test Mail Settings button to test the SMTP settings. If successful, the Success! window will be displayed. Click OK to close the Success! window.

5. After both tests have been performed successfully, click Save Settings. The current configuration will be saved to the RptTsk.ini file in the EnergyCAP installation directory.
6. When done, click Close to close the Report Emailer Setup and Testing window.

NOTES: 

Once configuration information has been saved, saved settings for rpttsk.exe will be automatically used by a windows scheduled task when using the following command:

rpttsk -a

To override the saved settings, specific command line settings can be used. Click the Command Line Settings button from the Report Emailer Setup and Testing window for more information.

The DataBase name needs to match the ODBC setting in EnergyCAP.

Click the Command Line Settings button to open the Usage window with current information regarding rpttsk switches.

Running rpttsk for multiple databases

Organizations managing multiple EnergyCAP databases will find it helpful to set up a batch file with separate lines in the query for each managed datasource. An example batch file format is included below:

NOTES: This batch file needs to be edited before using. Replace CAPS variables with YOUR ACTUAL VALUES. Each line pertains to one database. The -a switch at the end will run the Report Distribution manager for all distribution lists in that database.

This file should either be executed from the EnergyCAP installation folder, OR EnergyCAP's rpttsk should be in your system's PATH variable.

rpttsk.exe -u USER -p PASSWORD -d ODBC_DATASOURCE_NAME_DB1 -a

rpttsk.exe -u USER -p PASSWORD -d ODBC_DATASOURCE_NAME_DB2 -a

rpttsk.exe -u USER -p PASSWORD -d ODBC_DATASOURCE_NAME_DB3 -a

rpttsk.exe -u USER -p PASSWORD -d ODBC_DATASOURCE_NAME_DB4 -a

rpttsk.exe -u USER -p PASSWORD -d ODBC_DATASOURCE_NAME_DB5 -a