Update Access database when saving Sales Order

Question

Hello, I'm a little new to Odoo and I'm working on an integration between Odoo 14 and a legacy system that uses Access 97.  Our plan is to get away from this Access system completely.
I'm trying to execute some Python code that will insert data from a Sales Order into multiple tables in the Access database.
Would I use a Server Action or Automated Action for this?  I'm having a little trouble figuring out how the Server Action works so it will run on create.
Can someone point me in the right dir

Mehjabin Farsana · Answer

Hi,
You can design the system as follows:
* run a scheduled action that runs in specific time interval
* call a function from this scheduled action, which will fetch the data from legacy system and create records in odoo
You can follow above pattern or:
* from the legacy system side
* on creation or updation of records there, you can trigger an action in odoo via xml rpc to create records in odoo
Thanks

Related Posts	Odgovori	Prikazi
(((Oficial~ C.O.P.A!@!Ecuador)))¿Cómo puedo llamar a Copa Airlines desde Ecuador? sales.order	0 dec. 25	43
Transform Quotations to sales orders or invoices in a bulk action sales.order	3 feb. 25	3462
Orden de venta borrada por error sales.order	1 dec. 24	2897
How to create a subsection in the product order line and make the main section sum the total of the subsections in Odoo? Solved sales.order	2 mar. 24	3299
Managing orders from repeat customers Solved sales.order	2 mar. 24	3822

This question has been flagged

Enjoying the discussion? Don't just read, join in!