xoe-labs / dodoo-loader Goto Github PK

Forgive the question (if github issues is not the place I understand), but I was led here from looking at the odoo_csv_import repo. This project (and odoo_csv_import) both look quite similar to something I've started working on earlier today, and I'm wondering if I even need to continue or if I can somehow be useful enough to contribute.

I'm looking at the chunking code (I'm unfamiliar with pandas) and trying to figure if the way it's done currently it would end up splitting line information across multiple files? For example, when importing via the GUI I know I need to blank certain fields otherwise odoo does not consider them to be lines. Is that also the case via the API? Or am I completely barking up the wrong tree?

Hi, me again. Sorry.

The company work for has consultancy time with Odoo. Their recommendation for imports is via the GUI. That just doesnt work for us at the moment purely because of the quantity of data I'm feeding in during a test migration.

With that explanation out of the way...

I've got about 315k partners (suppliers, customers (mostly shipping addresses), etc.). I used dodoo-loader to get a lot of this data in. Worked mostly fine.

Unfortunately since getting all this data in subsequent imports seem to fail in a way I dont fully understand.

Importing small quantities (< 5 or so records) is fine. More than that and dodoo-loader logs that its gotten IDs back, but there's nothing in the database. For example;

},{
    "batch": 104,
    "candidates": [
        "__testimport.order_879069"
    ],
    "loaded": [
        109
    ],
    "model": "sale.order",
    "state": "success",
    "x_msgs": []
},{

user@test:~$ sudo -u postgres psql redacted -c "select count(*) from sale_order"
 count 
-------
     0
(1 row)

I'm definitely looking at the right DB, I can see the postgres seq has advanced, so I'm assuming its rolled back. But I see nothing of value in the odoo-server.log at the moment I'm struggling to understand why Odoo would respond with an ID in the middle of a transaction, if it can roll it back?

I can't really use our Odoo consultancy time since dodoo-loader is an unsupported tool, and I'll be (quite reasonably) asked to load all that data in by hand to ensure it's not an import problem.. But it will literally take days.

Any suggestions before I start seriously considering doing that?