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 »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Only Importing 15 records
Pages: [1]

Author Topic: Only Importing 15 records  (Read 2250 times)

DamianBunn

  • Guest
Only Importing 15 records
March 18, 2009, 09:49:29 am
Hmm - not sure what has happened here. I have been importing from a CSV file with no problems. Now every time I try and import I only get 15 records even though there are nearly 200 in the csv file.

Any thoughts ?

Damian

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: Only Importing 15 records
March 18, 2009, 10:14:36 am
Hi Damien,
First, a request: It would be very helpful to those trying to help you if you would update your forum profile with the version of CiviCRM/Drupal?Joomla that you are using.

1. Are you getting any error messages?
2. How about the report that appears on the screen after the import? How many records does it say were imported?
3. Is it possible that the other records are being flagged as duplicates and therefore not getting imported?
4. If none of the above makes sense please provide more specifics about what you are doing.

Let's start with answers to these questions and take it from there.

Cynthia

DamianBunn

  • Guest
Re: Only Importing 15 records
March 19, 2009, 02:07:50 am
Profile Updated.

Strange this - I tried several different methods of importing and the same result every time. I removed an extra column I had added without any content that I was also importing and it worked fine.

Damian

pickettcrm

  • Guest
Re: Only Importing 15 records
June 10, 2009, 02:33:36 pm
I had a similar issue today.  The import would only recognize 15 records until I removed unnecessary columns from the spreadsheet.  Then it would hang up at 31 records which I suspect was related to some columns having no entries.  It worked fine when I performed the import with only the columns that every contact had data in.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Only Importing 15 records
June 10, 2009, 05:53:07 pm

can u try to reproduce this on the demo machine

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

pickettcrm

  • Guest
Re: Only Importing 15 records
June 23, 2009, 01:28:00 pm
Just tried to re-create the issue on the demo machine with sample data and the function worked correctly. 

creducation

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
Re: Only Importing 15 records
January 14, 2010, 05:59:52 pm
I experienced the 15 user limit on uploads as well a few days ago, running CiviCRM 3.0.1 in Drupal 6.15.  Everything seemed to work in terms of dealing with duplicates and such, but only 15 records would go at a time. I would delete the top 15 rows in the spreadsheet and try again, and each time it would take the first 15 records and then stop without error.

Puzzling, yes.  I'll have to keep in mind the idea of eliminating columns that aren't essential and see if that helps.

sjthespian

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 3
    • The League of Professional System Administrators
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 6.28
  • MySQL version: 5.1.66
  • PHP version: 5.3.3
Re: Only Importing 15 records
July 16, 2010, 08:43:54 am
I am running into a very similar issue.  We are migrating from a drupal 4.x server to 6.x and converting to CiviCRM 3.1.5 in the process.  As I am importing my contacts into Civi via. a csv export from the old drupal server I have a couple of export files where the import is only pulling in some percentage of the file like the last one that only worked on 86 records out of 500.

In my case the problem appears to be caused by records in the csv file with 8-bit characters. If I remove those entries the import completes successfully.

As an example, the following record causes the import to stop:
Quote
"xxxx","someone@gmail.com","Ã<96>zgür","PekçaÄ<9f>lıyan","64.xxxx. 7/8 xxxx","","Ankara","Turkey","06510","Turkey","","","System Administrator",""
Dan Rich <drich@lopsa.org>
    Director, LOPSA - http://lopsa.org/
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • Only Importing 15 records

This forum was archived on 2017-11-26.