跳至内容
此问题已终结
4 回复
780 查看
形象
ivan liu

Anyone could advise how to import multiple values with commas form Excel

For example, import "Sport, Exercise" and "Fruits, Vegetables" to the "Tags" field in CRM > Customer


Tried to import as

"Sport, Excerise","Fruits,Vegetables"

 but a warning of "Sport not found was shown, the system seems split the value by comma


I have created two tags with commas in the odoo form and export

The excel is separated to two rows which cannot be import back to odoo


Any way we can escape the commas in value, thanks


形象
丢弃
形象
ivan liu
编写者 最佳答案

When one of the tags is "Sport, Exercise" that means it include comma in it, the system will split up to Sport and Exercise, but I would like to have a tag "Sport, Exercise".

I have tried semicolons but it is not working, it only accepts comma. Any way to change the delimiters ?When one of the tags is "Sport, Exercise" that means it include comma in it, the system will split up to Sport and Exercise, but I would like to have a tag "Sport, Exercise".I have tried semicolons but it is not working, it only accepts comma. Any way to change the delimiters ?

形象
丢弃
形象
Thuy Ngoc
最佳答案

Hi ivan liu,

I think this video can help you (starting at 30:00 in this video):

https://www.youtube.com/watch?v=Auaqj6WtdcM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=5

形象
丢弃
形象
Balagopal R
最佳答案

Hello,

Add the Tags value like the following and try to import


https://youtu.be/X0ADWmqLdAM

形象
丢弃
形象
Rakesh Patel (patr)
最佳答案

Use Semicolon Separator for Multiple Tags: Odoo recognizes semicolons (;) as delimiters between multiple tag values in a single cell. So, if your tag values have commas within them, try formatting them in the Excel file like this: "Sport, Exercise; Fruits, Vegetables"

形象
丢弃