XLS export plugin
Added by Vitaly Klimov over 14 years ago
Up to date plugin page¶
http://www.redmine.org/plugins/redmine_xls_export
XLS export plugin¶
With the help of this plugin you can export issues list with all information to XLS file. Also it is possible to export issues with attachments as a ZIP archive.
Requirements¶
Plugin requires Redmine version 1.3.0 or higher.
Plugin relies on spreadsheet gem for XLS based operations. Please install this gem before running plugin. Also if you want to use attachments export you should install rubyzip gem.
Features¶
- Export active or all columns
- Export issue descriptions
- Export journal entries - both inline or as separate file per each issue
- Export relations information
- Export spent time data
- List attachments information
- Export attachments
- Export watchers
- Split information by sheets based on grouping criteria
- Correct formatting and width of worksheet cells
Details¶
Plugin adds following links with 'XLS export:' prefix at the bottom of the page under 'Also available in' bar:
- Quick
One click export to XLS using default export settings from plugin configuration screen - Detailed
Brings up dialog where user can choose export options before export
Installation and Setup¶
- Install spreadsheet gem ('gem install spreadsheet')
- Install rubyzip gem if you want to use export attachments feature
- Install plugin Plugin views with revisions if you do not have it installed
- Follow the Redmine plugin installation steps at: http://www.redmine.org/wiki/redmine/Plugins
- Run rake task
rake redmine:plugins:process_version_change RAILS_ENV=production - Login and configure the plugin (Administration > Plugins > Configure)
Replies (276)
RE: XLS export plugin
-
Added by Terence Mill about 13 years ago
In the redmine issue list there is no hierarchy on redmine 1.1.2. Maybe thats came since 1.2?
RE: XLS export plugin
-
Added by Terence Mill about 13 years ago
I just checked on demo.redmine.org and there is no hierarchy on 1.20 either!
Must be a plugin you have installed.
RE: XLS export plugin
-
Added by Alex A about 13 years ago
I have a issue list hierarchy, sortet by parent issue
issue_list.GIF (16.6 KB) issue_list.GIF |
RE: XLS export plugin
-
Added by Terence Mill about 13 years ago
Someone else? Checko this out on demo.redmine.org (which is 1.2 deployed)..there is no such feature..
RE: XLS export plugin
-
Added by Alex A about 13 years ago
Terence Mill wrote:
Someone else? Checko this out on demo.redmine.org (which is 1.2 deployed)..there is no such feature..
This issue list from demo.redmine.org
subissues.GIF (10.3 KB) subissues.GIF |
RE: XLS export plugin
-
Added by Marco Lima about 13 years ago
Added Italian translation.
Thanks for the plugin!
RE: XLS export plugin
-
Added by Francesco Filippi about 13 years ago
Hi,
thanks for the plugin. I'm using Redmine 1.1 and I have a problem with the export.
In particular the problem start when I try to add the "issue description" to the exporting data. Does any one have this problem?
Thanks in advance,
Francesco
RE: XLS export plugin
-
Added by Alexey Marochkin about 13 years ago
It would be great if the feture "Split information by sheets based on grouping criteria" will option to be "Group information in one sheet based on grouping criteria such in query of redmine"
Thanks to author ! Excelent plugin !
RE: XLS export plugin
-
Added by Joel Bearden about 13 years ago
I have just discovered this plugin and it appears to do exactly what we want, however, I cannot get it to work.
Here is my environment:
Ruby = 1.8.6
Rails = 2.3.8
Mongrel = 1.1.5
Redmine = 1.2.1
Spreadsheet GEM = 0.6.5.7
XLS Plugin = 0.1.3
When I try to export, either Quick or Detailed, I get the following error message in my log file:
NoMethodError (undefined method `count' for #<Spreadsheet::Row:0x60a85a0>): config/initializers/mongrel.rb:62:in `dispatch_cgi'
It should be mentioned, that due to the version of rails that I am using with Mongrel, I had to utilize the fix mentioned in Defect #7688.
Thanks in advance.
RE: XLS export plugin
-
Added by Ivan Cenov about 13 years ago
Joel Bearden wrote:
I have just discovered this plugin and it appears to do exactly what we want, however, I cannot get it to work.
Here is my environment:
Ruby = 1.8.6
Rails = 2.3.8
Mongrel = 1.1.5
Redmine = 1.2.1
Spreadsheet GEM = 0.6.5.7
XLS Plugin = 0.1.3When I try to export, either Quick or Detailed, I get the following error message in my log file:
[...]It should be mentioned, that due to the version of rails that I am using with Mongrel, I had to utilize the fix mentioned in Defect #7688.
Thanks in advance.
I am with Ruby 1.8.7 Rails 2.3.11 Mongrel 1.5 Redmine 1.2.1 XLS Plugin = 0.1.3 and it works.
RE: XLS export plugin
-
Added by Joel Bearden about 13 years ago
Ivan,
Thanks for the response, I upgraded to Ruby 1.8.7 and it is now working. Never could get it to work with 1.8.6.
RE: XLS export plugin
-
Added by Blake Sobiloff almost 13 years ago
Ivan, I love your plug-in since it saves me a lot of time versus having to format a CSV file and save as XLS. Thanks!
I'm just hoping you find the time soon to add the ability to export the issue history as well. Other than the PDF export I don't know of any way to get this information out of Redmine. Some folks I work with are still wedded to spreadsheets and it's a big effort to export PDFs or cut-n-paste from the browser into a spreadsheet.
RE: XLS export plugin
-
Added by Ivan Cenov almost 13 years ago
Blake Sobiloff wrote:
... I'm just hoping you find the time soon to ...
Unfortunately, I am not the author of this plugin, I am just a happy user of it.
Ivan
RE: XLS export plugin
-
Added by Blake Sobiloff almost 13 years ago
Yikes! Apologies, Vitaly! Thanks for the correction, Ivan.
RE: XLS export plugin
-
Added by John Alberts almost 13 years ago
This is a great plugin but I noticed a problem today which made me have to uninstall it. With this plugin installed, I can no longer right click on an issue in the issues list to get the pop up menu. Is anyone else seeing this problem and/or have a solution for it?
John
RE: XLS export plugin
-
Added by Joel Bearden almost 13 years ago
Make sure you are not right-clicking on an issue column that is not also a link(ie. Subject). If I right-click on a column that contains a link, I do not get the pop-up menu.
It works fine in Firefox, Chome, and IE.
RE: XLS export plugin
-
Added by John Alberts almost 13 years ago
Yes, I've made sure to click in an empty area on the line and the ajax 'loading' graphic pop up for a split second and then goes away. After removing the xls_export plugin, right clicking in the same place works as expected.
I forgot to put all of my version info in my previous post.
I'm using redmine 1.2.1, ruby 1.8.7, passenger 3.0.7 and nginx 1.0.0
I have the following plugins installed:
haru_iida-redmine_theme_changer
open_flash_chart
parking_lot_chart
projects_tree_view
redmine_charts
redmine_code_review
redmine_favourite_projects
John
RE: XLS export plugin
-
Added by Ivan Cenov almost 13 years ago
Joel Bearden wrote:
Make sure you are not right-clicking on an issue column that is not also a link(ie. Subject). If I right-click on a column that contains a link, I do not get the pop-up menu.
It works fine in Firefox, Chome, and IE.
Same in our installation. It works. Redmine 1.2.1, Apache , Mongrel, Windows, Firefox
RE: XLS export plugin
-
Added by Karel Pičman almost 13 years ago
One of the users of our company Redmine requested to add issue history into the Excel report. I've implemented this feature using the attached patch. Please add into the trunk if it makes sense for you.
export_history.patch was created in redmine_xls_export_v_013.zip.
export_history.patch (12.1 KB) export_history.patch |
RE: XLS export plugin
-
Added by Steven Wong almost 13 years ago
Hi, Karel Picman
How do I use the patch for redmine_xls_export? Where should I place the patch? Thanks.
Karel Picman wrote:
One of the users of our company Redmine requested to add issue history into the Excel report. I've implemented this feature using the attached patch. Please add into the trunk if it makes sense for you.
export_history.patch was created in redmine_xls_export_v_013.zip.
RE: XLS export plugin
-
Added by Tatsuya Saito almost 13 years ago
Alex A wrote:
Terence Mill wrote:
Sory. this is too much pacthes now. Getting patch order errors..
Please post the whole file,s o we can test itThis is whole file
It works on 1.2.1 like following post if I sorted issues list by Parent Task.
http://www.redmine.org/boards/3/topics/11986?r=24814#message-24814
RE: XLS export plugin
-
Added by Tatsuya Saito almost 13 years ago
Thanks good work, Karel Picman :)
Steven Wong wrote:
Hi, Karel Picman
How do I use the patch for redmine_xls_export? Where should I place the patch? Thanks.
Please try following in parent folder of redmine_xls_export:
$ patch -p4 < export_history.patch
By the way, I translated this patch for Japanese and others(using Google Translate).
https://github.com/two-pack/redmine_xls_export
RE: XLS export plugin
-
Added by Vitaly Klimov almost 13 years ago
Karel, thank you for the patch, i will integrate it into next release of the plugin
RE: XLS export plugin & Closed Date
-
Added by Roy Leo almost 13 years ago
Installing both the closed date plugin with yours causing the closed date fields to be no longer available.
The date of closure field is important to us and it would be nice if both plugins played nicely!
Regards
Roy