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

Author Topic: CSV errors  (Read 498 times)

jerryamiller22

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.1
  • MySQL version: ??
  • PHP version: ??
CSV errors
January 22, 2015, 08:00:30 pm
I imported one file- about 100 records- into Civic CRM and it went fine.  I tried to import a second file - first with all 1000 + names and then with just 500.  I keep getting the error message that it must be in a CSV format. I double checked, even opening the file in Word to make sure it was CSV, but still I get the error message.  I cleaned up the headers so there were no special characters in there and I made sure the date was formatted properly. Any thoughts?

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: CSV errors
January 22, 2015, 08:41:59 pm
Hi Jerry,

Can you post the exact error message here?  And maybe your header with a sample line or two (anonymized)?  That will let people better troubleshoot.

When you get the error, does it appear on screen?  Or does it appear in a CSV that you get by clicking a "Download Errors" link?
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: CSV errors
January 22, 2015, 11:30:29 pm
I think Word can also add non-standard characters.  I always open things in Notepad.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • CSV errors

This forum was archived on 2017-11-26.