New Custom Fields for Target Smart Import
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	NNichols
	May 6 2019, 12:55 AM

Description

Hi!
We have created some new custom fields on the Prospect tab in preparation of the TargetSmart update.
We have ordered a few new fields this year. Both new fields live in the Prospect tab.

Family Composition - has a select option with new drops down options
Occupation - has a select option with new drops down options
- I was only able to create 10 options for the drop down for this new field. I need to add a couple more but there was not an option to create more (the following are the instructions from the civi) help!

I need to add:

Financial Services
Teacher/Educator
Legal Services
Religious

Details

	Subject	Repo	Branch	Lines +/-
	Alter option_group table to default to is_locked = 0	wikimedia/fundraising/crm	deployment	+12 -0
	Alter option_group table to default to is_locked = 0	wikimedia/fundraising/crm	master	+12 -0

Customize query in gerrit

Event Timeline

NNichols created this task.May 6 2019, 12:55 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 6 2019, 12:55 AM

• DStrine added a project: Fundraising Sprint It Came From Out of Scope.May 6 2019, 7:46 PM

• DStrine moved this task from Triage to Current Sprint on the Fundraising-Backlog board.

@NNichols So for some reason when you created those fields the db field is_locked was set to true - I've changed that & you can proceed but I'll try to figure out why

OK - I see why - for some reason our schema is missing a change

ALTER TABLE civicrm_option_group MODIFY COLUMN is_locked TINYINT(4) NOT NULL DEFAULT 0 COMMENT 'A lock to remove the ability to add new options via the UI.';

I'll put up a patch - but you can proceed with creating new fields & I can fix if they incorrectly get locked

Eileenmcnaughton claimed this task.May 8 2019, 12:04 AM

Fantastic! I was able to add the rest of the fields I needed. Thanks!

Eileenmcnaughton moved this task from Backlog to Review on the Fundraising Sprint It Came From Out of Scope board.May 9 2019, 12:04 AM

Change 508961 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Alter option_group table to default to is_locked = 0

https://gerrit.wikimedia.org/r/508961

gerritbot added a project: Patch-For-Review.May 9 2019, 12:06 AM

Change 508961 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Alter option_group table to default to is_locked = 0

https://gerrit.wikimedia.org/r/508961

• DStrine added a project: Fundraising Sprint James Bond: Licensed to Share.May 14 2019, 10:36 PM

Eileenmcnaughton moved this task from Review to Pending Deployment on the Fundraising Sprint It Came From Out of Scope board.May 15 2019, 12:38 AM

Change 510289 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@deployment] Alter option_group table to default to is_locked = 0

https://gerrit.wikimedia.org/r/510289

Change 510289 merged by jenkins-bot:
[wikimedia/fundraising/crm@deployment] Alter option_group table to default to is_locked = 0

https://gerrit.wikimedia.org/r/510289

Eileenmcnaughton closed this task as Resolved.May 15 2019, 1:44 AM

Eileenmcnaughton moved this task from Pending Deployment to Done on the Fundraising Sprint It Came From Out of Scope board.

Eileenmcnaughton moved this task from Backlog to Done on the Fundraising Sprint James Bond: Licensed to Share board.May 15 2019, 8:48 AM

New Custom Fields for Target Smart ImportClosed, ResolvedPublicActions

Description

Details

Event Timeline

New Custom Fields for Target Smart Import
Closed, ResolvedPublic
Actions