Skip to Content
Menu
This question has been flagged
2 Replies
2188 Zobrazenia

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?

Avatar
Zrušiť
Best 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

Avatar
Zrušiť
Best 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.

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
2
júl 25
3306
2
júl 25
3021
2
jún 25
1811
0
máj 25
14
2
jan 25
3372