A module for the IBM i (AS, iSeries) that enables you an easy conversion of print spool files from the IBM i to XML flies. – Spool to XML in seconds!. On iSeries, instead of transferring a spool file to an Excel spreadsheet, use the CPYTOIMPF command to create a CVS text file that can be easily loaded into. This allows the first character to be used as a control character so that you can convert the contents of the physical file back to a spool file and.

Author: Mokree Dagor
Country: Singapore
Language: English (Spanish)
Genre: Sex
Published (Last): 26 September 2007
Pages: 91
PDF File Size: 5.50 Mb
ePub File Size: 9.22 Mb
ISBN: 562-5-16911-508-3
Downloads: 50480
Price: Free* [*Free Regsitration Required]
Uploader: Miramar

CPF Copy request failed.

You might currently extract separate sections of the data created on your system to send to different departments or individuals.

Required product option not available. The method I am going to describe can only be used IBM i servers with either version 6. However, the CoolSpools Spool Converter does more than just spool conversion.

Job name JOB Specifies the job that created the spooled file whose data records are to be copied. So what have you got to lose?

Convert IBM i | AS/400 | iSeries print files into XML

While there are still many of us who would rather read a printed document than looking at the same document on a computer monitor, the main benefits of CoolSpools are the money saved, the easy access you have to your spooled files and the positive impact on the environment by refraining from printing unnecessarily.

The licensed program code if different depending upon which release your server is running: CoolSpools can handle all of this, without having to reopen your Excel document to manually amend it. Creation date date Specify the date the spooled file was created. So, do you need to convert spool to Excel? Simon Hutchinson April 8, at 4: From IBM’s Suport documents: Channel 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Element 2: Paul thank you bring this to my attention. Paul Putkowski March 27, at 3: If you want to understand how our solutions can help your business, please contact us at www.


Converting a spooled file to PDF

Channel number refers to a method of determining skipping for reports. And remember, CoolSpools software is created by Ariadne Software, well-established global experts in providing Ss400 i filee — so you can trust it to be reliable as well as powerful.

Checking the veracity of the data. CoolSpools can even split your System i Excel files into multiple different files based on criteria you specify — then send your System i Excel files to multiple recipients.

Print lines that are all blank are not copied. Line The line number assigned for the channel number in the same list. This ultimately saves your time and money by moving your business away from paper-based documents and by distributing information via electronic formats.

spool file converter Archives – CoolSpools

Randall Ames March 31, at 8: I use this tool extensively to generate PDF instead of a spool file Simon Hutchinson November 13, at The assigned channel values as specified on the command are as follows: Written by Simon Hutchinson at 4: Specifies a list of channel numbers with their assigned line numbers.

I have a physical file with a record length on my box that I’ve been using to copy spool files in for different reasons. The licensed program code if different depending upon which release your server is running:. Before you can do what I will describe in this post you need to check if you have the necessary licensed program, Transform Services, installed on your IBM i.


There is a direct correlation between the amount of trees that have to be cut down and the amount of money it costs you, and the initial cost for CoolSpools, is usually far surpassed by the savings in reduced paper for most businesses. Bob Cancilla March 26, at I have received several communications informing me that you can use the Operation Navigator to convert a spool file to a PDF file.

Parameters Examples Error messages.

Copy Spooled File (CPYSPLF)

This can be handled within CoolSpools as we have devised a system which allows you to select which lines or pages to include or exclude and which people you wish to receive each section of information. Markus During June 8, at 3: This is just a taste of how CoolSpools spool file converter can make your working life easier. Graphics data is lost. But I have a problem. This conversion allows the flies of spooled files in applications using microfiche, data communications, or data processing.

CoolSpools takes the data straight from your System i spool files and converts it to Excel. Update I have received several communications informing me that you can use the Operation Navigator to convert a spool file cconvert a PDF file. Anonymous August 3, at 7: The range of valid line numbers is 1 through All these posts are developed and tested on servers running IBM i 7.

Job name Name Qualifier 2: How CoolSpools software can help: