Hello,
I am in the process of familiarizing myself with the development of modules on Odoo 14, for the moment I only handle the local database. So I would like to know how I could link or call an external or local database (whether on Postgresql or Mysql) to my module?
My goal is to retrieve the list of customers for example and put a selection field that retrieves its values from this base.
I found the External Database Sources module, but it is compatible that on Odoo 8/7, by installing it on the 14 I get a python error "argument of type 'bool' is not iterable" when I test the connection with any other base.
If you have any ideas or suggestions do not hesitate
I thank you in advance.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
11666
Weergaven
Using XML-RPC you can connect external Odoo server or using psycopg you can connect the external postgresql database.
You can also use mysql connector to connect mysql database using python.
Try anyone of these and let us know at which point you are stuck.
I tried to connect with odoo postgres database in server using python in local computer, i just could not establish connections, it throws an error , upon contacting hosting provider they say odoo has restricted their database for public access .
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden
Thanks Sudhir Arya