File Name Options in Quiz and the Scheduler

In Quiz and the Background Schedule Task programs you can assign a fixed file name for the output of a report. The output format can be PDF, spreadsheet (in report or row formats), comma delimited or tab delimited.

We have added the ability to format the file name with variable embedded information.

  • Quiz (sqrstd.exe) version
  • Schedule Task (smtask.exe) version
  • Server Schedule Task (smtasksrv.exe) version

The variable data is enclosed with < (left) and > (right) angle brackets.

For example, a file name is set as: “c:\temp\testfile.pdf”

Embedded Date fields:

  • “c:\temp\testfile <yyyy-mm-dd>.pdf” —  testfile 2013-01-01.pdf
  • “c:\temp\testfile <mm-dd-yy>.pdf”testfile 01-01-13.pdf
  • “c:\temp\<yyyy-mm>testfile.pdf”2013-01testfile.pdf
    • yy or yyyy — year
    • mm — month
    • dd — day

The date parts can be anywhere in the file name, in any order. They are replaced with the corresponding parts of the report date (or the trigger date if set in the Scheduler).

Embedded Number field:

  • “c:\temp\testfile <yyyy-mm-dd  ##.pdf”testfile 2013-01-01 00.pdf
  • “c:\temp\<###  mm-dd-yy> testfile.pdf”000 01-01-13 testfile.pdf
  • “c:\temp\testfile <###>.pdf” testfile 000.pdf
  • “c:\temp\<###>testfile.pdf” 000testfile.pdf
    • the # (pound) sign sets the position of the sequential number in the file name.
    • the number of # signs sets the maximum number that can be assigned: # = 0-9; ## = 00-99; ### = 000-999, etc.

The report program will look up the exact file name (with the variable date if present) starting with zero.  If that file already exists, the number is incremented by one until a matching file is not found. If all the possible numbers are used up, the file with the highest number will be overwritten. In the example above — testfile 2013-01-01 00 — testfile with that same date would have to be printed 100 times before the number ran out (00-99).

All of the embedded information must be contained in one set of left and right angle brackets.