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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Contact import fails
Pages: [1]

Author Topic: Contact import fails  (Read 1004 times)

ewanmclean

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
Contact import fails
October 30, 2013, 01:57:44 pm
Hi

I'm trying to import a batch of 1000 (out of 20k) contacts from a CSV file. If I try 5000 contacts it doesn't get past the first step. If I try 1000 it lets me map the fields then fails to do the preview. In either case there is no error message, it simply reloads the first step (upload etc.) and doesn't import any contacts. I've tried setting my PHP timeout to 10 minutes just in case, but the process fails within 10 seconds usually anyway. No errors in my cPanel error log.

Any ideas?

Thanks

clarkac

  • Administrator
  • Ask me questions
  • *****
  • Posts: 399
  • Karma: 11
  • CiviCRM version: 4.4.11 & 4.5.5
  • CMS version: Drupal 7
  • MySQL version: 5.1.61-cll
  • PHP version: 5.3.27
Re: Contact import fails
October 30, 2013, 02:03:17 pm
Try a very small number of records - like maybe 50.  In my experience errors in your input can cause this kind of behaviour, which is not very helpful.  Once I have my input all sorted with minimal errors, generally import behaves well.
Andy Clark

ewanmclean

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
Re: Contact import fails
October 30, 2013, 02:11:17 pm
Good thought but this didn't help, its still just reverting to the first page :(

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: Contact import fails
October 30, 2013, 05:42:31 pm
this isn't one of those odd www v no www conundrums is it?
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

ewanmclean

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
Re: Contact import fails
October 31, 2013, 05:57:44 pm
Funny you should say that, we did have a problem with www vs non www (one of our staff insisted on putting www in front of everything and kept getting logged out) but there's now a redirect rule in place using the standard drupal .htaccess rules:

  # To redirect all users to access the site WITHOUT the 'www.' prefix,
  # (http://www.example.com/... will be redirected to http://example.com/...)
  # uncomment the following:
 RewriteCond %{HTTP_HOST} ^www\.(.+)$ [NC]
 RewriteRule ^ http%{ENV:protossl}://%1%{REQUEST_URI} [L,R=301]

I have tried giving the script more resources but even parsing just fifty is throwing me back to the start.

post_max_size 64M
upload_max_filesize 32M
memory_limit 128M
max_execution_time 600
max_input_time 600

I appreciate people's time trying to help me find a solution :)

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: Contact import fails
October 31, 2013, 06:00:52 pm
yes but are you sure the entires in civicrm.settings.php (or is it settings.php) are sorted correctly - am sure there have been mysterious outcomes if not
and have you eyeballed your url when you are on the import wizard, and when you get thrown back to start?
probably pointing you at wild geese though
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

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 fails
November 01, 2013, 08:17:21 am

how are u running php? if under apache can u try using modphp (instead of fcgi or other methods)

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

ewanmclean

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
Re: Contact import fails
November 01, 2013, 08:51:54 am
Quote from: petednz on October 31, 2013, 06:00:52 pm
yes but are you sure the entires in civicrm.settings.php (or is it settings.php) are sorted correctly - am sure there have been mysterious outcomes if not
and have you eyeballed your url when you are on the import wizard, and when you get thrown back to start?
probably pointing you at wild geese though

Good idea to check, I put in the settings.php base url absolutely just in case, and the civicrm.settings.php one was already right, but no dice :(

Quote from: Donald Lobo on November 01, 2013, 08:17:21 am

how are u running php? if under apache can u try using modphp (instead of fcgi or other methods)

lobo


I'll ask my host. I'm sure its something to do with the server/host/php settings, because I never had an issue with this on our old server.

ewanmclean

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
Re: Contact import fails
November 09, 2013, 11:39:48 am
They say they're using suphp under apache. I tried importing just five rows and it worked fine: http://www.webpagescreenshot.info/img/527e8f14e0a9b7-50286132

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 fails
November 09, 2013, 12:35:05 pm

you might want to try using a different host. Our list of hosting providers is here:

https://civicrm.org/providers/hosting

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

ewanmclean

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
Re: Contact import fails
December 08, 2013, 11:00:01 am
I'd rather avoid setting up a separate host for one site if I can (though that may be the only option).

I've deployed a test install of drupal and Civi and can import successfully, although I get this error repeatedly during navigation: Warning: curl_setopt() [function.curl-setopt]: CURLOPT_FOLLOWLOCATION cannot be activated when safe_mode is enabled or an open_basedir is set in CRM_Utils_HttpClient->createCurl() (line 192 of /home/serviste/public_html/republic/sites/all/modules/civicrm/CRM/Utils/HttpClient.php).

I noticed this warning during install too: XCache compatibility   XCache is installed and there are known compatibility issues between XCache and CiviCRM. Consider using an alternative PHP caching mechanism or disable PHP caching altogether.

Can anyone think of anything I can do with my current site short of rebuilding it?
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Contact import fails

This forum was archived on 2017-11-26.