Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
1 Vastaa
955 Näkymät
Avatar
DT

Hello, 


I am looking for a new ERP system and am evaluating Odoo in this context. Odoo has made a good impression so far, but I have now reached a point where I am stuck:

It is about (product) data import. Small test imports were satisfactory, but now I wanted to import a first larger chunk of data (about 350,000 products). The import via the GUI does not work (the import page has been showing a spinning circle for over an hour). I haven't tried splitting into "smaller" chunks yet, but from what I have read, this tip is also given to people who want to import only a few thousand products. I don't feel like creating 350 or more chunks now. Besides that, I am looking for a solution to automate the import (preferably daily). Ultimately, I want to regularly (daily) import about 700,000 products.

What are my options? Can I script the import? Are there any examples for this? In a quick search, I did find a few scripts, but they are generally more than 5 years old. Are there alternative approaches to solve my problem? Is bulk import easier / more performant in the Enterprise version?

I am currently using Odoo 17 community in an on-premise installation on a Debian 12 host.

Avatar
Hylkää
Avatar
Niyas Raphy (Walnut Software Solutions)
Paras vastaus

Hi,
Either you can split and import data into odoo using the import feature of odoo or as you mentioned you can create python  script which takes data from some db/sheet at regular interval and create data inside odoo.

From python script using the service like xmlrpc or json rpc, you can connect into odoo db and created records in it.

Sample:  Read Data From CSV File And Create Records Inside Odoo Database Using Python Scrypt



Thanks

Avatar
Hylkää