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

CRM
e-Commerce
Бухгалтерия
Склад
PoS
Проекты
MRP

All apps

Все посты Люди Значки

Теги (Смотреть все)

odoo accounting v14 pos v15

Об этом форуме

Помощь

File for import with commas in names [Odoo 17]

import CSV Odoo17

1 Ответить

2065 Представления

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

Автор

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.

Не оставайтесь в стороне – присоединяйтесь к обсуждению!

Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!

Регистрация

Похожие посты	Ответы	Просмотры
CSV import line error Enterprise 16 Решено import invoice.line CSV	2 мар. 23	3039
Issue with import and comma in Excel File (odoo 19) import	0 сент. 25	234
Displaying Many2one field on mobile devices identical to desktop view in Odoo 17 Odoo17	1 июл. 25	1660
Importacion de Atributos y Valores import	2 мая 25	2341
Import from Winbooks Решено import	4 мая 25	6910

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!