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) »
  • field separator not recognized
Pages: [1]

Author Topic: field separator not recognized  (Read 2012 times)

cgrauer@netscript.net

  • Guest
field separator not recognized
July 01, 2009, 11:11:59 am
I try to import a csv file with ; as separator and 3 fields. The first row contains field names. But CiviCRM does not recognize the 3 fields but puts the whole row in one single field. I tried it with updating to the newest version (2.2.6), I tried it with the demo on civicrm.org and I tried it with different types of csv files (comma, semicolon, tab, with and without single and double quotes): all the same. I can't import my contacts because all the data is put together in one single field. Every hint is appreciated. I'm very new to CiviCRM, running on a drupal 6.x version (up to date), debian, php5, MySQL 5, apache etc.
Christian

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: field separator not recognized
July 01, 2009, 12:17:57 pm
Hello Christian,
Would it be possible for you to attach (or just copy/paste here) the first few lines of your file (including the header line)? This way we could see exactly what you are trying to import and possibly figure out why it is not working for you.

Cynthia

cgrauer@netscript.net

  • Guest
Re: field separator not recognized
July 01, 2009, 01:49:34 pm
sure. this is the file I used:

first_name;last_name;email
Christian;Grauer;cgrauer@xxxxxx.net
Felix;Hau;felix@xxxxxx.de
Simon;Knipping;simon.knipping@xxxxx.de

(changed the addresses for privacy...)

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: field separator not recognized
July 01, 2009, 10:50:43 pm
hi Christian

I would like to follow these steps

1. Configure field separator.
go to -> Administer CiviCRM -> Global Settings -> Localization -> check "Import / Export Field Separator" give your field separator here.

2. Try to import .csv file which has configured field separator.

hope this help

kiran



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

cgrauer@netscript.net

  • Guest
Re: field separator not recognized
July 02, 2009, 01:56:51 am
hi Kiran,
thanks a lot! It works! It would be a great thing if this was mentioned in the documentation...
Christian

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: field separator not recognized
July 02, 2009, 10:27:43 am
The documentation is a wiki - and CiviCRM relies on the community to improve it. You can register to get a login (Signup link upper right corner), and then add the "tip" in a good spot :-)
« Last Edit: July 02, 2009, 10:29:55 am by Dave Greenberg »
Protect your investment in CiviCRM by  becoming a Member!

cgrauer@netscript.net

  • Guest
Re: field separator not recognized
July 02, 2009, 11:49:44 am
You're right! I just did so.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • field separator not recognized

This forum was archived on 2017-11-26.