The following solution uses the example of removing a phone type called Home 1 and retaining a phone type called Home.

  1. Create a constituent query
  2. On the Criteria tab, select:
    • Addresses, All Addresses, Phones, Specific Phones, Home 1, Home 1 Number not blank
    • AND Addresses, All Addresses, Phones, Specific Phones, Home, Home Number blank
  3. Globally change phone type for the query of constituents created in steps 1 and 2. Replace the Home 1 phone type with the Home phone type.
    Note: You will receive exceptions for each phone number on the constituents' records that are not Home 1 phone numbers. This is expected. The global change still processes the Home 1 phone numbers.
  4. Create a constituent query
  5. On the Criteria tab, select:
    Addresses, All Addresses, Phones, Specific Phones, Home 1, Home 1 Number not blank
    AND Addresses, All Addresses, Phones, Specific Phones, Home, Home Number not blank
  6. Create a constituent phone import file in CSV (Comma Separated Values) format based on the query created in steps 4 and 5
  7. On the Fields tab, select the fields required for a constituent phone import  
  8. Click Create Now to create the CSV file
  9. Open the CSV file
  10. Sort the spreadsheet by the Address Import ID column  
  11. If the Home and Home 1 phone numbers match, delete both rows from the file
  12. With the remaining rows, decide which phone number is to be kept. The 'good' phone number should be listed on the Home row. Delete the Home 1 row for the constituent.  
  13. Perform a Constituent Phone import. Mark the option to Update existing records.
  14. Run the Delete Phones plug-in to delete all Home 1 phone numbers from the database  
  15. Delete the Home 1 table entry from the Phone Types table