Skip to Content
Menu
This question has been flagged
3 Replies
2730 Views

By default imports are case-sensitive, i.e. if the country "Italy" is wrote "ITALY" or "italy" when importing a contact the import fails beacuse the country is not found.

Is there a setting to make the import case-insensitive ?

Avatar
Discard

Hi Alessandro Fiorino,

Did you found any solution to this issue?

Author
No :( I used the excel function Proper to convert the strings to "First letter uppercase"

Il giorno gio 7 mag 2020 alle ore 11:55 Gokulakrishnan Murugesan <gokulakannanaj@gmail.com> ha scritto:

Hi Alessandro Fiorino,

Did you found any solution to this issue?

Sent by Odoo S.A. using Odoo.

Best Answer

No, this is logically not possible as long as you do not use the External ID instead of the field content of the field to be imported. For referential integrity, it is absolutely necessary to exactly match the field content of a referential field when not referencing it by its External ID, otherwise a new referential record will be created and you will end up having different "Italian" countries for all cases and typos.


Avatar
Discard
Related Posts Replies Views Activity
1
Aug 24
350
3
Aug 24
1811
1
Feb 24
1118
3
Oct 23
9059
3
Oct 23
1233