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) »
  • Data conversion
Pages: [1]

Author Topic: Data conversion  (Read 1911 times)

roland

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
Data conversion
February 25, 2009, 09:43:54 pm
Hi, we have a feed (CSV) each day from an external system that we load into Civi. The external feed stores 'gender' values as "f" and "m". Is there any way this can be converted to the correct values of "1" and "2" during the import facility?

I couldn't find any details in regards to this so I thought I would post it here.

Sincerely,
Roland.

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: Data conversion
February 25, 2009, 11:34:14 pm
hi roland

(IMO) You can not import gender data with values 'f', 'm' or 't'. You has to have proper values ( like  female, male, transgender ).
It would be good if you convert these values to proper values before import to CiviCRM.

kiran

 
You Are Designed To Choose... Defined By Choice.

roland

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
Re: Data conversion
February 26, 2009, 09:39:03 pm
Thanks Kiran.

I changed the csv to 'female' and 'male'. It wasn't clear that these were the valid values. I had assumed the values were '1', '2' and '3' as they are radio buttons. But all is good now.

It would be good if the import facility could do the conversion of the data (simple stuff like this). I might have a go at mapping this out and putting it through for a future release.

Thanks again.

Sincerely.

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: Data conversion
February 26, 2009, 10:07:40 pm
hi

Quote
It wasn't clear that these were the valid values. I had assumed the values were '1', '2' and '3' as they are radio buttons.

It would be good practice, If check the supported data format by exporting some sample data and try to import data in same format.
(IMO) This will work for almost all CiviCRM data fields.

kiran
You Are Designed To Choose... Defined By Choice.

dharmatech

  • I post frequently
  • ***
  • Posts: 280
  • Karma: 53
    • dharmatech.org
Re: Data conversion
April 11, 2009, 03:32:02 pm
Quote from: roland on February 25, 2009, 09:43:54 pm
Hi, we have a feed (CSV) each day from an external system that we load into Civi. The external feed stores 'gender' values as "f" and "m". Is there any way this can be converted to the correct values of "1" and "2" during the import facility

I filed issue CRM-4360 with a patch to 2.2.2 to do what you want.

-- Walt
http://dharmatech.org
oss@dharmatech.org
801.541.8671
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Data conversion

This forum was archived on 2017-11-26.