Skip to Content
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
All Posts Люди Значки
Мітки (View all)
odoo accounting v14 pos v15
Про цей форум
Це запитання позначене
imagefilestoreproduct.templateodoo11.0
2 Відповіді
8360 Переглядів
Аватар
Supreeth KV

How to Fetch images which are stored in file-store odoo-11

I am trying to fetch product.template image which is stored in ir_attachment in the format "39/39abfeca081b17a6b93fbeaeead3e34025a39f9c".

This is not a binary code. I tried this code in this URL \https://codebeautify.org/base64-to-image-converter. It didn't give any image. Later i understood that, this is a code in file store. When we download a Database in zip format and extract the DB we will see the file-store inside this folder "39" is a folder name and "39abfeca081b17a6b93fbeaeead3e34025a39f9c" is a image name.

My Requirement is Product Image will be fetched from other Application, how can i store this in database with binary code. So that other application will fetch that binary code and get image?

Thanks in Advance.

Аватар
Відмінити
Аватар
Sudhir Arya (ERP Harbor Consulting Services)
Найкраща відповідь

HI Supreeth,

You just need to use "datas" field of ir.attachment object to get the binary data from filestore if you are accessing binary data from attachment object.

If you want to fetch product template image directly from product.template object, use "image" field.

I hope this will solve your problem.

Аватар
Відмінити
Supreeth KV
Автор

@SudhirArya Thank you, but product.template object, "image" will not store in database rite?

Sudhir Arya (ERP Harbor Consulting Services)

Yes, image field is not stored in the database. If you are using xmlrpc, you can directly use image field to fetch the image in binary format.

shalin wilson

what if we are using a query?

same problem for me also

Аватар
nesefi
Найкраща відповідь

Hi, i know this is kind of an old post but im new to odoo and ive been reading about this since i need to perform a migration from DB and need those images in a folder.

ive been using the query:

Select * from ir_attachment WHERE res_model = 'product.template' and res_field = 'image' and 'db_datas' is not null

to get the binaries so i can export decode them and get my images on an output but to no avail, im not able to find those binaries in the DB, im aware db_datas is suposed to have the data i need, but where can i get those binaries?

this is the output im getting:  docs.google.com/spreadsheets/d/1g1zZrTLu56MU7S5O5nzg-QQtsLa8QaE7jflddnRb9Wo/edit?usp=sharing

i cannot export the Csv from the web interface because the image export im getting for the full resolution images is broken

Аватар
Відмінити
Related Posts Відповіді Переглядів Дія
Add image_medium in product_product_templates.xml - Odoo Community 10 Вирішено
image product.template
Аватар
1
черв. 19
7011
Odoo11 : How can i set default product image? Вирішено
image default odoo11.0
Аватар
Аватар
2
серп. 25
8226
Contact image via url Вирішено
image url odoo11.0
Аватар
Аватар
Аватар
2
вер. 21
8939
[How to get images from filestore to image field ] ?
image field filestore
Аватар
Аватар
Аватар
2
серп. 17
8789
Add an image URL on Media center and save to server file system.
image filestore url media
Аватар
0
черв. 23
6072