Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

File for import with commas in names [Odoo 17]

import CSV Odoo17

1 Odpowiedz

2070 Widoki

Vasilis Zartilas

I'm trying to add some values to Odoo 17 (specifically countries).

Some names have commas in them. What structure should I follow for a CSV file?

For example, "Bonaire, Sint Eustatius and Saba" is a country/region, and the comma is part of the name. So, for Odoo to understand it correctly, it must be entered together.

What should be the Formatting (Encoding, Separator, Text Delimiter) and structure in the CSV file so that Odoo can distinguish that it is a single name?

countries.csv

1.Name,Countries
2.World,"Algeria,Antigua and Barbuda,Bahamas,"Bonaire, Sint Eustatius and Saba""
3.Europe,"Austria,Belgium,Bulgaria,Croatia"

Thank you in advance for your answers.

Mishri

Hi Vasilis Zartilas,

You can use following format:

"id","name","code"

1,"Bonaire, Sint Eustatius and Saba","BQ"
2,"Saint Kitts and Nevis","KN"
3,"United States","US"

Thank you

Vasilis Zartilas

Autor

Hi Mishri,

Maybe it's my mistake, but in the CSV file above, the numbers in front symbolize the lines in the file and not the ID.

The "Name" field is the category of countries, where countries are divided into European and non-European. The "Countries" field contains the names of the countries, so your example does not help me.

Thank you, however, for your response.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
CSV import line error Enterprise 16 Rozwiązane import invoice.line CSV	2 mar 23	3039
Issue with import and comma in Excel File (odoo 19) import	0 wrz 25	234
Displaying Many2one field on mobile devices identical to desktop view in Odoo 17 Odoo17	1 lip 25	1660
Importacion de Atributos y Valores import	2 maj 25	2341
Import from Winbooks Rozwiązane import	4 maj 25	6915

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!