Author Topic: Changing 'contact type' for existing custom data group (Read 695 times)

petednz · November 14, 2009, 07:55:41 pm

Hi - seem to have hit this twice in short succession so thought it would be good to get this answered on here.

A Custom Data group was set up as for Contacts - it should have been set up for only Individuals.

TO avoid recreating the fields and doing a copy via sql, should it be possible to back-end modify the Group and Fields so they behave correctly as 'Individual' fields, namely so they will show up under 'individuals' in Import, Export and Profiles.

I know chris engaged briefly with lobo on this when it failed for us the first time. Is there a route to do this 'conversion' of Group/Fields?

Thanks

Donald Lobo · November 14, 2009, 09:00:51 pm

i just gave it a quick try in 3.0 and it worked fine:

1. change extends in civicrm_custom_group;

update civicrm_custom_group set extends = 'Individual' where id = 1;

2. truncate the cache table

truncate civicrm_cache ; truncate civicrm_acl_cache;

the above seemed to work with our generated data set

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Changing 'contact type' for existing custom data group (Read 695 times)

petednz

Changing 'contact type' for existing custom data group

Donald Lobo

Re: Changing 'contact type' for existing custom data group