Home > IT Answers > Development > Converting spyview optical reports to pc .pdf
Karen0502
0 pts.
 Converting spyview optical reports to pc .pdf
Application development, AS/400, CLP, PC/Windows Connectivity
I am trying to convert my as400 reports that are currently stored on optical using the product spyview (Gauss Company) to a .pdf report on my pc/server. I currently do not have support with Gauss any more so I can not call them. I need to restore all of my history from the last 6 years and put it on a server. I tried the command EXPOBJSPY and I could restore the reports to pc but it put the report out as a .txt report and I would like for it to be an .pdf report so I would be assured that no one would change the report. It also would not allow me to print the report in it's original format. This command was nice because I could put in one report name and it would restore all of the reports for me. I also looked at restoring the reports from my optical by doing the option to restore and print in spyview. Then do a CPYSPLIFS to put the report to a .pdf on the pc. This will work but it is a very long and cumbersome process. I would really appreciate any help that anyone can give me on this. Thanks in advance.

Software/Hardware used:
ASKED: April 3, 2006  9:49 AM
UPDATED: April 5, 2006  2:35 PM
RELATED QUESTIONS
Answer Wiki:
If you can restore your reports to the iSeries you can generate the PDF files directly from the iSeries. Create an *IPDS printer: Device class . . . . . . . . . . . : *LAN Device type . . . . . . . . . . . : *IPDS Device model . . . . . . . . . . . : 0 LAN attachment . . . . . . . . . . : *IP Advanced function printing . . . . : *YES Port number . . . . . . . . . . . : 11002 Remote location: Name or address . . . . . . . . : 127.0.0.1 User-defined object . . . . . . . : ********* Library . . . . . . . . . . . . : ******* Object type . . . . . . . . . . : *PSFCFG The *PSFCFG will define the output format and destination on the IFS. PDF device emulation type . . . . . . : *IP40300 PDF file location . . . . . . . . . . : /PDF REPORTS This will cause the PDF report to be output to a directory called "PDF Reports" on the IFS. You use the created output queue as a normal output queue and any spool files are "printed" and converted to PDF on the IFS. Hope this helps. Miles
Last Wiki Answer Submitted:  April 4, 2006  6:53 am  by  MilesButler   0 pts.
All Answer Wiki Contributors:  MilesButler   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Interesting solution – what version of OS/400 does this apply to? I tried it on v4r5, but can’t see anywhere to define the PDF output folder, etc.

Jonathan

astradyne
 370 pts.
 

Create PSF Configuration CRTPSFCFG
PSF configuration . . . . > TEST
…..
Generate PDF output . . . . . . *NONE *NONE, *SPLF, *STMF, *MAIL

When you change the PDF output option you get a range of pssibilities including destination.
Miles

MilesButler
 0 pts.
 

To use the PDF transform on the iSeries, you require only Infoprint Server for iSeries (5722-IP1).

Or you can download CVTSPLSTMF (Converts an SCS spool file to a stream file. Text, HTML, and PDF conversions supported. It is part of the Other utilities) from http://www.easy400.net/mmail/start

JPLamontre
 0 pts.