COOLSPOOLS TRAINING

Expert training to support your AS400 modernization and reporting.

Training videos

Please review our collection of training videos below, each of which have been prepared by our IBM i and CoolSpools experts.

Each video addresses a different real-world scenario, demonstrating the steps needed to deliver the solution to a specific business requirement with CoolSpools.

If you have a business requirement that is not covered by the existing videos then please contact [email protected] to request product support, which may include the creation of a new video.

One to One training and support

For users that have a specific goal – or that want to do something more advanced with their CoolSpools software we offer one to one training sessions. These are aimed at providing insight into common tasks such as XML output formatting, importing data to your AS400 from Excel and other more complex tasks.

If you are a CoolSpools user and would like some one-to-one training with our team, please send your requirements to [email protected].

Training Video Collection

Convert Spooled File Documents to PDF

See how to convert an IBM i spooled file containing a document (such as an Order, Invoice or Statement) to PDF using CoolSpools. The example shown includes overlay of an image to mimic pre-printed stationery and appending of a standard page of T&Cs. The generated PDF document is also delivered as an email attachment.

CoolSpools commands covered are CVTSPLPDF, MRGPDF, GETSPLDTA and SNDCMNMSG.

Split an IBM i spooled file to Multiple PDFs

How to use CoolSpools to split and distribute a multi-page IBM i spooled file as multiple PDF documents.

A spooled file containing multiple payslips is used as an example, with the CoolSpools command CVTSPLPDF used to generate PDF documents, with an overlaid JPG image mimicking pre-printed stationery. A new PDF payslip is generated on each change of employee id, and a database lookup identifies each employee’s email address for automatic distribution of the payslip as an email attachment.

Deliver IBM i reports and data to SharePoint

This video provides a step-by-step guide to delivering database tables and spooled file reports from your IBM i server to a SharePoint document library in PDF or Excel format.

This is achieved by using a combination of CoolSpools commands (such as CVTSPLPDF and CVTDBFXLSX), an Office 365 shared mailbox and a PowerAutomate flow.

Import from text file to IBM i database

This video provides an overview of the IMPFXDDBF command, a powerful alternative to IBM’s CPYFRMSTMF and CPYFRMIMPF commands, which allows you to import data from a fixed position text file without programming knowledge and without requiring the creation of an FDF field definition file.

The command also allows you to select which rows to import, making it ideal for files containing multiple record types, and allows you to select and sequence the data columns to be imported.

Export a complex IBM i spooled file to Excel using a Map

This video provides an overview of the CoolSpools commands needed to create and maintain a Report Definition and a Report-to-Excel Map. Creating this CoolSpools configuration will allow you to easily convert the data content of an IBM i spool file with a complex structure (i.e. where the data is not arranged in simple columns) to an Excel spreadsheet.

CoolSpools commands that are covered include WRKRPTDFN, WRKRPTXL and CVTSPLXL. These commands will enable the conversion of any spooled file’s content to Excel, with control of Excel cell formatting by applying styles, and even distribution of the converted spreadsheet as an email attachment.

Convert Data from Query/400 to Excel

This video provides an overview of the CoolSpools commands needed to convert IBM i data from an existing QUERY/400 query to Excel. The video demonstrates how you can easily convert the detail rows and/or the summary rows to an Excel spreadsheet, how you can apply formatting to cells, how to update an Excel chart with new data, and how a Database-to-Excel map allows you to perform more complex conversions.

CoolSpools commands that are covered include CVTDBFXLSX, WRKSTLDFN and WRKDBFXL. These commands will enable the conversion of a QUERY/400 query’s output data set to Excel, with control of Excel cell formatting by applying styles, and even distribution of the converted spreadsheet as an email attachment.

Easy AS/400 FTP with CoolSpools

This video provides an overview of the FTP commands included with the CoolSpools application, together with an example CL Program that combines multiple those commands to get a list of files currently on a remote file server, and to copy those files to your IBM i server.

CoolSpools commands that are covered include FTPPUT, FTPGET, FTPDLT and FTPDIR.

Extract IBM i System Information with SQL Services and CoolSpools

This video provides an overview of the how to use IBM i SQL Services with the CoolSpools application to generate Excel and XML extracts of IBM i system information, such as user listings, object listings, active job details, licensing and PTF information.

CoolSpools commands that are covered include CVTDBFXML and CVTDBFXLSX.

CoolSpools managed services to the rescue

If you are struggling with a project that you think CoolSpools can help with, ask us to help with some or all of the challenge.
Our managed services offer consulting and technical implementation to help you deliver on your vision for AS400 modernisation.

Learn more about our managed services for AS400 report automation and data management:

Managed Services