« Fac/staff directory creation | Main | Perkin's Soil Overview »
September 9, 2008
Ofax overview
Where to start?
Ofax uses the temp table ryrotmp to load the flat file in wouprd and the table ryrofax which is behind the form RYAOFAX.
The Banner program, szrofax, creates a file which gets uploaded to the ofax web site https://secure2.osac.state.or.us/fao/ You run szrofax from Banner job submission and print to database so you can grab the file. You can get login info to the state web page from financial aid. You upload the file and then download a return file. This file,ofaxout.csv, contains info from all institutions in the the dual enrolled student's program. It gets ftp'd to wou_sis$disk:[wouprd.ftp.fafsa].
This file often has the last character of a date missing on one record which will foul you up. The leading 0's on SSNs also often get dropped.
The program szpofax converts data in ryrotmp and inserts into ryrofax.
The terms of all institutions in the ofaxout.csv file have to be the same.
At the start of a term, I usually make delete and recreate a backup table of ryrofax. There is a delete statement in the program szpofax that will error out if no data exists in the new term. I left this in to prevent the cron fron processing the first entry in a new term. You save yourself a lot of headaches if you check the file to make sure all the terms are the same and run szpofax
while commenting out the delete statement for the first run. Financial aid runs it at the end of the term to get grades and often the next run has mixed terms
Posted by wendlerb at September 9, 2008 9:47 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)