Contact Import stops/hangs in SugarCE 5

[mbaucsoft]

I couldn't find anything by searching that seems to address this.

I'm using Sugar CE 5 on Ubuntu. I added some custom fields to Account and Contact and edited the layouts to show them.

Importing Accounts from a CSV file worked (once I removed single quotes in the account name). Importing Contacts displays a message that the import was started, imports a few records then just stops. I set the debug level to debug and didn't see anything interesting in the log file.

For grins, I downloaded and installed v4.5.1 and tried the same CSV files. It successfully imported Account and Contact.

Any ideas?

[mbert9]

I encountered the same problem after appying the 5.0.0b patch on SugarCE on Ubuntu.

Works fine on 5.0.0a.

[kbrill]

Find out which line is the last to be imported, then look at the next line in the CSV for differences that might break it.

[panthia]

I am having the same issue. I tried a fresh install of 5.0b but it was stoping at about 100 records. I looked at the data that is being imported and I don't see anything that I can tell would be causing any trouble. I tried again and it failed at 31 records so I sorted by a different field and tried again and it failed again at 31 records but of course the import was of totally different names due to the different sort. It does not seem to be an issue of bad data.

Additionally the data I am using was from an export on a SugarCRM 4.51 installation so it should be correct. The added frustration is that there are not predefined fields for importing data from other Sugar installations and when it fails to complete the mapping is not saved. It would be nice if the mapping was saved first then I would not have to remap every time I try something different.

[JVWay]

I had a problem with Contacts and it turned out to be apostrophe's in the account name. I imagine apostrophes anywhere would cause a problem but you won't find them most places.

Got rid of the apostrophes or used the account ID to make the join and it worked fine.

Order of sorting made no difference for me either. I think Sugar must sort before it imports.

JW

[panthia]

That worked. Thanks.

[midimarcus]

[...]
Got rid of the apostrophes or used the account ID to make the join and it worked fine.
[...]
JW

I had the same problem importing contacts with apostrophes in many different fields.
I solved the problem by escaping apostrophes with a backslash:
\' instead of '
This, unluckily, creates records with the backslah as part of the value. Note that to search a field with a "like" query for \ you have to escape the character and searching for %\\%.
Especially in surnames it is very annoying but in my case contacts are quite a few to be edited by hand.

[salehgaliwala]

Guys check the data in the map field of excel sheet.The datatypes in Sugar has limitaion .For eg postal code field can accept only upto 10 characters not more than that.If you try uploading the excel sheet withpostal code field with more than 10 character Sugar will hang and it will only import records upto that record having postal code field with more than 10 chars.

Regds
Saleh

[cbierwerth]

This is very basic functionality that has been overlooked, along with some other DUH stuff that I have run across. CRM is supposed to make things easier and automate the processes, not make the user/admin engage in after the fact editing that comes from a bad import design. How hard it is to fix this stuff???????

Sugar, start paying attention! It is the accumulation of neglecting the little details that are STANDARD on any other CRM program on the planet, that add up to a very poor customer experience. I would never recommend this product to any other sales person - ever. For Sales, it is incredibly inefficient, incomplete and does not add to the bottom line. In fact, I make the sales process more costly due to all the bugs, bad design, having to edit records that are not imported like they should, extra keystrokes to complete a task................I could go on and on......

[bwyman]

What I did to solve this problem was to replace some code in modules/Import/ImportStep4.php

The line that is:
$query = "SELECT id FROM {$definition['table']} WHERE { $definition['rname']} = '{$focus->$field}'";

I replaced the single quotes around $focus->$field with double quotes:

$query = "SELECT id FROM {$definition['table']} WHERE { $definition['rname']} = \"{$focus->$field}\"";


And it works better now (as far as the single quotes are concerned).