FAQs and Guides

How to use CVTDBFTXT FROMFILE(*SQL) with IBM SQL JSON functions to convert from your database to JSON format with CoolSpools.

CoolSpools FTP commands make it easy to perform file transfers to and from your IBM i server.

Use CoolSpools to relay email messages from your IBM i server via Microsoft 365 (Office 365) authenticating the SMTP connection with MS OAUTH 2.0.

Replacing KemeTECH ConversionSuite quickly and easily with the CoolSpools Database module

Use CoolSpools to extract data from IBM i application databases to MS Excel spreadsheets.

Distribute IBM i data and reports to SharePoint as Excel or PDF by using CoolSpools and Power Automate.

The CoolSpools application is not impacted by the Apache ActiveMQ vulnerability CVE-2023-46604

IBM have announced the withdrawal of IBM Db2 Web Query for i. Is CoolSpools affected, or can it be used as a replacement tool?

Use CoolSpools to extract data from IBM i application databases to MS Excel spreadsheets.

Use CoolSpools to deliver email messages from your IBM i server with multiple sender address domains without being tripped up by spam filters.

Combine IBM i SQL services with CoolSpools database to easily distribute system information, such as active job information, in a variety of formats…

Control user permissions to CoolSpools application commands and features

The CoolSpools application is not impacted by the Spring Framework vulnerability CVE-2022-22965

Extend your IBM i Spooled File Automation by integrating a custom CL program with CoolSpools Spool Admin

An IBM i (AS/400) users guide to distributing existing QUERY/400 reports as Excel Spreadsheets from CoolSpools.

Automate your IBM i (AS/400, iSeries) Spooled File Processing with CoolSpools

Maximise your IBM i Spooled File archiving capabilities by combining CoolSpools with IBM Content Manager OnDemand

Compose content-rich email messages on IBM i

This page answers frequently asked questions about upgrading from Version 6 to Version 7 of CoolSpools.

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

What is the difference between CoolSpools license and support keys?

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

How can I use CoolSpools to import data from an XML file to my IBM i Database?

I’m running CoolSpools V6, CoolSpools PLUS, CoolSpools V5 or Slipstream V4 and am having problems opening Excel files in Excel 2010.

CoolSpools software for IBM i (AS/400) can generate AS/400 XML documents onto your server's IFS or distribute them via email or FTP and includes a…

Use CoolSpools command GETSPLDTA to populate a CL variable with data from within an IBM i spooled file.

Everything you need to keep CoolSpools running after a hardware or operating system upgrade

The options listed below all install a full working version of CoolSpools.

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

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

Where does my output go and how can I access it?

I’m running CoolSpools V6, CoolSpools PLUS, CoolSpools V5 or Slipstream V4 and am having problems opening Excel files in Excel 2010.

Can CoolSpools password-protect an Excel file?

Do I need to buy a license for my backup/D.R. system? Do you have special deals for backup systems?

My document prints on a pre-printed form and I need to see that inside the PDF. Can CoolSpools do that?

Can CoolSpools produce PDF-A?

I’m upgrading to IBM i V6R1M0-V7R5M0, do I need a special version?

We’re using a High Availability system that replicates our objects and data to a backup system. What do I have to do in relation to CoolSpools etc?

Does CoolSpools handle forms overlays?

How do I tell CoolSpools who to email a converted spooled file to?

Can CoolSpools password-protect a PDF?

What versions of your software are currently supported?

With which versions of OS/400 is your software compatible?

Our guide to creating Excel format files on your AS/400 System I / iSeries. You need Excel format from your spool files because that’s the format in…

There are some pages/lines in the report I don’t want. How can I get rid of them?

My emails are being sent/aren’t being delivered: how can I work out why?

Does CoolSpools handle color?

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

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

Can you prevent people from modifying/printing/copying text from PDF’s?

The options listed below all install a full working version of CoolSpools V6

How do I set up automatic processing of spooled files?

Why doesn’t my overlay line up properly?

Why create XML files on your system i?

What are CoolSpools Database variables?

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

How do I write an exit program for CoolSpools to call?

I want to give my files a meaningful name. How can I do that?

My spooled file contains multiple documents (invoices, statements etc.) that need to be sent to different people (customers, departments etc.). How…

This page answers frequently asked questions about upgrading to Version 6 or 7 from an older release of CoolSpools.

Microsoft plans to discontinue the support for Transport Layer Security (TLS) versions 1.0 & 1.1 in Office 365 and Office 365 GCC as of June 2020.

CoolSpools recently introduced command CHKXML runs natively on the IBM i platform to validate the content of an XML file against an XSD schema

On January 9, IBM confirmed that Spectre and Meltdown does affect IBM POWER Systems servers.

Converting important data from your iSeries system to be shared across intranets, the world wide web and elsewhere requires a flexible file format.

CoolSpools lets you easily pull together reports in PDF, XML and Excel formats from IBM iSeries / AS400 using different selections of the company…

CoolSpools quickly distributes information from System i into a variety of different formats including Excel, XML and PDF.

There are a number of reasons why converting a spool file in IBM AS400 / System I to PDF will benefit you and your company

The CoolSpools range of AS/400 solutions includes a powerful spool file converter that can output to a wide range of popular file formats, including…

If you work in an IBM iSeries, System i or AS/400 environment, creating PDFs has got even easier! All thanks to CoolSpools spool file converter.

CoolSpools is designed to make it easier, quicker and more convenient to manage, access, convert and distribute information using System i.

CoolSpools is a powerful, fully-featured spool file converter, offering an easy, customizable way to convert spool to PDF and a whole host of other…

CoolSpools can generate a wide range of file formats by converting your iSeries spool files including PDF, Excel and crucially XML.

With CoolSpools software you can automatically convert your spool file to PDF, or multiple PDF’s, saving time and ensuring accuracy.

Don’t you wish someone would invent an easier way to automatically convert System i spool & database files into Excel documents?

If you work in an IBM System i, AS/400 or iSeries environment, there are many applications on the market than claim to make things easier and faster.…

How much of your day is spent creating, formatting and distributing reports on the System i, AS/400 or iSeries?

Creating PDFs just got a whole lot easier! Why manually create PDFs when CoolSpools can automate the process from your spool files?

Are you getting the most from your System i environment? Is your data managed, extracted and communicated in the most efficient manner? Or do you…

When communicating information throughout your business, there are several factors to consider.

CoolSpools really IS the most powerful, most fully-featured, easiest to use System i spool file converter

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

If you work within an AS/400 environment, wouldn’t it be great if you could take your spooled files and use them to communicate information across…

Here are a few of the ways that we keep our customers happy and our software up to such a high standard.