Data integration for Odoo

[Anonymous]

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.

[vapukov]

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

[Anonymous]

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

[vapukov]

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

[Anonymous]

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

[vapukov]

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

[Anonymous]

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

[vapukov]

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

[Anonymous]

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

[vapukov]

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-...

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

so this column in ODOO presented