Project

General

Profile

XLS export plugin

Added by Vitaly Klimov about 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)

Replies (276)

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

Plugin updated.

New and updated features include:

  • Rails 3 (Redmine 2.x.x) compatibility added
  • Controller completely rewritten - no more IssuesController monkey-patch
  • Journal entries could be exported as well
  • Ability to export journal entries in separate files, one per each issue
  • Ability to export attachments in ZIP file
  • Ability to set start offset for export

RE: XLS export plugin - Added by Steven Wong over 11 years ago

Hi, Vitaly Klimov

I tested it on Redmine 2.0.3 and something wrong.

the error information is :

Started GET "/projects/upnp/issues_xls_export" for 192.168.3.139 at Mon Jun 25 17:10:21 +0800 2012
Processing by XlsExportController#index as HTML
  Parameters: {"project_id"=>"upnp"}
Completed 500 Internal Server Error in 39ms

ActionView::MissingTemplate (Missing template xls_export/index, application/index with {:locale=>[:zh, :en], :formats=>[:html], :handlers=>[:rjs, :rsb, :builder, :erb]}. Searched in:
  * "/usr/local/redmine-2.0/plugins/redmine_xls_export/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_work_time/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_reorder_links_arbitrary/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_projects_accordion/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_private_wiki/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_preview_attach_column/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_parallel_issue/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_my_roadmaps/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_multiple_files_upload/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_monitoring_controlling/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_logs/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_lightbox/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_knowledgebase/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_issue_history_tabs/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_inline_attach_screenshot/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_incr_code_search/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_favourite_projects/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_code_review/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_ckeditor/app/views" 
  * "/usr/local/redmine-2.0/plugins/redmine_attachments_size/app/views" 
  * "/usr/local/redmine-2.0/app/views" 
):
  actionpack (3.2.6) lib/action_view/path_set.rb:58:in `find'
  actionpack (3.2.6) lib/action_view/lookup_context.rb:109:in `find_template'
  actionpack (3.2.6) lib/action_view/renderer/abstract_renderer.rb:3:in `__send__'
  actionpack (3.2.6) lib/action_view/renderer/abstract_renderer.rb:3:in `find_template'
  actionpack (3.2.6) lib/action_view/renderer/template_renderer.rb:34:in `determine_template'
  actionpack (3.2.6) lib/action_view/renderer/template_renderer.rb:10:in `render'
  actionpack (3.2.6) lib/action_view/renderer/renderer.rb:36:in `render_template'
  actionpack (3.2.6) lib/action_view/renderer/renderer.rb:17:in `render'
  actionpack (3.2.6) lib/abstract_controller/rendering.rb:110:in `_render_template'
  actionpack (3.2.6) lib/action_controller/metal/streaming.rb:225:in `_render_template'
  actionpack (3.2.6) lib/abstract_controller/rendering.rb:103:in `render_to_body'
  actionpack (3.2.6) lib/action_controller/metal/renderers.rb:28:in `render_to_body'
  actionpack (3.2.6) lib/action_controller/metal/compatibility.rb:50:in `render_to_body'
  actionpack (3.2.6) lib/abstract_controller/rendering.rb:88:in `render'
  actionpack (3.2.6) lib/action_controller/metal/rendering.rb:16:in `render'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:40:in `render'
  activesupport (3.2.6) lib/active_support/core_ext/benchmark.rb:5:in `ms'
  /usr/local/ruby/lib/ruby/1.8/benchmark.rb:308:in `realtime'
  activesupport (3.2.6) lib/active_support/core_ext/benchmark.rb:5:in `ms'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:40:in `render'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:83:in `cleanup_view_runtime'
  activerecord (3.2.6) lib/active_record/railties/controller_runtime.rb:24:in `cleanup_view_runtime'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:39:in `render'
  actionpack (3.2.6) lib/action_controller/metal/implicit_render.rb:10:in `default_render'
  actionpack (3.2.6) lib/action_controller/metal/implicit_render.rb:5:in `send_action'
  actionpack (3.2.6) lib/abstract_controller/base.rb:167:in `process_action'
  actionpack (3.2.6) lib/action_controller/metal/rendering.rb:10:in `process_action'
  actionpack (3.2.6) lib/abstract_controller/callbacks.rb:18:in `process_action'
  activesupport (3.2.6) lib/active_support/callbacks.rb:458:in `_run__32250161__process_action__199225275__callbacks'
  activesupport (3.2.6) lib/active_support/callbacks.rb:405:in `send'
  activesupport (3.2.6) lib/active_support/callbacks.rb:405:in `__run_callback'
  activesupport (3.2.6) lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks'
  activesupport (3.2.6) lib/active_support/callbacks.rb:81:in `send'
  activesupport (3.2.6) lib/active_support/callbacks.rb:81:in `run_callbacks'
  actionpack (3.2.6) lib/abstract_controller/callbacks.rb:17:in `process_action'
  actionpack (3.2.6) lib/action_controller/metal/rescue.rb:29:in `process_action'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:30:in `process_action'
  activesupport (3.2.6) lib/active_support/notifications.rb:123:in `instrument'
  activesupport (3.2.6) lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  activesupport (3.2.6) lib/active_support/notifications.rb:123:in `instrument'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:29:in `process_action'
  actionpack (3.2.6) lib/action_controller/metal/params_wrapper.rb:206:in `process_action'
  activerecord (3.2.6) lib/active_record/railties/controller_runtime.rb:18:in `process_action'
  actionpack (3.2.6) lib/abstract_controller/base.rb:121:in `process'
  actionpack (3.2.6) lib/abstract_controller/rendering.rb:45:in `process'
  actionpack (3.2.6) lib/action_controller/metal.rb:203:in `dispatch'
  actionpack (3.2.6) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
  actionpack (3.2.6) lib/action_controller/metal.rb:246:in `action'
  actionpack (3.2.6) lib/action_dispatch/routing/route_set.rb:73:in `call'
  actionpack (3.2.6) lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
  actionpack (3.2.6) lib/action_dispatch/routing/route_set.rb:36:in `call'
  journey (1.0.4) lib/journey/router.rb:68: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.6) lib/action_dispatch/routing/route_set.rb:600:in `call'
  rack-openid (1.3.1) lib/rack/openid.rb:98:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
  rack (1.4.1) lib/rack/etag.rb:23:in `call'
  rack (1.4.1) lib/rack/conditionalget.rb:25:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/head.rb:14:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/params_parser.rb:21:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/flash.rb:242:in `call'
  rack (1.4.1) lib/rack/session/abstract/id.rb:205:in `context'
  rack (1.4.1) lib/rack/session/abstract/id.rb:200:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/cookies.rb:338:in `call'
  activerecord (3.2.6) lib/active_record/query_cache.rb:64:in `call'
  activerecord (3.2.6) lib/active_record/connection_adapters/abstract/connection_pool.rb:473:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/callbacks.rb:28:in `call'
  activesupport (3.2.6) lib/active_support/callbacks.rb:405:in `_run__397314981__call__4__callbacks'
  activesupport (3.2.6) lib/active_support/callbacks.rb:405:in `send'
  activesupport (3.2.6) lib/active_support/callbacks.rb:405:in `__run_callback'
  activesupport (3.2.6) lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
  activesupport (3.2.6) lib/active_support/callbacks.rb:81:in `send'
  activesupport (3.2.6) lib/active_support/callbacks.rb:81:in `run_callbacks'
  actionpack (3.2.6) lib/action_dispatch/middleware/callbacks.rb:27:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
  railties (3.2.6) lib/rails/rack/logger.rb:26:in `call_app'
  railties (3.2.6) lib/rails/rack/logger.rb:16:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/request_id.rb:22:in `call'
  rack (1.4.1) lib/rack/methodoverride.rb:21:in `call'
  rack (1.4.1) lib/rack/runtime.rb:17:in `call'
  activesupport (3.2.6) lib/active_support/cache/strategy/local_cache.rb:72:in `call'
  rack (1.4.1) lib/rack/lock.rb:15:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/static.rb:62: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.6) lib/rails/engine.rb:479:in `call'
  railties (3.2.6) lib/rails/application.rb:220:in `call'
  rack (1.4.1) lib/rack/content_length.rb:14:in `call'
  railties (3.2.6) lib/rails/rack/log_tailer.rb:17:in `call'
  rack (1.4.1) lib/rack/handler/webrick.rb:59:in `service'
  /usr/local/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
  /usr/local/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
  /usr/local/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
  /usr/local/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start'
  /usr/local/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
  /usr/local/ruby/lib/ruby/1.8/webrick/server.rb:95:in `start'
  /usr/local/ruby/lib/ruby/1.8/webrick/server.rb:92:in `each'
  /usr/local/ruby/lib/ruby/1.8/webrick/server.rb:92:in `start'
  /usr/local/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start'
  /usr/local/ruby/lib/ruby/1.8/webrick/server.rb:82:in `start'
  rack (1.4.1) lib/rack/handler/webrick.rb:13:in `run'
  rack (1.4.1) lib/rack/server.rb:265:in `start'
  railties (3.2.6) lib/rails/commands/server.rb:70:in `start'
  railties (3.2.6) lib/rails/commands.rb:55
  railties (3.2.6) lib/rails/commands.rb:50:in `tap'
  railties (3.2.6) lib/rails/commands.rb:50
  script/rails:6:in `require'
  script/rails:6

Vitaly Klimov wrote:

Plugin updated.

New and updated features include:

  • Rails 3 (Redmine 2.x.x) compatibility added
  • Controller completely rewritten - no more IssuesController monkey-patch
  • Journal entries could be exported as well
  • Ability to export journal entries in separate files, one per each issue
  • Ability to export attachments in ZIP file
  • Ability to set start offset for export

RE: XLS export plugin - Added by Steven Wong over 11 years ago

I run the rake command ag and found another problem

when I choose the configuration to export the issues, the error information is

Started POST "/projects/upnn/issues_xls_export" for 192.168.3.139 at Mon Jun 25 17:20:33 +0800 2012
Processing by XlsExportController#index as HTML
  Parameters: {"commit"=>"export", "project_id"=>"upnn", "authenticity_token"=>"c8qQ2hAj6zP/8C3ztrjVdcXOJdBLoJbcX6blmf3y5ds=", "utf8"=>"✓", "issues_export_offset"=>"0", "settings"=>{"relations"=>"1", "issues_limit"=>"0", "export_name"=>"issues_export", "watchers"=>"1", "journal"=>"1", "time"=>"1", "description"=>"1", "generate_name"=>"1", "attachments"=>"1"}}
Completed 500 Internal Server Error in 289ms

NoMethodError (undefined method `show_value' for #<XlsExportController:0xb60f1ed0>):
  app/models/user.rb:202:in `each_with_index'

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

Please download and try to export again - i fixed this issue and reuploaded the archive

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

Is it dowwards compatible to redmine 1.3 and 1.4 ?

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

Terence Mill wrote:

Is it dowwards compatible to redmine 1.3 and 1.4 ?

Yep

RE: XLS export plugin - Added by Steven Wong over 11 years ago

Hi, Vitaly Klimov

It seems still have some issue not fixed.
when I want to export with journal entries, the error information is

Started POST "/projects/upnp/issues_xls_export" for 192.168.3.139 at Tue Jun 26 09:50:42 +0800 2012
Processing by XlsExportController#index as HTML
  Parameters: {"commit"=>"export", "project_id"=>"upnp", "authenticity_token"=>"m0p7GWZPPCFWFPOqDH/mqXobtrOsNCBiJWzvfZenU0k=", "utf8"=>"✓", "issues_export_offset"=>"0", "settings"=>{"relations"=>"1", "issues_limit"=>"0", "export_name"=>"issues_export", "journal"=>"1", "separate_journals"=>"1", "description"=>"1", "generate_name"=>"1"}}
Completed 500 Internal Server Error in 406ms

NoMethodError (undefined method `format_value' for #<XLS_JournalQueryColumn:0xb6288294>):
  app/helpers/issues_helper.rb:235:in `show_detail'
  app/models/user.rb:202:in `each_with_index'

Vitaly Klimov wrote:

Please download and try to export again - i fixed this issue and reuploaded the archive

RE: XLS export plugin - Added by Steven Wong over 11 years ago

Hi, Vitaly Klimov

I've updated the newest zh.yml for 0.2.0.

please check it. thanks.

zh.yml (1.6 KB) zh.yml zh.yml for 0.2.0 2012-06-25

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

Hi, Vitaly Klimov

Thnak you for your working.
I've updated the newest ja.yml for 0.2.0.

Thanks.

Vitaly Klimov wrote:

Plugin updated.

...

ja.yml (1.79 KB) ja.yml Japanese translation for 0.2.0

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

Steven Wong wrote:

Hi, Vitaly Klimov

It seems still have some issue not fixed.
when I want to export with journal entries, the error information is

Please check latest version 0.2.1 which i uploaded right now to plugin page.

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

Redmine 2.0.3
Ruby 1.9.3
Rails 2.3.6
I got Internal error when pressed on "Detailed" link under the issues list. Here is the log:

Started GET "/issues_xls_export" for 192.168.20.9 at 2012-07-05 18:08:52 +0300
Processing by XlsExportController#index as HTML
Completed 500 Internal Server Error in 411ms

ActionView::MissingTemplate (Missing template xls_export/index, application/index with {:locale=>[:en], :formats=>[:html], :handlers=>[:erb, :builder, :rsb, :rjs]}. Searched in:
  * "D:/apps/redmine/plugins/wiking/app/views" 
  * "D:/apps/redmine/plugins/redmine_xls_export/app/views" 
  * "D:/apps/redmine/plugins/redmine_theme_changer/app/views" 
  * "D:/apps/redmine/app/views" 
):
  actionpack (3.2.6) lib/action_view/path_set.rb:58:in `find'
  actionpack (3.2.6) lib/action_view/lookup_context.rb:109:in `find'
  C:in `find_template'
  actionpack (3.2.6) lib/action_view/renderer/template_renderer.rb:34:in `determine_template'
  actionpack (3.2.6) lib/action_view/renderer/template_renderer.rb:10:in `render'
  actionpack (3.2.6) lib/action_view/renderer/renderer.rb:36:in `render_template'
  actionpack (3.2.6) lib/action_view/renderer/renderer.rb:17:in `render'
  actionpack (3.2.6) lib/abstract_controller/rendering.rb:110:in `_render_template'
  actionpack (3.2.6) lib/action_controller/metal/streaming.rb:225:in `_render_template'
  actionpack (3.2.6) lib/abstract_controller/rendering.rb:103:in `render_to_body
'
  actionpack (3.2.6) lib/action_controller/metal/renderers.rb:28:in `render_to_b
ody'
  actionpack (3.2.6) lib/action_controller/metal/compatibility.rb:50:in `render_
to_body'
  actionpack (3.2.6) lib/abstract_controller/rendering.rb:88:in `render'
  actionpack (3.2.6) lib/action_controller/metal/rendering.rb:16:in `render'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:40:in `block
 (2 levels) in render'
  activesupport (3.2.6) lib/active_support/core_ext/benchmark.rb:5:in `block in ms'  C:/Ruby193/lib/ruby/1.9.1/benchmark.rb:295:in `realtime'
  activesupport (3.2.6) lib/active_support/core_ext/benchmark.rb:5:in `ms'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:40:in `block in render'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:83:in `cleanup_view_runtime'
  activerecord (3.2.6) lib/active_record/railties/controller_runtime.rb:24:in `cleanup_view_runtime'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:39:in `render'
  actionpack (3.2.6) lib/action_controller/metal/implicit_render.rb:10:in `default_render'
  actionpack (3.2.6) lib/action_controller/metal/implicit_render.rb:5:in `send_action'
  actionpack (3.2.6) lib/abstract_controller/base.rb:167:in `process_action'
  actionpack (3.2.6) lib/action_controller/metal/rendering.rb:10:in `process_action'
  actionpack (3.2.6) lib/abstract_controller/callbacks.rb:18:in `block in process_action'
  activesupport (3.2.6) lib/active_support/callbacks.rb:458:in `_run__1051411189
__process_action__525044979__callbacks'
  activesupport (3.2.6) lib/active_support/callbacks.rb:405:in `__run_callback'
  activesupport (3.2.6) lib/active_support/callbacks.rb:385:in `_run_process_act
ion_callbacks'
  activesupport (3.2.6) lib/active_support/callbacks.rb:81:in `run_callbacks'
  actionpack (3.2.6) lib/abstract_controller/callbacks.rb:17:in `process_action'

  actionpack (3.2.6) lib/action_controller/metal/rescue.rb:29:in `process_action'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:30:in `block in process_action'
  activesupport (3.2.6) lib/active_support/notifications.rb:123:in `block in instrument'
  activesupport (3.2.6) lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  activesupport (3.2.6) lib/active_support/notifications.rb:123:in `instrument'
  actionpack (3.2.6) lib/action_controller/metal/instrumentation.rb:29:in `process_action'
  actionpack (3.2.6) lib/action_controller/metal/params_wrapper.rb:206:in `process_action'
  activerecord (3.2.6) lib/active_record/railties/controller_runtime.rb:18:in `process_action'
  actionpack (3.2.6) lib/abstract_controller/base.rb:121:in `process'
  actionpack (3.2.6) lib/abstract_controller/rendering.rb:45:in `process'
  actionpack (3.2.6) lib/action_controller/metal.rb:203:in `dispatch'
  actionpack (3.2.6) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
  actionpack (3.2.6) lib/action_controller/metal.rb:246:in `block in action'
  actionpack (3.2.6) lib/action_dispatch/routing/route_set.rb:73:in `call'
  actionpack (3.2.6) lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
  actionpack (3.2.6) lib/action_dispatch/routing/route_set.rb:36: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.6) lib/action_dispatch/routing/route_set.rb:600:in `call'
  rack-openid (1.3.1) lib/rack/openid.rb:98:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
  rack (1.4.1) lib/rack/etag.rb:23:in `call'
  rack (1.4.1) lib/rack/conditionalget.rb:25:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/head.rb:14:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/params_parser.rb:21:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/flash.rb:242:in `call'
  rack (1.4.1) lib/rack/session/abstract/id.rb:205:in `context'
  rack (1.4.1) lib/rack/session/abstract/id.rb:200:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/cookies.rb:338:in `call'
  activerecord (3.2.6) lib/active_record/query_cache.rb:64:in `call'
  activerecord (3.2.6) lib/active_record/connection_adapters/abstract/connection_pool.rb:473:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/callbacks.rb:28:in `block in
 call'
  activesupport (3.2.6) lib/active_support/callbacks.rb:405:in `_run__488234448__call__1011667048__callbacks'
  activesupport (3.2.6) lib/active_support/callbacks.rb:405:in `__run_callback'
  activesupport (3.2.6) lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
  activesupport (3.2.6) lib/active_support/callbacks.rb:81:in `run_callbacks'
  actionpack (3.2.6) lib/action_dispatch/middleware/callbacks.rb:27:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
  railties (3.2.6) lib/rails/rack/logger.rb:26:in `call_app'
  railties (3.2.6) lib/rails/rack/logger.rb:16:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/request_id.rb:22:in `call'
  rack (1.4.1) lib/rack/methodoverride.rb:21:in `call'
  rack (1.4.1) lib/rack/runtime.rb:17:in `call'
  activesupport (3.2.6) lib/active_support/cache/strategy/local_cache.rb:72:in `call'
  rack (1.4.1) lib/rack/lock.rb:15:in `call'
  actionpack (3.2.6) lib/action_dispatch/middleware/static.rb:62: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.6) lib/rails/engine.rb:479:in `call'
  railties (3.2.6) lib/rails/application.rb:220:in `call'
  rack (1.4.1) lib/rack/content_length.rb:14:in `call'
  railties (3.2.6) lib/rails/rack/log_tailer.rb:17:in `call'
  rack (1.4.1) lib/rack/handler/webrick.rb:59:in `service'
  C:/Ruby193/lib/ruby/1.9.1/webrick/httpserver.rb:138:in `service'
  C:/Ruby193/lib/ruby/1.9.1/webrick/httpserver.rb:94:in `run'
  C:/Ruby193/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread'

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

Ivan Cenov wrote:

I got Internal error when pressed on "Detailed" link under the issues list. Here is the log:

Have you installed plugin "Views with revisions" and ran rake task as described in installation guide?

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

Vitaly Klimov wrote:

Ivan Cenov wrote:

I got Internal error when pressed on "Detailed" link under the issues list. Here is the log:

Have you installed plugin "Views with revisions" and ran rake task as described in installation guide?

Hmmmm, I haven't ... After installing it this 'error' disappeared.

RE: XLS export plugin - Added by Alessio Pollero over 11 years ago

Hi, Vitaly Klimov

i have installed the latest version of the plugin on my redmine 1.4.4 installation, when i export issue list with the quick button everything works fine, while if i try to export with the detailed button i get this error :

ActionView::MissingTemplate (Missing template xls_export/index.erb in view path vendor/plugins/localizable.0.2.0/app/views:vendor/plugins/redmine_xls_export/app/views:app/views):
  app/controllers/application_controller.rb:557:in `default_template'
  /usr/lib/ruby/vendor_ruby/rack/adapter/rails.rb:69:in `call'
  /usr/lib/ruby/vendor_ruby/thin/connection.rb:80:in `pre_process'
  /usr/lib/ruby/vendor_ruby/thin/connection.rb:78:in `catch'
  /usr/lib/ruby/vendor_ruby/thin/connection.rb:78:in `pre_process'
  /usr/lib/ruby/vendor_ruby/thin/connection.rb:53:in `process'
  /usr/lib/ruby/vendor_ruby/thin/connection.rb:38:in `receive_data'
  /usr/lib/ruby/vendor_ruby/eventmachine.rb:257:in `run_machine'
  /usr/lib/ruby/vendor_ruby/eventmachine.rb:257:in `run'
  /usr/lib/ruby/vendor_ruby/thin/backends/base.rb:61:in `start'
  /usr/lib/ruby/vendor_ruby/thin/server.rb:159:in `start'
  /usr/lib/ruby/vendor_ruby/thin/controllers/controller.rb:86:in `start'
  /usr/lib/ruby/vendor_ruby/thin/runner.rb:185:in `send'
  /usr/lib/ruby/vendor_ruby/thin/runner.rb:185:in `run_command'
  /usr/lib/ruby/vendor_ruby/thin/runner.rb:151:in `run!'
  /usr/bin/thin:6

Seems that there is a problem with the localizable plugin ...
How can i solve the problem ?

Thanks.

I have an error - Added by Ki Won Kim over 11 years ago

I upgrade xls export plugin from 0.1.3 to 0.2.1.
and Redmine upgrade from 1.3.2 to 1.4.4

I have an error with "UnkownAction", when export "Quick" or "Detail" both same error.

My Environments
  • OS : Windows 2008 R2 64x Korean
  • Redmine 1.4.4
  • Ruby & Ruby Gems
    • Ruby version 1.9.3 p125 (i386-mingw32)
    • RubyGems version 1.8.24
    • Rack version 1.1.3
    • Rails version 2.3.14
    • Database adapter mysql2
  • Gem list
    • actionmailer (2.3.14)
    • actionpack (2.3.14)
    • activerecord (2.3.14)
    • activeresource (2.3.14)
    • activesupport (2.3.14)
    • bigdecimal (1.1.0)
    • bluefeather (0.40)
    • bundler (1.1.4)
    • coderay (1.0.7)
    • daemons (1.1.8)
    • eventmachine (1.0.0.rc.4 x86-mingw32)
    • execjs (1.4.0)
    • i18n (0.4.2)
    • io-console (0.3)
    • json (1.5.4)
    • mini_magick (3.4)
    • minitest (2.5.1)
    • multi_json (1.3.6)
    • mysql (2.8.1 x86-mingw32)
    • mysql2 (0.2.18 x86-mingw32)
    • net-ldap (0.3.1)
    • rack (1.1.3)
    • rails (2.3.14)
    • rake (0.9.2.2)
    • rdoc (3.9.4)
    • rmagick (2.13.1)
    • ruby-ole (1.2.11.4)
    • ruby-openid (2.1.8)
    • rubyzip (0.9.9)
    • spreadsheet (0.6.8)
    • subexec (0.2.2)
    • thin (1.3.1)
    • tzinfo (0.3.33)

production.log log file

Processing XlsExportController#export_current (for 127.0.0.1 at 2012-07-10 10:24:10) [GET]
  Parameters: {"controller"=>"xls_export", "action"=>"export_current", "project_id"=>"isetda"}

ActionController::UnknownAction (No action responded to export_current. Actions: accept_api_auth?, accept_rss_auth?, api_key_from_request, api_offset_and_limit, api_request?, authorize, authorize_global, back_url, check_if_login_required, check_project_privacy, current_language, current_menu_item, day_name, default_search_scope, default_search_scopes, default_template, deny_access, filename_for_content_disposition, find_current_user, find_current_user_with_screenshot, find_current_user_without_screenshot, find_issues, find_language, find_model_object, find_optional_project, find_project, find_project_by_project_id, find_project_from_association, format_date, format_time, handle_unverified_request, invalid_authenticity_token, l_days, l_hours, l_or_humanize, l_weeks, ll, logged_user=, logout_user, menu_items, month_name, params_filter, parse_qvalues, per_page_option, pick_layout, query_statement_invalid, redirect_back_or_default, redirect_to_project_menu_item, render_403, render_404, render_attachment_warning_if_needed, render_error, render_feed, render_validation_errors, require_admin, require_admin_or_api_request, require_login, session_expiration, session_expired?, set_flash_from_bulk_issue_save, set_language_if_valid, set_localization, start_user_session, try_to_autologin, use_layout, user_setup, utf8nize!, and valid_languages):
  <internal:prelude>:10:in `synchronize'
  thin (1.3.1) lib/thin/connection.rb:80:in `block in pre_process'
  thin (1.3.1) lib/thin/connection.rb:78:in `catch'
  thin (1.3.1) lib/thin/connection.rb:78:in `pre_process'
  thin (1.3.1) lib/thin/connection.rb:53:in `process'
  thin (1.3.1) lib/thin/connection.rb:38:in `receive_data'
  D:/CI/Ruby/lib/ruby/gems/1.9.1/gems/eventmachine-1.0.0.rc.4-x86-mingw32/lib/eventmachine.rb:187:in `run_machine'
  D:/CI/Ruby/lib/ruby/gems/1.9.1/gems/eventmachine-1.0.0.rc.4-x86-mingw32/lib/eventmachine.rb:187:in `run'
  thin (1.3.1) lib/thin/backends/base.rb:61:in `start'
  thin (1.3.1) lib/thin/server.rb:159:in `start'
  thin (1.3.1) lib/thin/controllers/controller.rb:86:in `start'
  thin (1.3.1) lib/thin/runner.rb:185:in `run_command'
  thin (1.3.1) lib/thin/runner.rb:151:in `run!'
  thin (1.3.1) bin/thin:6:in `<top (required)>'
  D:/CI/Ruby/bin/thin:23:in `load'
  D:/CI/Ruby/bin/thin:23:in `<main>'

Rendering rescues/layout (not_found)

Quick export rendering view result

Unknown action
No action responded to export_current. Actions: accept_api_auth?, accept_rss_auth?, api_key_from_request, api_offset_and_limit, api_request?, authorize, authorize_global, back_url, check_if_login_required, check_project_privacy, current_language, current_menu_item, day_name, default_search_scope, default_search_scopes, default_template, deny_access, filename_for_content_disposition, find_current_user, find_current_user_with_screenshot, find_current_user_without_screenshot, find_issues, find_language, find_model_object, find_optional_project, find_project, find_project_by_project_id, find_project_from_association, format_date, format_time, handle_unverified_request, invalid_authenticity_token, l_days, l_hours, l_or_humanize, l_weeks, ll, logged_user=, logout_user, menu_items, month_name, params_filter, parse_qvalues, per_page_option, pick_layout, query_statement_invalid, redirect_back_or_default, redirect_to_project_menu_item, render_403, render_404, render_attachment_warning_if_needed, render_error, render_feed, render_validation_errors, require_admin, require_admin_or_api_request, require_login, session_expiration, session_expired?, set_flash_from_bulk_issue_save, set_language_if_valid, set_localization, start_user_session, try_to_autologin

RE: I have an error - Added by Ki Won Kim over 11 years ago

Same environment but xls plugin 0.1.3 version.

I click "Quick export" then other error.

Processing ApplicationController#export_current (for fe80::c4aa:cf66:81b2:94d1 at 2012-07-10 10:16:46) [GET]
  Parameters: {"controller"=>"xls_export", "action"=>"export_current", "project_id"=>"isetda"}

LoadError (Expected D:/CI/Redmine/vendor/plugins/redmine_xls_export/app/helpers/xls_export_helper.rb to define XlsExportHelper):
  vendor/plugins/redmine_xls_export/app/controllers/xls_export_controller.rb:9:in `<top (required)>'
  <internal:prelude>:10:in `synchronize'
  thin (1.3.1) lib/thin/connection.rb:80:in `block in pre_process'
  thin (1.3.1) lib/thin/connection.rb:78:in `catch'
  thin (1.3.1) lib/thin/connection.rb:78:in `pre_process'
  thin (1.3.1) lib/thin/connection.rb:53:in `process'
  thin (1.3.1) lib/thin/connection.rb:38:in `receive_data'
  D:/CI/Ruby/lib/ruby/gems/1.9.1/gems/eventmachine-1.0.0.rc.4-x86-mingw32/lib/eventmachine.rb:187:in `run_machine'
  D:/CI/Ruby/lib/ruby/gems/1.9.1/gems/eventmachine-1.0.0.rc.4-x86-mingw32/lib/eventmachine.rb:187:in `run'
  thin (1.3.1) lib/thin/backends/base.rb:61:in `start'
  thin (1.3.1) lib/thin/server.rb:159:in `start'
  thin (1.3.1) lib/thin/controllers/controller.rb:86:in `start'
  thin (1.3.1) lib/thin/runner.rb:185:in `run_command'
  thin (1.3.1) lib/thin/runner.rb:151:in `run!'
  thin (1.3.1) bin/thin:6:in `<top (required)>'
  D:/CI/Ruby/bin/thin:23:in `load'
  D:/CI/Ruby/bin/thin:23:in `<main>'

Rendering D:/CI/Redmine/public/500.html (500 Internal Server Error)

RE: XLS export plugin - Added by Vladimir Pitin over 11 years ago

In version 021

I have error "LoadError (No such file to load -- spreadsheet):"

My gem list is

  • LOCAL GEMS ***

actionmailer (3.2.6, 3.2.3)
actionpack (3.2.6, 3.2.3)
activemodel (3.2.6, 3.2.3)
activerecord (3.2.6, 3.2.3)
activeresource (3.2.6, 3.2.3)
activesupport (3.2.6, 3.2.3)
arel (3.0.2)
autotest-notification (2.3.4)
autotest-rails (4.1.2)
autotest-standalone (4.5.9)
builder (3.0.0)
bundler (1.1.3)
coderay (1.0.7, 1.0.6)
daemon_controller (1.0.0)
database_cleaner (0.7.2, 0.6.7)
diff-lcs (1.1.3)
erubis (2.7.0)
factory_girl (3.5.0, 1.3.3, 1.3.0)
factory_girl_rails (3.5.0)
fastthread (1.0.7)
hike (1.2.1)
hoe (2.12.3)
i18n (0.6.0)
journey (1.0.4, 1.0.3)
json (1.7.3)
mail (2.4.4)
mime-types (1.19, 1.18)
multi_json (1.3.6, 1.3.5)
mysql (2.8.1)
mysql2 (0.3.11)
net-ldap (0.3.1)
nokogiri (1.5.5)
passenger (3.0.12)
polyglot (0.3.3)
prototype-rails (3.2.1)
rack (1.4.1, 1.1.0)
rack-cache (1.2)
rack-openid (1.3.1)
rack-ssl (1.3.2)
rack-test (0.6.1)
rails (3.2.6, 3.2.3)
railties (3.2.6, 3.2.3)
rake (0.9.2.2, 0.9.2)
rdoc (3.12)
RedCloth (4.2.9)
rmagick (2.13.1)
rspec (2.10.0, 1.3.2, 1.3.0)
rspec-core (2.10.1)
rspec-expectations (2.10.0)
rspec-mocks (2.10.1)
rspec-rails (1.3.4, 1.3.0)
ruby-ole (1.2.11.4)
ruby-openid (2.1.8)
rubygems-bundler (1.0.2)
rvm (1.11.3.3)
shoulda-matchers (1.2.0)
simple_enum (1.6.1)
simplecov (0.6.4)
simplecov-html (0.5.3)
simplecov-rcov (0.2.3)
spreadsheet (0.7.3)
sprockets (2.1.3)
sqlite3 (1.3.4)
test-unit (2.5.1, 1.2.3)
thor (0.15.4, 0.15.3, 0.14.6)
tilt (1.3.3)
treetop (1.4.10)
tzinfo (0.3.33)
uuidtools (2.1.2)
xapian-full (1.2.3)
ZenTest (4.8.1)
zip (2.0.2)

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

Vladimir Pitin wrote:

In version 021

I have error "LoadError (No such file to load -- spreadsheet):"

Please add gem "spreadsheet" line to your gemfile.local file

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

Alessio Pollero wrote:

Hi, Vitaly Klimov

i have installed the latest version of the plugin on my redmine 1.4.4 installation, when i export issue list with the quick button everything works fine, while if i try to export with the detailed button i get this error :

Please install plugin Plugin views with revisions and run rake redmine:plugins:process_version_change RAILS_ENV=production after that, as described in plugin installation guide.

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

Ki Won Kim wrote:

Same environment but xls plugin 0.1.3 version.

I click "Quick export" then other error.

It seems that you installed plugin over existing installation of pre 1.3 version. Please remove folder redmine_xls_export completely and then install latest version using installation guide provide on plugin page.

RE: XLS export plugin - Added by Vladimir Pitin over 11 years ago

Vitaly Klimov wrote:

Vladimir Pitin wrote:

In version 021

I have error "LoadError (No such file to load -- spreadsheet):"

Please add gem "spreadsheet" line to your gemfile.local file

I try it, but I have no result

error: "LoadError (No such file to load -- spreadsheet):"

gemfile.local content is:

gem "spreadsheet" 

RE: XLS export plugin - Added by Jens Krämer over 11 years ago

...and don't forget to run bundle install after modifying Gemfile or Gemfile.local.

RE: XLS export plugin - Added by Артем Миротин over 11 years ago

Works fine for me! But there is one problem:
When using CKeditor - all html tags are exported in xls (in issue description)

RE: XLS export plugin - Added by Anonymous over 11 years ago

Hi,
I run redmine 1.3.2 on CentOs via apache//passenger

I use the 2.1 release of the plugin. When i click on export I get this error:

Processing XlsExportController#index (for 24.37.69.148 at 2012-08-29 15:03:05) [POST]
  Parameters: {"action"=>"index", "project_id"=>"174004-donnermetals", "issues_export_offset"=>"0", "controller"=>"xls_export", "settings"=>{"generate_name"=>"1", "group"=>"1", "journa$

NameError (undefined local variable or method `controller' for #<XLS_JournalQueryColumn:0xb6ba6560>):
  lib/redmine/hook.rb:143:in `call_hook'
  app/helpers/issues_helper.rb:202:in `show_detail'
  app/models/user.rb:194:in `each_with_index'
  vendor/plugins/redmine_xls_export/app/controllers/xls_export_controller.rb:116:in `export_to_string'
  vendor/plugins/redmine_xls_export/app/controllers/xls_export_controller.rb:38:in `index'
...
...
...

spreadsheet is in my gemlist and I ran gem install and rake redmine:plugins:process_version_change RAILS_ENV=production
I can't figure out what is the problem

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

Redmine version is current trunk (past )2.1.2, ruby is 1.9.3, command line

thin start -e production

Here is what I receive when click on "Detailed"

Started GET "/issues_xls_export" for 192.168.2.100 at 2012-10-14 18:22:06 +0300
Processing by XlsExportController#index as HTML
  Current user: jwalker (id=30)
Missing template, responding with 404
  Rendered common/error.html.erb within layouts/base (0.0ms)
  Rendered plugins/redmine_favourite_projects/app/views/favourite_projects/_favourite_projects_searchbox_partial.html.erb (0.0ms)
  Rendered plugins/redmine_favourite_projects/app/views/favourite_projects/_update_menu.erb (0.0ms)
Completed 404 Not Found in 188ms (Views: 93.8ms | ActiveRecord: 15.6ms)
(151-175/276)