TOPS Master File - End of Term Grade Import
At the end of each semester, we download a copy of the Louisiana student master list from LOSFA, run it against our registered students, and send our students' grades back to LOSFA: https://mylosfa.la.gov/. This process is completed once per semester, and is augmented by a separate process that updates any grade changes each month.
Overview
Download TOPS “Master File” from LOFSA using Filezilla Client (http://filezilla-project.org/ )
Decrypt TOPS “Master File” using Kleopatra (https://tulane.box.com/s/19w2dbid6lp4v3s21gcd )
Upload TOPS “Master File” to Banner
Run APPWORX Job: REG_TOPS_EXPORT_C
Encrypt Grade File
Upload Grade File to LOSFA
Set Up Local TOPS processing directory
Create a new, current term directory in the following Box folder: https://tulane.box.com/s/ryffo6ojtuquz52ly9jdxr91v6kua26f
A new year directory may need to be created, with term subdirectories
Save all processing files in this directory
Download TOPS master file
Install Filezilla and set up LOSFA connection (if not already configured)
Download the LOSFA master file (TPYMR01.pgp) from the /college/Tulane/outgoing LOSFA directory
Section 1 instructions in this document: https://tulane.box.com/s/7k4bd4liqqzsz88p4yds429i4mt7m8o0
Decrypt TOPS master file
Install and set up Kleopatra (if not already configured)
Section 2 instructions in this document: https://tulane.box.com/s/7k4bd4liqqzsz88p4yds429i4mt7m8o0
Decrypt the LOSFA master file (TPYMR01.pgp)
Prepare list for Tulane processing
Upload the TOPS Master file (TPYMR01)
Banner form: GUAUPLP
Process name: Registration - TOPS
Appworx request
REG_TOPS_EXPORT_C
Parameters
Term Code used for the extract of information - required
The most recent spring/summer/fall graded term
Current Term (Current term of attendance) - required
The upcoming spring/fall enrollment term
File Type: Complete or incremental - required
Select “complete” as this is the first run of the term
Maintenance Date - optional
Defaults to last run date
This is the previous upload date in “Upload History” on the LOSFA website
Not required as this process is only used for the initial file upload
Prepare list for submission to LOSFA
Select Filename ‘tops_YYYYMMDD.txt’ from the APPWORX output
Save file with this naming format: TPYAI01.txt
Encrypt TOPS master file
Open Kleopatra and encrypt the TPYAI01 file
Section 4 instructions in this document: https://tulane.box.com/s/7k4bd4liqqzsz88p4yds429i4mt7m8o0
Rename the encrypted (.gpg) file to TPYAI01.pgp
Make sure the name is an exact match - case sensitive, change file extension, etc.
Upload TOPS master file
Open Filezilla
Upload TPYAI01.pgp to the /college/Tulane/incoming LOSFA directory
Section 5 instructions in this document: https://tulane.box.com/s/7k4bd4liqqzsz88p4yds429i4mt7m8o0
Notify Financial Aid
Email Roland Keller (rkeller1@tulane.edu) and Shan Baptiste (Baptiste, Shan sbaptis@tulane.edu) when grades have been submitted to LOSFA.
On this page
Related content