Hi

I wonder if anyone could help me.

I am running SugarCRM Community Edition (latest release, not beta).

I need to import approx 40,000 contacts in a csv format (which i got from exporting test contacts).

In the initial csv of 40k contacts it failed due to size. So I split it down into 4 import files with 10k on each.

The imports ran ok, I got the first one imported and contacts were showing up ok, so I imported the 2nd... checked the contacts and it said No Data. But the accounts which were created with the contacts were showing... and the respective contacts were also listed.

So I cleared out the MySQL database for contacts using the SQL command (which I found on SugarWIki):

TRUNCATE `accounts`;
TRUNCATE `accounts_contacts`;
TRUNCATE `contacts`;
TRUNCATE `users_last_import`;

Then I tried again - this time I increased the memory sizes in my php5.ini to:
max_execution_time = 3000
max_input_time = 6000
memory_limit = 386M

I then split the contact csvs in two again, resulting in 8 csv import files with about 5000 contacts in each.

I then ran the first two imports, and contacts were showing up ok. Ran the third and back to showing No Data under the contacts view. (But accounts still being made, and their contacts being listed beneath).

I've checked through the data and ensured it is as clean as possible (email addresses formated ok, last names included etc). I've also opened the csv file in OpenOffice (as Excel tends to mess with the UTF-8 encoding) and ensured they were saved as UTF-8 csv files.

Can anyone shed any light on this or experience the same difficulties?

Thanks
James