SQR output files in PeopleTools 8.16

["Palmese, Carman J." <PALMECA@MAIL.NORTHGRUM.COM>]

Don,  thanks for sharing the code below.


It works OK for us,  except it seems to have a limitation on certain file
extensions.   I have a SQR that creates both xxx.DAT and xxx.LTR files.
Both files get FTP'ed over to the Report Manager and are included in the
Report directory that is created on our Report server,  but the xxx.LTR is
not included in the INDEX.HTML that the PS Report Panel uses when you access
the reports.

Has anyone seen limitations on file extensions and developed a fix ?



Carman Palmese
Northrop Grumman Information Technology
Internal Information Services





-----Original Message-----
From: Don Barclay [mailto:      ]
Sent: Wednesday, June 05, 2002 16:53
To: SQR-USERS@list.iex.net
Subject: Re: SQR output files in PeopleTools 8.16


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