contacts import stops at 384

[tresero]

I am using community edition, 5.0. I am new to Sugar, but not programming.

I have a csv file with 1400 existing contacts. I do import, and it stops at 384. Any ideas?

Thanks

[Angel]

This is usually the result of a problem with the source data.

For example, a comma within the value portion of a column to be import, as it would throw off the number of columns from one record to the next. Another possibility is extraneous carriage returns. The latter is a common problem if you have a free text field that you are importing.

Inspect your source data around records 384, 385 and see if you notice anything unusual or along the lines of what I described above.

[Aisha16]

I have exported a file of contacts from sugar, cleared out all my contact and now try to import it back in again.

It will only import 79 contact and then it stops.

How can there be errors with my data if it is a file exported from sugar and i have not made any changes to it.

Please hlep

I really need to import my contact back in again

[Angel]

There could be errors because while you may have used Sugar to perform the export, Sugar doesn't control what you typed into all the fields for those records, which is where these types of problems usually come from.

See my previous reply for some potential reasons for your problem.

[satyaprasadtammana]

Hi,

IF your data in CSV is in the correct format with the filed types in DATABASE and all the formats are GOOD. Then It should work.

Please check your data once and try again.

Regards,
Satya.

[tresero]

Just to finish this thread. The real problem was not having enough memory set for php.

I set memory_limit to 500M and it worked fine. I know this is not ideal, but it did fix the problem.

[Angel]

Good catch. That can definitely affect it. Same is true for the max execution time setting.