Command Line Parameters for Dynamic Batch Scheduling
The following command line parameters can be used with the Dynamic Batch Scheduling feature in Jet Reports.
Parameter | Action |
---|---|
/M | Sets the mode: UPDATE, VALUES, SIMPLEWEB, PDF, CSV, CSVFIRSTSHEET, TXT, or TXTFIRSTSHEET (see the Modes section for details). |
/I | Specifies the input directory or a particular report. |
/O | Specifies the output directory where the report(s) will be saved or a path to the output report. |
/D | Turns on DEBUG mode. You can specify a text file where the debug information will be saved. When AutoPilot runs, Excel will open visibly and errors and status will be stored in the text file. |
/L | Creates a log file just like /D except without opening Excel visibly. If no log file is specified, a text file will be created in My Documents with the data in the filename |
/ELN | Allows a specific email to be specified to receive an email indicating an error has occurred with a report. (i.e. /ELN "email@domain.com") |
/S | Emails the reports via SMTP. SMTP settings must be configured in the Jet Application Settings. Requires /E |
/E | Emails the report(s) to the email addresses in the specified Excel named range or a semicolon-separated lists of email addresses. Cannot be used with a mode of SIMPLEWEB. |
/CC | Adds email addresses specified in Excel Named range or semicolon-separated lists of email addresses to "CC" of email. Requires /E |
/BCC | Adds email addresses specified in Excel Named range or semicolon-separated lists of email addresses to "BCC" of email. Requires /E |
/U | Specifies the subject of the email. Can be text or an Excel named range containing the subject. If no subject is specified, the filename of the report will be used. |
/B | Specifies the message body of the email. Can be text or an Excel named range containing the message body. If no message body is specified, the filename of the report will be used. |
/N | Prompts a "notification" style email to be sent when using /E. In a "notification" email, the completed report will NOT be attached. If using /N, it is recommended that you also use the /B and /U parameters. Requires /E. |
/R | Removes all hidden workbook elements (rows, columns, and sheets) when used with VALUES or SIMPLEWEB modes. |
/P | Starts the list of named range replacements. This must be last in the command line. (i.e., /P "Range1" "Value1" "Range2" "Value2"). |
Please note the following rules when building a command line:
The first command line item should be the path to the “AutoPilot.exe” file.
There must be a space both before and after each command line item.
Enclose all command line values (not the parameters) in quotes.
The /P parameter must be last.
Place the entire command line in a named range.
Example command line:
Modes
UPDATE : Opens the workbook, runs the report, and saves the workbook in the output folder.
VALUES: Opens the workbook, runs the report, breaks all links with the Jet add-in by permanently removing all Jet functions, and saves the workbook in the output directory. The outputted workbook can no longer be refreshed. Column A and Row 1 are deleted. If /R is specified, all hidden rows, columns, and sheets are deleted.
SIMPLEWEB : Opens the workbook, runs the report, and saves the workbook as a single html file with a folder containing supporting files. Email is not supported with this mode.
PDF : Opens the workbook, runs the report, breaks all links with the Jet add-in by permanently removing all Jet functions, deletes all hidden rows, columns, and sheets, and saves the workbook in the output directory as a PDF file.
CSV : Opens the workbook, runs the report, breaks all links with the Jet add-in by permanently removing all Jet functions, deletes all hidden rows, columns, and sheets, and saves the workbook in the output directory as a CSV file with all visible sheets.
CSVFIRSTSHEET : Opens the workbook, runs the report, breaks all links with the Jet add-in by permanently removing all Jet functions, deletes all hidden rows, columns, and sheets, and saves the workbook in the output directory as a CSV file with only the leftmost visible sheet.
TXT : Opens the workbook, runs the report, breaks all links with the Jet add-in by permanently removing all Jet functions, deletes all hidden rows, columns, and sheets, and saves the workbook in the output directory as a text file with all visible sheets.
TXTFIRSTSHEET : Opens the workbook, runs the report, breaks all links with the Jet add-in by permanently removing all Jet functions, deletes all hidden rows, columns, and sheets, and saves the workbook in the output directory as a text file with only the leftmost visible sheet.