Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi everybody,
I would like to add an image to a xml file.
This image is stored on the database (like res_partner.image).
How is possible to print this image on a xml file?
It will be nice to have this image with a sql request (cr.execute) and convert it in binary or in picture in order to have the possibility to print it.
Thank you a lot
Selverine
You can load your image in any form that have image field (for example Product). And then export this field to CSV file. Open CSV file in Excel and copy data of image in ANSII text format. After it paste data to your XML file.
You can use features "encodestring" and "decodestring" of base64 module in python to do this.
It is, and you can find examples in the standard modules. The trick is to convert the image to base64. Yiou can find a tool, do it with a small Python script, or even use a website service for that (there are several on the web).
For an example have a look at addons/base/res/res_partner_demo.xml.
Dear Daniel Reis, thank your for your help. I don't find other function. I try this cr.execute('SELECT res_company.logo_web FROM res_company') res = cr.fetchall() v['logoTmp'] = base64.decodestring(str(res[0])), and others fonctions without results. Have you some idea please? Thanks a lot!
Hi wowas, OpenERP Vietnam,
Thank you, really, for your help. I will be more precise about my problem: I use the code below:
cr.execute('SELECT res_company.logo_web FROM res_company') res = cr.fetchall() v['logo_Print'] = res[0]
I would to put in the field logo_Print, the picture that is stored in the table: res_company, field logo_web, id = one. I think that maybe there is an fonction to translate bytea image (field in database) into binary in my python code, no?
Thnak you!
Selverine
[Edit] Now, i try with :
cr.execute('SELECT res_company.logo_web FROM res_company') res = cr.fetchall() v['logoTmp'] = base64.decodestring(str(res[0]))
But still doesn't work, any idea please? How is possible to convert an "tuple" into a string? Or maybe, need i to get the picture differently?
Thank!!
Hi Selverine, python will translate from bytea (in database) into <type 'buffer'> in your python code.
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
2
déc. 23
|
14017 | ||
|
3
juil. 22
|
24436 | ||
|
2
juin 21
|
19512 | ||
|
0
sept. 20
|
4417 | ||
|
0
mai 16
|
4960 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
See also: http://help.openerp.com/question/16735/images-in-webkit-mako-pdf-reports
<img t-att-src="widget.get_image_url(category)" />