Data Quality FAQ
Solutions and best practices to improve the quality of your data, including data correction, record updates, and system safeguards within the software tools available.
See our article on how to mass update city names.
See our article on how to search for incorrectly updated records.
First and foremost, delete with care! Speak with your SPoC to make sure it's okay to delete records.
If you truly should delete the records, the error unable to update or delete these records means that the system won't let you delete the records because dependencies exist. You must first remove the dependencies before you can delete the records.
For example, to delete a record with an outstanding Task associated with it, you must first complete the Task and then you can delete the record.
With the Reassign option, you can delete the current record or records and reassign any associated date to another record. Usually, you'll find the associated date on correlating tabs. This helps if you created duplicate records. You can delete one record and reassign the associated records to the record you want to keep. It helps to rename the record you want to delete to something unique before you begin, that way you know which record is which.
When correcting records that display in Fix Proper Case view, consider using the Add/Edit Family Tool instead. Open a record and launch the tool to fix the Household Name and Last Name for all the family members on one screen. Then, click Save to update the whole family.
If the records seem to be the same person, we recommend you use the Combine Contacts Tool to merge duplicate records. If the records are different people but share an email address, you should create a relationship. Go to the Contact record, click the Relationship tab, and add the appropriate new relationship. If the two people aren't related (which is extremely rare), you can mark the relationship as Similar Records.
Currently, the Portal, Platform, Tools, and Check-In only accept email addresses that are formatted as *@*.*, where the stars represent alphanumeric characters. For example, sally@gmail.com.
Professional Services can assist you with a Data Restore. Open a support case with the necessary information to locate which data you need restored.
You can also use Views with Audit Log fields to find the related records and Mass Assign the correct values. This View Example provides you a start on the columns you can use to help find your data.
Mass Update City Names
Use the Assign tool to make bulk changes to incorrect city names that you imported.
Sometimes you have to clean up data that you already imported into MinistryPlatform. For example, say you imported a lot of data and realized after you imported it that much of the information is in all caps. Use the Assign tool to make bulk changes to city names all at once.
While some data cleanup is tedious, sometimes you can't avoid it.
All the records you selected will set to proper case, and all the records that are already in proper case will stay in proper case.
Search for Incorrectly Updated Records
Use the User Audit Log Detail report to find a record that someone incorrectly updated, even if they don't remember which record they updated.
- You must be a database administrator to do this.
- Go to .
- Click Reports and select User Audit Log Detail.
- Enter a date range, Page, and User you want to search.
- Click View Report.
A list of changes the User made on a given Page during the time frame that you specified displays. Now you should be able to find which record your User updated.