Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Apskaita
Atsarga
PoS
Projektas
MRP

All apps

All Posts People Badges

Žymos (View all)

odoo accounting v14 pos v15

About this forum

Pagalba

Where are custom modules,views, fields, etc. located on Odoo.sh Shell?

shell odoo11 odoo.sh

3 Replies

15433 Rodiniai

Jean Donaires

Hello, I am new at Odoo, so i don't know exactly how does it work at a code level. But AFAIK everytime we create a field, view, module, etc with Odoo Studio, it generates new code on the server files right?So where is it? I have tried accesing to the server itself through Shell on Odoo.sh but I am completely lost on where are the files containing the code from the custom objects i created.

I would also like to know if it's possible to connect to the linux server through WinSCP since I think it would be easier to import, export files to the server. Does anyone know if it's possible?

Yenthe Van Ginneken (Mainframe Monkey)

Best Answer

Hi Jean,

The answer from Kevin is great but it doesn't answer everything.
Every behaviour that is done with Odoo studio (so adding fields, models, views, reports and so on) will not create physical files on the system. Those changes are all stored in the database and can only be found in the database. When you code your own modules however you will see files showing up. In Odoo.sh you can find custom modules under the folder src/user, it will contain all the code from your Github repository.

With Odoo.sh you're unable to access the database through pgadmin3 or WinSCP. The only way to connect to the database, get data or update things is by doing it through XML-RPC (see https://www.odoo.com/documentation/11.0/webservices/odoo.html ). If you want to get files into the Odoo.sh container you will need to add them to your Github repository to get them under src/user, but even then your options with those files are limited.

P.S: About the question in your answer on Kevin: the downvote/upvote function was broken for quite a while due to a bug. It has been patched on the official help forum and the official fix is on the way at https://github.com/odoo/odoo/pull/25671

Regards,
Yenthe

Kevin

Hi, odoo stores all the data in the postgresql database. The data stored in the database can be viewed with the help of an application called pgadmin3.(Don't know of using it with odoo.sh, but you could take a backup of your database and run on a local server).

In the case of fields created with odoo studio it is stored in a table called ir_model_fields. You can get to know where the data is stored by going to the app drawer and clicking the studio app, and then exporting all your studio customizations. You can search the xml files to see where exactly and in what name the field gets stored in the database.

Upvote if useful.

Jean Donaires

Autorius

Thanks! I did find you answer helpful. It didn't answer all my question regarding this specific topic, but i appreciate you giving me an start. I'll explain a little bit about my 1 day research on this comment.

1)I cannot upvote, I don't know why. Everytime i press upvote or downvote on this forum nothing happens.

2)I am currently doing an Odoo community installation on my local PC so i can have a better understanding on how does Odoo manage custom fields,models,etc.

3)I've seen people using WinSCP to connect to their Odoo DB on YT videos. Although in order to do that I need to know which port I will connect to. Since i created an instance on Odoo.sh I don't know which port should i point to, so connection with WinSCP to Odoo.sh is still unknown to me.

If you have any information regarding this topic, please comment. Thanks.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registracija

Related Posts	Replies	Rodiniai
Restart webshell in Odoo.sh shell odoo.sh	0 spal. 22	5079
odoo.sh: 'NameError: name 'active_id' is not defined' from multiple places odoo11 odoo.sh	2 vas. 22	9188
push changes made to already existing modules (such as survey) from staging to production. Solved shell odoo.sh GitHub	1 rugs. 21	4279
Odoo11 Deprecation warning after installing module (Odoo.sh) warning iso odoo11 odoo.sh	0 geg. 20	6758
Am I allowed to create/edit/delete directories/files on Odoo.sh (Odoo11)? permissions errors odoo11 odoo.sh	0 rugp. 18	4899

This question has been flagged

Enjoying the discussion? Don't just read, join in!