To use Monarch for DOS with WinSpool/400 Email Report Server version 3.0.0 or above to convert reports to spreadsheet or database formats:
 
  1. In WinSpool/400 Email Report Server, on the Edit Output Queue/Email Recipient screen, in Custom User API Command Line, enter the default command line for Monarch.

    For example: If Monarch is in the directory C:\Program Files\Monarch\Program and WinSpool/400 Email Report Server is substituting the input file, output file, and mask file names at runtime, use:

    C:\Program Files\Monarch\Program\MONARCH.EXE @INPUTFILE @MASKFILE @OUTPUTFILE

    Note: You can substitute the following variables:

    • @MASKFILE - The DataImport or DIW/Monarch mask file.
    • @MASKOUTPUTTYPE - The DataImport or DIW Mask/Monarch output type.
    • @INPUTFILE - The input PC file.
    • @OUTPUTFILE - The output PC file.
    • @SPOOL - The spool-file name.
    • @USERDATA - The spool-file user data.
    • @JOBNAME - The spool-file job name.
    • @FORMTYPE - The spool-file form type.
  2. In Output Format for each email recipient, choose API.
  3. In DataImport Mask File Name for each email recipient, enter the Monarch mask file name.
  4. In DataImport Output Data Type for each email recipient, enter the file extension for the selected file type. The following file types are valid:
    Extension    File Format
    DBF dBASE III
    TXT Fixed length ASCII
    WKS 1-2-3 Release 1, 1A
    WK1 1-2-3 Release 2.0, 2.01, 2.2   
    WK3 1-2-3 Release 3.0, 3.1
    XLS Microsoft Excel
    (Any other)    Delimited ASCI

    Note: When you create masks to use with Monarch, first download the report files with WinSpool 98 and use the ASCII Text - Print Control *PRTCTL format. Otherwise, the columns will not line up correctly when you convert the report with WinSpool/400 Email Report Server and Monarch.


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016