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: Nam Maushicage
Country: Australia
Language: English (Spanish)
Genre: Business
Published (Last): 2 May 2008
Pages: 336
PDF File Size: 17.59 Mb
ePub File Size: 1.33 Mb
ISBN: 142-4-91649-321-8
Downloads: 25748
Price: Free* [*Free Regsitration Required]
Uploader: Kashakar

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 it to the requestor. 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 cobvert using native IBM i features?

Ss400 method I am going to describe can only be used IBM i servers with either version 6. 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.

I rely on viewing the list of licensed programs to see if it is there. The licensed program code if different depending upon which release your server is running:. In this example I will save it to the document test.

As I have used the asterisk after the folder name the command displays all of the files in the folder:. I have received several communications informing me that you can use the Operation Navigator to convert a spool file to a PDF file.

The above post was to describe how to create a PDF file from a spool file without human intervention, for example: I use this tool extensively to generate PDF instead of a spool file Just using this way to generate PDF. Thank you very much.

Just a question – How if at all do I get it to convert Hebrew characters? If you can generate a spool file with Hebrew characters I do not see why this would not work. I cannot put my hand on my heart and say for sure as ocnvert servers I have access to only have the US-English character set. I couldn’t see it either, but the fact is that it happened. If Filee could attach some screen prints’ I’d show you.


I can verify the copy doesn’t work at V6R1, but you can circumvent that. 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. Using cknvert file this worked.

Copy Spooled File (CPYSPLF)

Do you know what I need to do to make these available on the command? Paul thank you bring this to my attention. All these posts are developed and tested on servers running IBM i 7. I do not have access to a server with 6. Just create a printer if you have client access and its print queue. Then move output to this printer queue.

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

I have using this since V5R4 and it still works in V7R1. I use this sequence: The trick is not in making the PDF out ad400 the spool file, but in placing the resulting PDF in a network directory after the creation Above article is good to a created PDF.

Having a problem when I copy the spool file to pdf with overlay. I have checked and we have all ptf’s installed. Just now reading this thread For IBM i 6. But I have a problem. From IBM’s Suport documents: Required product option not available.

The function requires fi,e product TS1 option 01 be available to use. Very helpful article Simon!

sponsored links

That is great to know. TIFF files as well. Need to incorporate along with traditional spool files. Have you tried what is suggested here Actually if you just define a printer emulation session and set the device to Microsoft PDF printer it’ll create a PDF a400 can be e-mailed. I am not so sure that would work in most scenarios I use this for as they are batch jobs that run as part of the night run.

To prevent “comment spam” all comments are moderated.

aa400 Learn about this website’s comments policy here. Some people have reported that they cannot post a comment using certain computers and browsers.


If this is you feel free to use the Contact Form to send me the comment and I will post it for you, please include the title of the post so I know which one to post the comment to.

The licensed program code if different depending upon which release your server is running: Scroll through the list of programs ocnvert find the following this is from a 7. If it is not installed on your server ask your IBM i fioe to install: Display Object Links Directory. Correct the error and try the request again. In my second example I am copying spiol existing spool file to my folder as a PDF file: You can learn more about these from the IBM web site: Update I have received several communications informing me that you can use the Operation Navigator to convert a spool file to a PDF file.

Written by Simon Hutchinson at 4: Sreedhar iSeries follower March 26, at 7: Ron Deardorff March 26, at 8: Bob Cancilla March 26, at Juan Dragone March 26, at 8: Moti March 27, at spoll Simon Hutchinson March 27, at 3: Moti April 1, at 8: Simon Hutchinson October 7, at 2: KJB March 27, at Anonymous October 7, at 2: Claudio Torres March 27, as400 3: Paul Putkowski March 27, at 3: Bob Schaefer March 28, at Miles Sa400 March 28, at Tim Austin March 31, at 4: Randall Ames March 31, at 8: Simon Hutchinson April 8, at 4: Steve Coyle April 22, at 1: Anonymous July 3, at 8: Anonymous August 3, at 7: Tom Liotta January 26, at 4: Damiano February 20, at Simon Hutchinson February 20, at 4: Ben Leon March 26, at 9: Simon Hutchinson March 26, at 9: Markus During June 8, at 3: Anonymous November 13, at 9: Simon Hutchinson November 13, at Anonymous November 13, at Simon Hutchinson November 13, at 1: Anonymous November 13, at 1: Simon Hutchinson August 27, at 7: Newer Post Older Post Home.