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) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • What's the largest .csv you've imported with 4.1beta codebase?
Pages: [1]

Author Topic: What's the largest .csv you've imported with 4.1beta codebase?  (Read 1045 times)

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
What's the largest .csv you've imported with 4.1beta codebase?
January 06, 2012, 11:49:57 pm
I'm trying to import contacts - a .csv file with 10k rows, and it's choking and giving me a 500 error after a few hundred.  So I scaled it back to 1000 rows, still an error.

I finally got import working at the 500 row mark.  That's like, 20 imports to get my 10,000 rows in.

Also the 'progress bar' isn't updating.  Never had trouble with large files like this in 4.0, in fact I remember importing a 17k file.

Think it's a server setting (CiviHosting)? PHP memory is 128mb

... or could this possibly be a bug in the Civi?

Although I had Civi's 'debug mode' enabled, CiviHosting doesn't allow direct access to the logs, and shows only a 500 error on the screen, so this is all I have to go on:
Quote
500 Error: Premature end of script headers


UPDATE: Due to server resource restrictions on civiHosting shared hosting (understandable) imports are generally limited to 500 rows per import, although the server admins will increase resources temporarily and I've been able to get 1000 per import successfully.
« Last Edit: January 07, 2012, 10:03:31 am by Stoob »
Try CiviTeacher: the online video tutorial CiviCRM learning library.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: What's the largest .csv you've imported with 4.1beta codebase?
January 07, 2012, 01:40:30 pm
Hi Stoob. Our shared accounts actually all come with 200MB RAM. :)

When an error occurs, does the import fail or succeed?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: What's the largest .csv you've imported with 4.1beta codebase?
January 12, 2012, 07:17:20 am
Quote from: Stoob on January 06, 2012, 11:49:57 pm
CiviHosting doesn't allow direct access to the logs

For the record, you can edit your php.ini file on any account on our servers and set your own error_log file location and thus you have access to PHP errors for your own site.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • What's the largest .csv you've imported with 4.1beta codebase?

This forum was archived on 2017-11-26.