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

Publicaciones relacionadas	Respuestas	Vistas
Transform Quotations to sales orders or invoices in a bulk action sales.order	3 feb 25	1601
Orden de venta borrada por error sales.order	1 dic 24	1810
How to create a subsection in the product order line and make the main section sum the total of the subsections in Odoo? Resuelto sales.order	2 mar 24	2144
Managing orders from repeat customers Resuelto sales.order	2 mar 24	2677
Sales order from customer order. sales.order	0 sept 23	1320

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!