Re: SQR output files in PeopleTools 8.16

[Aleksandra Gacevic <AGacevic@SCU.EDU>]

This is what I got from PeopleSoft when we had the same problem:

In PS 8 codeline, Distribution Agent  is not designed to recognize
file
extensions other than what has been currently coded.  The recognized
extensions are built in to our C++ code, and cannot be modified.  The
recognized extensions are:
.html
.htm
.trc
.log
.out
.aet
.csv
_frm.htm
.jpg
.pdf
.xls
.rtf
.doc
.spf
.wks
".jcd"
.txt
.lis

Without using one of  these extensions,  the file will never make it to
the
Report Repository.  The Distribution Agent will not recognize .dat
file
extension, or any other that is not on the list.

Although you cannot modify the recognizable extentions, you can modify
the extension on the file that is generated by your SQR report and
direct it to be sent to the desired location as a workaround.

Changing this in PeopleTools requires a database change, and that will
not
happen in the PT 8.1 codeline. The fix to this will be in PT 8.4.  See
T-KKO-VL9F8 Report Distribution - provide a utility to define
additional
files to be transfer for more information.




Aleksandra Gacevic
Programmer/Analyst
Santa Clara University
408 551 7124

>>> PALMECA@MAIL.NORTHGRUM.COM 09/11/02 11:57AM >>>
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