Report & Database - Winter 2016
Enhance "Major Donors" Report
We've added Mobile Phone and Email to the Show Contact Info option for the Major Donors report.
Fix "Selected Group Last Attended" Report
We've modified the Selected Group Last Attended Report to display the DOB correctly.
Fix "Selected Photo" Report
We've modified the Selected Photo Report to display the DOB correctly when chosen as an option.
Report Stored Procedures Updates
Enhance Event Setup Report
We have enhanced the Event Setup report to show events that span multiple days based on the Event Start and End Dates.
Page Layout Updates
Re-order Event Page Fields
We will be re-ordering and organizing fields on the Events page. New fields will be added to the "Notification Information" section. Existing fields will be moved under the new "Accounting Information" section. Several fields will be moved up to the "Public Website Settings" section.
System Setup Updates
We have fixed the Waiting On Me view on the Households page to pull any possible results if any exist in the system.
We have fixed the Double Booked view on the Room Reservation page to exclude cancelled reservations.
We have enhanced the Available Rooms view to allow rooms to be booked back-to-back.
We have fixed the Double Booked view on Events page to account for back-to-back bookings.
Nightly Routine Updates
We're standardizing and renaming a SQL Agent job called "MinistryPlatform.Temporary Fixes" to "MinistryPlatform.MP Quarter Hour". This job will be used anytime we want some database routine to run regularly throughout the day. The first item on this list is the new Registrant Message.
We're enhancing the Events page to include two new fields "Days out to Remind" is a field where a user can put the number of days before the Event Start Date when a reminder will be sent. "Optional Reminder Message" allows the user to overwrite the default reminder message with an event-specific reminder message.
We've added a new field to Events called "Registrant Message". No matter how a person is added to an event with status of "registered" they will get an email with this message if one is applied to this field. A new "Registrant Message Sent" bit field was added to the Event Participant record. A routine will send the email to new registrants every 15 minutes.
We're adding a new field to the Event record called "Register into Series". When true, anyone who is registered for one event in a series will automatically be added to future events in the series. Anyone who is cancelled in one event in the series will automatically be cancelled in future events in the series. This will run as part of the data quality routines nightly.
Database Object Change Updates
We've added a foreign key relationship between dp_Sub_Page_Views.User_ID and the primary key dp_Users.User_ID.
We're adding tooltips (help text) to all fields on the Events page.