I'm trying to import suppliers. Some are for foreign companies that have no state codes, which makes the import process return errors. Looking in the database, I see that field "state" in "res.partner" is nullable, so why can't I import a blank field? I have also tried replacing empty strings with "NULL" and "(null)", but neither works.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- إدارة علاقات العملاء
- e-Commerce
- المحاسبة
- المخزون
- PoS
- Project
- MRP
لقد تم الإبلاغ عن هذا السؤال
2
الردود
6174
أدوات العرض
What ended up working for me was to open the .csv file in OpenOffice, select the blank fields, and hit the "Delete" key. I then got a pop-up asking if I wanted to delete numbers, text, etc., or "Delete All". I chose "Delete All", then re-saved the file. After that, it validated and imported without problems! Hope this helps someone else when they run into the same issue.
I suspect that the fields of your initial csv file were not blank but filled with one symbol/caracter like ' which you cannot see by default.
هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!
أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!
تسجيل| المنشورات ذات الصلة | الردود | أدوات العرض | النشاط | |
|---|---|---|---|---|
|
2
مايو 25
|
1344 | ||
|
Import from Winbooks
تم الحل
|
|
4
مايو 25
|
5071 | |
|
1
أغسطس 24
|
2353 | ||
|
1
فبراير 24
|
3110 | ||
|
3
أكتوبر 23
|
11162 |
