FAQ’s and Guides
Frequently asked questions and useful guides from CoolSpools
FAQ: IBM i email troubleshooting
My emails are being sent/aren’t being delivered: how can I work out why?
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.
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?
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?
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: 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?
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 multiple channels?
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.
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. But are any of them as powerful as 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
FAQ: Restricting PDF actions
Can you prevent people from modifying/printing/copying text from PDF’s?
FAQ: Import XML to IBM i Database
How can I use CoolSpools to import data from an XML file to my IBM i Database?
Guide: 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.
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 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 feel like your System i databases and spool files…
FAQ: CoolSpools License and Support Keys
What is the difference between CoolSpools license and support keys?
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.
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.
Guide: Import Text File to IBM i Database Table with CoolSpools
Importing delimited and fixed-position text files to IBM i database with CoolSpools
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.
FAQ: CoolSpools and OS/400 (IBM i)
With which versions of OS/400 is your software compatible?
FAQ: Automatic spooled file processing
How do I set up automatic processing of spooled files?
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?
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.
Apache Log4j Vulnerability
CoolSpools General,Support Articles,News
The CoolSpools application is not impacted by the Apache Log4j vulnerability CVE-2021-44228
FAQ: CoolSpools and IBM i OS Upgrades
I’m upgrading to IBM i V6R1M0-V7R4M0, do I need a special version?
IBM i Document Creation: Problems Solved
When communicating information throughout your business, there are several factors to consider.
5 Great Reasons to Choose CoolSpools Software
CoolSpools really IS the most powerful, most fully-featured, easiest to use System i spool file converter
Guide: CoolSpools Version 7 Installation Options
The options listed below all install a full working version of CoolSpools.
IBM Power Systems – Spectre and Meltdown
On January 9, IBM confirmed that Spectre and Meltdown does affect IBM POWER Systems servers.
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.
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 which your users and customers want their……
Guide: Three Steps to Spooled File Automation Heaven
Automate your IBM i (AS/400, iSeries) Spooled File Processing with CoolSpools
Upgrade from CoolSpools Version 6 to Version 7
This page answers frequently asked questions about upgrading from Version 6 to Version 7 of CoolSpools.
Guide: CoolSpools Version 6 Installation Options
The options listed below all install a full working version of CoolSpools V6
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.
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.
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 Excel.
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 can I split/burst the spooled file so I can do…
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 variables?
FAQ: User profiles and email addresses
Where does CoolSpools get the email address for a user profile from?
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 variety of additional features that can modernise…
FAQ: CoolSpools and email addresses
How do I tell CoolSpools who to email a converted spooled file to?
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?
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 useful file formats.
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 data.
FAQ: CoolSpools Fonts
Why do Coolspools fonts looks different in the PDF to what it does when printed?
CoolSpools Support
Here are a few of the ways that we keep our customers happy and our software up to such a high standard.
Guide: Deliver Content Rich Email Messages from your IBM i Server
Compose content-rich email messages on IBM i
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.
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?
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
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?
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
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.
FAQ: Giving your files meaningful names
I want to give my files a meaningful name. How can I do that?
Guide: CoolSpools License Transfer
Everything you need to keep CoolSpools running after a hardware or operating system upgrade
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.