Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
3 Replies
21699 Tampilan

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

Avatar
Buang

<img t-att-src="widget.get_image_url(category)" />

Jawaban Terbai

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.

Avatar
Buang

You can use features "encodestring" and "decodestring" of base64 module in python to do this.

Jawaban Terbai

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.

Avatar
Buang
Penulis

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!

Penulis Jawaban Terbai

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

Avatar
Buang

Hi Selverine, python will translate from bytea (in database) into <type 'buffer'> in your python code.

Post Terkait Replies Tampilan Aktivitas
2
Des 23
12512
3
Jul 22
22817
2
Jun 21
18325
0
Sep 20
3614
0
Mei 16
3973