« April 2010 | Main | June 2010 »

May 28, 2010

Converting Directory Photos

I created a new action item in photoshop to convert .tif files to .jpg so that we can display our pictures on the web. I made a copy of my photoshop settings in the banner_information\campusdir\photshop directory, just in case we need to run it on another computer or if my machine dies.

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

Tgrzchk and fwpchkp mod

I made a small modification to TGRZCHK and FWPCHKP to change the account number on the checks.

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

Curriculum backfill fix

I added a mod to the soklcur package that should fix the curriculum backfill issues we've been seeing on some records since we upgraded to Banner 8. I'll have the business test it before I put it in production. It's a pretty simple fix that checks to see if the curriculum rule exists for a minor code before it inserts it into sgbstdn.

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

May 21, 2010

Updated job submission: SZRDEPS and SZRDEPM

I updated two job submissions this week: SZRDEPS (DEP section tally) and SZRDEPM (DEP Mreport). SZRDEPS has a new parameter to include part of term 6 courses (for legacy data). Both reports now include part of term 10 courses.

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

May 18, 2010

Java Security Warning Prompt and Banner INB

If you upgrade to Java 6 update 19 or higher, you will get a warning message indicating "Java has discovered application components that could indicate a security concern". To work around this problem use these steps:

1. Click Start.
2. Click Control Panel.
3. Double click on Java Control Panel.
4. Click Advance tab in Java Control Panel.
5. Double click on Security.
6. Double click on Mixed Code.
7. Click on "Enable - hide warning and run with protections".
8. Click ok and close all your web browsers.
9. Launch Banner INB

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

May 14, 2010

Early Bird registration time tickets

I setup the Early Bird registration time tickets this week. After these are setup, the new admits should be setup via the dbms_jobs cron on AERO (this runs every hour to pick up new students).

Note to self: Make sure to exclude the new freshman for Fall term, they will be setup before each SOAR event.

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

NCAA Graduation rates

I've been working on the NCAA graduation rate survey this week for the 2003-04 cohort. I finished the first two surveys and now I'm working on the athlete section. I'm missing a little bit of information that's not in Banner but Health and PE will provide me that data soon.

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

May 7, 2010

SZRENR2 change

I made a change to the job submission SZRENR2 (enrolled students for the term) so that it will find program codes that have spaces in them (i.e. "MSE INFOTECH"). To find these, use double quotes for the program parameter ("MSE INFOTECH").

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

TZPECHK - Error checking

I added a lot more error checking code into TZPECHK so that it catches any Oracle errors when it processes the remittance files for E-Check. I made a change to the credit card refund code so that it refunds the entire amount (Amount paid + Fee). It was only refunding the amount paid which caused AR balancing issues in Banner.

It's ok to re-run a remittance file that's already been processed. It will only update a few fields in the tzrechk table ( It will not re-post into Banner if the transaction already exists in tzrechk ).

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