Author Topic: Batch update for event profile ID's? (Read 379 times)

Michael · February 11, 2014, 12:51:17 pm

We have over 800 events that were created using one profile ID and we need to change the profile ID for all of them to a new one. We don't want to do this manually for each event. However, copying the old profile doesn't work, creating a new one doesn't work, there's no way to change the profile related to the events that are already created.

Is there a way to change the profile ID for all events in a batch? Any help will be very much appreciated.

Rajesh · February 12, 2014, 06:36:04 am

Hi Michael

If you have got database access, you can do it by SQL.

Example:
Below SQL will update the 'top of page' profile ID for all events to 1, where the existing profile ID used for the event is 12.

Code: [Select]

UPDATE `civicrm_uf_join` SET `uf_group_id` = 1 WHERE `uf_group_id` = 12 and `module` = 'CiviEvent' AND entity_table = 'civicrm_event' AND weight = 1;

You can modify the SQL to fit for your requirement.

Dont forget the golden rule before you perform any action straight in the database - backup, backup, backup

- Rajesh

Michael · February 12, 2014, 07:20:30 am

Thanks very much, Rajesh. That's perfect.

CiviCRM Community Forums (archive)

News:

Author Topic: Batch update for event profile ID's? (Read 379 times)

Michael

Batch update for event profile ID's?

Rajesh

Re: Batch update for event profile ID's?

Michael

Re: Batch update for event profile ID's?