Skip to Content
This question has been flagged
sales.order
1 Reply
2285 Views
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
Discard
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
Discard
Kent Koski
Author

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 Replies Views Activity
(((Oficial~ C.O.P.A!@!Ecuador)))¿Cómo puedo llamar a Copa Airlines desde Ecuador?
sales.order
Avatar
0
Dec 25
43
Transform Quotations to sales orders or invoices in a bulk action
sales.order
Avatar
Avatar
Avatar
3
Feb 25
3446
Orden de venta borrada por error
sales.order
Avatar
Avatar
1
Dec 24
2888
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
Mar 24
3283
Managing orders from repeat customers Solved
sales.order
Avatar
Avatar
Avatar
2
Mar 24
3816