ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Convert spool to PDF or Excel format

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Convert spool to PDF or Excel format

    How do I convert spool to PDF or Excel format ?
    iSeries Document Solutions
    A less paper office can create a healthier planet.

  • #2
    Re: Convert spool to PDF or Excel format

    This may help with PDF.

    http://www.itjungle.com/fhg/fhg043014-story02.html

    As for Excel, I have built stream files in IFS, but it hasn't been worth the effort in most cases. Scott Klement has some good stuff for this.

    http://www.scottklement.com/poi/

    Most of the time, I build CSV files. It's much easier and quicker on my end and usually sufficient for the user's needs. I have a scripting language that makes quick work of creating CSV files from spooled files.

    http://www.itjungle.com/fhg/fhg121212-story02.html

    Comment


    • #3
      Re: Convert spool to PDF or Excel format

      A commercial alternative for converting existing spool files (extracting the data from the report) to Excel is Monarch by Datawatch.

      Cheers,

      Emmanuel

      Comment


      • #4
        Re: Convert spool to PDF or Excel format

        If you're on i7.1, check to see if you have Product 5770TS1 option 01, the IBM Transform Services installed. It is a no-charge feature included with the OS, but it may not be installed on your system. If not installed, if you have the distribution disks for the OS it looks like this service is on B_GROUPx_04, according to this IBM information:


        Then you'll be able to use CPYSPLF... TOFILE(*STMF)... TOSTMF('myifspath') WCST(*PDF). Also you'll be able to view spoolfiles that are in an OUTQ as PDFs if you use IBM Navigator for i.

        Comment

        Working...
        X