Re: SQR output files in PeopleTools 8.16

[dennispal <dennispal@COX.NET>]

We are also on 8.16 and ran into this during our upgrade.
We opened a case with Psoft and were told that this is a
known bug.  They hope to have it fixed in release 8.4.

Meanwhile, you can handle it very simply with a few extra
lines of code.  You do NOT have to re-write your programs
that write files "to be reports".  SQR provides a built-in
variable called "$sqr-report".  This is actually the full path
filename (path+filename).    Simply strip off the front part
of the path - remove the trailing filename - and then append
whatever filename you want to the path.  I.e.   "their" filename
is typically of the form processname_instance.lis .  Your
 process definition name is (must be) the same name as your
SQR program.  Say the sqr is "mysqr.ssqr"  then "their"
filename will be "mysqr_567445.lis"  or "mysqr_567445.pdf"
if you run it as Web/pdf.  You should know how to run it (as
 pdf, ps, hp, etc).

Anyway, build your own "second" filename (DON'T use the
default one yourself), open it, write to it, close it.  It will put
it in the same "temp" directory that it would have put the
report into.   The Report Manager always seems to just scoop
up everything in that directory and then move it all to the
psreports directory and then builds links to it all.  We have done
this with programs that generate 3 flat files and 2 reports
and many other combinations.    It works great.

We are using Unix for our server environment, but that should
not matter - $sqr-report is always "right".  Sqr itself is using it !

By the way.  We never screw around with trying to build .CSV
files by running them as Web/CSV.  It's buggy.  We use the
technique I just described and simply name the resultant
output file   path/path/path/filename.csv ourselves.   That way,
WE control what goes into it.  Quotes, whatever.

Hope you find this useful.  It works great for us.  In fact, a
peoplesoft consultant who was helping us with our upgrade
was most interested in this technique.   hmmmmmm.

DennisP

----- Original Message -----
From: "Aleksandra Gacevic" <AGacevic@SCU.EDU>
To: <SQR-USERS@list.iex.net>
Sent: Wednesday, June 05, 2002 4:04 PM
Subject: SQR output files in PeopleTools 8.16


> 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