Skip to Content
Menu
This question has been flagged
3 Replies
11834 Views

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?

Avatar
Discard
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

Avatar
Discard
Best Answer

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.

Avatar
Discard
Author

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.

Related Posts Replies Views Activity
0
Oct 22
2783
2
Feb 22
7176
1
Sep 21
2483
0
May 20
4709
0
Aug 18
2978