SQR output files in PeopleTools 8.16

[Aleksandra Gacevic <AGacevic@SCU.EDU>]

Hi,

We are upgrading to People Tools 8.16 and have issue with how to make SQR 
output files (especially text or csv files) accessible to users. We are running 
SQRs on PSUNX.
PeopleSoft provides a way to move files from PSUNX to the report repository if 
the output type is 'Web'. It really works if the output is created using SQR 
'print' command, and the output format is PDF or HTML, but not CSV or TXT. If 
the file is to be opened and data written to it within SQR (so output file 
location is specified) - it never works.
I don't know if we're missing something in the Process Scheduler setup.

We tried another approach - to ftp files from PSUNX to browser within 
PeopleSoft using PeopleCode (AddAttachment function), but we got it to work 
only from browser to PSUNX (that's how we will upload files).

Did anyone experience similar problem?



Aleksandra Gacevic
Programmer/Analyst
Santa Clara University
408 551 7124