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

Powiązane posty	Odpowiedzi	Widoki
Transform Quotations to sales orders or invoices in a bulk action sales.order	3 lut 25	1594
Orden de venta borrada por error sales.order	1 gru 24	1806
How to create a subsection in the product order line and make the main section sum the total of the subsections in Odoo? Rozwiązane sales.order	2 mar 24	2140
Managing orders from repeat customers Rozwiązane sales.order	2 mar 24	2674
Sales order from customer order. sales.order	0 wrz 23	1318

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!