DBD::Chart copying and pasting...

------_=_NextPart_001_01C72F59.FA9562FE
Content-Type: text/plain;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable

Hi,

=20

When I copy and paste the image on my Excel Worksheet 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?

=20

Thanks,

=20

Thiago

=20


--=20
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
=20

------_=_NextPart_001_01C72F59.FA9562FE--

Re: DBD::Chart copying and pasting...

THIAGO LACERDA ZAGO wrote:
> When I copy and paste the image on my Excel Worksheet 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.

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 =3D $dbh->prepare(
"SELECT image, IMAGEMAP FROM=20
(select barchart from tb_serie_1
where color=3D'blue' and shape=3D'fillcircle' and showpoints=3D1 and =
showvalues=3D1 ) Media,
(select linegraph from tb_serie_2
where color=3D'red' and shape=3D'opencircle' and showpoints=3D1 and =
showvalues=3D0) Meta
=20
WHERE WIDTH=3D700 AND HEIGHT=3D400 AND
X-AXIS=3D\'Mes/Ano\' AND
Y-AXIS=3D\'Dias\' AND
TITLE =3D \'Gestao a Vista AREA: $V_AREA[0] INDICADOR: $V_IND[0]\' AND
COLOR=3D(red, blue, yellow, black, black, pink, orange, cyan) AND
SHOWGRID=3D1 AND
SHAPE=3D(filldiamond, fillsquare, filldiamond, fillsquare, filldiamond, =
fillsquare, filldiamond, fillsquare) AND
SHOWPOINTS=3D1 AND
BACKGROUND=3D'transparent' AND
FORMAT=3D'GIF' AND
MAPNAME=3D'testmap' AND
MAPURL=3D'http://www.gowi.com/cgi-bin/sample.pl?x=3D:X&y=3D: Y&z=3D:Z&plot=
no=3D:PLOTNUM' AND
MAPTYPE=3D'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@presicient.com]=20
Sent: quarta-feira, 3 de janeiro de 2007 15:59
To: THIAGO LACERDA ZAGO
Cc: dbi-users@perl.org
Subject: Re: DBD::Chart copying and pasting...

THIAGO LACERDA ZAGO wrote:
> When I copy and paste the image on my Excel Worksheet or PowerPoint=20
> 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.
>=20
> What could I do to overcome this problem?
>=20

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=3D'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.


--=20
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
=20

--=20
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
=20

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

OK!!!

Problem solved!

It was the background that was set to transparent.

Then, changing to 'white' as suggested, solved the problem.

Tanks!


Thiago

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

THIAGO LACERDA ZAGO wrote:
> When I copy and paste the image on my Excel Worksheet or PowerPoint=20
> 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.
>=20
> What could I do to overcome this problem?
>=20

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=3D'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.


--=20
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
=20

--=20
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.4/615 - Release Date: 3/1/2007 =
13:34
=20