Newbie with import troubles! Help!

[LloydCase]

I am a newbie with SugarCRM and trying my first import of contacts... a csv file I generated from Excel
It has 11 fiields per row and 159 rows. I have checked it for framing and I think it is ok... I have tried to import the csv file with comma separators, with tab separators, and even did the double quote(") thing too.... I keep getting an error message....

Fatal error: Call to a member function read() on a non-object in /home/altadena/public_html/sugar/modules/Import/ImportCacheFiles.php on line 114

Not sure what it means. I used the file manager to look at in with an editor and it looks like the line wants to check for .csv extensions during the cleaning of a cache. I do not know what that means to my import.

I can not get import to work.... can some one smart help me get an understanding of what is happening and what I ought to do to fix it??

Lloyd

[clint]

My guess is that the file isn't actually uploading properly.

Do you have the file permissions set properly on your server so that your web server can write to the cache directory in your Sugar installation?

A way to check this is to see if you can upload an attachment to a Note record.

[Tugui]

I tried to load 100 files and could only do 90. I saved the 10 left over and tried again.
I got the same error :

String too long to fit in the field LBL_BUISNESS_NAME (buisness_name_c)

The field is text and I dont understand why. All the other 90 got done. I also took out any , or any . from the csv fields but still it does not load them

Success:
0 Records created successfully
10 Records skipped due to error
Download List of Errors
Download records that could not be imported.

What else should I try?

Thanx guys

[sugarcane]

Hello Tugui,

check the records that did not import. How many characters are there in the import document for the buisness_name_c field that you are trying to import? What is the max size specified for your custom field buisness_name_c? It looks like the message is telling you that the field length maximum for the buisness_name_c is not long enough to contain the entire contents of this field on the import document for the records that failed. So instead of importing them cut off, it generating an error.

[LloydCase]

My guess is that the file isn't actually uploading properly.

Do you have the file permissions set properly on your server so that your web server can write to the cache directory in your Sugar installation?

A way to check this is to see if you can upload an attachment to a Note record.

Clint, I deeply appreciate hearing from you. I tried the upload of an attachment to a Note and it worked fine. I guess that means the permissions for the contact uploads go in the same directory and should work too?? I can check permission settings but this looks like we did that. Ugh... what is happening here?

Maybe I should tell you I also seem to fail on loading a company logo.... it shows a little cycling progress symbol and the thermometer at the bottom progresses rapidly but then nothing happens... what is going on?

[SergeiLo]

Hi Lloyd,

Try to use Apatar Data Integration ETL tool. Apatar is open source product and free to download and use. You will simply drag and drop a connectors for MS Excel and SugarCRM. Map required fields and run the transformation. All your records will be imported into SugarCRM. (Ex.: MS Excel --> Transform --> SugarCRM)

More info at our websites.

Regards,
Sergei

[hubcrm]

I'd only use Apatar this way if you're talking direct to the DB using it. I wouldn't bother trying a data migration through the SOAP API it'll bomb out at about 1000 records or less. The Sugar API that is and that's common, Salesforce limits to about 200 records. You go through web services when you want to enforce application logic on data. Outside that on data migration it's faster hitting the database,

Hope that helps..........