Financial Statuses Upload (Bulk) {FSAO-37} 


This program will upload the downloaded file from the directory as defined on {BATCH-7}.  Please take note that when the user change data on the existing records in the downloaded file, it is actually a new record that has been created. Therefor a new record will be inserted for the student.
Existing data will not be overwritten.  New records that have been inserted on the downloaded file will be uploaded as a new record.  
and {FSAO-38} and error messages will be available on the output list.  

It is recommended that the user run the upload program first in (T)rial mode, remove all the existing e.g. 'SQLERROR ERROR:  Record already exists' etc. records from the upload file so that only the new records exists on the upload program.  Thereafter the user can run the program in (U)pdate mode.

See examples below.
 
User Selection Prompt Text
* an item between square brackets [ ] is the default answer
Type
&
Length
Comments
  Enter the file name A60 The downloaded file name as created from {FSAO-38
(T)rial or (U)pdate RunA1User to insert either (T) for a trial run or (U)pdate to update the data on the system.
 


System Select  
  No special system selection.


Example
:

Example of ...



Example:  Import list

Example of ...


Example:  .csv file


Example of ...




Processing
Rules
 
  No special processing rules.




History of Changes

Date System Version By Whom Job Description
19-Sep-2019 v04.1.0.0 Magda van der Westhuizen
T237748 New manual.
29-Jan-2020v04.1.0.1Magda van der Westhuizent241379Update the manual.