openerp-community team mailing list archive

[Yannick Buron <yannick.buron@xxxxxxxxx>]

+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?

Yannick.


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
> Odoo.
>
> 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
> Odoo.
>
> Is there any solution for this?
>
> Thank You.
>
>
>
>
> -----
> Hans Yonathan
> OpenERP Support
> FALINWA Limited
> 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