What would you like to know more about?

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.

Note: We don't recommend mass assigning addresses because what you enter in the Address field in the Assign tool replaces the entire field contents, including the house number. Instead, we recommend you open a Contact record, launch the Add/Edit Family Tool, and correct the address there. This way, you can make corrections while you work in the Contact and make additional capitalization corrections to an entire family's last name all at once.

While some data cleanup is tedious, sometimes you can't avoid it.

  1. In the navigation menu, click Lookup Values > Addresses.
  2. Search for all the records with the first city name on your list, and select the Select All checkbox to select all the records with that name.
    Tip: Keep your bulk assignments below 1,000 records.
  3. From the Actions menu, select Assign.
  4. Change ONLY the City Name field to proper case.
    Change "austin" to Austin.
  5. Click OK.
  6. Repeat these steps until you complete your list of cities.

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.