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 Anonymous over 11 years ago

I am receiving the same LoadError message as previous posts: No such file to load -- spreadsheet.
I would try modifying the gemfile.local file, but none exists. I tried adding the line: gem "spreadsheet" to one of the 31 "gemfile" files but the Redmine service would not restart.

My installation was performed using a Bitnami distribution, mostly because I am behind a firewall, and it seemed like the easiest way to go.

Is there an equivalent file to the gemfile.local that you referred to, and in which folder would it reside, i.e. apps\redmine\htdocs, ruby\lib\ruby\gems?

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

Leon Michaud wrote:

I am receiving the same LoadError message as previous posts: No such file to load -- spreadsheet.
I would try modifying the gemfile.local file, but none exists. I tried adding the line: gem "spreadsheet" to one of the 31 "gemfile" files but the Redmine service would not restart.

My installation was performed using a Bitnami distribution, mostly because I am behind a firewall, and it seemed like the easiest way to go.

Is there an equivalent file to the gemfile.local that you referred to, and in which folder would it reside, i.e. apps\redmine\htdocs, ruby\lib\ruby\gems?

My Gemfile.local:

# Gemfile.local
gem "eventmachine", "~> 1.0.0.rc.4" 
gem "thin" 
gem "spreadsheet" 
gem "rubyzip" 
It resides in the root Redmine directory.

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

Good day

I was experiencing the LoadError message: No such file to load -- spreadsheet. in version 021 (p.s. i am on ubuntu 12, redmine 2.x, ruby 1.8.7, rails 3.2.8)

and have already seen this (or similar) on other plugins, i realized the possible cause was the plugin requiring dependency on the the file "spreedsheet" in redmine/plugins/lib/xls_export.rb was not finding the file in the local directory

i edited that file and pointed it to the folder that contains the spreadsheet (/var/lib/gems/1.8/gems/spreadsheet-0.7.4/lib/spreadsheet)

the error went away and the plugin loaded, However, when I click on the xls (Quick or Details) I get a 500 server error, with the page linking to .../projects/{Project_name}/issues_xls_export_current

and the message being LoadError message: No such file to load -- spreadsheet/excel/workbook.

And since i was in the folder spreadsheet, i changed the the link to point to (/var/lib/gems/1.8/gems/spreadsheet-0.7.4/lib/spreadsheet/ ) because the folder spreadsheet-0.7.4 had a file spreadsheet.rb and a subfolder and file spreadsheet/excel/workbook.rb

however doing this still does not fix the issue,
I hope this shed some light and someone can help resolve this

p.s. csv, pdf, and atom buttons function fine

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

For bitnami users to solve the LoadError message: No such file to load -- spreadsheet

You should edit the file Gemfile located at /opt/bitnami/apps/redmine/htdocs

Adding the following lines and restarting redmine worked for me.

gem "spreadsheet"
gem "rubyzip"

Obviously, this will work after you install those gem (or the bundle)

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

Hi,Vitaly Klimov

found an issue in Redmine 2.1.2 with ruby 1.9.3.

when I export issues with detail option, it occurs 404 page.

the log is here, please check it. Thanks


Started GET "/projects/upnv/issues_xls_export" for 192.168.3.41 at 2012-11-06 09:29:00 +0800
Processing by XlsExportController#index as HTML
  Parameters: {"project_id"=>"upnv"}
  Current user: wanghui (id=39)
Missing template, responding with 404
  Rendered common/error.html.erb within layouts/base (0.8ms)
  Rendered plugins/redmine_cut_tag/app/views/hooks/redmine_cut_tag/_includes.html.erb (0.9ms)
  Rendered plugins/redmine_private_wiki/app/views/hooks/_html_header.html.erb (0.2ms)
  Rendered plugins/redmine_private_wiki/app/views/hooks/_body_bottom.html.erb (0.2ms)
Completed 404 Not Found in 91ms (Views: 49.2ms | ActiveRecord: 3.4ms)

Started GET "/projects/upnv/issues_xls_export" for 192.168.3.41 at 2012-11-06 09:29:05 +0800
Processing by XlsExportController#index as HTML
  Parameters: {"project_id"=>"upnv"}
  Current user: wanghui (id=39)
Missing template, responding with 404
  Rendered common/error.html.erb within layouts/base (0.3ms)
  Rendered plugins/redmine_cut_tag/app/views/hooks/redmine_cut_tag/_includes.html.erb (0.9ms)
  Rendered plugins/redmine_private_wiki/app/views/hooks/_html_header.html.erb (0.2ms)
  Rendered plugins/redmine_private_wiki/app/views/hooks/_body_bottom.html.erb (0.2ms)
Completed 404 Not Found in 45ms (Views: 33.3ms | ActiveRecord: 3.3ms)

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

Is this plugin comaptible with redmine 2.1.x ? Which Version and where is the scm repo?

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

Terence Mill wrote:

Is this plugin comaptible with redmine 2.1.x ? Which Version and where is the scm repo?

Good day Terence,

Yes it is, but i say download the latest version (or at least v021, if linux, use

~:> wget http://www.redmine.org/attachments/download/7854/redmine_xls_export_v021.zip)

or just download the version the http link

hope this helps

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

Does not work for redmine 2.1.4

Started GET "/projects/spielwiese/issues_xls_export" for 172.16.104.41 at 2012-12-07 16:43:37 +0100
Processing by XlsExportController#index as HTML
Parameters: {"project_id"=>"spielwiese"}
Current user: 00001276 (id=3)
Missing template, responding with 404
Rendered common/error.html.erb within layouts/base (0.0ms)
Rendered plugins/redmine_code_review/app/views/code_review/_html_header.html.erb (0.0ms)
Rendered inline template (2.0ms)
Rendered plugins/redmine_incoming_mail_log/app/views/hooks/_incoming_mail_log_stylesheet.erb (0.0ms)
Rendered plugins/redmine_private_wiki/app/views/hooks/_html_header.html.erb (0.0ms)
Rendered plugins/redmine_wiki_extensions/app/views/wiki_extensions/_html_header.html.erb (0.0ms)
Rendered plugins/redmine_favourite_projects/app/views/favourite_projects/_favourite_projects_searchbox_partial.html.erb (0.0ms)
Rendered plugins/redmine_banner/app/views/banner/_project_body_bottom.html.erb (1.0ms)
Rendered plugins/redmine_code_review/app/views/code_review/_body_bottom.html.erb (0.0ms)
Rendered plugins/redmine_favourite_projects/app/views/favourite_projects/_update_menu.erb (0.0ms)
Rendered plugins/redmine_private_wiki/app/views/hooks/_body_bottom.html.erb (0.0ms)
Rendered plugins/redmine_wiki_extensions/app/views/wiki_extensions/_body_bottom.html.erb (0.0ms)
Completed 404 Not Found in 239ms (Views: 135.0ms | ActiveRecord: 26.0ms)
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true
[2012-12-07 16:43:37] WARN Could not determine content-length of response body. Set content-length of the response or set Response#chunked = true

Started GET "/projects/spielwiese/issues_xls_export_current" for 172.16.104.41 at 2012-12-07 16:43:51 +0100
Processing by XlsExportController#export_current as HTML
Parameters: {"project_id"=>"spielwiese"}
Current user: 00001276 (id=3)
Completed 500 Internal Server Error in 625ms

NoMethodError (private method `select' called for "#":String):
spreadsheet (0.6.8) lib/spreadsheet/excel/writer/worksheet.rb:122:in `strings'
org/jruby/RubyProc.java:249:in `call'
spreadsheet (0.6.8) lib/spreadsheet/worksheet.rb:113:in `each'
org/jruby/RubyInteger.java:139:in `upto'
spreadsheet (0.6.8) lib/spreadsheet/worksheet.rb:112:in `each'
org/jruby/RubyEnumerable.java:820:in `inject'
spreadsheet (0.6.8) lib/spreadsheet/excel/writer/worksheet.rb:121:in `strings'
spreadsheet (0.6.8) lib/spreadsheet/excel/writer/workbook.rb:486:in `write_sst'
org/jruby/RubyArray.java:1612:in `each'
org/jruby/RubyEnumerable.java:820:in `inject'
spreadsheet (0.6.8) lib/spreadsheet/excel/writer/workbook.rb:485:in `write_sst'
spreadsheet (0.6.8) lib/spreadsheet/excel/writer/workbook.rb:440:in `write_from_scratch'
spreadsheet (0.6.8) lib/spreadsheet/excel/writer/workbook.rb:621:in `write_workbook'
spreadsheet (0.6.8) lib/spreadsheet/writer.rb:12:in `write'
spreadsheet (0.6.8) lib/spreadsheet/workbook.rb:112:in `write'
plugins/redmine_xls_export/lib/xls_export.rb:259:in `issues_to_xls2'
plugins/redmine_xls_export/app/controllers/xls_export_controller.rb:116:in `export_to_string'
plugins/redmine_xls_export/app/controllers/xls_export_controller.rb:50:in `export_current'
org/jruby/RubyBasicObject.java:1667:in `__send__'
org/jruby/RubyKernel.java:2077:in `send'
actionpack (3.2.8) lib/action_controller/metal/implicit_render.rb:4:in `send_action'
actionpack (3.2.8) lib/abstract_controller/base.rb:167:in `process_action'
actionpack (3.2.8) lib/action_controller/metal/rendering.rb:10:in `process_action'
actionpack (3.2.8) lib/abstract_controller/callbacks.rb:18:in `process_action'
activesupport (3.2.8) lib/active_support/callbacks.rb:494:in `_run__1797721299__process_action__1591862135__callbacks'
org/jruby/RubyBasicObject.java:1667:in `__send__'
org/jruby/RubyKernel.java:2077:in `send'
activesupport (3.2.8) lib/active_support/callbacks.rb:405:in `__run_callback'
activesupport (3.2.8) lib/active_support/callbacks.rb:390:in `_run_process_action_callbacks'
org/jruby/RubyBasicObject.java:1673:in `__send__'
org/jruby/RubyKernel.java:2081:in `send'
activesupport (3.2.8) lib/active_support/callbacks.rb:81:in `run_callbacks'
actionpack (3.2.8) lib/abstract_controller/callbacks.rb:17:in `process_action'
actionpack (3.2.8) lib/action_controller/metal/rescue.rb:29:in `process_action'
actionpack (3.2.8) lib/action_controller/metal/instrumentation.rb:30:in `process_action'
activesupport (3.2.8) lib/active_support/notifications.rb:123:in `instrument'
activesupport (3.2.8) lib/active_support/notifications/instrumenter.rb:20:in `instrument'
activesupport (3.2.8) lib/active_support/notifications/instrumenter.rb:19:in `instrument'
activesupport (3.2.8) lib/active_support/notifications.rb:123:in `instrument'
actionpack (3.2.8) lib/action_controller/metal/instrumentation.rb:29:in `process_action'
actionpack (3.2.8) lib/action_controller/metal/params_wrapper.rb:207:in `process_action'
activerecord (3.2.8) lib/active_record/railties/controller_runtime.rb:18:in `process_action'
actionpack (3.2.8) lib/abstract_controller/base.rb:121:in `process'
actionpack (3.2.8) lib/abstract_controller/rendering.rb:45:in `process'
actionpack (3.2.8) lib/action_controller/metal.rb:203:in `dispatch'
actionpack (3.2.8) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
actionpack (3.2.8) lib/action_controller/metal.rb:246:in `action'
org/jruby/RubyProc.java:249:in `call'
actionpack (3.2.8) lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
actionpack (3.2.8) lib/action_dispatch/routing/route_set.rb:36:in `call'
journey (1.0.4) lib/journey/router.rb:68:in `call'
org/jruby/RubyArray.java:1612:in `each'
journey (1.0.4) lib/journey/router.rb:56:in `call'
actionpack (3.2.8) 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.8) 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.8) lib/action_dispatch/middleware/head.rb:14:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/params_parser.rb:21:in `call'
plugins/redmine_dmsf/lib/redmine_dmsf/webdav/no_parse.rb:33:in `call'
actionpack (3.2.8) 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.8) lib/action_dispatch/middleware/cookies.rb:339:in `call'
activerecord (3.2.8) lib/active_record/query_cache.rb:64:in `call'
activerecord (3.2.8) lib/active_record/connection_adapters/abstract/connection_pool.rb:473:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/callbacks.rb:28:in `call'
activesupport (3.2.8) lib/active_support/callbacks.rb:408:in `_run__226838744__call__10865137__callbacks'
org/jruby/RubyBasicObject.java:1667:in `__send__'
org/jruby/RubyKernel.java:2077:in `send'
activesupport (3.2.8) lib/active_support/callbacks.rb:405:in `__run_callback'
activesupport (3.2.8) lib/active_support/callbacks.rb:390:in `_run_call_callbacks'
org/jruby/RubyBasicObject.java:1667:in `__send__'
org/jruby/RubyKernel.java:2077:in `send'
activesupport (3.2.8) lib/active_support/callbacks.rb:81:in `run_callbacks'
actionpack (3.2.8) lib/action_dispatch/middleware/callbacks.rb:27:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
railties (3.2.8) lib/rails/rack/logger.rb:26:in `call_app'
railties (3.2.8) lib/rails/rack/logger.rb:16:in `call'
actionpack (3.2.8) 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.8) 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.8) 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.8) lib/rails/engine.rb:479:in `call'
railties (3.2.8) lib/rails/application.rb:223:in `call'
rack (1.4.1) lib/rack/content_length.rb:14:in `call'
railties (3.2.8) lib/rails/rack/log_tailer.rb:17:in `call'
rack (1.4.1) lib/rack/handler/webrick.rb:59:in `service'
/home/sidfunktion/.rvm/rubies/jruby-1.7.0/lib/ruby/1.9/webrick/httpserver.rb:138:in `service'
/home/sidfunktion/.rvm/rubies/jruby-1.7.0/lib/ruby/1.9/webrick/httpserver.rb:94:in `run'
/home/sidfunktion/.rvm/rubies/jruby-1.7.0/lib/ruby/1.9/webrick/httpserver.rb:72:in `run'
/home/sidfunktion/.rvm/rubies/jruby-1.7.0/lib/ruby/1.9/webrick/server.rb:191:in `start_thread'
/home/sidfunktion/.rvm/rubies/jruby-1.7.0/lib/ruby/1.9/webrick/server.rb:181:in `start_thread'

RE: XLS export plugin - Added by Ki Won Kim over 11 years ago

add Korean language file. in xls export plugin 0.2.1

Thank you.

ko.yml (1.87 KB) ko.yml Korean language file

RE: XLS export plugin - Added by Youssef Boujraf about 11 years ago

Environment:

Redmine version 2.2.0.stable
Ruby version 1.9.3 (i386-mingw32)
Rails version 3.2.9
Environment production
Database adapter Mysql2

Detailed button (error):

When I export issues with detailed button, it occurs 404 page.
The log is here, please check it. Thanks

Started GET "/redmine/projects/project1/issues_xls_export" for 127.0.0.1 at 2012-12-29 03:29:05 +0100
Processing by XlsExportController#index as HTML
Parameters: {"project_id"=>"project1"}
Current user: (id=3)
Missing template, responding with 404
Rendered common/error.html.erb within layouts/base (0.0ms)
Completed 404 Not Found in 70ms (Views: 56.0ms | ActiveRecord: 5.0ms)

zipfile (nothing inside):

When I exported the xls, in the zipfile we have nothing.

Best Regards,
Youssef

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

I added to specify cell format for date & time on following github:
https://github.com/two-pack/redmine_xls_export/commit/0a5b1e68ca68c38dc46e075aaf506b7b8c7156bb

Hope this help.

RE: XLS export plugin - Added by Jiyan Fan about 11 years ago

Hi Youssef Boujraf,
I found the same issue with you,when i export issues with deailed button,it occurs 404 page.
Do you resolved this issue?

the log is here:

Started GET "/redmine/projects/a03/issues" for 127.0.0.1 at 2013-01-07 15:28:49 +0800
Processing by IssuesController#index as */*
  Parameters: {"project_id"=>"a03"}
  Current user: admin (id=1)
  Rendered queries/_filters.html.erb (9.0ms)
  Rendered queries/_columns.html.erb (77.0ms)
  Rendered issues/_list.html.erb (10.0ms)
  Rendered issues/_sidebar.html.erb (3.0ms)
  Rendered issues/index.html.erb within layouts/base (148.0ms)
  Rendered plugins/redmine_code_review/app/views/code_review/_html_header.html.erb (3.0ms)
  Rendered plugins/redmine_code_review/app/views/code_review/_body_bottom.html.erb (1.0ms)
Completed 200 OK in 381ms (Views: 260.0ms | ActiveRecord: 22.0ms)
Started GET "/redmine/projects/a03/issues_xls_export" for 127.0.0.1 at 2013-01-07 15:29:13 +0800
Processing by XlsExportController#index as HTML
  Parameters: {"project_id"=>"a03"}
  Current user: admin (id=1)
Missing template, responding with 404
  Rendered common/error.html.erb within layouts/base (0.0ms)
  Rendered plugins/redmine_code_review/app/views/code_review/_html_header.html.erb (0.0ms)
  Rendered plugins/redmine_code_review/app/views/code_review/_body_bottom.html.erb (0.0ms)
Completed 404 Not Found in 190ms (Views: 80.0ms | ActiveRecord: 0.0ms)

Environment:
Redmine version 2.2.0.stable
Ruby version 1.9.3 (i386-mingw32)
Rails version 3.2.9
Environment production
Database adapter Mysql2
Redmine plugins:
planner 0.3
redmine_charts2 0.2.1
redmine_ckeditor 0.2.1
redmine_code_review 0.6.1
redmine_inline_note_images_plugin 0.0.1
redmine_knowledgebase 2.2.0
redmine_monitoring_controlling 0.1.1
redmine_xls_export 0.2.1

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

Jiyan Fan wrote:

Redmine plugins:
planner 0.3
redmine_charts2 0.2.1
redmine_ckeditor 0.2.1
redmine_code_review 0.6.1
redmine_inline_note_images_plugin 0.0.1
redmine_knowledgebase 2.2.0
redmine_monitoring_controlling 0.1.1
redmine_xls_export 0.2.1

Your plugin list has not Plugin views with revisions plugin.
Did you install and use it?
If not, please read Installation notes on *Up to date plugin page*

I reproduced this error when remove app/views/index.html.erb which was created above plugin.

Hope this helps.

RE: XLS export plugin - Added by Jiyan Fan about 11 years ago

Thanks Tatsuya Saito.
Yes, i forgot to install Plugin views with revisions plugin,it was careless of me.
When i installed Plugin views with revisions plugin, the deailed button worked correctly.

RE: XLS export plugin - Added by Youssef Boujraf about 11 years ago

Dear

Again,

After installing the plugin "Redmine plugin views revisions plugin" as recommended,

We have this error (see attachment) when we are pressing on the "QUICK" button.

Thanks I you have any idea.

Best Regards,
Youssef

15-01-2013 22-38-57.png (17.7 KB) 15-01-2013 22-38-57.png Error message after pressing Quick button

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

Hi Youssef Boujraf,

Did you resolve details button issue which was occurred 404?
And another is same problem?

Please attach invalid zip file if you can.
And please tell us your plugin settings.
Settings when use Quick button are in Administration - Plugins - Configure .

RE: XLS export plugin - Added by Youssef Boujraf about 11 years ago

Please find the plugin settings

Information

Redmine 2.2.0.stable

Default administrator account changed
Attachments directory writable
Plugin assets directory writable
RMagick available (optional)

Environment:
Redmine version 2.2.0.stable
Ruby version 1.9.3 (i386-mingw32)
Rails version 3.2.9
Environment production
Database adapter Mysql2
Redmine plugins:
redmine_dmsf 1.4.5 stable
redmine_lightbox 0.0.1
redmine_meetings 0.2.3
redmine_plugin_views_revisions 0.0.1
redmine_screenshot_paste 2.0.0
redmine_xls_export 0.2.1

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

Hi Youssef Boujraf,

I checked your attached file.
That file's name is .zip but content is xls.
#You can check it by renaming that file's extension zip to xls file and opening that file by Excel or something.

I need more information to research your problem.
First, tell me your gem list. You can check it by following command.

$ gem list

Second, tell me your plugin settings, NOT Redmine environment.
How to check it:
  1. Open your Redmine.
  2. Click Administration menu on top of Redmine view.
  3. Click Plugins link.
  4. Click Configure link, on the right of Issues XLS export plugin area. Then Settings: Issues XLS export view will be shown.
  5. Capture that view and attach it if you can.

RE: XLS export plugin - Added by Youssef Boujraf about 11 years ago

dear,

Please find all information requested in you latest email.

$ gem list

C:\BitNami\redmine\apps\redmine\htdocs\plugins>gem list

*** LOCAL GEMS ***

actionmailer (3.2.9)
actionpack (3.2.9)
activemodel (3.2.9)
activerecord (3.2.9)
activeresource (3.2.9)
activesupport (3.2.9)
ansi (1.4.3)
arel (3.0.2)
aws-sdk (1.6.9)
bcrypt-ruby (3.0.1 x86-mingw32)
bigdecimal (1.1.0)
bluecloth (2.1.0 x86-mingw32)
builder (3.0.0)
bundler (1.2.1, 1.0.21)
coderay (1.0.6)
coffee-rails (3.2.2)
coffee-script (2.2.0)
coffee-script-source (1.3.3)
crack (0.3.1)
daemons (1.1.8)
diff-lcs (1.1.3)
erubis (2.7.0)
eventmachine (1.0.0 x86-mingw32)
execjs (1.4.0)
fastercsv (1.5.4)
hike (1.2.1)
hoe (3.0.6)
hpricot (0.8.5)
httparty (0.8.3)
i18n (0.6.0)
io-console (0.3)
journey (1.0.4)
jquery-rails (2.1.3, 2.0.3)
json (1.7.5, 1.5.4)
mail (2.4.4)
metaclass (0.0.1)
mime-types (1.19, 1.18)
mini_magick (3.4)
mini_portile (0.3.0)
minitest (2.5.1)
mocha (0.12.3)
multi_json (1.3.6)
multi_xml (0.5.1)
mustache (0.99.4)
mysql2 (0.3.11 x86-mingw32, 0.2.18)
net-ldap (0.3.1)
nokogiri (1.5.6 x86-mingw32, 1.5.5 x86-mingw32, 1.4.7 x86-mingw32)
polyglot (0.3.3)
prototype-rails (3.2.1)
rack (1.4.1)
rack-cache (1.2)
rack-mount (0.8.3)
rack-openid (1.3.1)
rack-ssl (1.3.2)
rack-test (0.6.1)
rails (3.2.9)
railties (3.2.9)
rake (0.9.2.2)
rake-compiler (0.8.1)
rdiscount (1.6.8)
rdoc (3.12, 3.9.4)
RedCloth (4.2.9 x86-mingw32)
ri_cal (0.8.8)
rmagick (2.13.1)
ronn (0.7.3)
rspec (2.11.0)
rspec-core (2.11.1)
rspec-expectations (2.11.2)
rspec-mocks (2.11.1)
ruby-ole (1.2.11.6)
ruby-openid (2.1.8)
rubygems-update (1.8.24)
rubyzip (0.9.9)
rvm (1.11.3.5)
sass (3.1.20)
sass-rails (3.2.5)
simple_enum (1.6.4)
spreadsheet (0.7.6)
sprockets (2.4.5, 2.2.1, 2.1.3, 2.1.2)
sqlite3 (1.3.6 x86-mingw32)
sqlite3-ruby (1.3.2 x86-mingw32)
subexec (0.2.2)
test-unit (2.5.2)
thin (1.3.1)
thor (0.15.4, 0.14.6)
tilt (1.3.3)
treetop (1.4.10)
turn (0.9.6)
tzinfo (0.3.33)
uglifier (1.2.6)
uuidtools (2.1.3)
yard (0.8.1)
zip (2.0.2)

C:\BitNami\redmine\apps\redmine\htdocs\plugins>

Plugins

DMSF
Document Management System Features
https://github.com/danmunn/redmine_dmsf
Vit Jonas / Daniel Munn    1.4.5 stable    Configure

Redmine Light Box plugin
Lightbox for attachments
https://github.com/zipme/redmine_lightbox
G.K.    0.0.1    

Meetings plugin
plugin to manage meetings in REDMINE
Arnaud Martel    0.2.3    Configure

Redmine plugin views revisions plugin
This plugin tries to solve problem that is caused by inability to monkey-patch views in the Redmine.
For details please see http://www.redmine.org/plugins/redmine_plugin_views_revisions for more details
Vitaly Klimov    0.0.1    

Screenshot Paste
Allow pasting a screenshot from the clipboard on the issue form.
https://github.com/undx/redmine_screenshot_paste
Jean-Philippe Lang / Emmanuel GALLOIS (undx)    2.0.0    

Issues XLS export
Export issues to XLS files including journals, descriptions, etc. This plugin requires spreadsheet gem.
Vitaly Klimov    0.2.1    Configure

Settings: Issues XLS export

See attachment please.

Thank and best regards,
Youssef

issues xls export settings.tiff (68.6 KB) issues xls export settings.tiff issues xls export settings screenshot

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

Youssef Boujraf,

Your gem list has 'rubyzip. It is contradictory to your settings screenshot.
"(install rubyzip gem to access them)" on settings view is shown only when rubyzip is NOT installed.

C:\BitNami\redmine\apps\redmine\htdocs\plugins>

I think you use BitNami Redmine Stack.
Maybe your gems on BitNami Redmine Stack has not rubyzip gem.
Please check gem list again on your that stack path.
I don't know your that path, but some site wrote C:\Program Files\BitNami Redmine Stack\ruby\bin .

For example on Windows,

D:\> c:
C:\> cd C:\Program Files\BitNami Redmine Stack\ruby\bin
C:\Program Files\BitNami Redmine Stack\ruby\bin> gem list
....

If your gem list has not rubyzip, install it on like C:\Program Files\BitNami Redmine Stack\ruby\bin .
If not, I have no answer now :(

RE: XLS export plugin - Added by Youssef Boujraf about 11 years ago

Dear,

Please find the gemfile. May be something wrong.

I added the rubyzip manually.

source 'http://rubygems.org'

gem "thin" 
gem "spreadsheet" 
gem "rubyzip" 

gem 'rails', '3.2.9'
gem "jquery-rails", "~> 2.0.2" 
gem "i18n", "~> 0.6.0" 
gem "coderay", "~> 1.0.6" 
gem "fastercsv", "~> 1.5.0", :platforms => [:mri_18, :mingw_18, :jruby]
gem "builder", "3.0.0" 

Best Regards,
Youssef

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

Youssef Boujraf,

I'm trying to check with BitNami Redmine on Windows.
But I have not enough time for it, so not completed.

You wrote:

C:\BitNami\redmine\apps\redmine\htdocs\plugins>

I installed BitNami Redmine and checked default install path was C:\BitNami\redmine .
So I think you installed on default path.

Then, please check gem list again with like following commands and having 'rubyzip' on the list.

C:\BitNami\redmine>C:
C:\BitNami\redmine>path C:\BitNami\redmine\ruby\bin;%PATH%
C:\BitNami\redmine>gem list

You wrote:

I added the rubyzip manually.

Did you add that lines in C:\BitNami\redmine\apps\redmine\htdocs\Gemfile ?
And did you bundle install ?
If you did not bundle install , please try following commands.

C:\BitNami\redmine>C:
C:\BitNami\redmine>path C:\BitNami\redmine\ruby\bin;%PATH%
C:\BitNami\redmine>cd C:\BitNami\redmine\apps\redmine\htdocs
C:\BitNami\redmine\apps\redmine\htdocs> bundle install

After that, check gem list how to do first commands and check your problem happened again.

RE: XLS export plugin - Added by Youssef Boujraf about 11 years ago

Dear,

I tested again and unfortunately it wont to work.

When I say I added manually rubyzip, it is wrong.
I used bundle install and rubyzip 0.9.9 was installed.

What I added manually is in the Gemfile stored here :

C:\BitNami\redmine\apps\redmine\htdocs\Gemfile

This :

gem "thin" 
gem "spreadsheet" 
gem "rubyzip" 

I attached the gemfile and may be you can check if everything are ok.

Best Regards,
Youssef

Gemfile (2.27 KB) Gemfile GemFile

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

Youssef Boujraf,

I made BitNami Redmine environment on Windows 7 and try re-procedure your problem.

My environment has spreadsheet 0.7.9 and rubyzip 0.9.9 . I used your Gemfile and ran 'bundle install'.
But exported zip is NOT invalid.

Has your environment spreadsheet 0.7.6 and rubyzip 0.9.9? (You wrote on http://www.redmine.org/boards/3/topics/11986?r=35675#message-35675).
Please check again version above with following commands on 'C:\BitNami\redmine\apps\redmine\htdocs' :

C:\BitNami\redmine\apps\redmine\htdocs> bundle show spreadsheet
C:\BitNami\redmine\apps\redmine\htdocs> bundle show rubyzip

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

I have the same error and excel complains about security risk!

https://github.com/two-pack/redmine_xls_export/issues/15

(176-200/276)