Skip to Content
This question has been flagged
shellodoo11odoo.sh
3 Replies
15776 Views
Avatar
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?

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

Avatar
Discard
Avatar
Kevin
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
Jean Donaires
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
Restart webshell in Odoo.sh
shell odoo.sh
Avatar
0
Oct 22
5210
odoo.sh: 'NameError: name 'active_id' is not defined' from multiple places
odoo11 odoo.sh
Avatar
Avatar
Avatar
2
Feb 22
9378
push changes made to already existing modules (such as survey) from staging to production. Solved
shell odoo.sh GitHub
Avatar
Avatar
1
Sep 21
4379
Odoo11 Deprecation warning after installing module (Odoo.sh)
warning iso odoo11 odoo.sh
Avatar
0
May 20
6955
Am I allowed to create/edit/delete directories/files on Odoo.sh (Odoo11)?
permissions errors odoo11 odoo.sh
Avatar
0
Aug 18
5067