« April 2012 | Main | June 2012 »

May 25, 2012

Job scheduling on linux

We will be using Oracle's dbms_schedular when we migrate to Linux this summer. I ran into a problem when I tried to view the table dba_scheduler_jobs. It was giving me an ORA-01882 timezone region %s not found error. This error happens when the oracle client is below 11G.

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

Linux printing

I met with the OUS team this week and we decided to setup banner printers on our own local server and share our printers with OUS using the CUPS software. We setup a few test printers and OUS was able to browse our printers. I did a test landscape page and it printed successfully. Now I'm working with our unix admins to see if we can use PCL drivers instead of Postscript. We have several job submissions that have embedded PCL code so we really need PCL to work.

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

May 18, 2012

NCAA grad rates

This week I've been working on the NCAA graduation rate report. I loaded the cohorts into two tables (NCAA_GSR_2005_CHRT - for all the first time freshman,NCAA_GSR_2005_ATHL - for first time freshman athletes). All of the data has been loaded into the grad rate site. The only item left to do is checking whether a student athlete left while eligible to compete. I'll need help from Health & PE to finish this part since this data is not in Banner.

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

New Job Submission - FZPFEED

I created a new job submission called FZPFEED. This job runs FURFEED and FGRTRNI. It'll be used as a cron so that transactions posted from FUPLOAD are loaded into the finance system.

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

May 17, 2012

Linux printing update

I did some linux printer testing this week and I think the landscape printing issues we are having has to do with how the printer was configured in linux. When I do a lpoptions on our printers, it returns an error "Unable to get PPD file". For printers that print landscape correctly, this command returns a list of available options for that printer. I think once we get our printers setup correctly, it should fix the landscape problem we're experiencing.

Posted by soukupm at 11:13 AM | Comments (0)

Linux printing update

I did some linux printer testing this week and I think the landscape printing issues we are having has to do with how the printer was configured in linux. When I do a lpoptions on our printers, it returns an error "Unable to get PPD file". For printers that print landscape correctly, this command returns a list of available options for that printer. I think once we get our printers setup correctly, it should fix the landscape problem we're experiencing.

Posted by soukupm at 11:13 AM | Comments (0)

May 11, 2012

Degreeworks - Mods to DGW_Report.xsl

I made some changes to the Degreeworks worksheet this week. I removed the minor code for graduate students and replace it with a program code. Undergraduate students will still see a minor code. I removed the financial aid and athletic tabs from the sidebar by removing a few keys from SHPCFG. These can be added back fairly easily if we decide we want them back.

Posted by soukupm at 10:48 AM | Comments (0)

May 4, 2012

Degreeworks update

I met with the Registrar's this week about Degreeworks and they would like a few more mods to the student view worksheet for Graduate students. I'll start working on this next week. I ran into a problem where the bannerextract was not updating students and it seems like it's not using my sql file for loading students. I seem to get around the problem by feeding the bannerextact a list of vnumbers in a file.

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

Non-standard update on guruprf

I did a non-standard update to guruprf (banner inb preferences table) and removed all of the banner bookshelf links. This link no longer works on java 1.6.024 client because of a security risk. Users can still access the bookshelf through the WOU website.

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