5 Year End Best Practices for a Healthy & Clean Database

October 10, 2019 11:30 AM - 12:30 PM (CDT)

Description

Data cleansing is so important because it improves your data quality and in doing so, increases overall productivity. When you clean your data, all outdated or incorrect information is gone – leaving you with the highest quality information. In this session, participants will learn best practices for cleansing & maintaining a healthy database.

Agenda:

  • Identifying & Merging Duplicates
  • Updating Member Status
  • Request that Members Review & Update their Information
  • Review & Update Community Member
  • Review & Update Group Participation


Contact Information

Name: Cheri Petterson

Step 1: My Information

{{loginInfo.errorMessage}}

Logged In As {{Environment.CurrentUserData.DisplayName}}

Step 2: Registration Types

Name Price Qty
{{ert.EventRegistrationType.Name}}
{{(ert.EventRegistrationType.IsForMembers && !ert.EventRegistrationType.IsForNonMembers)?"(Members Only)":""}}
{{ert.EventRegistrationType.Price | currency }}
{{status.maxRegistrationLimitViolation[ert.EventRegistrationType.EventRegistrationTypeId].msg}}
Total vacant spots per event: {{ Environment.VacantSpotsPerEvent }}
{{status.maxEventLimitViolation.msg}}

Step 3: Attendees

Please add attendees

{{er.RegName}} Attendees

{{ ($index == 0 || er.Price > 0)? "Attendee" : (Environment.ExtraOptions.AdditionalAttendeesTerm || "Attendee") }} #{{ ((!Environment.ExtraOptions.AdditionalAttendeesTerm || Environment.ExtraOptions.AdditionalAttendeesTerm == "Attendee") || $index == 0 || er.Price>0)? ($index+1) : $index }}

Total: {{(att.Price - getAttendeeTotalDiscountAmount(att) + getPayableAttendeeExtraItemsPrice(att)).toFixed(2) | currency}} {{att.DiscountsApplied.length>0 ? "- Discounts have been applied" : ""}}

Personal Info


Address


Phone


Additional Information


Event Sessions

{{slot.Name}}

{{$select.selected.Name}}
(full)
{{slot.SelectedSession ? slot.SelectedSession.Description || "" : ""}}


Additional Items

Name Description Price Qty
{{item.Name + (item.IsForMembers && !item.IsForNonMembers ? " (Members Only)" : "")}} {{item.Description}} {{item.Price | currency }}
 
Registration is available to Members only

Step 4: Additional Items

Name Description Price Quantity
{{item.Name + (item.IsForMembers && !item.IsForNonMembers ? " (Members Only)" : "")}} {{item.Description}} {{item.Price | currency }}

Step {{getValidExtraPurchaseItems().length ? "5": "4"}}: Enter Promo Code

{{status.promocode.msg}}

Step {{Environment.HasPromoCodes && getValidExtraPurchaseItems().length? "6": (Environment.HasPromoCodes || getValidExtraPurchaseItems().length? "5" : "4")}}: {{(Environment.DonationTerm || "Donation/Contribution") + " Opportunities"}}

Campaign Name Item Description Amount
{{item.CampaignName}} {{item.Description + (item.ShowMinimumPrice && item.MinimumPrice ? " (Min: " + item.MinimumPrice + ")" : "")}}

Step {{getPaymentStepIndex()}}: Payment Information

{{status.form.msg}} {{status.maxEventLimitViolation.msg}} {{status.maxAllRegistrationLimitViolation.msg}}

Validation Summary

{{status.form.msg}} {{status.maxEventLimitViolation.msg}} {{status.maxAllRegistrationLimitViolation.msg}}

Sorry, you can't reduce the number of registrations or additional items. Please contact administrator.