Folders and files
| Name | Name | Last commit date | ||
|---|---|---|---|---|
Repository files navigation
NAME
RT-Extension-ExcelFeed
DESCRIPTION
This extenstion allows you to generate RT reports in MS Excel XSLX
format. It provides two ways to do this. First, it adds a new MS Excel
option to the 'Feeds' menu on the Query Builder search results page. It
also adds an option to the Dashboard subscription page that allows you
to have scheduled dashboards emailed to recipients as attached MS Excel
files rather than inline HTML reports.
RT VERSION
Works with RT 6.0. For RT 5.0 install the latest 0.* version.
INSTALLATION
"perl Makefile.PL"
"make"
"make install"
May need root permissions
Add this line to /opt/rt6/etc/RT_SiteConfig.pm
Plugin('RT::Extension::ExcelFeed');
Clear your mason cache
rm -rf /opt/rt6/var/mason_data/obj
Restart your webserver
CONFIGURATION
$HideChartDownloadButton
By default, a "Download as Microsoft Execel Spreadsheet" button is
enabled on Charts. You can disable it by adding the following config
to your RT_SiteConfig.pm:
Set( $HideChartDownloadButton, 1 );
$ExcelFeedProgressiveRows
When generating an Excel file, ExcelFeed progressively pages through
the search results $ExcelFeedProgressiveRows rows at a time. This
does not change the output, but can significantly reduce memory
usage on large result sets.
Set this to 0 to disable progressive generation and load the entire
result set into memory at once:
Set( $ExcelFeedProgressiveRows, 0 );
If this option is not defined, ExcelFeed falls back to RT's core
$ProgressiveSearchResultRows, and if that is also not defined, to
1000.
AUTHOR
Best Practical Solutions, LLC <modules@bestpractical.com>
BUGS
All bugs should be reported via email to
L<bug-RT-Extension-ExcelFeed@rt.cpan.org|mailto:bug-RT-Extension-ExcelFeed@rt.cpan.org>
or via the web at
L<rt.cpan.org|http://rt.cpan.org/Public/Dist/Display.html?Name=RT-Extension-ExcelFeed>.
LICENSE AND COPYRIGHT
This software is Copyright (c) 2015-2026 by Best Practical Solutions,
LLC
This is free software, licensed under:
The GNU General Public License, Version 2, June 1991