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) »
  • Import Bug? : Says that it has successfully imported X rows, but 0 rows imported
Pages: [1] 2 3

Author Topic: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported  (Read 13439 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
Import Bug? : Says that it has successfully imported X rows, but 0 rows imported
May 07, 2008, 01:05:09 pm
Hello, I did a good solid search for some import errors.  None of them appeared to be quite like what I just experienced, so I am posting a new thread.  Here is what I did.

1) Installed CiviCRM 2.0.3 on Drupal 5.7 - with test data.
2) Created a series of about a dozen Custom data fields (mostly Alpha/Numeric and Yes/No)
3) Did the data mapping and imported successfully 16 rows of data using the data mapping.
4) Realized I wanted a couple more Custom data fields, so created them. 
5) Searched for "All Contacts" and deleted all contacts, which deleted all the test data + my 16 rows.
6) Resyched Drupal users to CiviCRM (which brought back 2 users besides my own)
7) Edited the data mapping slightly (to account for new Custom Data fields)
8) Reimported all the 16 rows, which it said there was a success.
9) Searched for all Contacts, and none of the 16 un"successfully imported" rows show up.

Here is a screenshot of each step of the import pricess (step #8 above)

Any ideas on why these 16 users are not being imported when they were before and CiviCRM says they are now - but they are not?


« Last Edit: May 07, 2008, 01:06:54 pm by Stoob »
Try CiviTeacher: the online video tutorial CiviCRM learning library.

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
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 09, 2008, 03:11:36 pm
Hey, anyone got any ideas?  This one's been up for a couple of days.  I can't import our data, kinda a problem.
Try CiviTeacher: the online video tutorial CiviCRM learning library.

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: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported
May 09, 2008, 05:26:45 pm

you might want to try to reproduce on demo. if so, we can track it down.

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

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 12, 2008, 05:58:52 am
I've been having a similar problem.

Something is wrong with our CiviCRM install, so I've created a new one on another server, added all the custom fields, rebuilt the profiles, etc.

Then I exported the data out of the problem install and tried to import it into the new install.

I mapped out all the fields so they match the correct fields in the new database.

It tells me it successfully imported 98 rows, but there are only 66 contacts.

It's not an issue of duplicates, as there are many e-mail addresses missing.

And for the most part, only the e-mail addresses have been imported - no names, street addresses, etc.

It's really frustrating. I've been trying to get this imported for a week now. This is the first time I've gotten even a partial import - every other time nothing was imported.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 12, 2008, 06:18:38 am
I just used the exact same file on the demo site. I told it not to import any of the custom fields (since I hadn't created them on the demo site) and it imported fine.

So I tried just the non-custom fields on my site, and it imported fine.

Now I have to find out why I'm having trouble with the custom fields. There's only about 5 on this import (I have too many to import all at once - site runs out of memory).

kaless

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 12, 2008, 06:59:58 am
Hi,

did you skip some column in your .csv-file (selected by  -do  not import-)? I had a problem like you have. If every column of my .csv-file matches some field in civicrm, the import works properly.

Greetings

Bene

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 12, 2008, 07:22:43 am
It's funny, because on the demo site I skipped fields without problem.

I just cleared and re-installed CiviCRM so that I could try just adding a few custom fields and importing a bit at a time.

I just tried to import just the non-custom stuff (name, address, phone, etc.), and once again nothing imported even though it said it did.

So I removed fields from the CSV file that I was skipping. Now it contains only primary fields that I want to import.

I tried to import, and nada.

I checked the CiviCRM log, and no errors show up.

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: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported
May 12, 2008, 02:08:47 pm

hey jenni:

1. what version of civicrm?

2. if 2.0, can u get on IRC and give us ssh access to the server, a small sample of the import file etc so that we can debug it.

3. there is a really bad bug with import where it does not return the error due to some ajax issues. we hope to resolve it in 2.1. i suspect that might be tripping you up. its quite easy to trap it via firebug

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

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 12, 2008, 03:28:40 pm
Using 2.0.3.

It's been so long since I was on IRC (more than 10 years) that I don't even remember how. But I could definitely do that if you tell me how.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 12, 2008, 10:06:08 pm
Well, I am online in IRC now. My username there is horsetail.
« Last Edit: May 12, 2008, 11:13:08 pm by jsimonis »

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 13, 2008, 02:22:31 pm
Hi Lobo,

Could you detail how to trap the errors on firebug ? I'm afraid I've strumbled on the bug too.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

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: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported
May 13, 2008, 03:22:23 pm

I looked into this and fixed it for 2.0. This bug is filed and fixed here:

http://issues.civicrm.org/jira/browse/CRM-3112?page=com.atlassian.jira.ext.fisheye:fisheye-issuepanel

you only need the change to Preview.tpl

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

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 14, 2008, 08:05:04 am
"Updated to revision 14475."

I'll let you know. Thx
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

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
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 14, 2008, 10:26:39 am
Back to my original bug, I tried importing, deleting and re-importing on the Demo site, although with fewer custom fields.  I made over 20 custom fields on my own server, and didn't really have the time to make them all on your Demo site. 

Your demo site, as I suspected, works fine with no issues.  Keeping in mind.... Demo site has - maybe different installation, different hosting environment, the fact that the demo site already has dozens of groups and custom fields on it already from other people playing with it.  In other words, not an identical environment.  I'll likely never be able to replicate the bug on the Demo site.

We're going to switch hosting anyway, if we have this problem again I'll be in touch, until then my particular bug will have to remain un-replicated.
« Last Edit: May 14, 2008, 10:28:13 am by Stoob »
Try CiviTeacher: the online video tutorial CiviCRM learning library.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo
May 15, 2008, 10:32:33 pm
I don't think it's a hosting issue - we're running the same version on other sites installed on this VPS server, and we aren't having any problems importing information.
Pages: [1] 2 3
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Import Bug? : Says that it has successfully imported X rows, but 0 rows imported

This forum was archived on 2017-11-26.