Author Topic: How Do I Globally Update a Custom Yes/No field to Unselect? (Read 2248 times)

annaleevk · December 05, 2009, 10:23:14 am

Hello. We need to update a previously coded yes/no custom field to unselect. Is there a way to do this globally? I have 871 records that were coded as NO and I want to unselect this value so I can manually code them based on a postcard mailing we sent.

I tried using batch update for this with a profile but my only choices are yes or no.

Thanks,
Annalee

Kurund Jalmi · December 06, 2009, 11:37:25 pm

Can't you just export those 871 records and then re-import then in update mode with custom data set to No.

Kurund

annaleevk · December 07, 2009, 03:56:45 am

Nope. Because NO means something else. Basically, the YES/NO flag is a Go Paperless question. YES = Email List group and NO = Mailing List group.

I did fix it though. The resolution was that I had to run an update SQL statement for all records where the value was 0 and set it to NULL but it would be nice if I did not have to.

If Batch Update by Profile would allow the UNSELECT option (NULL), then I would not have had to go fishing in the backend.

Thanks,
Annalee

Dave Greenberg · December 07, 2009, 12:28:47 pm

This does seem like a "missing feature". I've posted an issue for 3.2 to remedy it:
http://issues.civicrm.org/jira/browse/CRM-5506

CiviCRM Community Forums (archive)

News:

Author Topic: How Do I Globally Update a Custom Yes/No field to Unselect? (Read 2248 times)

annaleevk

How Do I Globally Update a Custom Yes/No field to Unselect?

Kurund Jalmi

Re: How Do I Globally Update a Custom Yes/No field to Unselect?

annaleevk

Re: How Do I Globally Update a Custom Yes/No field to Unselect?

Dave Greenberg

Re: How Do I Globally Update a Custom Yes/No field to Unselect?