« September 2007 | Main | November 2007 »
October 30, 2007
wops link on aero
I edited the active remaining packages on aero using the wops link to views under wou_util. This included the faculty/staff search stuff, some stuff under univ_comp that had something to do with purchase requests written by a student programmer, and a few other odds and ends. The wops link was public so we wanted to get rid of it anyway, I had to change the pwd for the link userid since no one could remember it and dropped the public link. I got caught on the fopal sync because there is an identical link on baninst1 on wouprd. So I changed the pwd on that as well and it synced ok.
Posted by wendlerb at 10:17 AM | Comments (0)
October 26, 2007
SFRENRL
Student enrollment verification report
A request for this report is done thru SFARQST. Currently the user then goes to job submission and runs sfrenrl to print the report. It is usually done on special paper and the report spits out a blank sheet, the report, and a report info footer page. Registrars only wants the middle page. I looked at the source and noticed it was set up not to print the last page when running in sleep/wake mode. It looked like the com file started to be coded for sleep wake but not finished. So I debugged the com file so it works from sleep/wake and removed the blank page in front. It is currently running on W_REGCOUNTER every 45 sec.
Posted by wendlerb at 11:38 AM | Comments (0)
October 23, 2007
ftp_ous
This printer option didn't work in wouupg. The error message indicated the process made it to gjajobs_ftp.com ok and errored out there. Key pairs needed to be set up in wouupg for the sftp connection. Once the dbas did this, it worked ok. I'm having them set up wouprd now for this so we won't have to deal with it later after the merge.
Posted by wendlerb at 9:38 AM | Comments (0)
October 17, 2007
Shrtaeq
Issue: The report is supposed to not print out entire line when everything is the same except the wou equivalent attribute field. Now, sometimes it does and sometimes it doesn't. There is a wou mod that checks the previous record.
Solution: The sort order didn't always put the tsubj and tcrse together do I added the two fields at the end of the sort on the main select statement
Posted by wendlerb at 9:40 AM | Comments (0)
October 15, 2007
Employee tax packages
Bring over from wodv
bwpkxw2s
ppw2
pp_w2_2006
pp_w2_common
Posted by wendlerb at 8:25 AM | Comments (0)
October 8, 2007
Restricted list
baninst1
saturn
fimsmgr
wtailor
bansecr
oper
wendlerb
soukupm
vandeusm
whitenaf
silbernd
vickersb
lindj
dunkins
olsenk
hickersj
wongf
Posted by wendlerb at 10:47 AM | Comments (0)
October 4, 2007
Compliance compile
I had to try out a minimal change on smrgevl and thought i should document the compile steps so I could find them easily.
$! If only one of smrgevl,smreval,smrrule,smrjobs,smrsels,smrbcmp or
$! smrcmpl change then only compile the individual change.
$! The lnproc lines must always be included if any of the pieces
$! change.
$!
$ @gen$com:sctproc scroims OBJ "full userid=baninst1/u_pick_it"
$ @gen$com:sctproc scrrfun OBJ "full userid=baninst1/u_pick_it"
$ @gen$com:sctproc scrrims OBJ "full userid=baninst1/u_pick_it"
$ @gen$com:sctproc smrgevl OBJ "full userid=baninst1/u_pick_it"
$ @gen$com:sctproc smreval OBJ "full userid=baninst1/u_pick_it"
$ @gen$com:sctproc smrrule OBJ "full userid=baninst1/u_pick_it"
$ @gen$com:sctproc smrjobs OBJ "full userid=baninst1/u_pick_it"
$ @gen$com:sctproc smrsels OBJ "full userid=baninst1/u_pick_it"
$ @gen$com:sctproc smrbcmp OBJ "full userid=baninst1/u_pick_it"
$ @gen$com:sctproc smrcmpl OBJ "full userid=baninst1/u_pick_it"
$ set def gen$exe
$ lnproc smrcmpl smrcmpl,smreval,smrgevl,smrrule,smrjobs,smrsels,guaorac2,guastdf,guarpfe
$ lnproc smrbcmp smrbcmp,smreval,smrgevl,smrrule,smrjobs,smrsels,guaorac2,guastdf,guarpfe
Posted by wendlerb at 3:22 PM | Comments (0)
October 2, 2007
Web pin generation and forgot pin button
Registrars asked if no character 'O' could be used in web pin generation because students got it confused with the number 0. The package goklibs contains a f_GenRandChar function that gets used in pen generation when the form GUAPPRF has pins set to random. I moded function to not use the O character.
Registrars also asked that the user question get asked first before the forgotpin button on the login page goes to the pin reset link on aero. It's set up now to give the question first. If the response is incorrect, the user can click a button to go to the aero page. If the answer is correct, it does the Banner baseline reset.
Posted by wendlerb at 1:57 PM | Comments (0)