SQR output files in PeopleTools 8.16

[Aleksandra Gacevic <AGacevic@SCU.EDU>]

Thanks everyone for helpful suggestions!

The basic idea most of you used was the same - put the output file in the right 
directory - and it worked great!

I noticed that Report Manager moves all files sitting in that directory to 
psreports directory, but doesn't build the link in index.html if the file 
extension is 'ltr', for example.

Also, from index.html, almost all files (log, trace, output) are opened with 
IE. Flat files then have to be saved 'As Text' so other processes can use it. I 
hope they don't get modified through conversions. Is there a setup there that 
will cause TXT files to be opened with Notepad from IE, like PDF files are 
properly opened with Acrobat Reader?

Finally, is the Format specified in Process Scheduler Request completely 
irrelevant?

Thanks again.

Aleksandra Gacevic
Programmer/Analyst
Santa Clara University
408 551 7124

>>> colemanj@WASHPOST.COM 06/06/02 08:56AM >>>
We got the Report Distribution Manager to handle flat files using the
following steps.  We found it advantageous because it doesn't require any
modifications to delivered SQRs if the files are defined using FILEPREFIX
and FILESUFFIX, as are PeopleSoft's TAX SQRs.

Basically, you pass the %OUTDEST% to the SQR pre-compiler variable
FILEPREFIX, so the flat file ends up in that directory, and is handled by
the agent.  A file suffix of .txt is defined as a default, but it will also
work with .dat, .csv, and .lis.

(1) Modify setenv.sqc, as per the commented code:

#ifdef UNIX
!#define FILEPREFIX /usr/tmp/       !TWP
begin-setup                   !TWP
ask FILEPREFIX                !TWP - pass from cmd line
end-setup                     !TWP
#define FILEPREFIX {FILEPREFIX}/    !TWP
#define FILESUFFIX .txt             !TWP

(2)  Add the following to the pssqr command line definition in the process
scheduler for Unix.

-PP %%OUTDEST%%


(3) Use the following file-open syntax in the SQR

  open '{FILEPREFIX}TAX810DC{FILESUFFIX}' as 10 for-writing record=80:fixed









                      Aleksandra
                      Gacevic                  To:       SQR-USERS@list.iex.net
                      <AGacevic@SCU.EDU        cc:
                      >                        Subject:  SQR output files in 
PeopleTools 8.16
                      Sent by:
                      "Discussion of
                      SQR, Brio
                      Software's
                      database
                      reporting
                      language"
                      <SQR-USERS@list.i
                      ex.net>


                      06/05/02 04:04 PM
                      Please respond to
                      sqr-users






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