CODEWITHSUNDEEP
databasepostgresqlodooerp
Fabio
Fabio

Reputation: 1332

Is possible to connect the company DB to Odoo 9 (OpenERP)?

I am creating a business app to manage the inventory of a mid-sized shoe company. I already have a database created with PostgreSQL. I would now be able to connect it to Odoo 9 to develop applications.

How can I do that?

Upvotes: 0

Views: 1381

Answers (1)

danidee
danidee

Reputation: 9624

You can't just use your existing data directly with odoo

But Odoo makes it easy to use existing data from existing applications and databases with it's flexible import system. in which data is imported to it via csv files, you can import any data you can possibly think of, you just have to know the right format of data that odoo is expecting and the required fields you have to provide

Every model in Odoo even custom built modules can have data imported into them

If you want to import data just click on the listview of any model and you should see an import link beside the create button, from there you can carry on, there's even a FAQ there which you can read if you need to find out more about the import system.

As for knowing the required columns that have to be present when you're importing, Just create sample data and save it, Then

  • Go to the listview
  • Tick the check-box beside the record name to select it
  • Now click on the more button you should see an export option
  • From there you can pick the fields you want to export, the required fields will highlighted in blue

There are other ways of re-using existing data with odoo (You can write to the database directly...but this is not recommended as several constraints would not be checked and you can end up messing the database up) or you can use xmlrpc or jsonrpc which is going to be time consuming

Using the import functionality is the best and the easiest way.

Upvotes: 3

Related Questions