Answers.Body: <p>You should describe more these 3 columns as it's not clear what type they are and how you need to use them, but I would create them as either options on a custom field or as tags</p>
  
  <p>tags have 2 "usable" columns (the name and a description), optionvalues have 4 (label, value, name, description)</p>
  
  <p>you can import them from the command line using the api or use an extension.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-03T16:02:19.460Z
Answers.Text: Okay, I can explain again if there is any doubt remaining. You can consider the table as any ordinary table. Which is having three columns regarding (id, title, description).  And i know how to import the table in drupal. The main question is how can we show the 'title' from that table into our civicrm dropdown field.
Answers.UserDisplayName: Juyal Jee
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-03T16:37:10.623Z
Answers.Text: I would recommend you to use the existing tool, check how tag or custom fields work, and import your data into either civicrm_tag or civicrm_option_value and it will work out of the box
Answers.UserDisplayName: Xavier
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-02T07:30:07.440Z
Answers.LastActivityDate: 2015-06-02T07:30:07.440Z
Answers.UserDisplayName: Xavier
Body: <p>I have created a civicrm custom dropdown field in Drupal 7.  I have a excel spreadsheet contains some data in three columns. To which i need to import into civicrm and then the first column should be display in the custom dropdown field.</p>
  
  <p>So, i have two opinions at this stage</p>
  
  <p>1) I can create a custom table for Civicrm and then import the values from spreadsheet. OR</p>
  
  <p>2) I can create taxonomies terms having 3 fields in Drupal.</p>
  
  <p>After, that it should show it's values in the civicrm's custom dropdown field.</p>
  
  <p>But i couldn't able to find out the correct way to implement any of the approaches. Please suggest me the steps to implement either of those approaches or any new approach which will be quite easy to implement.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-23T13:57:56.313Z
Comments.Text: Is there a reason you aren't using the CiviCRM import features?
Comments.UserDisplayName: Nicholai
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-25T01:08:46.417Z
Comments.Text: Could you explain a bit more about what the three columns of data are about, and what kind of custom fields you are intending to store them in in CiviCRM? Are they like tags on a contact?? For example, is the first column a tag/taxonomy term, and the next two unique identifiers for a contact?
Comments.UserDisplayName: Joe Murray
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-25T01:16:05.523Z
Comments.Text: Rereading your question I wonder if you mean to say that the first column is actually a Drupal dropdown field that you want to use on CiviCRM objects, for example by making them Drupal fields.0
Comments.UserDisplayName: Joe Murray
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-26T05:09:06.350Z
Comments.Text: The field is civicrm custom field (created from backend) and not the Drupal field. The table in which we have three columns is just related to a 'Medicine's informations'.  To which we'll use to assign medicines to different contacts of the Civicrm. So, its just like tagging the contacts with medicine's data. But no column associated with unique contact in that table.
Comments.UserDisplayName: Juyal Jee
Tags: <drupal><civicrm-home>
Title: Set drupal taxonomy terms in the civicrm custom option fields
ThreadText: # Set drupal taxonomy terms in the civicrm custom option fields
  
  (Asked by: username_0 on 2015-05-23)
  
  I have created a civicrm custom dropdown field in Drupal 7. I have a excel spreadsheet contains some data in three columns. To which i need to import into civicrm and then the first column should be display in the custom dropdown field.
  
  So, i have two opinions at this stage
  
  1) I can create a custom table for Civicrm and then import the values from spreadsheet. OR
  
  2) I can create taxonomies terms having 3 fields in Drupal.
  
  After, that it should show it's values in the civicrm's custom dropdown field.
  
  But i couldn't able to find out the correct way to implement any of the approaches. Please suggest me the steps to implement either of those approaches or any new approach which will be quite easy to implement.
  
  **Tags:** drupal, civicrm-home
  
  > **Comments:**
  > **username_1**: Is there a reason you aren't using the CiviCRM import features?  
  > **username_2**: Could you explain a bit more about what the three columns of data are about, and what kind of custom fields you are intending to store them in in CiviCRM? Are they like tags on a contact?? For example, is the first column a tag/taxonomy term, and the next two unique identifiers for a contact?  
  > **username_2**: Rereading your question I wonder if you mean to say that the first column is actually a Drupal dropdown field that you want to use on CiviCRM objects, for example by making them Drupal fields.0  
  > **username_0**: The field is civicrm custom field (created from backend) and not the Drupal field. The table in which we have three columns is just related to a 'Medicine's informations'.  To which we'll use to assign medicines to different contacts of the Civicrm. So, its just like tagging the contacts with medicine's data. But no column associated with unique contact in that table.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2015-06-02. Score: 1
  
  You should describe more these 3 columns as it's not clear what type they are and how you need to use them, but I would create them as either options on a custom field or as tags
  
  tags have 2 "usable" columns (the name and a description), optionvalues have 4 (label, value, name, description)
  
  you can import them from the command line using the api or use an extension.
  
  > **Comments:**
  > **username_0**: Okay, I can explain again if there is any doubt remaining. You can consider the table as any ordinary table. Which is having three columns regarding (id, title, description).  And i know how to import the table in drupal. The main question is how can we show the 'title' from that table into our civicrm dropdown field.  
  > **username_3**: I would recommend you to use the existing tool, check how tag or custom fields work, and import your data into either civicrm_tag or civicrm_option_value and it will work out of the box  
  
  ---
  
  