Tag Archives: public safety

Update from Database Applications & Systems

Submitted by Chris Norris

Here are some of the projects and tasks that DAS staff members have been working on during the past month…

Mike Schuster
- Created a spec for Bookstore Upload / Course Listing Bookstore Links
- Researched problem Off Campus Study was having pushing Admissions applications
- Corrected problems with Bread Loaf, Language School, and Off Campus Study decisions processing reports, reports were broken due to System 9 upgrade
- Created SSB web package to allow residential systems coordinator to delete room draw preferences, reorder preferences, and activate/inactivate room draw applications
- Processed Fall 2008 course response form data
- Updated Feb’s MNET email addresses to “preferred”
- Fixed problem with LS & BLSE Financial Aid online web applications where bad data entry selection of dates in dropdown boxes would cause applications to get an Oracle error
- Modified custom p_assign_boxes database procedure to allow mail boxes to be assigned to students during winter term
- Worked with Liz Whitaker-Freitas and Marcy Smith to develop documents needed by Monterey staff when developing/requesting new reports

Liz Whitaker-Freitas
- Supporting Hyperion BI+ for functional & technical users
- Troubleshooting Admissions Decisions reports
- Coordinating roles to groups migration by Velaris

Ian McBride
- Added service to check GO addresses nightly
- Worked with Adam to develop web service for MiddTube
- Wrote WordPress plugin for MiddTube
- Developed Middlebury theme for WordPress
- Added a service to the Directory to automatically redirect to a user’s homepage
- Added a video icon to CMS home page news items with videos
- Developed home page for the New England Review site in WordPress
- Began investigation into Single Sign On applications
- Continued work with the Platform and Design/IA groups for the Web Makeover
- Finally launched News Portal at http://go.middlebury.edu/news!

Travis Stafford
- Created 7 new alumni event forms
- Tested WordPress CFORMS upgrade
- Upgraded all the WordPress blogs and cforms to the new version of CFORMS (13 blogs / +/- 50 forms)
- Completed porting over all the cat standard ecommunicate forms to CFORMS
- Minor changes the New England Review ecommerce form
- Troubleshot\Fixed issues with the CCAL Fundraising ecommerce form
- Added new functionality to the BLM application to show Counts by indicator flag for Banner-ListManager admins
- Added self service component to the BLM project for subscribing\unsubscribing to Newsletters and List Manager lists
- CFORMs support/training for various departments
- General support and HEAT tickets

Rob Pekor
- Rolled late graduates to Alumni
- Started developing and creating tables to hold Harris Online Directory data
- Started creating scripts to load initial data for Harris Online Directory
- Started very preliminary development of process to send updates to Harris
- Corrected problem with Phonathon SSB data selection page, page would error on multiple individual years selected, problem has been corrected and is now in production
- Created new function to retrieve a list of regions for a particular person
- Corrected problem in AIA relating to updating ask amounts, if an ask amount never existed before for a person, the SSB page would not update the value, problem has been corrected and is now in production
- Created list of people that currently have access to AIA
- Corrected issue with view for the Banner List Manager relating to the indicator for students

Chris Norris
- Participated in telephone interview for open DBA position
- Reviewed Phoenix BIA reports and summary
- Worked on spec for remote DR web presence
- Participated in CA fundraising strategy meeting
- Refined Banner-ListManager project spec with DAS staff
- Completed work with CA and Communications on Organic Garden giving form
- Met with DOC and PS staff regarding new ER web presence
- Met with technical/functional staff regarding eCommerce options for “pay-for-print”
- Met with Communications staff to plan for upcoming Newsletter projects
- Met with Career Services staff to plan for upcoming Newsletter projects
- Participated in various Web Makeover team meetings
- Met with HR staff regarding Web Makeover requirements
- Met with PHC staff regarding Web Makeover requirements
- Met with PS staff regarding Web Makeover requirements
Systems Administration
- Ongoing monitoring and problem resolution of online services
- Resolved service outages for Banner and Hyperion
- Resolved server config issue for GoogleEarth version of campusmap
- Updated TouchNet server config to support additional web servers
- Upgraded SubmissionManager web application for BLWC
- Configured new GO rewrite rules
- Ongoing tuning of GSA to improve search results
- Renewals of College-owned domain names
- Met with SNS staff regarding HSF config options
Help & Support
- Provided support to CFA staff for artsmail Newsletter IA
- Provided support to HR staff for middleader Newsletter buttons
- Reviewed President’s Holiday Card for pre-sending issues for Communications
- Updated Middlebury’s United Way web presence (campaign stats)
- Updated AbroadView.org web presence (footer)
- Provided various support for CMS editing, HEAT tix, and ad-hoc help calls
Vendor Related Activities
- Participated in Sun-Guard/SCT Banner DBA weekly status calls
- Participated in Velaris Hyperion SysAdmin weekly status calls
- Continued contract re-negotiation with Hyperion SysAdmin vendor (Velaris)
- Worked with DavisProjectsforPeace.org external web vendor to grant direct database access
- eCommerce call with alumni online community vendor (Harris) to define IMA requirements
- Coordinated redirect request from MIIS staff with www.MIIS.edu web vendor (NeptuneWeb)