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

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

File for import with commas in names [Odoo 17]

import CSV Odoo17

1 الرد

2068 أدوات العرض

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

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!