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. AS/ Spool Files Physical files don’t convert to spooled files. The RUNQRY command can print records from a physical file with very little. 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: Net Fegore
Country: Paraguay
Language: English (Spanish)
Genre: Health and Food
Published (Last): 22 October 2005
Pages: 275
PDF File Size: 2.99 Mb
ePub File Size: 3.14 Mb
ISBN: 450-5-26987-578-9
Downloads: 65147
Price: Free* [*Free Regsitration Required]
Uploader: Vudokinos

Dear everyone, I’ve one question as below.

How to convert AS/ spool file into text file ? – Objectif Lune Tech Support Self Help

When I need to design the form by planetperss design, I must convert convret report into text files, and then I can load the text file by data selector sample data file in planetpress design, so I can base on the format of report to do. If it is possible, can you give me some instructions on it?


Thank you very much! What’s the original format of the spool file?

If ot don’t know, tell us what third party tool you are using to convert it. Hi Andy, It all depends on what format your data comes in.

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

Below are the options you have as far as converting to text goes: You may be able to convert to a plain text format simply with a Create File and making use of data selections and maybe splitters if it’s in a format that’s easy to use like XML, CSV, etc If you have multiple pages, you can use the PDF Splitter to split every convertt, and then use convegt “concatenate” option in a Send to Folder to concatenate the pages together.

So if that’s what you have you can usually see the word “EMF” in the first line if you open convfrt with a text editor These are pretty much your options for conversion of different type of files to plain text format. If you have some sort of binary file, or non-readable PCL file, you will not be able to natively convert it to plain text, and may have to use an external program to do it.


And I said that our seller provide a tool called ‘Qprint’, this tool is written by them. Then I can based on the text files to design the form in planetpress design. Is it use for capture inputted spool data?

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

Can it converts captured data into text format? Andy, In answer to your questions: It mimics some of the functionality found in PlanetPress Workflow. But to capture jobs automatically, you must use PlanetPress Workflow.

You should try it, it may help you get rid of your current unstable tool I hope this helps. Previous Topic Index Next Topic. X Forms to PlanetPress 4. X Forms to PlanetPress 5.

Print Topic Switch to Threaded Mode. You are not logged in.

Andy OL Guru Registered: Objectif Lune, Montreal, Qc. Switch to Threaded Mode. Add to your Watched Users.