CoolSpools Admin

Automate your AS400 spool file conversion and distribution to PDF and Excel

Free Trial Download

Get complete control over your IBM AS400 spool file conversions

Now you can easily manage, convert and distribute spool files to PDF & Excel.
PLUS, CoolSpools Admin is now FREE with CoolSpools suite.

CoolSpools Admin lets you manage, convert and distribute AS400 spool files to PDF & Excel.

Spool files can be processed automatically as soon as they are created, as the system lets you define spool file monitors that “watch” nominated output queues for new files being created. There is no polling involved so the system loading is minimal.

New spool files are evaluated against spool file rules that you define to determine what type of spool file has been found and what should be done with it. Those spool files can then be automatically processed by running:

  • Standard, customizable options e.g. 10=Convert to PDF or 21=Email as Excel
  • User-defined options
  • Command strings e.g. to call a program to archive the spool file
  • Your own scripts.

In batch mode, CoolSpool Admin commands let you select sets of spool files to work on using various criteria and allows you to apply a command or sequence of commands to each of those selected spool files in turn. For example, you can select all spool files over 30 days old and archive them, then delete them, all with a single command.

CoolSpools Admin contains a highly powerful and customizable “work-with” screen for spool files in the style of PDM, that lets system operators and users manage, convert and email the spool files they produce. It includes features to select spool files by user, outq, user data, form type, and creation date. Plus there are many user-defined options.

Free Trial

CoolSpools Admin and the full CoolSpools Suite are available to download free for 30 days.


Would you like a demo?

Book a discovery session and we will create a relevant demo that addresses your needs.

CoolSpools Admin Features:

  • Automatic conversion, distribution and management of spool files
  • Work with spool files online
  • Select batches of spool files and run the same command against each

CoolSpools Admin Details & Specifications

CoolSpools helps you give your users and customers the right information, at the right time, and, just as importantly, in the right format.

While CoolSpools Spool Converter gives you the functionality to converts an IBM i spooled file to a variety of formats, such as PDF and Excel, and CoolSpools Email lets you email those files to users and customers, CoolSpools Spool Admin provides an infrastructure that lets you manage to convert, multiple and distribute spooled files, either:

  • Realtime
    WRKSPLFPDM (Work with Spooled Files PDM-style) is simple and familiar but highly powerful and customizable “work-with” screen for spooled files that lets system operators and users manage, convert and email the spooled files they produce. Includes features such as:

    • Select spooled files by user, outq, user data, form type, creation date etc.
    • User-defined options
    • Customizable standard options e.g. 10=Convert to PDF, 21=Email as Excel etc.
    • Sort by name or date
    • F13=Repeat option to the end of the list
  • In batch
    The RUNSPLFCMD (Run Spooled File Commands) command lets you select sets of spooled files to work on using various criteria and allows you to apply command or sequence of commands to each of those selected spooled files in turn. For example, select all spooled file on a given output queue and convert all to PDF, with one command. Or select all spooled files over 30 days old and archive them, then delete them, again with a single command.

  • Automatically
    Process spooled files automatically as soon as they are created. CoolSpools Spool Admin lets you define spooled file monitors that “watch” nominated output queues for new files being created. No polling involved: system loading is minimal. New spooled files that are detected are evaluated against spooled file rules that you define to determine what type of spooled file has been found and what should be done with it. Those spooled files can then be automatically processed by:

    • running a standard, a customizable option such as 10=Convert to PDF or 21=Email as Excel
    • running a user-defined option
    • running any command string, which might call a program, move, delete, send, convert or archive the spooled file etc.
    • any combination of the above in the form of a user-written spooled file script

Download CoolSpools

IBM Spool File Conversion Guides, FAQ’s and Articles

IBM I Spool to Exel

Take the Pain Out Of IBM i Spool to Excel File Creation

Don’t you wish someone would invent an easier way to automatically convert System i spool &…

Read More

Coolspools Email Setup Instructions

FAQ: AS400 email setup

What do I need to do to get email working on my system?

Read More

Coolspools variables

FAQ: Spool Admin Substitution Variables

What are CoolSpools Spool Admin substitution variables, how and where can I use them and how to…

Read More

FAQ: CoolSpools License and Support Keys

What is the difference between CoolSpools license and support keys?

Read More

How to Import Text Files to IBM i Database

Guide: Import Text File to IBM i Database Table with CoolSpools

Importing delimited and fixed-position text files to IBM i database with CoolSpools

Read More

Delivering AS400 data transformation efficiency

Apache Log4j Vulnerability

The CoolSpools application is not impacted by the Apache Log4j vulnerability CVE-2021-44228

Read More

All CoolSpools articles
REQUEST A CALL BACK

Want to know how the CoolSpools Suite could benefit your business?

Complete the form below and one of our team will get in touch.

CoolSpools logo