Error importing Leads

[evdm]

I am trying to import a file with lead details into Sugar (Community Edition Version 5.1.0a (Build 4837))

This file contains salutation fields which exactly seem yo match those in my drop-down box "Dhr." Which is Dutch for Mr. and a default value if I use the Dutch language option at login.

My import fails with this message for each record:

Value not in dropDown list. Allowed values are: ,Dhr.,Mevr.,Dr.,Prof.,MSc,BSc,LLB,LLM,BBA,MBA,Mrs. ,"LBL_SALUTATION (salutation)",Dhr.,1

Which seems strange, for if I understand well, it says "Dhr." is an allowed value,

Any suggestions what happens here are most appreciated!

Erik

My system is hosted and I do not know server, php and MySQL details. Might be able to collect that if required

[ptemplin7]

Check the import file and make sure about the ' or ". Are there any?
Double check the case is it Dhr or dhr. ALSO, chekc your dropdown and make sure that the displayed value is the same as the DB (internal) value. I forget exactly which Sugar tries to match up to, but my first guess is it is trying to match and the values are not identical. Also check that there are no spaces floating around too.

Let everyone know if these check out because those may be one of those international issues. That the team will need to sort out.

Hope this helps,
Paris

[evdm]

Thanks a lot for your swift response!

I think that I have exausted my options in checking for spaces, "" and '' mismatches. They do not seem to be there.
That leads me to believe that it might be your suggestion:

chekc your dropdown and make sure that the displayed value is the same as the DB (internal) value

However, I do not know how to check the DB (internal) value. Is there any way to query that from the application without diect access to the databse?

Thanks again!

Erik

[evdm]

I have played a bit more with this and found the following:

If I export som records, I see that the salutation which shows 'Dhr.' is exported as 'Mr.'.
I replaced all entries in my import file accordingly (changing 'Dhr.' to 'Mr.'. Now my import worked fine and the resulting records nicely show 'Dhr.' gain.
Now I know this it is usable, but the logic behind it fails me. Might this be a bug in the Internationalisation?

Anyway, hopes this helps.

Erik

[ptemplin7]

Yep, that's the import issue.

In the future you can see using your myphpadmin to look at the actual mysql tables. Also, you can use the dropdown editor as the admin and check the salutation dropdown. It will show both values.

My other suspicion is that this might be an english to Dutch translation issue. I have seen some other issues with inports that are not in English.

Good lukc, glad you found a work around,
Paris

[Tugui]

Hi,
I tried importing 100 leads as CSV. Initially none were getting through. After I checked the (") drop down 90 have been done rejecting 10. I then saved the 10 and tried again. This is what I get.


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

As errors it says:String too long to fit in the field LBL_BUISNESS_NAME (buisness_name_c)

I don't understand why. I tried erasing all the , or . from all of these records but still doesn't import them in Leads. Can anybody help?

[ptemplin7]

A couple of things.

In the future do not hijack another's thread like this. You are better off starting your own. You will be more likely to get help.

Look at the error. It's obvious what the problem is. You data is too long for the field. Either shorten the field length of the data to the correct length or change in the studio the allowed length of the field.

Have fun. Did you even try to look up in mysql site what the error was!

Thanks Paris