XLS export plugin

Added by Vitaly Klimov almost 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 Tatsuya Saito over 5 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 5 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 5 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 5 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 5 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

vi.yml Magnifier (54.5 KB)

RE: XLS export plugin - Added by Tatsuya Saito almost 5 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 5 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)

Untitled2.png (9.91 KB)

Untitled.png (12.1 KB)

Untitled3.png (12.1 KB)

vi.yml Magnifier (54.5 KB)

RE: XLS export plugin - Added by Tatsuya Saito almost 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 years ago

Done, it'work well.
Thanks you very much

RE: XLS export plugin - Added by Vui ve nao almost 5 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 5 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 5 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 5 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 4 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 4 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 4 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 4 years ago

Please post a corresponding part of the production.log file.

1 ... 7 8 9 10 11 12 (201-225/276)