Cleaning Up Your Database Entries
Over time, your Contacts and Locations database may accumulate inconsistencies in spelling or formatting. For instance, you might have entered "The Netherlands" in various ways, such as "Netherlands," "Holland," or "Nederland." Or perhaps "amsterdam" was entered without a capital letter by mistake.
Fortunately, there's a simple way to update these entries across your database without manually editing each one. This article will show you how to make these updates in your Database Entries.
Table of Contents
1. Accessing Database Entries
2. Selecting Your Data Group
3. Updating Values
4. Confirming Changes
1. Accessing Database Entries
To start cleaning your database, go to the Office section of your Agency account.
Click on Database Entries.
2. Selecting Your Data Group
Choose the data group you want to clean up: either Location or Contact.
Next, select the specific data point you want to update, such as a city, region, or country.
3. Updating Values
Click on Update selection to display all the current values in your database.
Enter the new value you want to use to replace any inconsistent entries, and then click on Update.
Please note: once changes are made, they cannot be reversed.
Updating the value will automatically change all related contacts or locations with the updated value.
4. Confirming Changes
Your database will now be updated. If you click on Update selection again, you’ll see that the outdated or incorrect value has been replaced, leaving your database clean and consistent.