Skip to Content
This question has been flagged
sales.order
1 Respondre
2274 Vistes
Avatar
Kent Koski

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 direction?


Avatar
Descartar
Avatar
Mehjabin Farsana
Best 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

Avatar
Descartar
Kent Koski
Autor

Thanks for responding. I actually wanted the data to flow the other way from Odoo to Access. I figured out how to install the base_automation module to create Automated Actions on create of a Sales Order. I will continue looking into that.

Related Posts Respostes Vistes Activitat
Transform Quotations to sales orders or invoices in a bulk action
sales.order
Avatar
Avatar
Avatar
3
de febr. 25
3430
Orden de venta borrada por error
sales.order
Avatar
Avatar
1
de des. 24
2880
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
Avatar
Avatar
2
de març 24
3270
Managing orders from repeat customers Solved
sales.order
Avatar
Avatar
Avatar
2
de març 24
3807
Sales order from customer order.
sales.order
Avatar
0
de set. 23
2191