Find External Files

by vandberg published Feb 28, 2012 11:30 AM, last modified Jun 23, 2017 02:37 PM
Run Instructions

Function:

Find and process files from an external system that match a specified pattern. 

Operation:

 From the menu, select:

Main Menu > UWO Student Financials > External Files > Find External Files 

Select a Run Control ID or create a new one.  -- See Using Run Control ID

Find External Files

Find External Files 1 

Select the code for the External File.  The process will use the setup information that was entered for that code.  See External File Table

SFTP Applications

Find External Files 2

 All files handled by this process must be copied to the database server.  An SFTP application must be defined for each file to do this. 

  • If the file name does not contain a date or other information that changes each time, there should be two SFTP applications.  One will get the file and the second will delete it. 
  • If the file name does change, there should be one SFTP application that does a multiple get (mget). 

See Secure FTP Applications.

External System SFTP Application Retrieving File Storing File
Bookstore sfprgpld_05 sfaout.txt  
Health Center sfprgpld_01 stu_health_bursar*.dat

 Load External File

Find External Files 3

Enter the information that is needed to load the external file.  See Entering Transactions from an External Source in Student Financials PeopleBook.

Business Unit is already set to the value for UW Oshkosh.

File Name and File Directory will automatically be set when the file is found.

Posting Group

Find External Files 4

Enter the information that is needed to post the group that is created when the external file is loaded.  See Posting Group Data Entries in Student Financials PeopleBook.

Business Unit is already set to the value for UW Oshkosh.

The Starting Group ID and Ending Group ID will automatically be set.  The Group ID can not be determined before the external file has been loaded.

Running the Process

Run the process using the Process Scheduler.  -- See Using Process Scheduler

Ensure the Process Scheduler Request page has these values:

  • Server Name is PSUNX.
  • The box is checked in the Process List by Find External Files, ZSFA041A, PSJob.

  • Type is Web and Format is  PDF.
External System Recurrence
Bookstore ZSFA041A_WEEKDAYS_1000AM
Health Center ZSFA041A_WEEKDAYS_0800PM

Use the Process Monitor to view the output of the process.  -- See Using Process Monitor 

The external files are loaded and posted by a different process than the one that finds them.   You only submit the process that finds the files.  The other process is submitted automatically, but you must be aware of the different processes when viewing the Process Monitor.  The process that finds the files is zsfa041a and the process that loads and processes them  is zsfa041.  If more than one file is found, there will be a separate zsfa041 process for each one.  If any file contains both positive and negative amounts, it will be split into two files and the zsfa041 process will be run for each one, instead of the original file.  Files which may contain both positive and negative amounts must not contain control totals, because they would not be correct after the files are split.

Additional Information:

See the system instructions -- Load External Charges  

There are a number of values that must be entered for each external system. -- See List of Values