RE: DBD::Chart copying and pasting...



Hi Dean,

Thanks again for your prompt reply.

I'm currently using the DBD::Chart version DBD-Chart-0.82., GD-2.35, PERL Version 5.8.0.
Firstly, I was saving with the PNG format, then I changed to GIF, but with no avail.

I've set my Background to transparent.

Here is a piece of code setting my DBD::Chart

$rsth = $dbh->prepare(
"SELECT image, IMAGEMAP FROM
(select barchart from tb_serie_1
where color='blue' and shape='fillcircle' and showpoints=1 and showvalues=1 ) Media,
(select linegraph from tb_serie_2
where color='red' and shape='opencircle' and showpoints=1 and showvalues=0) Meta

WHERE WIDTH=700 AND HEIGHT=400 AND
X-AXIS=\'Mes/Ano\' AND
Y-AXIS=\'Dias\' AND
TITLE = \'Gestao a Vista AREA: $V_AREA[0] INDICADOR: $V_IND[0]\' AND
COLOR=(red, blue, yellow, black, black, pink, orange, cyan) AND
SHOWGRID=1 AND
SHAPE=(filldiamond, fillsquare, filldiamond, fillsquare, filldiamond, fillsquare, filldiamond, fillsquare) AND
SHOWPOINTS=1 AND
BACKGROUND='transparent' AND
FORMAT='GIF' AND
MAPNAME='testmap' AND
MAPURL='http://www.gowi.com/cgi-bin/sample.pl?x=:X&y=:Y&z=:Z&plotno=:PLOTNUM' AND
MAPTYPE='HTML' ");
$rsth->execute;


I'll try to change the background and see the result.

Thanks in advance.

Thiago


-----Original Message-----
From: Dean Arnold [mailto:darnold@xxxxxxxxxxxxxx]
Sent: quarta-feira, 3 de janeiro de 2007 15:59
To: THIAGO LACERDA ZAGO
Cc: dbi-users@xxxxxxxx
Subject: Re: DBD::Chart copying and pasting...

THIAGO LACERDA ZAGO wrote:
When I copy and paste the image on my Excel Work*** or PowerPoint
right from my browser after running my DBD::Chart Perl script, the
image comes with its background all in black and the graph
hard to distinguish from the original.

What could I do to overcome this problem?


What version of DBD::Chart are you using ?

What version of GD are you using ?

What file format do you export the image as ?
PNG ? JPEG ? GIF ?

Have you set the BACKGROUND property in the chart query ? e.g.,

....AND BACKGROUND='white'...

IIRC, MSFT has had issues with PNG transparent colors, that
may be your issue. If possible, try exporting as GIF.

Dean Arnold
Presicient Corp.


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.3/614 - Release Date: 2/1/2007 14:58


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.3/614 - Release Date: 2/1/2007 14:58

.

Quantcast