« January 2008 | Main | March 2008 »
February 27, 2008
ID Masking
FTIIDEN
SOAIDEN
SOAIDNS
These have block definitions changed on spriden block as coming from a created view, spridenx. This view is only V numbers.
GB.IDENTIFICATION.f_idname_search changed to only pull v numbers. This is called from goqrpls library. It shows on search in name field of many forms.
Spaiden tab security is being used and alt id is masked along with ssn field in spbpers tab for all users. If a specific user has to be added, you have to enter in banner form
Posted by wendlerb at 11:13 AM | Comments (0)
February 26, 2008
Form upgrade
Going away:
SAADCRV
SHATAEQ
SFAREGS
SGASTDN
SOQOLIB
SOQRPLS
Also removed SWSPRDL from cron jobs and dropped the spriden_delete table trigger
Posted by wendlerb at 9:20 AM | Comments (0)
February 15, 2008
Hobson notes
I need to move data from banner into this Hobson software and also the other way around. Getting data from banner to Hobson is the easy part. I created SZRHOBS to pull recruit info based on term code , a from date, and a to date. The resulting file is a flat comma delimited flat file. Currently negotiating the exact format of the data with Hobson.
The other direction will be a lot trickier to deal with. I've set up an account to ftp output from Hobson over to wou_sis$disk:[wouprd.ftp.hobson] on spruce. I'll have to set up a temp table to sqlload the data into and then deal with creating new people in Banner without a unique id. Thinking of searching for matches with last name, first name initial, and birthdate. The only other stuff we have generating new ids now is the credit card stuff.
Posted by wendlerb at 10:11 AM | Comments (0)
February 6, 2008
OFAX Process
Here are the steps
1) Run szrofax with term code and save output to file from database. This pulls dual enrolled students (student type D) registered at WOU for the term
2) Log into state ofax site/
3) Upload the file into the state ofax database. Be sure and pick download return file instead of email.
4) Save return zip file and extract it with financial aid's password. Save file into J:\Financial_Aid-Business\OFAX. The file is a combination of WOU and Chemekata data which matches on SSN and birthday. Usually if there is a problem with the load, it's because a record in this file is missing the last character of a date.
5) The file is ftp'd to wou_sis$disk:[wouprd.ftp.fafsa] on spruce
6) Szpofax runs on a cron. It first sqlloads the file into a holding table, ryrotmp. Then the the proC program converts the format and loads the table ryrofax which is what is behind the Banner form.
Notes:
There is history on our table ryrofax but no history from the state ofax database. You get what was last put in. Szpofax deletes data from the current term before reinserting the new load but leaves previous terms alone. Data from Chemekata's last load and WOU's last load must be the same term or you end up with screwy data. There are a lot of mods in szpofax to deal with bad data coming from the state ofax site. Stuff like school codes coming in as 003209 and 3209.
Posted by wendlerb at 3:02 PM | Comments (0)
February 1, 2008
Print Credits
The busness office complained we were allowing students to buy print credits after they graduated. I went into wou_print and added a check for he following
Is term grad < current term
Do they have an awarded status on most current shrdgmr record
Are they not registered in the current term
If yes to these, they get a pop up box and then exit back to the student menu
Posted by wendlerb at 1:12 PM | Comments (0)