« July 2005 | Main | September 2005 »

August 26, 2005

Weekly Entry #2

Still working on scarf degrees and I'm making good progress on fixing those null major codes. I had Nancy fix the Education majors cipc, because that was coded in as a 000000 cipc code. I spent most of today getting the admitted term code into the licensure students record for the scarf report. I wrote the function to get the data but for some reason its still writing null in the output file. I'm going to try to narrow it down to my funtion, wou_student.pm package, or the scarf.pl script by putting in some debug code.

Posted by soukupm at 02:57 PM | Comments (0)

August 25, 2005

Weekly Entry #1

Nancy filled in several of the major and minor cipc codes into stvmajr and I ran a new scarf degree report and it cleaned up a bunch of null majors and minors but not all of them. It looks like there's a glitch on the Education majors and it returns a '000000' cipc minor code when it should be null (since education doesnt require a minor). So I'll have to step through the code and find where its failing.
I updated Financial Aid's laptop to run a local copy of SQL server since they take it to do presentations at high schools. It was a little involving to figure out how to import the database and configure it correctly so that they can connect to it. But a least I'm familiar with the process now so it shouldn't take long to get it ready when the time comes.
I wrote a script for Marilyn to display a list of students with AR holds for a given term and displays the students balance. As soon as I get extra time, I'll code it to display on the web so that she can run the report herself.

Posted by soukupm at 01:25 PM | Comments (0)

August 19, 2005

Weekly Entry #2

I finally figured out the major problem with the scarf degree report. It has to do with the table stvmajr, which holds all the codes for majors and minors and several other fields. After querying this table, I found that none of the minor codes have a cipc code. And several other majors and concentrations don't have cipc codes either. I'm working with Nancy and Faye to get those entered and then I'll send another report to OUS this next week to see how many errors this fixes.
I ran a report for Marilyn today that creates a data file for health insurance for students attending fall term. The process takes quite a while to run because you have to connect to the object server and type in a query, save the output to a file, run a sqlplus session, run another query, run a perl command to clean up the files, ftp the files to a unix computer and run another perl script, then ftp/or email it to a windows computer and import into excel. I think you get the idea...
Seems like a awful lot to do just to get an excel report. So I'm putting this on my list of things to re-code when I get some free time.

Posted by soukupm at 02:59 PM | Comments (0)

August 18, 2005

Weekly Report

This week I've been testing Banner 7 quite a bit, making sure all ends are covered. I met with Dorothy and tested shataeq. It seems to be working fine now that the patch was installed. I ran the payroll load for Sally, since Brian is on vacation this week. There was a couple problems I ran into since the pay number was incorrect but eventually got it resovled. I've been spending quite a bit of time on getting the problems fixed with the scarf degree report. Since I'm not totally familiar with all the tables involved in the process, its taken me a bit of time trying to figure it all out. But I've been able to fix a couple problems already and I doubled checked the number of degrees that we were reporting and the numbers look good. I helped get Financial Aid's database converted to SQL server yesterday and finished up the rest of the installs this morning and everything seems to be working fine. I also updated their website so that it connects to the new database. Last but not least, I've been helping Rick get the new lab image built for his new computers.

Posted by soukupm at 12:55 PM | Comments (0)

August 10, 2005

Continuing Banner 7 Testing

The Banner team has been hard at work testing Banner 7 before release in September so that we have a successful (hopefully bug free) launch. I've been able to add and drop classes from the web registration without any problems. We had a minor set back earlier in the week because web registration took around 5 mins or so to display the add/drop screen. It took me quite a while to figure out exactly where the slowdown was but I knew that it had something to do with a cursor that was selecting rows from spriden since we've encountered this type of problem many times in the past(because we use a view to the spriden table). So I ended up walking through the code line by line and looking at all the procedures and functions it was calling. I traced the major slowdown to a package called SOKLIBS. In this package, there's a cursor called advisorc that gets the name of the advisor. I added the compiler hint to it, and now the registration screen comes up in seconds. :)

Posted by soukupm at 12:40 PM | Comments (0)