Project

General

Profile

XLS export plugin

Added by Vitaly Klimov about 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

  1. Install spreadsheet gem ('gem install spreadsheet')
  2. Install rubyzip gem if you want to use export attachments feature
  3. Install plugin Plugin views with revisions if you do not have it installed
  4. Follow the Redmine plugin installation steps at: http://www.redmine.org/wiki/redmine/Plugins
  5. Run rake task
    rake redmine:plugins:process_version_change RAILS_ENV=production
  6. Login and configure the plugin (Administration > Plugins > Configure)

Replies (276)

RE: XLS export plugin - Added by Terence Mill over 12 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 over 12 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 over 12 years ago

I have a issue list hierarchy, sortet by parent issue

RE: XLS export plugin - Added by Terence Mill over 12 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 over 12 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

RE: XLS export plugin - Added by Marco Lima over 12 years ago

Added Italian translation.

Thanks for the plugin!

it.yml (1.24 KB) it.yml Italian translation

RE: XLS export plugin - Added by Francesco Filippi over 12 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 over 12 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 over 12 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 over 12 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.3

When 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 over 12 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 over 12 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 over 12 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 over 12 years ago

Yikes! Apologies, Vitaly! Thanks for the correction, Ivan.

RE: XLS export plugin - Added by John Alberts over 12 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 over 12 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 over 12 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 over 12 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 over 12 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.

RE: XLS export plugin - Added by Ivan Cenov over 12 years ago

+1 for export_history.patch

RE: XLS export plugin - Added by Steven Wong over 12 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 over 12 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 it

This 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 over 12 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 over 12 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 over 12 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

(101-125/276)