Author Topic: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported (Read 13439 times)

petednz · May 16, 2008, 12:56:23 pm

Hi - had an issue on an import last night same as you. Problem proved to be one row that had incorrect type of data for the field. Nothing was reported on. ON my third attempt with the same data I got two out of 100s imported and they had an error stating "Array is not of the type Integer".
So is it worth you double checking you don't have text in a field that is going to a field that is set for integer - or anything like that.

if you do, then we probably need to file this as an issue as i think the correct behaviour would be 'no rows imported successfully' and some indication as to which field has the problem data in it.

Note that the above 'desired' behaviour does occur eg if i am importing a file that has incorrect Date formatting and Prefix etc. Maybe it doesn't report properly on custom data fields.

jsimonis · May 25, 2008, 06:02:49 am

I just tried it on another server with a fresh install of 2.0.3 and it did it as well. I even tried just importing primary fields - first name, last name, address, email, etc. Still nothing imported even though it told me it did.

The data was exported from a CiviCRM site and was being imported into a new one.

Mishka3366 · May 26, 2008, 02:10:40 pm

I am having the exact same problem: import function says it was successful, but nothing imported. Yesterday, I easily imported 7000 records on an identical build (different NFP). You say....

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

but I don't know what you mean....Help?

Donald Lobo · May 26, 2008, 05:26:03 pm

You might want to wait till we release 2.0.4 which will happen in the next couple of weeks

lobo

xavier · May 28, 2008, 02:48:52 pm

Hi

I svn updated my 2.0 verified, ok template, but still the same behaviour:

sucessfully imported, but nothing in the db.

That's really painful to debug, I suspect that's about some custom fields.

I have a Yes to put on a yes/no field for instance, and it doesn't seem to like it. Not sure.

I'll try with a simple example on demo.

Is it possible to put trunk on a 2.0 ? I'd like to try the lastest version, see if it works better

petednz · May 28, 2008, 03:50:39 pm

If it is a yes/no field, might the 'yes' be a '1' rather than a yes?

Try entering the field in the database for a single individual, then export, and see what the data is meant to be. Just a thought.

Donald Lobo · May 28, 2008, 04:54:08 pm

Quote from: xavier on May 28, 2008, 02:48:52 pm

Is it possible to put trunk on a 2.0 ? I'd like to try the lastest version, see if it works better

you definitely dont want to do this

trunk is quite unstable, under active development and only works with drupal 6, joomla 1.5

lobo

xavier · May 28, 2008, 10:59:49 pm

@Peterd,

Yes, it shouldn't be Yes for yes, but 1.

From a usuability point of view, finding the correct values for the gender, the boolean fields, the multiple select is a hit or miss game, without feedback now, (but even when it was working, it was only that the value was invalid).

Given the odds of having the right combination of values when you import, that's a miss game.

Don't have a real suggestion, just sharing my pain while importing, and thinking it ought to be a better way.

I've hacked the import so it slightly less anal, and for intance recognise that m Male Man are all the same, a bit better, but still way to long and painful...

X+

jsimonis · May 29, 2008, 04:45:26 am

Thanks. We were trying to create a fresh CiviCRM install to see if we could fix the problem we're having with it not pulling everyone in the search - we thought maybe somewhere along the way there was an error in an update, but we didn't get an error message about it. But we can't import anything, not even just the primary fields (name, address, etc.), so that turned out to not be an option.

One quick question on a slightly different topic, although it might end up being related to this problem, did I read correctly in the install/upgrade instructions - does CiviCRM 2.x only work on MySQL 5+?

xavier · May 29, 2008, 08:16:27 am

You shouldn't have been able to install with the "wrong" version of mysql. You didn't get any error message ?

X+

xavier · May 29, 2008, 08:17:45 am

Ok, nailed down the issue: trying to import, but only with the country , not the other address fields.

Going to try on the demo.

X+

ParkHill · May 29, 2008, 08:19:34 am

This problem bites. I can't import anything.

My import was working for a while, then nothing, even though it says all rows were imported. I removed the CiviCRM database and upgraded to 2.0.3. Same problem. I tried importing a small file consisting only of "email, first, last, zipcode, country", but even that failed. Confirmed in a Bbedit that there were no strange, stray characters.

Environment: Mac OSX, Firefox, Bluehost.

The initial, successful loads may have occurred before I added any custom fields.

I haven't seen a comments in the thread that clarifies whether this problem is real, or that a solution has been identified, and solved for 2.0.4. Donald Lobo mentioned that you only need a change to preview.tpl, but it is unclear whether he's talking about the import bug or something else.

Thanx

jsimonis · May 29, 2008, 09:31:22 am

No errors, but in some places in the install it says that it won't work with MySQL 4.1. Sometimes it says MySQL 5 is recommended, other times it says required.

The server we're running on uses MySQL 4.1.22.

jsimonis · May 29, 2008, 09:32:54 am

ParkHill:

I know I tried a clean install with no custom fields, and I still couldn't get a few basic fields (name, addy, email, etc.) to import.

xavier · May 29, 2008, 09:57:28 am

Hi,

Spent another nightmarish day struggling with the import (retyping them would have been 10 time faster, and much better for my inner peace).

Still haven't nailed it down, but I think the bug does appear differently (or only?) in update when there the contact is already in the db. It seems it work better when there is a creation than an update. Could you try on your db ?

Otherwise, when the import lies, it's much faster than an import that works.

Dave, Lobo, is there a way of debugging that ? At least to be able to identify where the import fails ?

X+

CiviCRM Community Forums (archive)

News:

Author Topic: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported (Read 13439 times)

petednz

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo

jsimonis

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo

Mishka3366

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported

Donald Lobo

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported

xavier

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported

petednz

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo

Donald Lobo

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported

xavier

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows imported

jsimonis

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo

xavier

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo

xavier

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo

ParkHill

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo

jsimonis

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo

jsimonis

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo

xavier

Re: Import Bug? : Says that it has successfully imported X rows, but 0 rows impo