Not all contacts from CSV get imported to Sugar

[david00]

Hi,

I resolved my previous problem with contacts importing: http://www.sugarcrm.com/forums/showthread.php?t=47317

I've now got to the point where Sugar shows me errors with invalid data in my CSV, and allows me to fix it. For instance, some of the rows in my CSV had invalid email addresses. Having fixed all of those rows, though, Sugar still only imports 292 of my 810 records. It seems like everything's fine, no errors - it's like it doesn't know those extra rows exist.

Can anyone help? The log file shows nothing.

Thanks,
David

[david00]

Solved - despite there not being an error message the import was choking.
Once I removed the row after the last one imported, the import proceeded.

[susiewilliams]

Thanks for the follow up. I've found that some piece of weird data in the CSV file tends to cause problems with the import process. Sometimes just opening up the file in Excel and selecting "Save as CSV" again strips out the bad characters.