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 Tatsuya Saito over 11 years ago
Youssef Boujraf and Terence Mill,
Quick export problem is caused by conflicting of ruby zip library.
DMSF plugin needs 'zip', but XLS Export plugin needs 'rubyzip'.
Please check detail with following:
https://github.com/two-pack/redmine_xls_export/issues/15#issuecomment-15229376
I hope you will find it helpful.
RE: XLS export plugin - Added by Tatsuya Saito over 11 years ago
I checked this plugin on Redmine 2.3.0 and fixed some problem.
Please check following github if you need it:
https://github.com/two-pack/redmine_xls_export/tree/0.2.1.t2
And Redmine DSMF Plugin already uses 'rubyzip'. So above Quick button problem is resolved.
https://github.com/danmunn/redmine_dmsf
NOTE: https://github.com/danmunn/redmine_dmsf/pull/110
I hope you will find it helpful.
RE: XLS export plugin - Added by Vito Marolda over 11 years ago
Thank you for your great work!
I use this plugin rev. 0.2.1.t2 and I found an issue: I created a custom field for issues, which accepts multiple values.
But the exported column only shows one of the multiple values.
Can it be fixed?
RE: XLS export plugin - Added by Tatsuya Saito over 11 years ago
Vito Marolda,
Thanks report the issue. Please report the issue on the github.
https://github.com/two-pack/redmine_xls_export/issues
RE: XLS export plugin - Added by Doan Phuoc almost 11 years ago
hi all,
Environment:
Redmine version 2.3.3.stable
Ruby version 2.1.0-p-1 (2013-09-22) [x86_64-linux]
Rails version 3.2.13
Environment production
Database adapter Mysql2
Redmine plugins:
redmine_local_avatars 0.1.1
redmine_logs 0.0.5
redmine_plugin_views_revisions 0.0.1
When i install XLS export plugin , it's ok ! But when i pust button export xls ->
"Internal error
An error occurred on the page you were trying to access.
If you continue to experience problems please contact your Redmine administrator for assistance.
If you are the Redmine administrator, check your log files for details about the error.
Back"
Please help me fix it !
Thanks
RE: XLS export plugin - Added by Tatsuya Saito almost 11 years ago
Hi Doan Phuoc,
When i install XLS export plugin , it's ok ! But when i pust button export xls ->
Please more information:
1) Show your redmine log of the error if you can.
2) Show detail how to reprocedure.
RE: XLS export plugin - Added by Doan Phuoc almost 11 years ago
hi Tatsuya Saito
1.
LoadError (No such file to load -- spreadsheet): activesupport (3.2.13) lib/active_support/dependencies.rb:317:in `rescue in depend_on' activesupport (3.2.13) lib/active_support/dependencies.rb:312:in `depend_on' activesupport (3.2.13) lib/active_support/dependencies.rb:225:in `require_dependency' plugins/redmine_xls_export/app/controllers/xls_export_controller.rb:2:in `<top (required)>' activesupport (3.2.13) lib/active_support/dependencies.rb:251:in `require' activesupport (3.2.13) lib/active_support/dependencies.rb:251:in `block in require' activesupport (3.2.13) lib/active_support/dependencies.rb:236:in `load_dependency' activesupport (3.2.13) lib/active_support/dependencies.rb:251:in `require' activesupport (3.2.13) lib/active_support/dependencies.rb:359:in `require_or_load' activesupport (3.2.13) lib/active_support/dependencies.rb:502:in `load_missing_constant' activesupport (3.2.13) lib/active_support/dependencies.rb:192:in `block in const_missing' activesupport (3.2.13) lib/active_support/dependencies.rb:190:in `each' activesupport (3.2.13) lib/active_support/dependencies.rb:190:in `const_missing' activesupport (3.2.13) lib/active_support/inflector/methods.rb:230:in `block in constantize' activesupport (3.2.13) lib/active_support/inflector/methods.rb:229:in `each' activesupport (3.2.13) lib/active_support/inflector/methods.rb:229:in `constantize' activesupport (3.2.13) lib/active_support/dependencies.rb:554:in `get' actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:69:in `controller_reference' actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:54:in `controller' actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:32:in `call' journey (1.0.4) lib/journey/router.rb:68:in `block in call' journey (1.0.4) lib/journey/router.rb:56:in `each' journey (1.0.4) lib/journey/router.rb:56:in `call' actionpack (3.2.13) lib/action_dispatch/routing/route_set.rb:612:in `call' rack-openid (1.4.0) lib/rack/openid.rb:98:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call' rack (1.4.5) lib/rack/etag.rb:23:in `call' rack (1.4.5) lib/rack/conditionalget.rb:25:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/head.rb:14:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/params_parser.rb:21:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/flash.rb:242:in `call' rack (1.4.5) lib/rack/session/abstract/id.rb:210:in `context' rack (1.4.5) lib/rack/session/abstract/id.rb:205:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/cookies.rb:341:in `call' activerecord (3.2.13) lib/active_record/query_cache.rb:64:in `call' activerecord (3.2.13) lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/callbacks.rb:28:in `block in call' activesupport (3.2.13) lib/active_support/callbacks.rb:405:in `_run__3717129474147333754__call__1322722477505814967__callbacks' activesupport (3.2.13) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.13) lib/active_support/callbacks.rb:385:in `_run_call_callbacks' activesupport (3.2.13) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.13) lib/action_dispatch/middleware/callbacks.rb:27:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/remote_ip.rb:31:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' railties (3.2.13) lib/rails/rack/logger.rb:32:in `call_app' railties (3.2.13) lib/rails/rack/logger.rb:16:in `block in call' activesupport (3.2.13) lib/active_support/tagged_logging.rb:22:in `tagged' railties (3.2.13) lib/rails/rack/logger.rb:16:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/request_id.rb:22:in `call' rack (1.4.5) lib/rack/methodoverride.rb:21:in `call' rack (1.4.5) lib/rack/runtime.rb:17:in `call' activesupport (3.2.13) lib/active_support/cache/strategy/local_cache.rb:72:in `call' rack (1.4.5) lib/rack/lock.rb:15:in `call' actionpack (3.2.13) lib/action_dispatch/middleware/static.rb:63:in `call' rack-cache (1.2) lib/rack/cache/context.rb:136:in `forward' rack-cache (1.2) lib/rack/cache/context.rb:245:in `fetch' rack-cache (1.2) lib/rack/cache/context.rb:185:in `lookup' rack-cache (1.2) lib/rack/cache/context.rb:66:in `call!' rack-cache (1.2) lib/rack/cache/context.rb:51:in `call' railties (3.2.13) lib/rails/engine.rb:479:in `call' railties (3.2.13) lib/rails/application.rb:223:in `call' railties (3.2.13) lib/rails/railtie/configurable.rb:30:in `method_missing' passenger (4.0.20) lib/phusion_passenger/rack/thread_handler_extension.rb:77:in `process_request' passenger (4.0.20) lib/phusion_passenger/request_handler/thread_handler.rb:140:in `accept_and_process_next_request' passenger (4.0.20) lib/phusion_passenger/request_handler/thread_handler.rb:108:in `main_loop' passenger (4.0.20) lib/phusion_passenger/request_handler.rb:441:in `block (3 levels) in start_threads'
2.
spreadsheet (0.9.6)
rubyzip (1.1.0, 1.0.0)
Plugin views with revisions 0.0.1
xls_export.021.tgz
My language is vietnamese.
production (1).log (390 KB) production (1).log | |||
Untitled2.png (9.91 KB) Untitled2.png | |||
Untitled.png (12.1 KB) Untitled.png | |||
Untitled3.png (12.1 KB) Untitled3.png | |||
vi.yml (54.5 KB) vi.yml |
RE: XLS export plugin - Added by Tatsuya Saito almost 11 years ago
Doan Phuoc wrote:
1. attch file
Your environment is not correct because production(1).log has following line:
LoadError (No such file to load -- spreadsheet):
Could you re-install the plugin from github?
https://github.com/two-pack/redmine_xls_export
RE: XLS export plugin - Added by Doan Phuoc almost 11 years ago
Could you re-install the plugin from github? https://github.com/two-pack/redmine_xls_export
I'm try with version to 0.2.1.t5. fixes but my redmine can't start
Web application could not be started
log
Connecting to database specified by database.yml XLS export controller: rubyzip gem not available OpenIdAuthentication.store is nil. Using in-memory store. Creating scope :system. Overwriting existing method Enumeration.system. Creating scope :sorted. Overwriting existing method User.sorted.
RE: XLS export plugin - Added by Tatsuya Saito almost 11 years ago
Doan Phuoc wrote:
log
XLS export controller: rubyzip gem not available
Did you success to execute 'bundle install' ?
Could you show your installation log of the plugin?
RE: XLS export plugin - Added by Doan Phuoc almost 11 years ago
+++ bundle install complete
[root@redmine redmine]# bundle install The source :rubygems is deprecated because HTTP requests are insecure. Please change your source to 'https://rubygems.org' if possible, or 'http://rubygems.org' if not. Using rake (10.1.0) Using i18n (0.6.1) Using multi_json (1.8.2) Using activesupport (3.2.13) Using builder (3.0.0) Using activemodel (3.2.13) Using erubis (2.7.0) Using journey (1.0.4) Using rack (1.4.5) Using rack-cache (1.2) Using rack-test (0.6.2) Using hike (1.2.3) Using tilt (1.4.1) Using sprockets (2.2.2) Using actionpack (3.2.13) Using mime-types (1.25) Using polyglot (0.3.3) Using treetop (1.4.15) Using mail (2.5.4) Using actionmailer (3.2.13) Using arel (3.0.2) Using tzinfo (0.3.38) Using activerecord (3.2.13) Using activeresource (3.2.13) Using nokogiri (1.5.10) Using ffi (1.9.0) Using childprocess (0.3.9) Using rubyzip (1.0.0) Using websocket (1.0.7) Using selenium-webdriver (2.37.0) Using xpath (1.0.0) Using capybara (2.0.3) Using coderay (1.0.9) Using docile (1.1.1) Using rack-ssl (1.3.3) Using json (1.8.1) Using rdoc (3.12.2) Using thor (0.18.1) Using railties (3.2.13) Using jquery-rails (2.0.3) Using metaclass (0.0.1) Using mocha (0.13.3) Using mysql2 (0.3.13) Using net-ldap (0.3.1) Using ruby-openid (2.2.3) Using rack-openid (1.4.0) Using bundler (1.3.5) Using rails (3.2.13) Using rmagick (2.13.2) Using shoulda-context (1.0.2) Using shoulda-matchers (1.4.1) Using shoulda (3.3.2) Using simplecov-html (0.8.0) Using simplecov (0.8.2) Using simplecov-rcov (0.2.3) Using yard (0.8.7.2) Your bundle is complete! Use `bundle show [gemname]` to see where a bundled gem is installed.
Thanks
RE: XLS export plugin - Added by Tatsuya Saito almost 11 years ago
Doan Phuoc wrote:
+++ bundle install complete
[...]
Thanks
Do 'bundle install' in redmine_xls_export folder.
RE: XLS export plugin - Added by Doan Phuoc almost 11 years ago
[root@redmine plugins]# cd redmine_xls_export-features/ [root@redmine redmine_xls_export-features]# bundle install Fetching gem metadata from https://rubygems.org/......... Resolving dependencies... Using ruby-ole (1.2.11.7) Using rubyzip (1.1.0) Using spreadsheet (0.9.6) Using bundler (1.3.5) Your bundle is complete! Use `bundle show [gemname]` to see where a bundled gem is installed. [root@redmine redmine_xls_export-features]# rake redmine:plugins:migrate RAILS_ENV=production (in /var/www/redmine) Migrating redmine_local_avatars (Redmine Local Avatars plugin)... Migrating redmine_logs (Redmine Logs plugin)... Migrating redmine_plugin_views_revisions (Redmine plugin views revisions plugin)... Migrating redmine_xls_export-features (Issues XLS export)... [root@redmine redmine_xls_export-features]# service httpd restart Stopping httpd: [ OK ] Starting httpd: [ OK ] [root@redmine redmine_xls_export-features]#
+++log
Creating scope :system. Overwriting existing method Enumeration.system. Creating scope :sorted. Overwriting existing method User.sorted. Connecting to database specified by database.yml XLS export controller: rubyzip gem not available OpenIdAuthentication.store is nil. Using in-memory store. Creating scope :system. Overwriting existing method Enumeration.system. Creating scope :sorted. Overwriting existing method User.sorted.
Redmine can't start
i'm using redmine_xls_export-features
RE: XLS export plugin - Added by Tatsuya Saito almost 11 years ago
Doan Phuoc wrote:
Redmine can't start
i'm using redmine_xls_export-features
Rename 'redmine_xls_export-features' to 'redmine_xls_export'.
By the way, Can you start redmine without redmine_xls_export?
RE: XLS export plugin - Added by Doan Phuoc almost 11 years ago
1.
Rename 'redmine_xls_export-features' to 'redmine_xls_export'.
Yes,redmine can run. I can use "Quick Export" xls but I can config in Administrator and Detailed XLS.
Error
404 The page you were trying to access doesn't exist or has been removed.
+++ log
Connecting to database specified by database.yml XLS export controller: rubyzip gem not available OpenIdAuthentication.store is nil. Using in-memory store. Creating scope :system. Overwriting existing method Enumeration.system. Creating scope :sorted. Overwriting existing method User.sorted. Creating scope :sorted. Overwriting existing method Group.sorted. Started GET "/settings/plugin/redmine_xls_export" for 192.168.68.18 at 2013-11-13 05:51:06 +0700 Processing by SettingsController#plugin as HTML Parameters: {"id"=>"redmine_xls_export"} Current user: admin (id=1) Rendered settings/plugin.html.erb within layouts/admin (35.8ms) Missing template, responding with 404 Rendered common/error.html.erb within layouts/base (0.7ms) Completed 404 Not Found in 181ms (Views: 54.4ms | ActiveRecord: 4.9ms)
2.
By the way, Can you start redmine without redmine_xls_export?
Yes
Thanks for support Tatsuya Saito
RE: XLS export plugin - Added by Tatsuya Saito almost 11 years ago
Doan Phuoc wrote:
1.
[...]Yes,redmine can run. I can use "Quick Export" xls but I can config in Administrator and Detailed XLS.
Re-run following rake command:
rake redmine:plugins:process_version_change RAILS_ENV=production
RE: XLS export plugin - Added by Doan Phuoc almost 11 years ago
Done, it'work well.
Thanks you very much
RE: XLS export plugin - Added by Vui ve nao almost 11 years ago
I used Bitnami Redmine 2.4.2, here 's my environment:
Environment:
Redmine version 2.4.2.stable
Ruby version 1.9.3-p231 (2012-05-25) [i386-mingw32]
Rails version 3.2.16
But when installed XLS export, click to Quick button, the redmine say:
"Internal error
An error occurred on the page you were trying to access."
Please help me to fix it! THanks!
RE: XLS export plugin - Added by Tatsuya Saito almost 11 years ago
Vui ve nao wrote:
But when installed XLS export, click to Quick button, the redmine say:
"Internal error
An error occurred on the page you were trying to access."
Please check your redmine log of this error and show it if you can.
RE: XLS export plugin - Added by jose ba almost 11 years ago
is it possible to extend the projects right bottom side(where atom is) to list every project?
RE: XLS export plugin - Added by Tatsuya Saito almost 11 years ago
jose ba wrote:
is it possible to extend the projects right bottom side(where atom is) to list every project?
I don't understand what you want.
Please tell more details.
RE: XLS export plugin - Added by Lajish Lakshmanan over 10 years ago
Can somebody please update this plugin for compatible with 2.4 and 2.5 version.
RE: XLS export plugin - Added by Karel Pičman over 10 years ago
Why do you think that it is incompatibile? I run the version 0.2.1.t3 in both 2.4 and 2.5 versions without any problems.
RE: XLS export plugin - Added by Lajish Lakshmanan over 10 years ago
Karel Pičman wrote:
Why do you think that it is incompatibile? I run the version 0.2.1.t3 in both 2.4 and 2.5 versions without any problems.
Hi Karel Pičman,
Thanks for replying it. Actually I am a newbie, using redmine in windows via Bitnami distribution. The error message which I am getting is
"Internal error
An error occurred on the page you were trying to access.
If you continue to experience problems please contact your Redmine administrator for assistance.
If you are the Redmine administrator, check your log files for details about the error.
Back"
Can you please help me to sort out this problem.
RE: XLS export plugin - Added by Karel Pičman over 10 years ago
Please post a corresponding part of the production.log file.