Setup¶

In this chapter, you will learn:

• To set up your local development environment.

• The outline of the Odoo database structure.

• To export and import an Odoo database in your local environment.

• To have an Odoo instance up and running.

Install¶

There are multiple ways to install Odoo, depending on the intended use case. This documentation assumes you use the source install (running Odoo from the source code), which is best suited for Odoo designers and developers.

Databases¶

Structure¶

Every Odoo application works similarly; they are built with the same logic. A model contains fields and relational fields that link to other models. Each model has views representing all its fields, with backend and frontend views.

Models¶

The basis of Odoo is models. Models use fields to record the data. Records are stored in a database: they are therefore linked to a model. In Odoo, you can find the different models in the backend by enabling the developer mode and then going to Settings ‣ Technical ‣ Database Structure: Models.

Fields¶

In a model, we will centralize fields (field names we need to target in our code).

Classic fields¶

• Date

• Char

• Selection

• …

Relational fields¶

Relational fields call a field from another model. They allow you to link models together and make them interact easily. In other words, when you use a relational field, you link a record with another one (located on another model), enabling you to retrieve the content of the fields located on this linked record.

• Many2one fields are filled in by choosing one record from a list of records on another model (from many records, you select one). For example, the customer field on a quotation makes you choose one customer from a list of several customers on the contact model.

• One2many fields are reverse searches of existing many2one relations. For example, you could list on a contact all their existing quotations (from one record, you display many).

• Many2many fields are filled in by choosing one or several records from a list of records on another model. For example, you can put several tags on one product, and several products can use the same tags (from many records, you can select many).

Views¶

Views define how records should be displayed to end-users. They are specified in XML, meaning they can be edited independently from the models they represent. They are flexible and allow deep customization of the screens they control.

Backend vs. Frontend¶

• Backend views: Kanban, List, Form, etc.

• Frontend view: QWeb

Static vs. Dynamic¶

• Static pages have stable content, such as the homepage. You can define their URL and set some properties like published, indexed, etc.

• Dynamic pages are dynamically generated, such as the product page. Their URL is dynamic and is accessible to all by default (this can be changed by configuring access rights).

Standard vs. Inherited¶

• Standard views are base views implemented by Odoo. They are directly derived from their model. You should never change them as they allow updating an Odoo database without overwriting a client’s modifications.

• Inherited views are duplicated views. Modifications always take place in an inherited view. If there is a duplicate view, there will be two views with the same name in the database, but the duplicated view will not have an ID like for standard view.

Import an existing database¶

Dump¶

Odoo SaaS¶

Go to <database_url>/saas_worker/dump.

Odoo.sh¶

1. Connect to Odoo.sh.

2. Select the branch you want to back up.

3. Choose the BACKUPS tab.

4. Click the Create Backup button.

5. When the process is over, a notification appears. Open it and click the Go to Backup button.

6. Click the Download icon. Select Testing under Purpose and With filestore under Filestore.

   

7. You will receive a notification when the dump is ready to be downloaded. Open it and click on Download to get your dump.

   

Move filestore¶

Copy all the folders included in the filestore folder and paste them to the following location on your computer:

• macOS: /Users/<User>/Library/Application Support/Odoo/filestore/<database_name>

• Linux: /home/<User>/.local/share/Odoo/filestore/<database_name>

Database setup¶

Create an empty database.

createdb <database_name>

Import the SQL file in the database that you just created.

psql <database_name> < dump.sql

Reset the admin user password.

psql \c
<database_name>
update res_users set login='admin', password='admin' where id=2;

Getting started¶

Running Odoo¶

Once all dependencies are set up, Odoo can be launched by running odoo-bin, the command-line interface of the server. It is located at the root of the Odoo Community directory.

• Running Odoo

• Docker

To configure the server, you can specify command-line arguments or a configuration file. The first method is presented below.

The CLI offers several functionalities related to Odoo. You can use it to run the server, scaffold an Odoo theme, populate a database, or count the number of lines of code.

Shell script¶

A typical way to run the server would be to add all command line arguments to a .sh script.

./odoo-bin --addons-path=../enterprise,addons --db-filter=<database> -d <database> --without-demo=all -i website --dev=xml

Sign in¶

After the server has started (the INFO log odoo.modules.loading: Modules loaded. is printed), open http://localhost:8069 in your web browser and log in with the base administrator account.

Type admin for the email and admin for the password.

Developer mode¶

The developer mode, also known as debug mode, is useful for development as it gives access to additional tools. In the next chapters, it is assumed that you have enabled the developer mode.