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 Anonymous almost 12 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 almost 12 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 almost 12 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 almost 12 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 almost 12 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.
RE: XLS export plugin
-
Added by Youssef Boujraf over 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: yboujraf@xxx.xx (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 over 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 over 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 over 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 over 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 over 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 over 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 over 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 over 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 listSecond, tell me your plugin settings, NOT Redmine environment.
How to check it:
- Open your Redmine.
- Click Administration menu on top of Redmine view.
- Click Plugins link.
- Click Configure link, on the right of Issues XLS export plugin area. Then Settings: Issues XLS export view will be shown.
- Capture that view and attach it if you can.
RE: XLS export plugin
-
Added by Youssef Boujraf over 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 over 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 over 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 over 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 over 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
RE: XLS export plugin
-
Added by Tatsuya Saito over 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 over 11 years ago
I have the same error and excel complains about security risk!