CiviCRM Community Forums (archive)

It took my forever to figure out that my field mapping to a campaign had to match the "name" field in civicrm_campaign table, which is NOT the ID, not the external id and not the title and is not shown at all in the user interface.

Basically, I had to replace all spaces with underscores and all dashes OR space-dash-space sequences with an underscore in my case.

I have no idea how to make use of the external id for a campaign. No amount of searching or experimenting shed any light on this.

sample data from civicrm_campaign table:

Unique Campaign ID.   name title description start_date end_date campaign_type_id status_id  external_identifier
1    2012_Annual_Fund    2012 Annual Fund    NULL   2012-01-01 00:00:00    2012-12-31 00:00:00    1    3    487189
2    2013_Annual_Fund    2013 Annual Fund    NULL   2013-01-01 00:00:00    2013-12-31 00:00:00    1    3    1033539
3    2014_Annual_Fund    2014 Annual Fund    NULL   2014-01-01 00:00:00    2014-07-01 00:00:00    1    3    1080694
4    Subscribe_to_2014_15_series    Subscribe to 2014-15 series    NULL   2014-07-23 14:24:00    2014-10-26 00:00:00    4    NULL   NULL
5    2014_2015_Concert_Ticket_Sales    2014–2015 Concert Ticket Sales    NULL   2014-05-30 13:30:00    2015-05-01 00:00:00    3    NULL   NULL
6    2005_Annual_Fund    2005 Annual Fund    NULL   2004-06-30 17:43:00    2005-07-01 00:00:00    1    NULL   137053
8    2006_Annual_Fund    2006 Annual Fund    NULL   2005-07-01 18:11:00    2006-06-30 00:00:00    5    NULL   114584
9    2007_Annual_Fund    2007 Annual Fund    NULL   2014-08-04 18:12:00    NULL   5    NULL   185049
10    2006_07_Planned_Giving_Seminar    2006-07 Planned Giving Seminar    NULL   2014-08-04 18:12:00    NULL   5    NULL   200901
11    2007_08_Tickets_Sold_Offline_Entry_Form    2007-08 Tickets Sold Offline Entry Form    NULL   2014-08-04 18:12:00    NULL   5    NULL   235217