As Asked: September 10, AM Last updated: October 25, 7: 31 PM. Related Questions. how to convert physical file to spool file? Navigation. We have a requirement, where in the AS spool file (report) needs to be converted to a formatted excel sheet and mailed to the respective. It can be painful to convert spool files from the IBM i, iSeries or AS to user friendly reports such as PDF and Excel without the right tools. Paperless Report.
|Published (Last):||6 March 2015|
|PDF File Size:||15.75 Mb|
|ePub File Size:||10.96 Mb|
|Price:||Free* [*Free Regsitration Required]|
The spooled files can optionally be converted using a workstation customizing object, which allows the spooled file to be converted to other formats. I would take a look at the Apache POI library.
IBM Knowledge Center
We’ll email you when relevant content is added and updated. Sign up using Facebook. Hi Jamie, Thanks for the quick response.
Add to your Watched Users. If you don’t know, tell us what third party tool you are using to convert it.
Ask a Question
If the page width isuse the following command to create a physical file with a record length of bytes: But, it’s the most basic format you can output to get a matrix of stuff out. This extra byte will be used for a First Character Form Control or FCFC character which will preserve the line spacing and page breaks in the spooled file.
Look to see the value specified for the Widththen use one of the following CRTPF commands to create a physical file to store the data from the spooled files. Post a question and let’s find out. If “cells” are needed regularly, there how to convert as400 spool file to two general options other than manual: Document information More support for: Check here to start a new keyword search. Another method to use is to creat a PF with a length of rather than How to convert a AS spool how to convert as400 spool file to report to a formatted excel sheet?
You should try it, confert may help you get rid of your current unstable tool I hope this helps. Then I can based on the text files to design the form in planetpress design. Find out the job qualifier, file name, and spooled file number for this spooled file. Anyone know how to do it?
This is an example. Can any one help me out with the code? But to capture jobs automatically, you must use PlanetPress Workflow.
Print Topic How to convert as400 spool file to to Threaded Mode. Hi Sopol, It all depends on what format your data comes in. IBM i Print Software version: If the page width isconvegt the following command to create a physical file with a record length of bytes, since an spoo byte is not needed for the First Character Form Control FCFC: It is meant to handle Microsoft format, including Excel.
Lots of ways to tackle this one For more information, refer to Example 7: And How to convert as400 spool file to said that our seller provide a tool called ‘Qprint’, this tool is written by them.
If the intent is to copy a spooled file, modify the data in the spooled file, and then copy it back to a new spooled file, then a source physical file should be created using the Create Source Physical File CRTSRCPF command. You need to parse that acordingly.
Convert spool file to physical file in AS/ – IT Answers
Lastly if its just querying tables you can do that using perl on a Win32 system and tl the results directly into a spreadsheet and email it. February 12th, Please try again later. Create a physical file using the CRTPF command with a record length equal to the record length of the spooled file.
This will take you to the Work spoo, Spooled File Attributes screen. February 27th, Sign up using Email and Password. April 13th, ,