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 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
RE: XLS export plugin - Added by Vitaly Klimov almost 14 years ago
Version 009. More sort order fixes.
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 over 13 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 over 13 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
RE: XLS export plugin - Added by Vitaly Klimov over 13 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.
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
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
- Added Bulgarian translation
- Fixed typos
- Added to plugin base - http://www.redmine.org/plugins/redmine_xls_export
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_actionActionView::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:19Rendering /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
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
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