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 Vitaly Klimov over 12 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 12 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 12 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 12 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 12 years ago
Is it dowwards compatible to redmine 1.3 and 1.4 ?
RE: XLS export plugin - Added by Vitaly Klimov over 12 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 12 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 12 years ago
Hi, Vitaly Klimov
I've updated the newest zh.yml for 0.2.0.
please check it. thanks.
RE: XLS export plugin - Added by Tatsuya Saito over 12 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.
...
RE: XLS export plugin - Added by Vitaly Klimov over 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 years ago
...and don't forget to run bundle install
after modifying Gemfile or Gemfile.local.
RE: XLS export plugin - Added by Артем Миротин over 12 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 12 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 about 12 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)