Problem With CSV Imports

[jlamb]

Hello,

I am trying to import a large number of accounts (approx 7500) into Sugar 5.1 CE. I broke the accounts up into smaller files with 500 accounts each in them. When I select one of these csv files for import and assign all the fields, the import screen appears ('import started at ...') and then hangs.

I have enabled debug logging in the sugarlog file, and the problem appears to be with the sql queries. Although the first two rows are parsed into the field mapping screen (step 3) of the import fine, the sql queries set a blank value for the accounts_cstm and a null value for the accounts table for the first account id (should be a 36 digit hex uuid (including dashes ie 1152a5e7-089c-451f-af60-08b0d6eabd6a) from Microsoft CRM). This results in a fatal log event that the account id can't be null.

Any ideas as to why the uuid isn't working properly? Any suggestions? Help please!

[knicola]

Same problem here....

[tbladecki]

I can assist you both with the import, please PM. Importing 7500 or 75K accounts is all the same but the file must be right to do it. I have imported more them 100K records successfully and converted 3 ACT databases. I don't use the built in import feature as i have found it to not be robust enoght to import all the data that is required

[cstewart57]

I just finished importing 6600+ accounts into version 5.2.0a and although it started off pretty rough, I finally got the hang of it. The two things that I found to be the biggest problems were, A) making sure that I had the correct field delimiter and text qualifier combinations. The second issue is that I would try an import and accept it, then delete the Accounts through Sugar, but, Sugar didn't really delete the records from mySQL. So after each import attempt I went through and cleaned up all the files using myPHPAdmin.

Don't know if this will help your situation. I hope so.