Create records using CSV file

Question

When creating records using a CSV file, is it necessary to have the columns for all the fields in the model used?
If the fields not placed in the CSV are not required, will odoo place them as null?

Ray Carnes (ray) · Answer

You don't need all columns.
Columns not provided will result in either a NULL value or a DEFAULT value, depending on the field.
Create a record via the UI and supply the same fields manually to see which other ones get filled in to know exactly.
See also  https://www.odoo.com/documentation/14.0/applications/general/export_import_data.html#import-data-into-odoo [1]

[1] https://www.odoo.com/documentation/14.0/applications/general/export_import_data.html#import-data-into-odoo

Josep Anton Belchi Riera · Answer

You don't have to include all the fields, only those
that are relevant to you and the "required" ones.
You can see which fields are required by looking at the menu option (in debug mode) "Settings/Technical/Models".
The fields without assigned values will be set to "null" or to the default value, if any.

İlgili Gönderiler	Cevaplar	Görünümler
Odoo14 alternative for Automated Translations through Gengo API module v14	1 Tem 25	2185
Update Initial Stock of Product using XMLRPC API [Odoo14] Çözüldü v14	2 Tem 25	7688
"AttributeError: 'NoneType' object has no attribute 'CompileError'" configuring document Layout - Odoo 14 v14	2 Tem 25	4107
In user settings access group check box changed to list view how can i change back it to checkbox v14	2 Tem 25	3850
Odoo Power Bi Connector v14	2 Haz 25	2461

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!