Answers.Body: <p>a) Is there a way to include OpenID as a drop down option in the contribution list? </p>
  
  <p>If you created a custom data field called "OpenID", you need to make sure the field can be used for contributions and that it is marked as searchable for it to appear in the list of fields when mapping contributions for import, </p>
  
  <p><strong>BUT</strong></p>
  
  <p>if memory serves me correctly, the system will require either an internal or external contact ID when importing contributions, so...</p>
  
  <p>b) Is there a way to convert OpenID to external identifier?</p>
  
  <p>Since you already imported the contacts, you can export all contacts being sure to include the OpenID and internal contact ID fields, then the update can be done in one of three ways - which ever you find easiest:</p>
  
  <ol>
  <li>Use the import contacts wizard to update all contacts mapping the OpenID to the external contact ID field using the internal ID as the link, <strong>OR</strong></li>
  <li>Use a vlookup in csv to match the internal contact ID to the OpenID in your contribution data import file, and then import your contributions based on the internal contact ID, <strong>OR</strong></li>
  <li>Use an SQL statement that will copy the OpenID to the external contact ID field by contact ID directly in the database</li>
  </ol>
  
  <p>Hope this helps,
  Tamar</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-05T17:17:15.813Z
Answers.LastActivityDate: 2016-10-05T17:17:15.813Z
Answers.UserDisplayName: Tamar Meir - Cividesk
Body: <p>When I imported contacts, I listed their identification number as OpenID. Now, I am trying up import the contacts' contributions. Along with their name, amount, date of donation, I am including their OpenID.....yet, the drop down options in the import contributions does not include OpenID...therefore, the import will not function. </p>
  
  <p>a) Is there a way to include OpenID as a drop down option in the contribution list? 
  if not...
  b) Is there a way to convert OpenID to external identifier? </p>
  
  <p>Thank you! </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-10-03T12:28:50.213Z
Comments.Text: What is the name of the drop down list that you want to include it in?
Comments.UserDisplayName: JohnFF
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-10-03T19:45:17.023Z
Comments.Text: I'm not exactly sure of the specific name  - but the drop down list appears in: import contributions, match fields (step 2 of 4), Matching CiviCRM Field (this is where the drop down list appears). does this info help? thanks for thinking about this.
Comments.UserDisplayName: annieboydramirez
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-10-04T16:55:29.913Z
Comments.Text: Hi @JohnFF I'm sorry, I forgot to add in your name to my response yesterday - here it is again -     
  I'm not exactly sure of the specific name - but the drop down list appears in: import contributions, match fields (step 2 of 4), Matching CiviCRM Field (this is where the drop down list appears). does this info help? thanks for thinking about this.
Comments.UserDisplayName: annieboydramirez
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-10-04T17:02:13.067Z
Comments.Text: What are the options that are available?
Comments.UserDisplayName: JohnFF
Tags: <import><contributions>
Title: Is there a way to include OpenID as a drop down option in the contribution lis? or Is there a way to convert OpenID to external identifier?
ThreadText: # Is there a way to include OpenID as a drop down option in the contribution lis? or Is there a way to convert OpenID to external identifier?
  
  (Asked by: username_0 on 2016-10-03)
  
  When I imported contacts, I listed their identification number as OpenID. Now, I am trying up import the contacts' contributions. Along with their name, amount, date of donation, I am including their OpenID.....yet, the drop down options in the import contributions does not include OpenID...therefore, the import will not function.
  
  a) Is there a way to include OpenID as a drop down option in the contribution list?
  if not...
  b) Is there a way to convert OpenID to external identifier?
  
  Thank you!
  
  **Tags:** import, contributions
  
  > **Comments:**
  > **username_1**: What is the name of the drop down list that you want to include it in?  
  > **username_0**: I'm not exactly sure of the specific name  - but the drop down list appears in: import contributions, match fields (step 2 of 4), Matching CiviCRM Field (this is where the drop down list appears). does this info help? thanks for thinking about this.  
  > **username_0**: Hi @username_1 I'm sorry, I forgot to add in your name to my response yesterday - here it is again -      I'm not exactly sure of the specific name - but the drop down list appears in: import contributions, match fields (step 2 of 4), Matching CiviCRM Field (this is where the drop down list appears). does this info help? thanks for thinking about this.  
  > **username_1**: What are the options that are available?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-10-05. Score: 1
  
  a) Is there a way to include OpenID as a drop down option in the contribution list?
  
  If you created a custom data field called "OpenID", you need to make sure the field can be used for contributions and that it is marked as searchable for it to appear in the list of fields when mapping contributions for import,
  
  **BUT**
  
  if memory serves me correctly, the system will require either an internal or external contact ID when importing contributions, so...
  
  b) Is there a way to convert OpenID to external identifier?
  
  Since you already imported the contacts, you can export all contacts being sure to include the OpenID and internal contact ID fields, then the update can be done in one of three ways - which ever you find easiest:
  
  1. Use the import contacts wizard to update all contacts mapping the OpenID to the external contact ID field using the internal ID as the link, **OR**
  2. Use a vlookup in csv to match the internal contact ID to the OpenID in your contribution data import file, and then import your contributions based on the internal contact ID, **OR**
  3. Use an SQL statement that will copy the OpenID to the external contact ID field by contact ID directly in the database
  
  Hope this helps,
  Tamar
  
  
  ---
  
  