Tag Archives: cso

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
Staffing
– Participated in telephone interview for open DBA position
Projects
– 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)

Update from Database Applications and 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
- Modifications to a Banner custom process for the Registrar’s office that creates student class codes to meet new business rules.
– Modifications to the “LS Stats- new” Hyperion report to display applications for students applying to language schools at Mills College.
– Assisting with applying the Banner financial aid SSB upgrade in the DEV2 database.
– Investigating issues with Banner custom database triggers that create “away” and “returning” general student records for students going on leave.

Rob Pekor
- Modifications to the Phone-a-thon data interface for College Advancement.
– Gathering requirements for the data feed for the Harris online community project.
– Refinement of the Banner/ListManager (Broadcast Email tool) integration model with Travis.
– Loading MIIS gift history for Monterey and College Advancement.

Travis Stafford
– Refinement of the Banner/ListManager (Broadcast Email tool) integration model with Rob.
– Transitioning the Alumni office and CSO towards use of the self-service WordPress cformsII plug-in for all “new” non-eCommerce forms.
– Clean-up of code and adding functionality to Project Tracker.

Liz Whitaker-Freitas
– Ongoing work related to the Hyperion System 9 Upgrade/Migration (one line item, but this is a BIG project).

Ian McBride
- Completed development on a News Dashboard for College Communications (http://web.middlebury.edu/systems/newsboard). This will soon replace the main Public Affairs News home page and aggregate news content from several sources.
– Supporting CMS content providers and other web-related requests.
– Participating in the Web Makeover team meetings.

Chris Norris
– Migrated GO.middlebury.edu to a more stable prod environment, implemented GO.miis.edu for Monterey.
– Refinement of service-level monitoring, including addition of escalation groups.
– Project Phoenix BIA reviews, planning, specification for remote DR web presence.
– Pre-migration configuration, testing, troubleshooting of eCommerce web forms.
– Supporting ListManager newsletters, conducting ListManager workshops (only a couple more to go!).
– Contacting various folks about outstanding FileMakerPro requests, pre-migration web forms questions.
– Working on updated SWOT analysis of the DAS workgroup.