← Back to team overview

openerp-community team mailing list archive

Re: Image store problem in Odoo


+1 I have the same problem with the marketplace module in communityTools. We need to have pictures displayed on the announcements, and I really don't want to store them in database.

I worked on the problem three month ago, and at this time the problem was : There was no way to store the content of binary fields on the ir.attachments, and thus store the content in filesystem. When you set the ir_location key in system configuration, ir.attachments are correctly stored in filesystem, the problem is really the fact that there is no link between binary fields and ir.attachments.

I tried to make a workaround in my module, please see http://bazaar.launchpad.net/~yannick-buron/openerp-communitytools/trunk/view/head:/marketplace/marketplace.py starting line 173. It almost work, the content is stored in filesystem, but unfortunately then it's not displayed back correctly on the form in the picture widget. I only spent some hours on this problem, so maybe there is little to correct to make it works.

This was an issue three month ago, with the ecommerce module I really hope that Odoo SA worked on this because having such limitations on binary fields is really a pain. Does someone have some news regarding this matter?


Le 11/06/2014 10:49, Falinwa Hans a écrit :
Hi Guys,

I find that the image in Odoo is stored in database.
Did we can change the configuration so it can stored in the file system?
I can't find the tutorial anywhere. So I think we cannot.

What I know is we can change the configuration when we want to store the
attachment, but its different case in image.

I think its an important feature for Odoo, importantly Odoo will have an
e-commerce and website builder feature which we will have a lot of image in

I find that its very important and there's a problem when the image is
stored in database :
1. Odoo not convert the size/resolution of the image. (We must warned the
end user to only just upload a small size of file, which usually user always
make a mistake)
2. Its very hard to make an importation on image
3. The database will be very big because of image, and it will be hard to
make a dump file(backup and restore) in web interface.
(which end user always use this feature to make a test database which image
is not important in here)

If we can change the configuration so we can store it in file system and
save the database only the name of file. We will have advantage:
1. It will be  easier to make an importation of image.
2. We will not care about file size anymore because it save on file system.
3. The database size will reduce greatly.

Before I have a problem in attachment, when my database size raise to 2 GB
which impossible to make a dump(backup and restore) in web interface. After
I change the configuration the database size reduce greatly to only 30 MB.
So I think this problem will occur again if we begin to upload the image in

Is there any solution for this?

Thank You.

Hans Yonathan
OpenERP Support
Expert in Finance & Business Intelligence
OpenERP Silver Partner
Website: www.falinwa.com

View this message in context: http://openerp-community.2306076.n4.nabble.com/Openerp-community-Image-store-problem-in-Odoo-tp4645755.html
Sent from the OpenERP Community mailing list archive at Nabble.com.

Mailing list: https://launchpad.net/~openerp-community
Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp

Follow ups