Author Topic: Import process will not pass step 2 (Read 5573 times)

johnny.kelley · December 18, 2009, 01:56:32 am

I'm volunteering for a non-profit trying to migrate a very messy Access database. I'm currently trying to import contact from a .csv. The contacts are all non-US residents. I've configured CiviCRM to accept all international addresses. When I get to step 2 of the import process, I match the .csv fields to standard CiviCRM fields. I then click "Continue". The page takes about 30 seconds to load. When it does, it simply reloads the same page. I've made a test .csv with mock domestic contacts, and it imported perfectly. Any help would be appreciated.

Kurund Jalmi · December 18, 2009, 03:02:52 am

Bit strange. How many records to do have? Can you try to split your .csv file into multiple csv's and try to import.

HTh
Kurund

johnny.kelley · December 21, 2009, 12:38:28 pm

I've tried splitting, removing uncommon fields. Nothing works.

conductorchris · December 21, 2009, 06:47:13 pm

At one time I had trouble importing and the issue was the php memory limit (civiCRM wants 128mb and Thinkhost has a default limit that is much lower). Eventually I worked out I was only able to import 15 records at a time, which is a slow way to import a 2,000 record list! I worked with my host to relax my limits overnight and that did the trick.

squidgy · December 21, 2009, 08:56:47 pm

I am having the same difficulty with import, I have split the database and my host provider has increased my memory size and still getting stuck, Any ideas?

Kiran Jagtap · December 21, 2009, 09:01:48 pm

you might want to try on our demo site : http://drupal.demo.civicrm.org/

If you attach sample data file ( .csv ) here, that would be helpful to debug.
( Of course any private / personal info should be disguised. )

kiran

jsimonis · January 17, 2010, 11:25:25 pm

I am running into the same issue. Trying to import a file that is about 620kb. Keeps returning me to Step 2.

adixon · January 18, 2010, 07:29:08 pm

1. check the log in files/civicrm/upload/CiviCRM.log
it usually has useful information if something goes wrong.

2. if you've got server issues - try setting yourself up a development environment and doing the import there, and then just loading the database on your server [not a great solution w/ a live site though].

3. consider changing your server to one that gives you more access/memory. This might be just the beginning of your hassles ...

Lionsharz · February 18, 2010, 12:27:50 pm

Hi,

I've got the same problem (15 row limit on my .csv file) I've tried using UTF 8 encoding and the regular encoding for a .csv while saving from Excel. My hosting provider has upped our memory limit with no effect. I didn't think it would as our .csv file is really small (491kb). Moreover, I've just reproduced the behaviour on the demo site. It's only recognizing the first 15 records. Tried all the available duplicate checking options to see if that would do anything but no effect.

Any ideas what might be causing this limiting reaction?

Neilo

Lionsharz · February 18, 2010, 05:04:23 pm

Updating the last post, for me it turned out to be a problem with excel's .csv export. I was exporting from access to Excel 97-2000 and checking the data by opening it in Excel and then saving as a .csv. That was the problem - civicrm didn't like the .csv created by Excel (even if I later opened or pasted it into a Notepad and saved again using UTF8 encoding). So I exported the tables from Access directly as a .csv (you can also encode in Access directly as UTF8).

If you aren't exporting from Access recommend downloading Open Office and using the spreadsheet in there - civicrm had no problems of limiting imports when using a .csv file from Open Office either.

Hope this helps someone!

Neilo

petednz · February 18, 2010, 06:51:03 pm

I concur - client had same problems but we don't as we use NeoOffice. For them it was odd characters such as accents tripping the system up since it was not utf-8

deciofabio · March 05, 2010, 08:01:11 am

Unfortunately it did not fucntion to me. I tried to import it from a joomla virtuemart user table using a variety of options, including CSV from the phpmyadmin export option , without success.
Amazingly, civicrm did not recognize the "," and give me a message of error with the citation of "too long" name.
This name is the first head row, without the recognition of the

Code: [Select]

,The codification of joomla original base is latin1-swedish-ci
Any permition issue can be related to that?
I would appreciate so much for help.

CiviCRM Community Forums (archive)

News:

Author Topic: Import process will not pass step 2 (Read 5573 times)

johnny.kelley

Import process will not pass step 2

Kurund Jalmi

Re: Import process will not pass step 2

johnny.kelley

Re: Import process will not pass step 2

conductorchris

Re: Import process will not pass step 2

squidgy

Re: Import process will not pass step 2

Kiran Jagtap

Re: Import process will not pass step 2

jsimonis

Re: Import process will not pass step 2

adixon

Re: Import process will not pass step 2

Lionsharz

Re: Import process will not pass step 2

Lionsharz

Update on problem (solved for me anyway)

petednz

Re: Import process will not pass step 2

deciofabio

Re: Import process will not pass step 2