AS400 SPOOL FILE AUTOMATION TOOLS

CoolSpools Admin

Get complete control over your IBM i (AS400) spool file data. CoolSpools Admin lets you automate the conversion and distribution of spool files. PLUS, CoolSpools Admin is now FREE with the complete CoolSpools suite.

Download and evaluate the complete CoolSpools Suite free for 30 days.

Request a one-to-one demonstration from an IBM i specialist:

Book a demo
IBM i AS400 admin: delete, save, copy, clear spool files
IBM i AS400 admin: delete, save, copy, clear spool files

Automate your spool file conversion and distribution

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

CoolSpools Admin lets you manage:

  • 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

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. Those spool files can then be automatically processed by running:

  • Standard, customisable 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 scripts.

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

CoolSpools Admin contains a compelling and customisable “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, user data, form type, and creation date. Plus, there are many user-defined options.

CoolSpools Admin Specifications

CoolSpools helps you give your users and customers the correct information at the right time and, importantly, in a valid format.

While CoolSpools Spool Converter gives you the functionality to convert 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 enables you to manage to convert, multiple and distribute spooled files, either:

Realtime

WRKSPLFPDM (Work with Spooled Files PDM-style) is a familiar, straightforward, compelling, and customisable “work-with” screen for spooled files that lets system operators and users manage the conversion 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
  • Customisable 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 spooled files to work on using various criteria and apply a command or sequence of commands to each of those spooled files in turn. For example, select all spooled files on a given output queue and convert all to PDF with one order. Or select all spooled files over 30 days old, archive them, and delete them 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. Those spooled files can then be automatically processed by:

  • running a standard, customisable 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 FREE for 30 days

Take a free test drive of the entire CoolSpools Suite, including converter, database, email and admin FREE for 30 days.

Download CoolSpools Suite

CoolSpools Guides, FAQ’s and Documentation

FAQ: Splitting/bursting spooled files

My spooled file contains multiple documents (invoices, statements etc.) that need to be sent to…

FAQ: Why use PDF format for IBM I (AS/400) reports?

Why should I convert a spool file to PDF to distribute my AS/400 documents?

Email and User identity in CoolSpools

FAQ: User profiles and email addresses

Where does CoolSpools get the email address for a user profile from?

max larochelle - AS400

Is This The Most Powerful Spool File Converter Yet?

If you work within an AS/400 environment, wouldn’t it be great if you could take your spooled files…

iseries xml

Converting IBM AS/400 files to XML – communication in the modern world

Converting important data from your iSeries system to be shared across intranets, the world wide…

Coolspools Email Setup Instructions

FAQ: AS400 email setup

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

CoolSpools Fonts

FAQ: CoolSpools Fonts

Why do Coolspools fonts looks different in the PDF to what it does when printed?

Convert spool to pdf

How Spool File Converters Can Help Your Business

Could you be making better use of your data extracts? Maybe you’re wasting time performing tasks…

All CoolSpools articles

REQUEST A CALL BACK

Would you like to see how CoolSpools Suite could modernise data management on your your IBM i?

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

CoolSpools logo