« September 2005 | Main | November 2005 »
October 28, 2005
SHRTRAT and AHRTATT attribute codes for split course
Both split courses need attributes given to the primary one. In order to do this I had to find transfer courses that had the split where only one had the attributes and then copy them to the other course. Two scripts take care of this, shatatr_insert and shatrns_insert. Ran into a problem with obsolete records of the 100T attribute. The seqno of these records is pretty tricky and the 100T record was fouling it up the first try. Wrote a script, shatatc_tmix, to take care of a bunch of these T records.
Posted by wendlerb at 1:35 PM | Comments (0)
October 27, 2005
Staff Development Day
I worked on getting familiar with Bi-Query Administrator. Took a while to find the installation stuff but I put it on one of the machines in ITC104. I am doing something with this for senior project so it's dovetailing nicely with work. It wasn't that hard to create a con connection to wilbur. Spend most of my time with design layout, look and feel today.
Posted by wendlerb at 11:21 AM | Comments (0)
Undergraduate on line application
I actually got in here while looking at the web credit card piece and discovered it looked like crap. All the header and footer images were broken making it look really unprofessional and certainly not something we'd want perspective students to see. The images were all linked to https://wou.edu:8080/images This port is no longer any good. The images are actually found at http://www.wou.edu/images. I changed the url of the images in the code where I found it on the applications schema but that didn't help the main page. Holy cow, what a can of worms. This page was created under WEBDV and the page header and footer info comes from a table buried way down. The table is wwv_usr_app_template_details$ and it is in the long variable. Probably want to talk to Ron and see if we can map these so we can keep them in SSL.
Posted by wendlerb at 11:14 AM | Comments (0)
October 26, 2005
Senior Project
I've been taking a class a term in the Information Systems program now for over 2 years. This semester and next I'm doing senior project. In order to get something out of this that might be useful, I and my other two students in 3Wolf Consulting are going to work on an AR module to a prototype student warehouse in Bi-Query. Jermmy has agreed to be our sponser removing me one step from WOU. This is suppoded to be a two term project so I'll be learning Microsoft project as well as Bi-Query administrator. I wonder if ETS has any training material on it.
Posted by wendlerb at 9:08 AM | Comments (0)
October 24, 2005
CC double charge
We've had an issue with the new undergrad application web credit card oiece for quite a while. People were double clicking the submit button and charging themselves $50 multiple times. I put some pretty simple java code in the package in wou_sis_util to prevent double clicking but it never seemed to work and I couldn't figure out why. Well it looks like it was something kinda strange. The statement vcount++; was not working properly and actually caused the rest of the whole function to not execute. No errors to indicate this. vcount = vcount + 1 works fine and the function works normally. I looked at 13 transactions over the weekend and no duplicates.
Posted by wendlerb at 9:03 AM | Comments (0)
October 20, 2005
pidm creation
It turns out we were having a problem with the new logic that banner uses now to create the next pidm. It uses a squence now instead of the old sobseqn table. The two systems were each using their own pidm sequence which can get offset from each other. There is logic which looks at max pidm on spriden. There is a table,swbpidm, which contains crosswalk information on pidms between SIS and Fis. The spriden insert table trigger does not fire if this pidm exists in swbpidm. The problem happens when a purge process takes place removing spriden records. The corresponding records in swbpidm do not get removed. The pidm generation looks at max pidm on spriden and assigns it next one which is already in swbpidm. The table trigger doesn't fire and you end up with no V number generation untill you get past the last pidm in swbpidm. In order to fix this we are going to use the pidm sequence on wops for both systems through a mod to gb_common in wouprd.
Posted by wendlerb at 11:21 AM | Comments (0)
October 17, 2005
Swbpidm
This is a table that tracks sis pism and corresponding fis pidms. It came up when PPAIDEN stopped working in WODV. Turns out that spriden_table trigger will not fire if pidm already exists in this table.
Posted by wendlerb at 3:17 PM | Comments (0)
October 13, 2005
This and that
Started getting strange things going on with the student check system yesterday late afternoon. Checks were being duplicated or taking 2 pages to print, etc. Looks to be that the were coming from WOUCHEK running on a particular machine. Had them reboot. Also have request to set up audit mode on batch check process.
Posted by wendlerb at 8:04 AM | Comments (0)
October 11, 2005
Fzruinv
This open invoice report has always been a tricky one. In the past the report has only shown one of the next approver in the queue and not all of them. I changed the main select union to pick them all up and reformatted the output so all the approvers line up.
Posted by wendlerb at 9:01 AM | Comments (0)
October 7, 2005
Bi-Query training
The Bi-Query training went pretty smooth yesterday. telecom has tirned off several network jacks again to avoid a charge so we are finished with the extra computers Rick installed. I will put the connection default back to the proper con file.
Posted by wendlerb at 11:40 AM | Comments (0)
October 4, 2005
Campus Directory
I've recieved all the new employee photo ids and directory photos from telecom. I did the batch process on Adobe Photoshop 7.0 and placed finished pics in the programmer folder under ucs. Teresa has handed me all the returned employee forms and I've input their decisions into the zsraddr table. Next we wait on HR to do a bunch of the address corrections. This would be greatly speeded up if staff were encouraged more strongly to do this for themselves on line in web for employee.
Posted by wendlerb at 2:57 PM | Comments (0)
October 3, 2005
Bi-Query
We are currently running Bi-Query Version 7.0 with several models and data marts. There's a model for Hr, am model for fis, a model for telcon, and a model for sis. There's a mmodel that the physical plant uses and a budmart used by the budget office. The sis model is actually a virtual data warehouse that is tied to the research table. So far we still have the problem of having to install oracle form server on the machine because the bi-query install uses something from it in order to do a sqlnet connection.
Posted by wendlerb at 8:47 AM | Comments (0)