Bulk Update and Delete Profiles

Names

Each profile in your site will be in this file. You can update the name fields and many other profile fields such as birthday, anniversary, inactive, deceased, pronouns, etc. Download the file to see what fields are available. This is for updating information on existing profiles, not creating new profiles in bulk. Import Profiles provides guidance for creating new profiles in bulk.

Addresses, Phones, and Emails

Addresses, phone numbers, and emails each have a different bulk update file. Each address, phone, and email on a profile will be listed in the respective file type. You can add additional addresses, phone numbers, and emails through bulk update by including the profile ID of the profile to which the address, phone number, or email will be added. 

This example demonstrates how to bulk update names, but the process is the same for addresses, phones, and emails.

1. Navigate to the Profiles page and click Bulk Update in the left-side menu.
   
2. Click Names.
   
   
   
3. Click [Download Names].
   • A .csv file containing every profile will download to your computer.
     
     
     
4. Make a copy of the downloaded file. 
   • It is recommended to keep an unedited copy of the data. 
5. Open the file that you want to edit, make changes to the data, and save the file.
   
   • The ProfileID column is required and must match an existing profile ID.
   • In the Names bulk update, the Type column is required and cannot have its value changed.
   • If a column is not available in the downloaded file, it is not available in bulk update.
   • Do not add additional columns to the file. 
   • Do not edit column headers.
   • Removing columns and rows that were not edited is recommended.
     • Remove the entire column or row versus clearing the data in the cells and keeping the header. That would import blanks into those cells.
     • Removing columns and rows that are not being edited reduces file processing time since the import will look for changes in every row/column with data. 
   • If you use any formulas in your editing, convert the formulas to values prior to attempting upload.
   • The bulk update pages for names, addresses, phones, and emails contain additional information about the file requirements and import process. 
6. Click Choose File.
    
   
   
7. Select the .csv file from your computer, and then click Process.
   • Testing this import in the Sandbox site before it is imported into the Live site is strongly recommended.
     
     
     

Processing a file will create a background job. Refresh this screen to check update progress and error status. If there is an error in your upload, no changes in the file will be processed. Click the JobID to view the errors, correct the errors in the file, and re-upload.

Profiles that have been created within a specific start and end date can be bulk deleted. The system will search for all profiles created between the start and end date. Profiles that cannot be bulk deleted include profiles that have donation, grants, pledges, opportunities etc., are part of a household, or have a relationship link with another profile. 

1. Navigate to the Profiles page and click Bulk Update in the left-side menu.
2. Click Bulk Delete in the left-side menu.
3. Enter a Profile Created Start Date, Profile Created End Date, and then click Search.
   
   
4. Click Delete Profiles (Yes, I know I can not undo this!).