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) »
  • Contact import hangs up
Pages: [1]

Author Topic: Contact import hangs up  (Read 1483 times)

dsdart

  • I post occasionally
  • **
  • Posts: 85
  • Karma: 3
  • CiviCRM version: 4.4
  • CMS version: Drupal 7.25
  • MySQL version: 5.1.41
  • PHP version: 5.3.1
Contact import hangs up
December 11, 2011, 01:32:38 pm
When I import contact information from a csv file, the little white window showing the percentage will get to, say, 35% or 52%, then hangs.  I've waited 45 minutes and nothing changes.  I don't know whether it's the little window that is not getting updated or the database that's not getting updated, since a spot check seems to show that the data is there. 

I tried importing the csv file as UTF-8, but that didn't help.  There are less than 300 records so this seems out of line.

Suggestions?

Thanks

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: Contact import hangs up
December 11, 2011, 04:11:25 pm

can u check your php and/or apache error logs and see if there are any messages recorded

if i had to guess, one of the process is timing out

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

dsdart

  • I post occasionally
  • **
  • Posts: 85
  • Karma: 3
  • CiviCRM version: 4.4
  • CMS version: Drupal 7.25
  • MySQL version: 5.1.41
  • PHP version: 5.3.1
Re: Contact import hangs up
January 04, 2012, 02:45:48 pm
Finally got back to this... I don't see any errors in the logs. 

It looks like its just very slow.  Using a csv file with 500 records with only 10 columns, the message said it had done 200 of 500 after about 45 minutes and I got impatient and refreshed the page.  A couple of hours later, it looks like all the records have been processed.

I'm running XAMPP on a windows box.  Is there anything that can be done to speed this process up?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Contact import hangs up
January 06, 2012, 04:19:41 am
Quote from: dsdart on January 04, 2012, 02:45:48 pm
I'm running XAMPP on a windows box.  Is there anything that can be done to speed this process up?

You can certainly attempt to optimize your XAMPP install. You can Google for various settings to do there--one thing that comes to mind is raise the memory limit for PHP. Beyond that, I don't think there is much that can be done as this is basically a feature of the CPU and RAM which are provided to CiviCRM. Meaning, if you want it a lot faster, consider using better hardware. :)
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) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Contact import hangs up

This forum was archived on 2017-11-26.