CiviCRM Community Forums (archive)

the easiest way to do this is by direct manipulation of the database. If you are not familiar with sql, you might want to find someone who can hep you. Please read and follow these steps carefully

1. backup your current civicrm database

2. find the current custom field id, lets call it FIELD_ID

3. find the new custom group id, lets call it GROUP_ID

4. run the following sql statement

update civicrm_custom_field set custom_group_id = GROUP_ID where id = FIELD_ID

lobo

I just tried this but found that it doesn't work - probably due to 2.0 schema changes.

Are you able to provide an update here?

haha - yes - thought that would be an appropriate response!  I also took a look and found the new style tables for each custom data group.

For both 2.2 and 2.0, I would suggest creating the new field in the new custom group, copying the data across via SQL, then removing the old field.

We recently had some similar requirements, except we were moving data about a member's AP payment from the Contact record to the Membership record.

In that case, having created the custom field against memberships, we used the following SQL - I hope it will help you do something similar:

             CREATE TABLE test.ap_memberships
                   SELECT m.id
                     FROM custom_value_1_Other ap
                     JOIN civicrm_contact c ON ap.entity_id = c.id
                     JOIN civicrm_membership m ON m.contact_id = c.id
                    WHERE ap.Payment_Method = 'AP' ;

              INSERT INTO civicrm_value_1_ap_payment_pd_test_20 ( domain_id, entity_id, pays_ap )
                   SELECT 1, id, 'yes'
                     FROM test.ap_memberships
  ON DUPLICATE KEY UPDATE pays_ap='yes';

So Andrew - are you going to one of the US training workshops? Or have you got a special secret Aussie session happening soon?

Ha - good catch pete