Fetch images which are stored in filestore odoo 11

Question

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 "

Sudhir Arya (ERP Harbor Consulting Services) · Accepted Answer

HI Supreeth,
You just need to use "* datas [1] *" 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.

[1] https://github.com/odoo/odoo/blob/10.0/odoo/addons/base/ir/ir_attachment.py#L23

nesefi · Answer

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

المنشورات ذات الصلة	الردود	أدوات العرض
Add image_medium in product_product_templates.xml - Odoo Community 10 تم الحل image product.template	1 يونيو 19	7004
Odoo11 : How can i set default product image? تم الحل image default odoo11.0	2 أغسطس 25	8206
Contact image via url تم الحل image url odoo11.0	2 سبتمبر 21	8931
[How to get images from filestore to image field ] ? image field filestore	2 أغسطس 17	8775
Add an image URL on Media center and save to server file system. image filestore url media	0 يونيو 23	6062

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!