Re: SQR output files in PeopleTools 8.16

[Jerry Coleman <colemanj@WASHPOST.COM>]

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