跳至內容
選單
此問題已被標幟
1 回覆
4262 瀏覽次數

Hello everybody, I have a problem, I need get data from a external table of a external database for use this data in a many2one field, my problem is that the external table is getting new records and I must refresh that table in Odoo, but I don't if this is possible, anyone could help me? Thanks!!!

頭像
捨棄
最佳答案

you can always make a connection to that other database and refresh the table in odoo from that table there. It would be just setting up a cron which will run every 1 hour lets say, and if the cron finds new records that do not exists in the odoo table, create them. It would be as easy as that. Cheers

頭像
捨棄
作者

I finally found a solution with the dblink extension of Postgres that allows connect two different databases in the same query :)

相關帖文 回覆 瀏覽次數 活動
1
4月 18
2900
5
6月 21
23839
1
4月 20
12905
1
1月 19
3443
5
4月 23
16437