CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing Data for a Alphanumeric / Select Field - Help needed
Pages: [1]

Author Topic: Importing Data for a Alphanumeric / Select Field - Help needed  (Read 2047 times)

Chris7789

  • Guest
Importing Data for a Alphanumeric / Select Field - Help needed
February 18, 2009, 06:56:28 am
Hi,

I have a custom data field set to:

Data Type = Alphanumeric
Field Type = Select

I have five Multiple Choice Options for this field.

The problem is when importing data I am getting an Invalid value for field error.

Data format I am trying is =  this, is, data, that, import
I have tried using = "this, is, data, that, import"

Both get same message. It works if I change the field type to Multiselect on the data without the "". However that has raised seperate issues. I would presume that because you are allowed multiple choice options for a Select field then their must be a way to import more than one value?

I am currently running version 2.0.6

Please help it would be greatly appreciated.

Thanks

Chris

ctarascio

  • I post frequently
  • ***
  • Posts: 334
  • Karma: 30
    • American Friends Service Committee
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 6.26
  • MySQL version: 5.5.20
  • PHP version: 5.3.13
Re: Importing Data for a Alphanumeric / Select Field - Help needed
February 18, 2009, 07:10:07 am
Hi Chris,
I think if you leave out the spaces between the values it will work. Try this: "this,is,data,that,import".

If it doesn't work, please let us know.

Cynthia

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Importing Data for a Alphanumeric / Select Field - Help needed
February 18, 2009, 07:12:37 am
Chris:

Since the field type is "Select", it expects a single value (from the Multiple Choice Options)
You could use a type "Checkbox" / "MultiSelect" if you wish to import/store multiple data for a custom field.

HTH
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

ctarascio

  • I post frequently
  • ***
  • Posts: 334
  • Karma: 30
    • American Friends Service Committee
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 6.26
  • MySQL version: 5.5.20
  • PHP version: 5.3.13
Re: Importing Data for a Alphanumeric / Select Field - Help needed
February 18, 2009, 07:13:35 am
Oops! Missed the field type... sorry  :-[

Chris7789

  • Guest
Re: Importing Data for a Alphanumeric / Select Field - Help needed
February 18, 2009, 07:20:15 am
The problem with the checkbox is I have lots of fields. Making the screen look very messy. But I also idearly only want them to be able select one value.

So can Select not take multiple choice?

Thanks for replying

Chris

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Importing Data for a Alphanumeric / Select Field - Help needed
February 18, 2009, 07:24:20 am
Quote
So can Select not take multiple choice?

Nope. You can use multi-select instead.

-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Chris7789

  • Guest
Re: Importing Data for a Alphanumeric / Select Field - Help needed
February 18, 2009, 07:29:09 am
Ok thanks for replying.

The problem I have with multi-select I have posted here.

http://forum.civicrm.org/index.php/topic,6681.0.html

Any help would be great.

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: Importing Data for a Alphanumeric / Select Field - Help needed
February 18, 2009, 07:30:39 am
hi Chris

best bet would be export sample data for any field from civicrm that you want to import and check the supoorted data formats.
Try to import field data in same format as exported format, ( IMO ) This should work for all fields.

kiran   
You Are Designed To Choose... Defined By Choice.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing Data for a Alphanumeric / Select Field - Help needed

This forum was archived on 2017-11-26.