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: Aragis Zukazahn
Country: Tajikistan
Language: English (Spanish)
Genre: Software
Published (Last): 22 July 2014
Pages: 421
PDF File Size: 15.89 Mb
ePub File Size: 16.81 Mb
ISBN: 667-4-62796-927-9
Downloads: 36982
Price: Free* [*Free Regsitration Required]
Uploader: Kelabar

I have seen the examples posted. Steve Coyle April 22, at 1: TIFF files as well. Creation date Date Element 2: How to convert a AS spool file report to a formatted excel sheet? Using that file fkle worked. Specifies the name of aw400 system where the job that created the spooled file JOB parameter ran.

Use this value when the spooled file create date and time parameter is to take precedence over the job system name when selecting a spooled file.

I have attached a sample of how the excel sheet should come up The newly copied data is added to data existing in the member. Channel number refers to a method of determining skipping for reports. The AS spool report is generated.


I have using this since V5R4 and it still works in V7R1. You can learn more about these from the IBM web site: Then move output to this printer queue. This conversion dpool the use of spooled files in applications using microfiche, data communications, or data processing.

Convert IBM i (AS/) data and Spool files into XML

The newly copied data replaces all old data in the member because all old records have been cleared. Newer Post Older Post Home. Simon Hutchinson February 20, at 4: Go helpful article Simon! Today’s Posts Member List Calendar. I have times when a user will request that a report be emailed to them, rather than printed and sent to them via the inter company mail. The easiest way would be to create a PDF file from the spool file and then email ae400 to the requestor.

Qualified job name Optional Qualifier 1: Scroll through the list of programs to find the following this is from a 7. Moti March 27, at 9: Juan Dragone March 26, at 8: If it is not installed on your server ask your IBM i administrator to install: Just using this way to generate PDF. Just create a printer if you have client access and its print queue.

IBM i: Converting a spooled file to PDF

Bob Cancilla March 26, at Have you tried what is suggested here I couldn’t see it either, but the fact is that it happened. If you can generate a spool file with Hebrew characters I do not see why this would not work. Some people have reported that they cannot post a comment using certain computers and browsers.


Having a problem when I copy the spool file to pdf with overlay. I rely on viewing the list of licensed programs to see if it is there. This option may be useful for microfiche production.

Converting a spooled file to PDF

March 30th, I am not so sure that would work too most scenarios I use this for as they are batch jobs that run as part of the night run. CPF Duplicate job names found. As I have used the asterisk after the folder name the command displays all of the files in the folder:. Anonymous November 13, at Where allowed to run: I have received several communications informing me that you can use the Operation Navigator to convert a spool file to a PDF file.

sponsored links

Anonymous August 3, at 7: Lots of ways to tackle this one Specifies which print control characters if any are to replace the spooled file’s internal print control characters. This is a required parameter. To prevent “comment spam” all dpool are moderated.