May 18, 2013

Realtime schedule fix

I made some changes to the realtime schedule this week to fix an issue where the waitlist column was not displaying for courses that had non-typical start and end dates.

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

Dropped several temp tables

I dropped several temporary tables this week to clean up our database. All of the tables ended in '%BAK'. These are used to temporarily backup tables before a non-standard update.

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

May 10, 2013

Pinmail migrated to Linux

I migrated the program PINMAIL to Linux this week. This program is used to notify the summer session students that their pawprint account will be created. This script was a little bit tougher to convert because it calls three other programs to complete the job.

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

Reverse transfer update #2

To send out the reverse transfer transcripts, you have to run GLBDATA (or insert records directly into the glbextr table) to grab the population of students. Then you run SHRTPOP on that selection. Finally you run SHREDIY to transfer the transcripts. The first parameter has to be set to "Y" so that it sends transcripts from the SHRTPOP population.

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