XLS export plugin

Added by Vitaly Klimov over 9 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 Peng Wang over 8 years ago

Here comes the Chinese translation.

Br
-Peng

zh.yml Magnifier - Simplified Chinese translation (1.07 KB)

RE: XLS export plugin - Added by Terence Mill over 8 years ago

Terence Mill wrote:

BUG Report for 0.1.1

When clicking on Detailed XLS Export i get "Internal Error" and following message in log

[...]

The buf is solved now, but you took the nione updated german trasnlation - i posted an update yet after the first upload, that is more up to date.

I would like to make a feature request:

  • Optionally Export als Comments (history), not only the latest value of the description field. This is needed because it is context for the whole ticket and needful to understand the history and have it with offline an mobile in exported report.
  • expoprt attachments as http links to the original documents, so you can click them for download. It would be adavanced even to configure a regexp to replace default https://redmine.domain/attachments/290/file.txt with eg. a webdav access, like "https://redmine.domain/webdav/files/attachments"

RE: XLS export plugin - Added by Tatsuya Saito over 8 years ago

Thanks great works :)
I created Japanese translation and put in following github:
https://github.com/two-pack/redmine_xls_export/blob/master/config/locales/ja.yml

RE: XLS export plugin - Added by Vitaly Klimov over 8 years ago

Terence Mill wrote:

The buf is solved now, but you took the nione updated german trasnlation - i posted an update yet after the first upload, that is more up to date.

I checked both posts - the files are identical - it seems that you uploaded same version twice.

  • Optionally Export als Comments (history), not only the latest value of the description field. This is needed because it is context for the whole ticket and needful to understand the history and have it with offline an mobile in exported report.

Should be relatively easy to do. Will do it as soon as i have some spare time.

  • expoprt attachments as http links to the original documents, so you can click them for download. It would be adavanced even to configure a regexp to replace default https://redmine.domain/attachments/290/file.txt with eg. a webdav access, like "https://redmine.domain/webdav/files/attachments"

Same as above.

RE: XLS export plugin - Added by Vitaly Klimov over 8 years ago

Updated to version 0.1.3. See plugin page

RE: XLS export plugin - Added by Anson Chen over 8 years ago

Hi, I created a traditional chinese tranlation. It is converted from simplified chinese by cconv tool.
You can get the file from https://github.com/jvmgroup/redmine_xls_export/raw/master/config/locales/zh-TW.yml.

RE: XLS export plugin - Added by Andrey Bruggemann over 8 years ago

Portuguese(Brazil) translation

pt-BR.yml Magnifier - Portuguese(Brazil) translation (1.22 KB)

RE: XLS export plugin - Added by Eddy Edisys about 8 years ago

Hello,
I'm trying to install this wonderful plugin but when I use it, I've got an error 500.
I've installed Redmine v1.1.1 and the last version of xls export plugin.
In the redmine log, I've got this error :

Processing IssuesController#xls_export_action (for x.x.x.x at 2011-05-10 18:25:44) [POST]
Parameters: {"project_id"=>"xxxxx", "commit"=>"Export", "action"=>"xls_export_action", "authenticity_token"=>"xxxxxxxxxxxxxxxxxxx", "controller"=>"issues", "settings"=>{"export_name"=>"issues_export", "issues_limit"=>"0", "watchers"=>"1", "relations"=>"1", "time"=>"1", "description"=>"1", "group"=>"1", "query_columns_only"=>"1", "attachments"=>"1"}}

NoMethodError (undefined method `count' for #<Spreadsheet::Row:0x5fd9314>):
Rendering xxxxxxxxxxxx/public/500.html (500 Internal Server Error)

Does anybody have an idea ?
Thanks

RE: XLS export plugin - Added by Terence Mill about 8 years ago

Check if you installed gem "spreadsheet" sucessfully .

RE: XLS export plugin - Added by Eddy Edisys about 8 years ago

Thnak you for the reply but, yes I did. The 0.6.5.4 version.
By the way, I've installed Redmine on windows XP.
Any other idea ?

RE: XLS export plugin - Added by Tomasz Sawicki about 8 years ago

Polish translation.

pl.yml Magnifier - Polish translation for Redmine XLS Export plugin (1.25 KB)

RE: XLS export plugin - Added by Tomasz Sawicki about 8 years ago

Same error here:(

NoMethodError (undefined method `count' for #<Spreadsheet::Row:0x2b19d06f7a60>):
  /usr/lib/ruby/1.8/thread.rb:135:in `synchronize'
  thin (1.2.11) lib/thin/connection.rb:84:in `pre_process'
  thin (1.2.11) lib/thin/connection.rb:82:in `catch'
  thin (1.2.11) lib/thin/connection.rb:82:in `pre_process'
  thin (1.2.11) lib/thin/connection.rb:57:in `process'
  thin (1.2.11) lib/thin/connection.rb:42:in `receive_data'
  eventmachine (0.12.10) lib/eventmachine.rb:256:in `run_machine'
  eventmachine (0.12.10) lib/eventmachine.rb:256:in `run'
  thin (1.2.11) lib/thin/backends/base.rb:61:in `start'
  thin (1.2.11) lib/thin/server.rb:159:in `start'
  thin (1.2.11) lib/thin/controllers/controller.rb:86:in `start'
  thin (1.2.11) lib/thin/runner.rb:185:in `send'
  thin (1.2.11) lib/thin/runner.rb:185:in `run_command'
  thin (1.2.11) lib/thin/runner.rb:151:in `run!'
  thin (1.2.11) bin/thin:6
  /usr/bin/thin:19:in `load'
  /usr/bin/thin:19

Rendering /opt/redmine/public/500.html (500 Internal Server Error)

Versions:
redmine (1.1.3.stable.5761)
ruby (1.8.7)
actionmailer (2.3.5)
actionpack (2.3.5)
activerecord (2.3.5)
activeresource (2.3.5)
activesupport (2.3.5)
cgi_multipart_eof_fix (2.5.0)
coderay (0.9.8)
daemons (1.1.3)
eventmachine (0.12.10)
i18n (0.4.2)
pg (0.9.0)
rack (1.0.1)
rails (2.3.5)
rake (0.8.7)
ruby-ole (1.2.11.1)
spreadsheet (0.6.5.4)
thin (1.2.11)

RE: XLS export plugin - Added by Andreas Dijkman about 8 years ago

I've installed this plugin on a fresh 1.1.3-installation. However the plugin can't work together with the other plugin of the same developer, Extra query operators plugin. Has anybody else problems with this?

What I'm seeing is either one is working. Or the XLS-plugin or the Extra Query Options, but not both at the same time.

RE: XLS export plugin - Added by Alex A about 8 years ago

Excellent plugin, but wants one feature: make mark subissues like in html one. Author, is it possible?

RE: XLS export plugin - Added by Alex A about 8 years ago

Alex A wrote:

Excellent plugin, but wants one feature: make mark subissues like in html one. Author, is it possible?

This is a pacth file that mark subissues like in html.
To apply patch

cd redmine/vendor/plugins/redmine_xls_export/lib
patch xls_export.rb /path_to_the_patch_file/xls_export.rb.patch

RE: XLS export plugin - Added by Terence Mill about 8 years ago

Can u post a screenshot.. tx

RE: XLS export plugin - Added by Alex A about 8 years ago

Terence Mill wrote:

Can u post a screenshot.. tx

1.GIF (16.2 KB)

RE: XLS export plugin - Added by Alex A about 8 years ago

Another visrsion of my patch

1.GIF (11.2 KB)

xls_export.rb.patch Magnifier (1.22 KB)

RE: XLS export plugin - Added by Alex A about 8 years ago

sorry, the last patch doesn`t work correctly, it`s have a formatting problems

RE: XLS export plugin - Added by Alex A about 8 years ago

This is resolved patch #2

RE: XLS export plugin - Added by Terence Mill about 8 years ago

Its not working on redmine 1.1.2 and office 2010

show.png (40.3 KB)

RE: XLS export plugin - Added by Terence Mill about 8 years ago

Sory. this is too much pacthes now. Getting patch order errors..
Please post the whole file,s o we can test it

RE: XLS export plugin - Added by Alex A about 8 years ago

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

xls_export.rb Magnifier (9.72 KB)

RE: XLS export plugin - Added by Terence Mill about 8 years ago

Still not working .. Which excel version your are using?
Seems that that the only thing is doing, is that makuing the whole row fat

RE: XLS export plugin - Added by Alex A about 8 years ago

Tested on redmine 1.2, ms excel 2007, 2010, open office calc 3.
Do you have issues hierarchy on html issues list?

1 2 3 4 5 6 ... 12 (76-100/276)