FREQUENTLY ASKED QUESTIONS AND USEFUL GUIDES FROM COOLSPOOLS

FAQs and Guides

Download CoolSpools Suite
IBM i Data to SharePoint

Deliver IBM i Data to SharePoint

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

EmailCloud

Sending Email via Office 365

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

Spring4Shell Vulnerability

Apache ActiveMQ Vulnerability

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

Sunset Image

Withdrawal of IBM Db2 Web Query

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

Easy Conversion of IBM i data

Easy Conversion of IBM i data to Excel

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

send emails

Send Email Using Multiple Sender Domains

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

IBM i SQL Services

Extract Active Job Data with IBM i SQL Services and CoolSpools

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

CoolSpools Application Security

CoolSpools Application Security

Control user permissions to CoolSpools application commands and features

Spring4Shell Vulnerability

Spring4Shell Vulnerability

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

Extend CoolSpools Automation

Extend CoolSpools Automation With Your Own CL Programs

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

QUERY/400

Distribute Your Existing QUERY/400 Reports as Excel Spreadsheets

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

Guide: Three Steps to Spooled File Automation Heaven

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

Guide: Spooled File Archiving with IBM Content Manager OnDemand and CoolSpools

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

CoolSpools and email addresses

Upgrade from CoolSpools Version 6 to Version 7

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

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

PDF passwords and encryption

FAQ: CoolSpools License and Support Keys

What is the difference between CoolSpools license and support keys?

Delivering AS400 data transformation efficiency

Apache Log4j Vulnerability

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

XML file

FAQ: Import XML to IBM i Database

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

PTF's for O/S V5R3 & R4

FAQ: CoolSpools PTF’s for O/S V5R3 & R4

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

Coolspools IBM as/400

Generate AS/400 XML reports on your IBM i with CoolSpools

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…

New Command GETSPLDTA

Guide: Retrieve Spooled File Data to a CL Variable

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

CoolSpools License Transfer

Guide: CoolSpools License Transfer

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

Guide: CoolSpools Version 7 Installation Options

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

Coolspools variables

FAQ: Spool Admin Substitution Variables

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

Coolspools Email Setup Instructions

FAQ: AS400 email setup

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

FAQ: Coolspools & the IFS

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

FAQ: CoolSpools and Excel

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

Coolspools and encrypted files

FAQ: Using encrypted zip files

Can CoolSpools password-protect an Excel file?

CoolSpools and backup systems

FAQ: CoolSpools backup systems

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

AS400 adding images in PDF reports

FAQ: Including images in PDFs

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

Spool file to PDF/a Standard with Coolspools

FAQ: CoolSpools and PDF/A standards

Can CoolSpools produce PDF-A?

IBM IOS update and Coolspools

FAQ: CoolSpools and IBM i OS Upgrades

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

FAQ: CoolSpools and H.A. / Replication

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?

FAQ: CoolSpools and Overlays

Does CoolSpools handle forms overlays?

CoolSpools and email addresses

FAQ: CoolSpools and email addresses

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

PDF passwords and encryption

FAQ: PDF passwords and encryption

Can CoolSpools password-protect a PDF?

FAQ: Supported versions

What versions of your software are currently supported?

FAQ: CoolSpools and OS/400 (IBM i)

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

Guide: Creating Excel files on your IBM i

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…

Sorting files with CoolSpools

FAQ: Dropping unwanted pages from spools

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

FAQ: IBM i email troubleshooting

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

CoolSpools and Color

FAQ: CoolSpools and Color

Does CoolSpools handle color?

CoolSpools Fonts

FAQ: CoolSpools Fonts

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

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?

AS400 security for PDF files

FAQ: Restricting PDF actions

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

Guide: CoolSpools Version 6 Installation Options

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

Automatic spooled file processing

FAQ: Automatic spooled file processing

How do I set up automatic processing of spooled files?

Overlay alignment in CoolSpools

FAQ: CoolSpools and Overlay alignment

Why doesn’t my overlay line up properly?

AS400 to XML file spool conversion

FAQ: Creating XML files on your IBM i

Why create XML files on your system i?

Database Variables

FAQ: Database Variables

What are CoolSpools Database variables?

Email and User identity in CoolSpools

FAQ: User profiles and email addresses

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

Spool file exit program with Coolspools

FAQ: Coolspools Exit Programs

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

FAQ: Giving your files meaningful names

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

FAQ: Splitting/bursting spooled files

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

razvan chisu - Upgrade CoolsPools

Upgrade to CoolSpools Version 6 or Above from an Older Version

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

IBM I 7.1 - office 365

Sending emails to Office 365 from applications using IBM i 7.1?

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 CHKXML

CHKXML – Check XML files using XSD schema

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

IBM Power Systems – Spectre and Meltdown

IBM Power Systems – Spectre and Meltdown

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

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 web and elsewhere requires a flexible file format.

iseries pdf

Do you need to convert complex iSeries data into manageable PDF files?

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

New Command GETSPLDTA

IBM i to Excel – a need not a want

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

tobias fischer spool file to pdf

5 benefits of converting a spooled file to 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

Convert Spool to Excel with CoolSpools

How to Convert IBM Spool to Excel with CoolSpools

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…

edwin andrade

The Power of iSeries PDFs (And The Easy Way to Create Them)

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.

alvaro reyes

IBM i File Conversion: Making it Easy With CoolSpools Software

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

PDF

The Many Benefits of PDFs (And The Easy Way To Create Them)

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 License Transfer

Create iSeries XML the Easy Way with CoolSpools

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

annie spratt

A smarter way to create PDF files in an IBM AS400 environment

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

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 & database files into Excel documents?

patrick amoy - IBM I tasks

3 Everyday IBM i Tasks Made Easy

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.…

as/400 iseries

Reclaim Hours, using Spool File Converter

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

Spool File Converter Turbo

17 Ways Spool File Converter Turbo-Boosts AS400 Systems

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

Productivity - IBM I

IBM i Information Management Made Easy

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…

light bulbs- IBM solved

IBM i Document Creation: Problems Solved

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

Reasons to choose coolspools software

5 Great Reasons to Choose CoolSpools Software

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

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 that could be automated

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 and use them to communicate information across…

jordon conner - Coolspools support

CoolSpools Support

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

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

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