Answers.Body: <p>I was able to successfully import the campaign on a contribution by importing the campaign's CiviCRM ID.</p>
  
  <p>I agree that it seems odd that campaigns have an "External ID" field, but it can't be used for imports, though!</p>
  
  <p>You can find your campaign IDs by going to <strong>Campaigns menu » Dashboard » Campaigns</strong>.  In CiviCRM 4.7+, they'll be in the first column of the list.  See screenshot 1 below.  If you're using CiviCRM 4.6 or lower, you can find the ID by hovering your mouse over the "Edit" button next to a campaign and reading the ID that appears in the URL at the bottom of your web browser.  See screenshot 2 below.</p>
  
  <p><a href="https://i.sstatic.net/vsfzq.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/vsfzq.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.sstatic.net/Pzhzg.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Pzhzg.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-12T02:05:06.690Z
Answers.Text: Thanks. Can you please clarify where i would find the CiviCRM ID? (Sorry if its obvious, I'm a newbie.)
Answers.UserDisplayName: Nomi
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-12T02:18:49.913Z
Answers.Text: Stack Exchange is for newbies!  I updated the question to answer you.  If you have just a couple of different campaigns in your import, this is a quick find-and-replace job in Excel.  If you have hundreds of campaigns, this is going to get annoying quickly.  If that's the case, leave a comment (or find me on chat.civicrm.org) and we'll get into your options.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-13T04:31:47.180Z
Answers.Text: Thanks! Cant figure out how to attach a screenshot but I dont have that column on my dashboard. Just starts with the Title column. What am I missing? Thank for your help!
Answers.UserDisplayName: Nomi
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-13T11:58:33.737Z
Answers.Text: @Nomi Hmm - apparently that column is only in Civi 4.7.  I just updated the question with instructions for Civi 4.6!
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-11T06:29:53.177Z
Answers.LastActivityDate: 2017-01-13T11:58:02.797Z
Answers.LastEditDate: 2017-01-13T11:58:02.797Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>Is the campaign currently active or was it started before the dates your importing? I'm just throwing out a possible reason why it fails. I do not know if this would make or break the import.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-11T04:59:06.717Z
Answers.Text: Yes its both currently active and and the dates should not conflict.
Answers.UserDisplayName: Nomi
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-11T02:28:02.060Z
Answers.LastActivityDate: 2017-01-11T02:28:02.060Z
Answers.UserDisplayName: Iowa Boy
Body: <p>I'm trying to import a CSV file with donations that need to be linked with a certain campaign. I tried putting the campaign name, then the external id, and even just "matching" but all of them are generating an error. Any advice? </p>
  
  <p>I am running CiviCRM 4.6.19 on Drupal. The error message is: </p>
  
  <blockquote>
    <p>'xyz' is not a valid option for field campaign_id</p>
  </blockquote>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-01-11T06:25:49.230Z
Comments.Text: Hi, and welcome to Stack Exchange! You can help us help you by giving us more information.  Could you please edit your question a) to include the error that you're seeing?  Also the CMS you're using (Drupal, WordPress, Joomla, Backdrop) and your CiviCRM version?  Thanks!  I'll post a partial answer below.
Comments.UserDisplayName: Jon G - Megaphone Tech
Tags: <custom-fields><import>
Title: What should be entered in the campaign field when importing a CSV file?
ThreadText: # What should be entered in the campaign field when importing a CSV file?
  
  (Asked by: username_0 on 2017-01-10)
  
  I'm trying to import a CSV file with donations that need to be linked with a certain campaign. I tried putting the campaign name, then the external id, and even just "matching" but all of them are generating an error. Any advice?
  
  I am running CiviCRM 4.6.19 on Drupal. The error message is:
  
  > 'xyz' is not a valid option for field campaign\_id
  
  **Tags:** custom-fields, import
  
  > **Comments:**
  > **username_1**: Hi, and welcome to Stack Exchange! You can help us help you by giving us more information.  Could you please edit your question a) to include the error that you're seeing?  Also the CMS you're using (Drupal, WordPress, Joomla, Backdrop) and your CiviCRM version?  Thanks!  I'll post a partial answer below.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-01-11. Score: 2 | Accepted answer
  
  I was able to successfully import the campaign on a contribution by importing the campaign's CiviCRM ID.
  
  I agree that it seems odd that campaigns have an "External ID" field, but it can't be used for imports, though!
  
  You can find your campaign IDs by going to **Campaigns menu » Dashboard » Campaigns**. In CiviCRM 4.7+, they'll be in the first column of the list. See screenshot 1 below. If you're using CiviCRM 4.6 or lower, you can find the ID by hovering your mouse over the "Edit" button next to a campaign and reading the ID that appears in the URL at the bottom of your web browser. See screenshot 2 below.
  
  [![enter image description here](https://i.sstatic.net/vsfzq.png)](https://i.sstatic.net/vsfzq.png)
  
  [![enter image description here](https://i.sstatic.net/Pzhzg.png)](https://i.sstatic.net/Pzhzg.png)
  
  > **Comments:**
  > **username_0**: Thanks. Can you please clarify where i would find the CiviCRM ID? (Sorry if its obvious, I'm a newbie.)  
  > **username_1**: Stack Exchange is for newbies!  I updated the question to answer you.  If you have just a couple of different campaigns in your import, this is a quick find-and-replace job in Excel.  If you have hundreds of campaigns, this is going to get annoying quickly.  If that's the case, leave a comment (or find me on chat.civicrm.org) and we'll get into your options.  
  > **username_0**: Thanks! Cant figure out how to attach a screenshot but I dont have that column on my dashboard. Just starts with the Title column. What am I missing? Thank for your help!  
  > **username_1**: @username_0 Hmm - apparently that column is only in Civi 4.7.  I just updated the question with instructions for Civi 4.6!  
  
  ---
  
  ### Answer by username_2 on 2017-01-11. Score: -1
  
  Is the campaign currently active or was it started before the dates your importing? I'm just throwing out a possible reason why it fails. I do not know if this would make or break the import.
  
  > **Comments:**
  > **username_0**: Yes its both currently active and and the dates should not conflict.  
  
  ---
  
  