Hi Yannick,
Thx for your response.
I see the code, and it's a nice idea. I will keep it on myself.
It will be nicer if the improvement is made from Odoo framework itself.
Thank You.
Best Regards,
*Hans Yonathan*
*OpenERP Support*
FALINWA Limited
/Expert in Finance & Business Intelligence/
/OpenERP Partner/
/Website: //www.falinwa.com/ <http://www.falinwa.com/>
*From:*Yannick Buron-2 [via OpenERP Community] [mailto:[hidden email]
</user/SendEmail.jtp?type=node&node=4645759&i=0>]
*Sent:* Wednesday, June 11, 2014 5:06 PM
*To:* Falinwa Hans
*Subject:* Re: [Openerp-community] 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
<http://bazaar.launchpad.net/%7Eyannick-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 <http://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
<https://launchpad.net/%7Eopenerp-community>
> Post to : [hidden email]
</user/SendEmail.jtp?type=node&node=4645757&i=0>
> Unsubscribe : https://launchpad.net/~openerp-community
<https://launchpad.net/%7Eopenerp-community>
> More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~openerp-community
<https://launchpad.net/%7Eopenerp-community>
Post to : [hidden email]
</user/SendEmail.jtp?type=node&node=4645757&i=1>
Unsubscribe : https://launchpad.net/~openerp-community
<https://launchpad.net/%7Eopenerp-community>
More help : https://help.launchpad.net/ListHelp
------------------------------------------------------------------------
*If you reply to this email, your message will be added to the
discussion below:*
http://openerp-community.2306076.n4.nabble.com/Openerp-community-Image-store-problem-in-Odoo-tp4645755p4645757.html
To start a new topic under OpenERP Community, email [hidden email]
</user/SendEmail.jtp?type=node&node=4645759&i=1>
To unsubscribe from OpenERP Community, click here.
NAML
<http://openerp-community.2306076.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
Hans Yonathan
OpenERP Support
FALINWA Limited
Expert in Finance & Business Intelligence
OpenERP Silver Partner
Website: www.falinwa.com
------------------------------------------------------------------------
View this message in context: RE: [Openerp-community] Image store
problem in Odoo
<http://openerp-community.2306076.n4.nabble.com/Openerp-community-Image-store-problem-in-Odoo-tp4645755p4645759.html>
Sent from the OpenERP Community mailing list archive
<http://openerp-community.2306076.n4.nabble.com/> 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
