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: Tygorn Bragal
Country: Indonesia
Language: English (Spanish)
Genre: Medical
Published (Last): 22 January 2010
Pages: 436
PDF File Size: 16.87 Mb
ePub File Size: 1.68 Mb
ISBN: 214-5-51142-542-4
Downloads: 77957
Price: Free* [*Free Regsitration Required]
Uploader: Miramar

Job name JOB Specifies the job that created the spooled file whose data records are to be copied. The licensed program code if different depending upon which release your server is running:.

Specifies which print control characters if any are to replace the spooled file’s internal print control characters. Juan Dragone March 26, at 8: Channel number refers to a method of determining skipping for reports. If this file does not exist at the time of the copy, the copy will fail.

February 11th, Actually if you just define a printer sopol session and set the device to Microsoft PDF printer it’ll create a PDF that can be e-mailed.

This value is not allowed for spooled files which exist on primary or secondary auxiliary storage pools. The FCFC 1-byte print control character is used and takes advantage of the assigned channel values in formatting the output.


The only valid values for this parameter are 1 through The assigned line number for channel 1 is line 1. The above post was to describe how to create a PDF file from a spool file without human intervention, for example: Also check out this article which discusses how to copy spool files to your PC via Operations Navigator: This option may be useful for microfiche production.

sponsored links

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. Anonymous November 13, at CPF Member not added. The flie channel values as specified on the command are as follows:. Job name name Specify the name of the job that created the spooled file.

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

In this example I will save it to the document test. Graphics data is lost. I couldn’t see it either, but the fact is that it happened.

Read this pyiscal file and split the rows into columns. Do you know what I need to do to make these available on the command? Moti April 1, at 8: Tom Liotta January 26, at 4: Ben Leon March 26, at 9: February 12th, Need to incorporate along with traditional spool files.

In fild second example I am copying an existing spool file to my folder as a PDF file: I rely on viewing the list of licensed programs to see if it is there. Randall Ames March 31, at 8: Moti March 27, at 9: From IBM’s Suport documents: Claudio Torres March 27, at 3: Here are the steps: Conveet 4-byte print control code is created.


You can learn more about these from the IBM web site: Anonymous November 13, at 9: I have seen the examples posted. There are many third party tools that allow you to be able to convert a spool file to PDF, but how can I do it just using native IBM i features? There are also lots of commercial convdrt that can do this stuff for as400 automagically.

Required product option not available. This parameter is considered after the job name, user name, job number, spooled file name, and spooled file number parameter requirements have been met.

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

I have been building all of my reports with 3 options Thank you very much. Lastly if its just querying tables you can do that using perl on a Win32 system and ump the results directly gile a spreadsheet and email it. Bar code data is lost. Anonymous July 3, at 8: CPF Duplicate spool names found. CPF Copy request failed. To data base file name Specify the file name of the physical file to receive the copy.

Simon Hutchinson August 27, at 7: