Hi Hans,

Glad to have been of help and thanks for your appreciation of our other works.


Best regards,
<http://www.openerp.cn>

*Tony Gu*  --Shine IT-- Shanghai, China
Tel : + 86 21 66044468
Cell: + 86 13386068213  Skype: digitalsatori
http://www.openerp.cn
OpenERP Consultans China Linkedin Group  
<http://www.linkedin.com/groups/OpenERP-Consultants-China-4009853?home=&gid=4009853&trk=anet_ug_hm>
*OpenERP Official Partner in China*


On 06/11/2014 06:45 PM, Falinwa Hans wrote:

Hi Tony,

Wow, I look on the code, and its very beautiful.

Thanks for the solution, I think it will solved the problem for now.

Very appreciated it.

I remember that you developed oe_cn_fonts module too.

It's a great work.

Hi Franck Bret,

Thanks for the information, its nice to see that we have the same problem in this topic.

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/>

On 06/11/2014 06:28 PM, Tony Gu wrote:

Hi Hans,

You may be interested to have a look at our module here: https://github.com/shine-it/product_image_filestore The image on product can be save as an attachment of the product and display correctly on the product form. If you have product image stored in database already, this module will also extract the binary and store it back to file store.

Have fun!

*From:*Franck Bret [via OpenERP Community] [mailto:[hidden email] </user/SendEmail.jtp?type=node&node=4645761&i=0>]
*Sent:* Wednesday, June 11, 2014 6:31 PM
*To:* Falinwa Hans
*Subject:* Re: [Openerp-community] Image store problem in Odoo

there is a community call for discussion around this here, hope it helps

https://twitter.com/Seb_Beau/status/474847322887974912

https://code.launchpad.net/~akretion-team/server-env-tools/server-env-tools <https://code.launchpad.net/%7Eakretion-team/server-env-tools/server-env-tools>

Interesting read and module too here :

https://bitbucket.org/anybox/advanced_attachment
http://docs.anybox.fr/advanced_attachment/current/

Le 11/06/2014 11:48, Falinwa Hans a écrit :

    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 <http://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  
<https://launchpad.net/%7Eopenerp-community>

    Post to     :[hidden email]  
</user/SendEmail.jtp?type=node&node=4645760&i=0>

    Unsubscribe :https://launchpad.net/~openerp-community  
<https://launchpad.net/%7Eopenerp-community>

    More help   :https://help.launchpad.net/ListHelp




--
Franck Bret
============
Consultant fonctionel OpenErp
------------
[hidden email]  </user/SendEmail.jtp?type=node&node=4645760&i=1>
Gsm. 0603906598


_______________________________________________
Mailing list: https://launchpad.net/~openerp-community <https://launchpad.net/%7Eopenerp-community> Post to : [hidden email] </user/SendEmail.jtp?type=node&node=4645760&i=2> 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-tp4645755p4645760.html

To start a new topic under OpenERP Community, email [hidden email] </user/SendEmail.jtp?type=node&node=4645761&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-tp4645755p4645761.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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openerp-community
More help   : https://help.launchpad.net/ListHelp

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

Reply via email to