Ir al contenido
Se marcó esta pregunta
4 Respuestas
759 Vistas
Avatar
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


Avatar
Descartar
Avatar
ivan liu
Autor Mejor respuesta

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 ?

Avatar
Descartar
Avatar
Thuy Ngoc
Mejor respuesta

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

Avatar
Descartar
Avatar
Balagopal R
Mejor respuesta

Hello,

Add the Tags value like the following and try to import


https://youtu.be/X0ADWmqLdAM

Avatar
Descartar
Avatar
Rakesh Patel (patr)
Mejor respuesta

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"

Avatar
Descartar