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: Malagami Taulkis
Country: Burundi
Language: English (Spanish)
Genre: Art
Published (Last): 25 March 2009
Pages: 253
PDF File Size: 19.56 Mb
ePub File Size: 15.16 Mb
ISBN: 163-9-28298-912-7
Downloads: 20389
Price: Free* [*Free Regsitration Required]
Uploader: Kalrajas

However, with the CoolSpools Spool Converter solution, you can automatically generate reports to PDF files and distribute them electronically or publish them in the cloud.

The licensed program filrs if different depending upon which release your server is running:. Thank you very much. Checking the veracity of the data. In my second example I am copying an existing spool file to my folder as a PDF file: The method I am going to describe can only be used IBM i servers with either version aas400. Just using this way to generate PDF.

Print lines that are all blank are not copied.

Job name Name Qualifier 2: I use this sequence: To data base file name Specify the file name of the physical file to receive the copy. Creation date date Specify the date the spooled file was created.

Creating PDF files from spool files | – From AS to IBM i

CoolSpools software can convert your spool file data to XML, ready to be imported into your web applications. Specifies a list of channel numbers with their assigned line numbers. Very helpful article Simon! Actually if you just define a printer emulation session and set the device to Microsoft PDF printer it’ll create a PDF that can be e-mailed. If this file does not exist at the time of the copy, the copy will fail. It helps you give your users and customers the right information, at the right conevrt, and, just as importantly, in the right format.


Specifies a user-defined physical database file to which the spooled records will be copied. There are still many organisations worldwide where vast amounts of reports are produced and printed out on printers and then manually analysed and distributed to the appropriate staff.

Sending the PDFs by email.

Tag Archives: spool file converter

Channel ocnvert Specify which channels are used to control skipping on a report. It will facilitate efficiency and transparency across your organisation and help your business to meet targets and analyse your operation in a more efficient manner.

Spooling is a function of your computer system that saves data for later processing or printing.

The licensed program code if different depending upon which release your server is running: Juan Dragone March 26, at 8: Your Excel files can be formatted conevrt you, with color-coding and even conditional formatting. Using that file this worked. CoolSpools is easy to use but immensely powerful.

Copy Spooled File (CPYSPLF)

I use this tool extensively to generate PDF instead of a spool file To prevent “comment spam” all comments are moderated. When it comes to converting spool to Excel, PDF, XML or many other popular file formats, few — if any — System i solutions on the market match the simplicity and versatility of CoolSpools software. To data base file Name Qualifier 2: How CoolSpools software can help: Line 3 assigned to channel 1 Line 15 assigned to channel 4.


All these posts are developed and tested on servers running IBM i 7. CoolSpools can handle all of this, without having to reopen your Excel document to manually amend it.

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

Apart from producing bespoke reports, the Spool Converter also enables the originator to password protect and encrypt the outputted PDF convery, as well as adding restrictions to the PDF conert including digital signatures to authenticate the report and show it has not been tampered with.

Anonymous October 7, at 2: The trick is not in making the PDF out of the spool file, but in placing the resulting PDF in a network directory after the creation Sreedhar iSeries follower March 26, at 7: You might currently extract separate sections of the data created on your system to send to different departments or individuals.

Find out more at http: User Name Qualifier ti Paul Putkowski March 27, at 3: Some people have reported that they cannot post a comment using certain computers and browsers.