Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
odoo10.0
2 Odpovědi
11919 Zobrazení
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
Zrušit
Avatar
Ray Carnes
Nejlepší odpověď

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
Zrušit
Avatar
Vicky
Autor Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
count number of records based on condition Vyřešeno
odoo10.0
Avatar
Avatar
1
lis 24
20312
How to install odoo 10 in ubuntu 20.04? Vyřešeno
odoo10.0
Avatar
Avatar
1
zář 23
3119
Question about action_confirm
odoo10.0
Avatar
Avatar
Avatar
3
kvě 23
5691
How to see the and activate the developer mode in odoo version 10 Vyřešeno
odoo10.0
Avatar
Avatar
Avatar
Avatar
Avatar
7
dub 23
49082
Barcode scanner from mobile Vyřešeno
odoo10.0
Avatar
Avatar
1
pro 22
7917