0

I have updated some contacts and during import there was a mixup in some fields, i.e. an individual's "Website" field was filled with the value of an Organisation's website.

I want to set the value of "Website" field for this individual to empty. I tried updating the contact with both Update and Fill options, leaving the "Website" field empty, but this didn't work.

What is the best way to do this?

  • what version of CiviCRM are you using? Do you have SQL skills and access to the database? – ErikH - CiviCooP Nov 30 '16 at 11:18
  • Version is 4.7.13. Unfortunately no skills in database handling! – Vassilis Chryssos Dec 8 '16 at 17:20
1

I would probably create a profile with the website, and then use the 'update multiple contacts' to clear the website a hundred at a time (which is the maximum of contacts you can update with one profile action).

First you need to create a profile, and read up on profiles in the User Guide if you are not familiar with them. Next you search for your contacts, and select a maximum of 100 at a time, and select the 'update multiple contacts' from the action list. You then select the profile and use the 'copy' functionality to set the website to empty. I have not tried this, but this is what I would try to do if updating SQL is not an option.

If that does not work you will probably either clean them in the database OR delete the contacts and re-import (if that is an option).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.