Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
shellodoo11odoo.sh
3 Odgovori
15414 Prikazi
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
Opusti
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
Opusti
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
Opusti
Jean Donaires
Avtor

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 Odgovori Prikazi Aktivnost
Restart webshell in Odoo.sh
shell odoo.sh
Avatar
0
okt. 22
5071
odoo.sh: 'NameError: name 'active_id' is not defined' from multiple places
odoo11 odoo.sh
Avatar
Avatar
Avatar
2
feb. 22
9181
push changes made to already existing modules (such as survey) from staging to production. Solved
shell odoo.sh GitHub
Avatar
Avatar
1
sep. 21
4274
Odoo11 Deprecation warning after installing module (Odoo.sh)
warning iso odoo11 odoo.sh
Avatar
0
maj 20
6738
Am I allowed to create/edit/delete directories/files on Odoo.sh (Odoo11)?
permissions errors odoo11 odoo.sh
Avatar
0
avg. 18
4893