Download images

[mapeal2]

Hi Luke,

How can the images be downloaded in the original format? they're downloaded in binary format as of now.

Thanks in advance,
Manuel.

[lukebranch]

@mapeal2 ,

Unfortunately i'm not sure about that. When you upload your images to Odoo it converts them into Base64 format, and this is the way they are stored in the database.

I believe you would need to create an extension to extend the default image widget to allow for display of the content in your preferred file format (eg. JPG).

As this is related to Odoo core functionality and not the module directly i'd recommend posting this question to help.odoo.com with a detailed description of what you would like to achieve. This way you will be able to pose the question to those more knowledgeable than me in regards to that particular widget.

Please provide me with a link once you create the forum post. I'll follow the post and provide an answer if I come across a workable method in the future.

[eversatis]

The Multi Image module that Serpent developed support image preview and can be downloaded as jpg original. I use it on OpenERP 7.0 version. Works like a charm. Not sure if that can be a help for the module develop.

https://code.launchpad.net/~serpentcs/openerp-web/multi-image-7.0

[lukebranch]

@frankmiao2015 ,

Thanks for the link. I've taken a look and it seems that the multi-image-7.0 module has support for storing the images in the local filestore rather than the database. Here's the code:

http://bazaar.launchpad.net/~serpentcs/openerp-web/multi-image-7.0/view/head:/addons/multi_image/controllers/main.py

Basically the module bypasses the database for the image store, so your images are still left in their original upload format and are stored in:

/web/static/src/img/image_multi/{{your file name here}}

I will label this as a feature request and look into adding this functionality at a later date when I can commit the required time to build it.

[mapeal2]

Hi,

I've posted the question on the forum:

https://www.odoo.com/forum/help-1/question/download-binary-files-with-original-format-72297

I guess the solution has to be found somewhere in the attachments functionality, since the attachments are uploaded in binary format as well, but downloaded in the original format.

Regards,
Manuel.

[lukebranch]

@mapeal2 ,

thanks, i've subscribed to the forum post. I'll keep digging through the source code until I can find a solution. I'll leave this issue open as a feature request until it has been implemented.

Please also note i've moved the synced sliders over to Slick Slider for now as it has much of the same features and is a more active project:

https://github.com/kenwheeler/slick

I will add a menu in the backend for choosing sliders, and adding slider options in an update soon.

Thanks for the suggestions!

[mapeal2]

Hi @lukebranch,

I've been investigating how to download binary files in the original format, and after realizing that attachments are stored in the file system with the purpose of leveraging the size of the database, I wonder now if it's more convenient to upload images as attachments instead of binary files. This has the following advantages from my humble point of view:

• The attachments preview is already implemented with the kanban view.
• Both files and images could be uploaded as attachments (Attachments button) and then displayed via 2 separate buttons on the product form, one for images and another one for files, the way it's done for projects.
• The attachment class could be extended to display a "Published" button.
• .pdfs and other kind of documents could also be available on the shop for download.

Please let me know what you think about my suggestions.

Regards,
Manuel.

[eversatis]

As well as I know, Odoo can store the attachments in local files rather than database. You can config it by Settings->Technical->Parameters-System parameters. Change ir_attachment.location to file:///filestore, then your attachments would stock in the openerp/filestore folder. But your idea adding Published button for front download is great idea.

Regards

Frank

[mapeal2]

Hi Frank,

I've double checked that, as per default, attachments are stored in the file system instead of the database. From ir_attachment.py (https://github.com/odoo/odoo/blob/8.0/openerp/addons/base/ir/ir_attachment.py):

"The 'data' function field (_data_get,data_set) is implemented using
_file_read, _file_write and _file_delete which can be overridden to
implement other storage engines, shuch methods should check for other
location pseudo uri (example: hdfs://hadoppserver)
The default implementation is the file:dirname location that stores files
on the local filesystem using name based on their sha1 hash"
(I've checked this also in my own implementations)

I'm trying to point out that it's maybe more convenient to follow the attachments philosophy of storing product images in the file system rather than in the database as binary files, in order to avoid further performance issues if the number/size of the images grow (which is likely to be like that).

Furthermore, I've seen there's another addon planned to be developed in this repository (website_product_attachments) and I was thinking if both images and product documents are uploaded as attachments, they can be distinguished by the extension of the file or even a new field on the attachments form to determine where the attachment must be included (documents or images). On the product form, 2 new buttons can be created to open separately image attachments or document attachments, similarly to how it's done with projects. These buttons would open the attachment kanban view which displays a preview of the images, and from there the standard/extended attachment functionality can be used. On the website side, images and documents could be splitted using the same criteria, and displayed via different templates (carousel template or attachments template).

I thought it was worth pointing out. If I didn't explain myself properly please let me know.

Regards,
Manuel.

[lukebranch]

@mapeal2 @frankmiao2015 ,

Thanks for all your feedback and ideas. I have been considering whether or not to keep the pictures in the database for a number of reasons, having them stored in the file system in their original format should theoretically allow people to use server-side optimisation for images like ngx_pagespeed among other things, while having them stored in the database allows for easier backups, scaleability and optimisations on image dimensions, on the fly in python (eg. serving a different image for retina/2x screens).

Both have their pros and cons, so I may provide both as options and allow for people to choose to switch between one or the other in the admin backend:

1. Store in database and allow for download > save as to download an image in it's original format from the database
2. Store images in a specified module directory in the filesystem

I will look into implementing the database option first as the basic framework is already there, and will work on implementing the second option once I can find some time.

Please feel free to suggest more features/ideas and i'll work on implementing them as soon as possible.

[mapeal2]

Thanks @lukebranch !

[mapeal2]

@lukebranch
There seems to be an open issue with binary fields:
odoo/odoo#3792
I was testing with Firefox when I posted my comments on this issue, but now I've double checked with Chrome and I'm able to download the decoded file although the original file name is not correct. Hope this helps.

[mapeal2]

And another one:
odoo/odoo#1239

[andreparames]

Hi, just wanted to point out that the last issue you linked has a pull request associated that fixes the file name issue: odoo/odoo#1241

Still not merged, alas, but you can apply the patch by saving it on a text file and doing git apply <patch file> from inside the Odoo directory.

[lukebranch]

@andreparames ,

Thanks for the update. I'll take a look at patching this on a development instance and look forward to this being patched further upstream.