Re: [sqr-users] Want to 'write' data file so it shows under 'ViewLog/Trace' in Peoplesoft

[don.barclay@srs.gov]

Dan,
Here's an answer that I posted in June.  This works quite well...

It is possible to have an SQR create a file and have it sent to the Report
Manager.  The trick is to write the file to the directory that holds the
reports before they are sent to the Report Manager.

A colleague of mine came up with this approach.  He uses the following
procedure to find the name of the directory folder that PeopleSoft uses to
hold files before they are moved to Report Manager:
______________

!************************************************************************
! Procedure: Get-Prcs-Output-Dir
!
! Descr:     Extract process output directory.  This file path is used to
!            put the output text file in the directory structure required
!            to be FTP'd to the Web Server.
!************************************************************************
BEGIN-PROCEDURE Get-Prcs-Output-Dir

BEGIN-SELECT ON-ERROR=SQL-ERROR

PRCSOUTPUTDIR    &PRCSOUTPUTDIR

FROM PSPRCSPARMS
WHERE PRCSINSTANCE = #prcs_process_instance
END-SELECT

END-PROCEDURE Get-Prcs-Output-Dir
______________

He then uses that directory when writing the file using code like this:
______________

  IF $prcs_process_instance = ''
    LET $FILENAME10   = '{FILEPREFIX}'||'sqrout\SRSIF34\Employee Extract_'
|| $Date ||'.dat'
  ELSE
    LET $FILENAME10   = &PRCSOUTPUTDIR || '\Employee Extract_' || $Date
||'.dat'
  END-IF
______________

As long as there is at least one other file being sent to Report Manager
(a single report would work), anything else that is in this directory
folder will be forwarded to Report Manager as well.  I know he's been able
to get this to work, but I haven't tested it.

Please let me know if you would like additional details.

Don Barclay
Westinghouse Savannah River Co.
Aiken, SC





"Dan Brinkley" <DBrinkley@techneglas.com>
Sent by: sqr-users-admin@sqrug.org


11/22/2002 01:55 PM
Please respond to sqr-users

 
        To:     <sqr-users@sqrug.org>
        cc: 
        Subject:        [sqr-users] Want to 'write' data file so it shows under 
'View Log/Trace' 
in Peoplesoft


Hello all (this is my first post)
Is there a way to get SQR (in Peoplesoft 8) to 'write' to a datafile so
that it will show in the 'View Log/Trace' option?
I know that:
'Show' commands create the logs.
'Print' commands create the PDF reports
'Write' writes to the datafile specified by the path in the 'open'
statement.

Since the path/directory changes with every run (eg.
log_output/SQR_SQRNAME_12345),
is there any way to put other files here?  And would the index.html
reference that file?

Anyone's feedback is greatly appreciated.

Daniel Brinkley
Techneglas, Inc.
Columbus, OH.
 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users