Page MenuHomePhabricator

New Custom Fields for Target Smart Import
Closed, ResolvedPublic

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.

  1. Family Composition - has a select option with new drops down options
  2. 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

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

@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

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

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

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

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