topic Re: Data integration for Odoo in Talend Studio

Data integration for Odoo

Anonymous — Sat, 16 Nov 2024 06:14:11 GMT

Hi everyone, i'm facing a problem while transefering data from a backup file (postgresql) to odoo server database. in fact after installing and configuring eveything on ubuntu 16.04 (talend v7, odoo v10), when i run a job for transfering a data for one table (backup DB) to another (odoo), job is built and having all rows in green light but when refreshing odoo nothing is being transferred. could anyone help or have a small idea about what i'm facing.

Re: Data integration for Odoo

vapukov — Wed, 27 Mar 2019 22:15:14 GMT

hi,

it not possible to answer without seen any portion of your job

just as common similar-looking error- do you check auto-commit in connection properties? if not do you make manual commit at the end?

regards

Re: Data integration for Odoo

Anonymous — Thu, 28 Mar 2019 09:37:49 GMT

hi, this is what i have when i'm mirating res_partner . everything is mapped and nothing is uploaded to odoo DB, i still don't know what is the problem

exe.PNG

Re: Data integration for Odoo

vapukov — Thu, 28 Mar 2019 11:09:42 GMT

you have error - null value in column

it means - all your transactions rejected

even if error in single row, default batch size for insert - 10000 (you have 847), all 10000 rollbacks with any single error

all as it must be

Re: Data integration for Odoo

Anonymous — Thu, 28 Mar 2019 11:13:06 GMT

that's where i exactly didn't know what to do or what is the problem and the solution for it!

Re: Data integration for Odoo

vapukov — Thu, 28 Mar 2019 11:21:05 GMT

all easy

you have a null value (in source table) in the column - invoice_warn

so you can:

check column invoice_warn allow null in output schema (tMap and output component) + same column allow nulls in database
OR replace null for empty string in tMap -

row1.invoice_warn==null?"":row1.invoice_warn

Re: Data integration for Odoo

Anonymous — Thu, 28 Mar 2019 12:27:33 GMT

well, the problem is that i don't have a column named "invoice_warn", and that's what drives me crazy

Re: Data integration for Odoo

vapukov — Thu, 28 Mar 2019 12:30:07 GMT

first of all - this is not seen from your pictures 🙂

but even if you have not it in a Talend - you could have it in PostgresSQL

check structure in the database (by database tools), check triggers if any presented

Re: Data integration for Odoo

Anonymous — Thu, 28 Mar 2019 12:34:53 GMT

i'm using pgadmin III, currently i deleted evry single FK with 0 trigger

Re: Data integration for Odoo

vapukov — Thu, 28 Mar 2019 12:40:22 GMT

did you see any columns in your picture? 🙂

I can see constraints, I can see Indexes

BUT, I can not see - not you tDBOutput schema (standard and advanced tabs) neither table names and columns in PGAdmin

also, we are both can see - a red error which returned by postgreSQL (it is not a Talend error), so ... just need to find source

UPD/ADD

https://www.odoo.com/forum/help-1/question/odoo-server-error-validation-error-object-with-reference-invoice-warn-invoice-warn-135649

so this column in ODOO presented

Re: Data integration for Odoo

Anonymous — Thu, 28 Mar 2019 12:58:58 GMT

okay sir, thank you for taking so much of your time

Re: Data integration for Odoo

vapukov — Thu, 28 Mar 2019 13:38:29 GMT

Welcome! 🙂

hope you will find it - I have not this system, so can not help there