« March 2011 | Main | May 2011 »

April 29, 2011

SWEFADP2 - Advisee List

I added a new column to SWEFADP2 (ESL) that identifies students that are only taking ESL classes for the term. This will help Advising filter out any ESL students that are registered for the term.

Posted by soukupm at 3:48 PM | Comments (0)

Banner INB login/password issues from portal

I made some changes to the Banner INB login procedure this week because several people were caught in an infinite loop where the system kept telling them to change their password. So far the fix seems to be working.

Posted by soukupm at 3:34 PM | Comments (0)

April 22, 2011

Badastd

I made some changes to the badastd.sql (bad academic standing) script this week. I added a new function f_cum_gpa_i that calculates cumulative institutional hours instead of overall hours. I made this change because WOU uses institutional hours to determine a student's academic standing instead of overall hours (institutional hours + transfer hours).

Posted by soukupm at 2:53 PM | Comments (0)

Scarf update

I changed the scarf script this week and added code to include workstudy data instead of running a separate procedure and manually pasting the data into the scarf file. It takes the script a little while longer to run but this way I don't have to remember to run a separate app for this data.

Posted by soukupm at 2:45 PM | Comments (0)

April 15, 2011

Real Time Schedule of Classes updated

I made some changes to the real time schedule of classes this week and added a new department selection to the app (Extended Programs). This choice will display all the Division of Extended Programs courses for the term. Prior to this update, DEP classes were not displayed on the real time schedule. I made some changes on the backend so that DEP's courses are loaded into the course table.

Posted by soukupm at 4:26 PM | Comments (0)

Linux Migration update

This week I was working on Pro C code compiling in Linux. The few programs that I tried compiled fine without errors. I ran into a problem with some of the programs though. They seem run fine until the end of the program and they'll crash with a segmentation fault. There's a line of code (exit2os()) that seems to be causing the problem. It's supposed to do memory and oracle connection cleanup, but it's crashing the program. I'm working on a solution and hopefully I'll have something next week.

Posted by soukupm at 4:17 PM | Comments (0)

April 8, 2011

Missing_grades job submission

I made a few more changes to the job submission missing_grades this week. It only pulls the primary instructor for the course now (it was returning secondary instructors prior to this so it had a lot of duplicates). I added some new logic that displays courses that have no instructor assigned to them (but the courses are gradeable).

Posted by soukupm at 3:16 PM | Comments (0)

Linux Migration Update

I got access to the Linux server this week so I started checking things out to get familiar with the system. At first, perl was missing the DBI package but OUS got that installed. A lot of our scripts use custom perl modules and they were all pointing to the old directories on VMS. I wrote a perl script ( fix_gencom_dirs.pl) that will fix all of these invalid directories.

Posted by soukupm at 3:00 PM | Comments (0)

April 1, 2011

Missing_grades and SWSRNGR mods

I made some changes to missing_grades and SWSRNGR job submissions today. Both of these jobs no longer exclude labs and look at the ssbsect_gradeable_ind to see if the course is gradeable. The part of term code in SWSRNGR will accept "%" for all parts of term codes.

Posted by soukupm at 3:34 PM | Comments (0)