« August 2012 | Main | October 2012 »

September 28, 2012

E-disbursement feed to finance

I manually fed the e-disbursement checks into finance on 9/26 and 9/27. Those checks haven't fed since we migrated to Linux on 9/3 because of a script error. All of the checks have a check date of 9/26/12.

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

Degreeworks - Mod for Post bac students and legend

I made a modification to the student worksheet for Post Bac students so that the "minor" and "anticipated grad term" display on the page. I also made a modification to the side bar legend so that the text matched the legend displayed on the bottom of the page.
I did some research to find out if we could change the "academic year" text for each block to "catalog year". It looks like it can be changed by updating the description field for the CATYR value in SCR001.

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

September 18, 2012

TZREDUD Table update

I made some changes to the external table TZREDUD (this is used by the e-disburse process). I added the following access parameters to the table:
lrtrim missing field values are null
REJECT ROWS WITH ALL NULL FIELDS

We received a file from the bank that had a string of whitespace at the end of each record and the rows were being rejected. We also had records that were blank (filled in with whitespace). These two parameters will filter those records out of the table.

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

Textpad - search for lines with spaces

To search for blank lines in Textpad use this expression:
\n\x20+$
Make sure the regular expression checkbox is checked.

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

September 14, 2012

Garden 2012

Here's some pics of my garden for 2012.






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

SWRRSC2

We had problems with the job swrrsc2 (student schedule print job). It was using too much redo space in Oracle. The job runs every minute and sweeps a collector table. It also was being called from gjajobs.shl which creates an entry in the job table. I changed the schedule for the job so it only runs Monday - Friday at 7am-5pm and I rewrote the script so that it doesn't use gjajobs.shl to run. Hopefully this will help.

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

September 6, 2012

SWBRDT* reports

There's several reports used by the business office that are named SWBRDT*. A lot of these had different spool file names or used an underscore followed by a number. I updated all of these scripts so that they used the name of the report as the spool file.
swbrdt2 -> spool $swbrdt2
All sql scripts that spool should follow this pattern because job submission automatically creates a variable in linux that points to the spool directory/user_job_oneupno.lis1 file.

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

SFTP public key gotcha

This week, MBS had problems logging into the linux server using a public key. I tried setting up public key authentication on my workstation and I couldn't get to work either. I worked with OUS on this problem and they narrowed it down to the key being the problem. Our keys needed to be converted to OpenSSH in order for them to work.

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