Project

General

Profile

Forums » Plugins »

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

  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)
redmine_xls_export_v003.zip (17.9 KB) redmine_xls_export_v003.zip

Replies (276)

RE: XLS export plugin - Added by Sergey Pavlenko almost 14 years ago

Thanks! Upgrade to 1.8.7 realy solved this problem!

RE: XLS export plugin - Added by Vitaly Klimov almost 14 years ago

Attached please find version 008 of the plugin.

Redmine versions prior to 1.0.1: attachment#redmine_xls_export_v008_before_101.zip
Redmine version 1.0.1 and higher: attachment#redmine_xls_export_v008_101_only.zip

Changes:

  • German translation added (thanks to Terence Mill)
  • Russian translation added (thanks to Alexander Sapozhnikov)
  • Sort order now favored for exports from 'XLS+' page
  • Minor export bugfixes
Download all files
redmine_xls_export_v008_101_only.zip (21.3 KB) redmine_xls_export_v008_101_only.zip
redmine_xls_export_v008_before_101.zip (21.2 KB) redmine_xls_export_v008_before_101.zip

RE: XLS export plugin - Added by Terence Mill almost 14 years ago

Bug-Report:

When using group (eg. per project) function and exorting, i only get the tickets from the first group, but no more.

RE: XLS export plugin - Added by Felix Friedrich almost 14 years ago

Hello,

I have a small problem with the plugin. I have a role defined, which is not allowd to see the spent time on tickets. But if I make an xls export of a list of tickets there is a column with the spent time, thus a person who is not allowed to see the spent time can manage to see it by exporting list of tickets to a xls file.

Would it be possible to implement this kind of permissions?

Best regards...

Felix

RE: XLS export plugin - Added by Mihail Mustafin almost 14 years ago

Hi, Vitaly! I recently switched to Redmine 1.0.3 ruby version 1.8.7. XLS export plugin version 009 (and earlier) shows Internal error when trying to upload the report. Please tell me that this can be done?
Have you thought about extending the plugin to the list of projects?
Thank you.
Привет, Виталий! Я недавно перешел на Redmine 1.0.3 ruby version 1.8.7. XLS export plugin version 009 (и ранние версии) показывает Internal error при попытке выгрузить отчет. Пожалуйста, подскажите что с этим можно сделать?
Вы не думали о распространении действия плагина на список проектов ?
спасибо вам.

RE: XLS export plugin - Added by Vitaly Klimov almost 14 years ago

I have a role defined, which is not allowd to see the spent time on tickets. But if I make an xls export of a list of tickets there is a column with the spent time, thus a person who is not allowed to see the spent time can manage to see it by exporting list of tickets to a xls file.

Felix, i do check for permission when exporting time entries, thus if the person which does not have permission to view time entries on the project tries to export time column, that column would be empty.

XLS export plugin version 009 (and earlier) shows Internal error when trying to upload the report.

Mihail, are you using proper version of 009 plugin (redmine_xls_export_v009_101_only.zip)? If so, can you please post me logs with Internal error so i will be able to see what's going on?

When using group (eg. per project) function and exorting, i only get the tickets from the first group, but no more

Terrence, can you check if you have option Split by grouping criteria enabled? In this case each group will be in the separate XLS sheet inside file

RE: XLS export plugin - Added by Mihail Mustafin almost 14 years ago

Vitaly Klimov wrote:

Mihail, are you using proper version of 009 plugin (redmine_xls_export_v009_101_only.zip)? If so, can you please post me logs with Internal error so i will be able to see what's going on?

redmine_xls_export_v009_101_only.zip

Processing IssuesController#index to xls (for 192.168.15.85 at 2010-11-23 14:38:08) [GET]
Parameters: {"format"=>"xls", "action"=>"index", "controller"=>"issues"}
Iconv::InvalidCharacter ("\320"):
spreadsheet (0.6.4.1) lib/spreadsheet/encodings.rb:29:in `iconv'
spreadsheet (0.6.4.1) lib/spreadsheet/encodings.rb:29:in `internal'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/biff8.rb:43:in `_unicode_string'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:508:in `_write_sst'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:502:in `each'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:502:in `each_with_index'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:502:in `_write_sst'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:489:in `write_sst'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:439:in `write_from_scratch'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:620:in `write_workbook'
spreadsheet (0.6.4.1) lib/spreadsheet/writer.rb:12:in `write'
spreadsheet (0.6.4.1) lib/spreadsheet/workbook.rb:106:in `write'

Rendering C:/bitnami2/apps/redmine/public/500.html (500 Internal Server Error)

RE: XLS export plugin - Added by Terence Mill almost 14 years ago

Terrence, can you check if you have option Split by grouping criteria enabled? In this case each group will be in the separate XLS sheet inside file

I just noticed that the group feature is done by seperating on sheets in one excel file. I overlooked thios the first time. So there is no bug, its perfectly working! Tx for help!

RE: XLS export plugin - Added by Terence Mill almost 14 years ago

BUG Report

Redmine 1.01 and Plugin Version 0.0.9

When i click XLS+ in Issue List, e.g /projects/spielwiese/issues/xls_export_action i get a Internal Error and this log entries:
BTw. does this plugin has github or other source repository?

ActionView::TemplateError (undefined local variable or method `xlse_list_of_columns'

ActionView::TemplateError (undefined local variable or method `xlse_list_of_columns' for #<ActionView::Base:0x7fe1108236d0>) on line #3 of vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:
1: 
2: <% fields_all = [] %>
3: <% fields_all << xlse_list_of_columns %>
4: <% fields_all << xlse_list_of_options %>
5: <% fields_all.each do |c|%>
6:     <div class="box tabular">

    vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:3
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:9:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:7:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    passenger (2.2.14) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
    passenger (2.2.14) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:441:in `start_request_handler'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:381:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/utils.rb:252:in `safe_fork'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:377:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:163:in `start'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:222:in `start'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

RE: XLS export plugin - Added by Lubor Nosek almost 14 years ago

I've created Czech locale, find it attached to this post.

Thanks for a good plugin. Would you consider putting it into official Redmine plugin repository?

Best Regards,
Lubor Nosek

cs.yml (867 Bytes) cs.yml

RE: XLS export plugin - Added by Vitaly Klimov almost 14 years ago

Lubor Nosek wrote:

I've created Czech locale, find it attached to this post.

Thanks!

Thanks for a good plugin. Would you consider putting it into official Redmine plugin repository?

Sure, no problem - just tell me how to do it. I've asked Jean-Philippe about the way one can get theirs plugins listed on plugins page some time ago, but got no answer so far.

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

Version 0.1.0

  • From now on plugin compatible only with Redmine 1.0.1 or higher.
  • Links to XLS export moved to issues index hook so index.rhtml not modified by plugin, thus removing conflicts with plugins which modified index.rhtml.
  • Plugin adds two links with 'XLS export' prefix at the bottom of the page under 'Also available in' bar.
redmine_xls_export_v010.zip (23 KB) redmine_xls_export_v010.zip

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

Hi,

I am translating the plugin to Bulgarian. What is the meaning of

label_plugin_xlse_issues_limit: "Overwrite export limit"
and what is the context it is used in?
Ivan

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

Ivan Cenov wrote:

I am translating the plugin to Bulgarian. What is the meaning of
[...] and what is the context it is used in?

There is a global setting in Redmine which controls how many issues you can export at once. This option allows you override this value.

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

Here is attached Bulgarian translation.

P.S. en.yml. What about

label_plugin_xlse_issues_limit: "Overwrite export limit"
compared to
label_plugin_xlse_issues_limit: "Override export limit"
?
I think the latter is more suitable, by my opinion.

Regards,
Ivan

bg.yml (1.69 KB) bg.yml

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

Ivan Cenov wrote:

Here is attached Bulgarian translation.

Thank you

I think the latter is more suitable, by my opinion.

Yes, you are right i fixed it.

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

Version 0.1.1

redmine_xls_export_v011.zip (23.8 KB) redmine_xls_export_v011.zip

Have a BUG - Added by Konstantin Rudenkov over 13 years ago

@Processing IssuesController#xls_export_action (for 89.175.182.222 at 2011-02-08 12:01:05) [GET]
Parameters: {"project_id"=>"allprojects", "action"=>"xls_export_action", "controller"=>"issues"}
SQL (0.5ms) SELECT max("settings".updated_on) AS max_updated_on FROM "settings"
User Load (0.9ms) SELECT * FROM "users" WHERE ("users"."id" = 3) AND (users.status = 1) AND ( ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) )
Project Load (0.5ms) SELECT * FROM "projects" WHERE ("projects"."identifier" = E'allprojects') LIMIT 1
EnabledModule Load (0.4ms) SELECT name FROM "enabled_modules" WHERE ("enabled_modules".project_id = 10)
Setting Load (0.2ms) SELECT * FROM "settings" WHERE ("settings"."name" = E'plugin_redmine_xls_export') LIMIT 1
Rendering template within layouts/base
Rendering issues/xls_export_action

ActionView::TemplateError (undefined local variable or method `xlse_list_of_columns' for #<ActionView::Base:0x7f8c988253a8>) on line #3 of vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:
1:
2: <% fields_all = [] >
3: < fields_all << xlse_list_of_columns >
4: < fields_all << xlse_list_of_options >
5: < fields_all.each do |c|%>
6: <div class="box tabular">

vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:3
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:9:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:7:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    thin (1.2.7) lib/thin/connection.rb:76:in `pre_process'
    thin (1.2.7) lib/thin/connection.rb:74:in `catch'
    thin (1.2.7) lib/thin/connection.rb:74:in `pre_process'
    thin (1.2.7) lib/thin/connection.rb:57:in `process'
    thin (1.2.7) 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.7) lib/thin/backends/base.rb:57:in `start'
    thin (1.2.7) lib/thin/server.rb:156:in `start'
    thin (1.2.7) lib/thin/controllers/controller.rb:80:in `start'
    thin (1.2.7) lib/thin/runner.rb:177:in `send'
    thin (1.2.7) lib/thin/runner.rb:177:in `run_command'
    thin (1.2.7) lib/thin/runner.rb:143:in `run!'
    thin (1.2.7) bin/thin:6
    /usr/bin/thin:19:in `load'
    /usr/bin/thin:19

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

This error appeared after trying to make a "detailed export" all my issues.

RE: Have a BUG - Added by Konstantin Rudenkov over 13 years ago

Konstantin Rudenkov wrote:

@Processing IssuesController#xls_export_action (for 89.175.182.222 at 2011-02-08 12:01:05) [GET]
Parameters: {"project_id"=>"allprojects", "action"=>"xls_export_action", "controller"=>"issues"}
SQL (0.5ms) SELECT max("settings".updated_on) AS max_updated_on FROM "settings"
User Load (0.9ms) SELECT * FROM "users" WHERE ("users"."id" = 3) AND (users.status = 1) AND ( ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) )
Project Load (0.5ms) SELECT * FROM "projects" WHERE ("projects"."identifier" = E'allprojects') LIMIT 1
EnabledModule Load (0.4ms) SELECT name FROM "enabled_modules" WHERE ("enabled_modules".project_id = 10)
Setting Load (0.2ms) SELECT * FROM "settings" WHERE ("settings"."name" = E'plugin_redmine_xls_export') LIMIT 1
Rendering template within layouts/base
Rendering issues/xls_export_action

ActionView::TemplateError (undefined local variable or method `xlse_list_of_columns' for #<ActionView::Base:0x7f8c988253a8>) on line #3 of vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:
1:
2: <% fields_all = [] >
3: < fields_all << xlse_list_of_columns >
4: < fields_all << xlse_list_of_options >
5: < fields_all.each do |c|%>
6: <div class="box tabular">

vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:3
vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:9:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:7:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
thin (1.2.7) lib/thin/connection.rb:76:in `pre_process'
thin (1.2.7) lib/thin/connection.rb:74:in `catch'
thin (1.2.7) lib/thin/connection.rb:74:in `pre_process'
thin (1.2.7) lib/thin/connection.rb:57:in `process'
thin (1.2.7) 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.7) lib/thin/backends/base.rb:57:in `start'
thin (1.2.7) lib/thin/server.rb:156:in `start'
thin (1.2.7) lib/thin/controllers/controller.rb:80:in `start'
thin (1.2.7) lib/thin/runner.rb:177:in `send'
thin (1.2.7) lib/thin/runner.rb:177:in `run_command'
thin (1.2.7) lib/thin/runner.rb:143:in `run!'
thin (1.2.7) bin/thin:6
/usr/bin/thin:19:in `load'
/usr/bin/thin:19

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

This error appeared after trying to make a "detailed export" all my issues.

I use last version, 011

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

Updates german translation for 0.1.1

de.yml (1.19 KB) de.yml

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

some fixes

de.yml (1.19 KB) de.yml

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

BUG Report for 0.1.1

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

# Logfile created on Tue Feb 08 12:32:15 +0100 2011
ActionView::TemplateError (undefined local variable or method `xlse_list_of_columns' for #<ActionView::Base:0x7fa6d68bc200>) on line #3 of vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:
1: 
2: <% fields_all = [] %>
3: <% fields_all << xlse_list_of_columns %>
4: <% fields_all << xlse_list_of_options %>
5: <% fields_all.each do |c|%>
6:     <div class="box tabular">

    vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:3
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:9:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:7:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    passenger (2.2.14) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
    passenger (2.2.14) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:441:in `start_request_handler'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:381:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/utils.rb:252:in `safe_fork'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:377:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:163:in `start'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:222:in `start'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

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

Version 0.1.2

  • DE translation updated
  • Hopefully fixed bug with 'xlse_list_of_columns' variable (obsolete helpers removed)

IMPORTANT! Please remove whole redmine_xls_export folder before unpacking new version, since this version have some old files removed

redmine_xls_export_v012.zip (23 KB) redmine_xls_export_v012.zip

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

Hi,

The plugin page is not updated, 0.1.1 is there. http://www.redmine.org/plugins/redmine_xls_export

(51-75/276)