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
- Buchhaltung
- Lager
- PoS
- Projekte
- MRP
Diese Frage wurde gekennzeichnet
1
Antworten
11647
Ansichten
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 .
Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
Registrieren
Thanks Sudhir Arya