Skip to Content
This question has been flagged
odoo10.0
2 Replies
11024 Views
Avatar
Vicky

I have a CSV with some data related to products and a Custom Module. How can I make my custom module to store the data into the product table (database) when the module gets installed. 

Assume that the CSV (with product data) is also included in module. If some fields from CSV are not present in the product table, it should get created automatically in the table.

Can someone please help me to understand how the CSV reading data works and how can I achieve this?




Avatar
Discard
Avatar
Ray Carnes
Best Answer

Take a look at the l10n_uk module.  This module imports a CSV file to populate UK Counties.

https://github.com/odoo/odoo/tree/10.0/addons/l10n_uk


You can see in the __manifest__ file of the module the direction to import the file:

'data': [ 
   'data/res.country.state.csv',
],

Also at https://github.com/odoo/odoo/blob/10.0/addons/l10n_uk/__manifest__.py#L26


The CSV file looks like this:

"id","country_id:id","code","name"

"state_uk_1","base.uk","A1","Aberdeenshire"

"state_uk_2","base.uk","A5","Angus"

"state_uk_3","base.uk","A7","Argyll"

"state_uk_4","base.uk","A9","Avon"

"state_uk_5","base.uk","B1","Ayrshire"

"state_uk_6","base.uk","B3","Banffshire"

"state_uk_7","base.uk","B5","Bedfordshire"

"state_uk_8","base.uk","B7","Berkshire"

"state_uk_9","base.uk","B9","Berwickshire"

"state_uk_10","base.uk","C1","Buckinghamshire"

"state_uk_11","base.uk","C3","Caithness"

Also at https://github.com/odoo/odoo/blob/10.0/addons/l10n_uk/data/res.country.state.csv


Which imports these records into Odoo:



Also, see:

https://www.odoo.com/documentation/10.0/reference/data.html#csv-data-files


Avatar
Discard
Avatar
Vicky
Author Best Answer

Hi Ray,

Thanks for your kind help. This worked for me well. I just exported the csv of my custom model. Then I put that csv in module with some other data, specified the location in __manifest__.file. Finally installed the module on a new database and all worked fine.

Avatar
Discard
Related Posts Replies Views Activity
count number of records based on condition Solved
odoo10.0
Avatar
Avatar
1
Nov 24
18020
How to install odoo 10 in ubuntu 20.04? Solved
odoo10.0
Avatar
Avatar
1
Sep 23
1203
Question about action_confirm
odoo10.0
Avatar
Avatar
Avatar
3
May 23
4092
How to see the and activate the developer mode in odoo version 10 Solved
odoo10.0
Avatar
Avatar
Avatar
Avatar
Avatar
7
Apr 23
47093
Barcode scanner from mobile Solved
odoo10.0
Avatar
Avatar
1
Dec 22
6435