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 Excel CSV files
Pages: [1]

Author Topic: Importing Excel CSV files  (Read 1376 times)

vanalive

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 1
Importing Excel CSV files
April 07, 2010, 02:23:02 am
This was driving me nuts for a few hours importing an excel CSV file. It was skipping rows and miscellaneous items.

If this is the case for you..

Try..
1) Add a column of nulls after your final column. 

Excel seems to leave off some of the final comma if you have a blank field and civi will miscount rows.

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Importing Excel CSV files
April 07, 2010, 11:52:33 am
Sounds good advice - other option would be to have the final column as incremental integer and import that to a custom field - then if the import falls over part way through or any other bizarre behaviour it is easy to track where it stopped, sputtered etc.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

pkeogan

  • I post frequently
  • ***
  • Posts: 130
  • Karma: 4
    • BackOffice Thinking
Re: Importing Excel CSV files
April 26, 2010, 07:04:39 pm
I generally put an ID (External or internal) in the last field to eliminate any issues. 

The key is not having any blanks in the last column.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing Excel CSV files

This forum was archived on 2017-11-26.