跳至内容
此问题已终结
shellodoo11odoo.sh
3 回复
15442 查看
形象
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)
最佳答案

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
编写者

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.

相关帖文 回复 查看 活动
Restart webshell in Odoo.sh
shell odoo.sh
形象
0
10月 22
5082
odoo.sh: 'NameError: name 'active_id' is not defined' from multiple places
odoo11 odoo.sh
形象
形象
形象
2
2月 22
9192
push changes made to already existing modules (such as survey) from staging to production. 已解决
shell odoo.sh GitHub
形象
形象
1
9月 21
4279
Odoo11 Deprecation warning after installing module (Odoo.sh)
warning iso odoo11 odoo.sh
形象
0
5月 20
6768
Am I allowed to create/edit/delete directories/files on Odoo.sh (Odoo11)?
permissions errors odoo11 odoo.sh
形象
0
8月 18
4906