Excel Exports in Zucker Report

[visucr]

Hi,

I am having a problem with the Excel export feature in Zucker Reports, When I try to run a report in excel format running on a windows machine with IE(version 7) the page will reload and a pop-up will appear then quickly disappear. If I run the same thing using Firefox I don't have any problems. But when run with pdf format in IE(version 7) and Firefox it was working fine.

[DragonflyMaster]

I answered to your question in this thread of yours

[visucr]

Hi,

In internet explorer 7
Tools -> Internet options -> security -> custom level

In that it contain Download Heading under that
Automatic Prompting for file downloads: “enable”

Initially it will be in disable .If we change it into enable then file will open fine.

[DragonflyMaster]

Very good, I knew it was a browser configuration issue!

[visucr]

Is there any chance to solve this issue by coding not in changing setting..

It is not possible to say every one to change in settings so we have to change by coding.
If we can solve this issue by coding then please suggest?

[kuske]

No you cannot !
This is some kind of security setting, and if everybody could change it by coding, every hacker could change it on you machine.
So you have to write a "SugarCRM Admin Note #1" and to send it to your users. What about a email-campiagn?

[DragonflyMaster]

So you have to write a "SugarCRM Admin Note #1" and to send it to your users. What about a email-campiagn?

That would be a nice way
Anyway, under certain circumstances there might be a way to set this configuration for every user.
Conditions are:

1. All users must be part of the same domain and logged to it;
2. The Domain Administrator must create a domain rule that checks at every connection to the domain that option is set as wanted

But is much easier to tell all your users how to change that setting by hand.

[kuske]

ok ok you are right dragon....

as i am a real policy hater I did not mention that method :-)
I always fight against our IT finding new thumbscrews in new policy rules *harharhra*

[DragonflyMaster]

ok ok you are right dragon....

as i am a real policy hater I did not mention that method :-)
I always fight against our IT finding new thumbscrews in new policy rules *harharhra*

I hate domain policies too and I've spent a considerable lot of time finding workaround ways...
I mentioned this opportunity only for thoroughness' sake.

[visucr]

what my question is in List view there are three button . Delete,Export,Mail Merge.

But in that if you click "Export" csv file is opening fine in ecel sheet.

Then why excel file was not opening while it was running in the zucker report.

If it is the local setting problem means it should not open in "export" option in search..

I checked it in coding that file was opening correctly by calling "export.php" file.
In that they set

BUILD THE EXPORT FILE
ob_clean();
header("Pragma: cache");
header("Content-type: application/octet-stream; charset=".$locale->getExportCharset());
header("Content-Disposition: attachment; filename={$_REQUEST['module']}.csv");
header("Content-transfer-encoding: binary");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT" );
header("Cache-Control: post-check=0, pre-check=0", false );
header("Content-Length: ".strlen($content));
print $locale->translateCharset($content, 'UTF-8', $locale->getExportCharset());

So we should do some modification in coding .. I tried to do modification in coding but it showing blank message..
where we can do the modification..

For exporting the excel file in report we have to work on these two files.

1) C:\Program Files\sugarcrm-5.0.0c\htdocs\sugarcrm\modules\ZuckerReportTemplat e\ReportTemplate.php

2) C:\Program Files\sugarcrm-5.0.0c\htdocs\sugarcrm\modules\ZuckerReports\Repor tondemand.php