Karel Pičman wrote:

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

This is the err msg production.log

LoadError (No such file to load -- spreadsheet):
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:317:in `rescue in depend_on'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:312:in `depend_on'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:225:in `require_dependency'
plugins/redmine_xls_export/app/controllers/xls_export_controller.rb:2:in `<top (required)>'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `require'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `block in require'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:236:in `load_dependency'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `require'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:359:in `require_or_load'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:502:in `load_missing_constant'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:192:in `block in const_missing'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:190:in `each'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:190:in `const_missing'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/inflector/methods.rb:230:in `block in constantize'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/inflector/methods.rb:229:in `each'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/inflector/methods.rb:229:in `constantize'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:554:in `get'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/routing/route_set.rb:69:in `controller_reference'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/routing/route_set.rb:54:in `controller'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/routing/route_set.rb:32:in `call'
vendor/bundle/ruby/1.9.1/gems/journey-1.0.4/lib/journey/router.rb:68:in `block in call'
vendor/bundle/ruby/1.9.1/gems/journey-1.0.4/lib/journey/router.rb:56:in `each'
vendor/bundle/ruby/1.9.1/gems/journey-1.0.4/lib/journey/router.rb:56:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/routing/route_set.rb:608:in `call'
vendor/bundle/ruby/1.9.1/gems/rack-openid-1.3.1/lib/rack/openid.rb:98:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
vendor/bundle/ruby/1.9.1/gems/rack-1.4.5/lib/rack/etag.rb:23:in `call'
vendor/bundle/ruby/1.9.1/gems/rack-1.4.5/lib/rack/conditionalget.rb:25:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/head.rb:14:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/params_parser.rb:21:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/flash.rb:242:in `call'
vendor/bundle/ruby/1.9.1/gems/rack-1.4.5/lib/rack/session/abstract/id.rb:210:in `context'
vendor/bundle/ruby/1.9.1/gems/rack-1.4.5/lib/rack/session/abstract/id.rb:205:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/cookies.rb:341:in `call'
vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/query_cache.rb:64:in `call'
vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/callbacks.rb:28:in `block in call'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/callbacks.rb:405:in `_run__1018047051__call__644581783__callbacks'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/callbacks.rb:405:in `__run_callback'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/callbacks.rb:81:in `run_callbacks'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/callbacks.rb:27:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/rack/logger.rb:32:in `call_app'
vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/rack/logger.rb:16:in `block in call'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/tagged_logging.rb:22:in `tagged'
vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/rack/logger.rb:16:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/request_id.rb:22:in `call'
vendor/bundle/ruby/1.9.1/gems/rack-1.4.5/lib/rack/methodoverride.rb:21:in `call'
vendor/bundle/ruby/1.9.1/gems/rack-1.4.5/lib/rack/runtime.rb:17:in `call'
vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/cache/strategy/local_cache.rb:72:in `call'
vendor/bundle/ruby/1.9.1/gems/rack-1.4.5/lib/rack/lock.rb:15:in `call'
vendor/bundle/ruby/1.9.1/gems/actionpack-3.2.17/lib/action_dispatch/middleware/static.rb:63:in `call'
vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:136:in `forward'
vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:245:in `fetch'
vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:185:in `lookup'
vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:66:in `call!'
vendor/bundle/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:51:in `call'
vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/engine.rb:484:in `call'
vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/application.rb:231:in `call'
vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/railtie/configurable.rb:30:in `method_missing'
vendor/bundle/ruby/1.9.1/gems/rack-1.4.5/lib/rack/urlmap.rb:64:in `block in call'
vendor/bundle/ruby/1.9.1/gems/rack-1.4.5/lib/rack/urlmap.rb:49:in `each'
vendor/bundle/ruby/1.9.1/gems/rack-1.4.5/lib/rack/urlmap.rb:49:in `call'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/lib/thin/connection.rb:80:in `block in pre_process'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/lib/thin/connection.rb:78:in `catch'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/lib/thin/connection.rb:78:in `pre_process'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/lib/thin/connection.rb:53:in `process'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/lib/thin/connection.rb:38:in `receive_data'
vendor/bundle/ruby/1.9.1/gems/eventmachine-1.0.3-x86-mingw32/lib/eventmachine.rb:187:in `run_machine'
vendor/bundle/ruby/1.9.1/gems/eventmachine-1.0.3-x86-mingw32/lib/eventmachine.rb:187:in `run'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/lib/thin/backends/base.rb:61:in `start'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/lib/thin/server.rb:159:in `start'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/lib/thin/controllers/controller.rb:86:in `start'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/lib/thin/runner.rb:185:in `run_command'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/lib/thin/runner.rb:151:in `run!'
vendor/bundle/ruby/1.9.1/gems/thin-1.3.1-x86-mingw32/bin/thin:6:in `<top (required)>'
bin/thin:16:in `load'
bin/thin:16:in `<main>'

LoadError (No such file to load -- spreadsheet) - that is the problem.
gem spreadsheet is missing.
Not familiar with bitnami but have you run bundle install or gem install spreadsheet?

Karel Pičman wrote:

LoadError (No such file to load -- spreadsheet) - that is the problem.
gem spreadsheet is missing.
Not familiar with bitnami but have you run bundle install or gem install spreadsheet?

Hi Karel,
this is the list of gems available in my machine. Spreadsheet and rubyzip gems are already available in my machine.

C:\Webserver\ruby>gem list

• LOCAL GEMS ***

actionmailer (3.2.17)
actionpack (3.2.17)
activemodel (3.2.17)
activerecord (3.2.17)
activeresource (3.2.17)
activesupport (3.2.17)
akami (1.2.0)
ansi (1.4.3)
arel (3.0.2)
atomic (1.1.14)
aws-sdk (1.8.3.1)
bcrypt-ruby (3.0.1 x86-mingw32)
bigdecimal (1.1.0)
bluecloth (2.1.0 x86-mingw32)
builder (3.0.0)
bundler (1.5.3)
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)
gyoku (0.4.6)
hike (1.2.1)
hoe (3.0.6)
hpricot (0.8.5)
httparty (0.8.3)
i18n (0.6.4)
iconv (1.0.3)
io-console (0.3)
journey (1.0.4)
jquery-rails (2.1.3)
json (1.7.7, 1.5.4)
mail (2.5.4)
mime-types (1.19)
mini_magick (3.4)
mini_portile (0.5.0)
minitest (2.5.1)
multi_json (1.3.6)
multi_xml (0.5.1)
mustache (0.99.4)
mysql2 (0.3.11 x86-mingw32, 0.2.18)
nokogiri (1.6.0 x86-mingw32, 1.5.5 x86-mingw32, 1.4.7 x86-mingw32)
pg (0.16.0 x86-mingw32)
polyglot (0.3.3)
rack (1.4.5)
rack-cache (1.2)
rack-mount (0.8.3)
rack-ssl (1.3.2)
rack-test (0.6.1)
rails (3.2.17)
railties (3.2.17)
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)
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.7)
rubygems-update (1.8.24)
rubyzip (1.1.2)
rvm (1.11.3.5)
sass (3.1.20)
sass-rails (3.2.5)
spreadsheet (0.9.7)
sprockets (2.4.5, 2.2.1)
sqlite3 (1.3.8 x86-mingw32)
sqlite3-ruby (1.3.2 x86-mingw32)
subexec (0.2.2)
thin (1.3.1)
thor (0.15.4)
tilt (1.3.3)
treetop (1.4.10)
turn (0.9.6)
tzinfo (0.3.33)
uglifier (1.2.6)
uuidtools (2.1.3)

Hmm. I dunno :-(
Check the previuos posts. The same problem has been already discussed a few times.

Karel Pičman wrote:

Hmm. I dunno :-(
Check the previuos posts. The same problem has been already discussed a few times.

Dear Karel,

Thanks for spending your precious time to look into this problem. Some how I will find the solution for same.

Dear Karel,
Today somehow, I have managed to make redmine_xls_export plugin(version 0.2.1.t5) to work partially. I actually there was a gem dependency due to which this plugin didn't work. That gem was zip-zip. Once again thanks for your valuable help.

Right now, the problem which I am facing is that the Quick Export is working fine but the Detailed Export showing Error 404. Same error is showing while landing on plugin configuration page.

Can somebody helps me to make it works smoother.

Lajish Lakshmanan wrote:

Right now, the problem which I am facing is that the Quick Export is working fine but the Detailed Export showing Error 404. Same error is showing while landing on plugin configuration page.

Did you install Plugin views with revisions plugin and run following rake?

rake redmine:plugins:process_version_change RAILS_ENV=production

Tatsuya Saito wrote:

Lajish Lakshmanan wrote:

Right now, the problem which I am facing is that the Quick Export is working fine but the Detailed Export showing Error 404. Same error is showing while landing on plugin configuration page.

Did you install Plugin views with revisions plugin and run following rake?

rake redmine:plugins:process_version_change RAILS_ENV=production

Thanks Tatsuya for your immediate response

Hi Tatsuya,
Is there any provision to export issues to excel using choose columns as that of CSV export.

Lajish Lakshmanan wrote:

Is there any provision to export issues to excel using choose columns as that of CSV export.

Use Export selected columns only in Detailed or Configure page.
Selected columns are specified options in Issues page.

Tatsuya Saito wrote:

Lajish Lakshmanan wrote:

Is there any provision to export issues to excel using choose columns as that of CSV export.

Use Export selected columns only in Detailed or Configure page.
Selected columns are specified options in Issues page.

I actually meant for selection of individual columns of issues. How can I export customized columns.

Ok Tatsuya,

Please neglect my previous comment. Now I got what u meant. Thanks for your information.

Hi Tatsuya,

One thing towards which I need to draw your attention is that it would be more presentable if exported excel column header fonts comes in White color. Since right now, column headers which has background color is much closer black color which diminishes cell content. Please check the attached image.

Lajish Lakshmanan wrote:

One thing towards which I need to draw your attention is that it would be more presentable if exported excel column header fonts comes in White color. Since right now, column headers which has background color is much closer black color which diminishes cell content. Please check the attached image.

I understand your request and will implement it.
Can you issue your request to Github?

Hi all,

My redmine is 2.5.1, redmine_xls_export is 0.2.1. I am not sure that my steps are correct. As described above, I realized that Detailed export does not work, but Quick export works fine. First I run dos2unix for each .rb and .yml recursively inside plugin folder. Once it helped to solve a stupid problem with non-working localization yml. In this case dos2unix is unhelpful.

Because I am not a developer, I decided to hide option for detailed export from the bottom of the page.

in file redmine_xls_export/lib/xls_export_hooks.rb I commented 3 lines (12,13,14):

      ret_str << content_tag('span', link_to(l(:label_plugin_xlse_export_format_detailed),
                                             hook_url_for({ :controller => 'xls_export', :action => 'index', :project_id => context[:project] }),
                                            { :class => 'xlse', :title => l(:label_plugin_xlse_export_format_detailed_tooltip) }))

Mime::Type.register('application/vnd.ms-excel', :xls, %w(application/vnd.ms-excel)) unless defined?(Mime::XLS)
Mime::Type.register('application/vnd.ms-excel', :xls, %w(application/vnd.ms-excel)) unless defined?(Mime::XLS)

Done. I have got almost operable plugin with quick xls export, without detailed option on issue page. Global settings work.

Ivan Rapekas wrote:

My redmine is 2.5.1, redmine_xls_export is 0.2.1. I am not sure that my steps are correct. As described above, I realized that Detailed export does not work, but Quick export works fine.

Please try following repository:
https://github.com/two-pack/redmine_xls_export

And can you tell details of error like logs if you have the error yet after above?

Tatsuya Saito wrote:

Please try following repository:
https://github.com/two-pack/redmine_xls_export

And can you tell details of error like logs if you have the error yet after above?

Installed from this repo, get an exception:

Started GET "/issues_xls_export" for 127.0.0.1 at 2014-06-26 13:35:06 +0400
Processing by XlsExportController#index as HTML
  Current user: *** (id=22)
=========== Applying access filters ==============
Current user is Сашка Родионов
No filters fit
Missing template, responding with 404
  Rendered common/error.html.erb within layouts/base (0.7ms)
  Rendered inline template (3.0ms)
  Rendered plugins/redmine_create_wiki_page/app/views/create_wiki_page/_init_create_wiki_page.erb (0.1ms)
  Rendered inline template (2.7ms)
  Rendered plugins/redmine_time_tracker/app/views/time_trackers/_assets.html.erb (7.8ms)
  Rendered plugins/single_auth/app/views/hooks/single_auth/_html_head.html.erb (1.7ms)
  Rendered plugins/clipboard_image_paste/app/views/clipboard_image_paste/_headers.html.erb (4.3ms)
  Rendered plugins/redmine_pusher_notifications/app/views/layouts/_pusher.html.erb (1.0ms)
  Rendered plugins/sidebar/app/views/sidebar/_base.html.erb (0.1ms)
  Rendered plugins/redmine_banner/app/views/banner/_project_body_bottom.html.erb (0.1ms)
  Rendered plugins/sidebar_hide/app/views/sidebar/_hideButton_partial.html.erb (1.4ms)
  Rendered plugins/clipboard_image_paste/app/views/clipboard_image_paste/_add_form.html.erb (3.2ms)
Completed 404 Not Found in 925.4ms (Views: 300.9ms | ActiveRecord: 21.5ms)

Ivan Rapekas wrote:

Installed from this repo, get an exception:

Did you install Plugin views with revisions and run following rake command after clone the repo?

rake redmine:plugins:process_version_change RAILS_ENV=production

Tatsuya Saito wrote:

Did you install Plugin views with revisions and run following rake command after clone the repo?

Dear Tatsuya-san, thank you so much for this problem. I've never used such command before. Now it cannot be executed:

rake redmine:plugins:process_version_change RAILS_ENV=production --trace
rake aborted!
Don't know how to build task 'redmine:plugins:process_version_change'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/lib/rake/task_manager.rb:49:in `[]'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/lib/rake/application.rb:148:in `invoke_task'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/lib/rake/application.rb:106:in `block (2 levels) in top_level'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/lib/rake/application.rb:106:in `each'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/lib/rake/application.rb:106:in `block in top_level'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/lib/rake/application.rb:115:in `run_with_threads'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/lib/rake/application.rb:100:in `top_level'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/lib/rake/application.rb:78:in `block in run'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/lib/rake/application.rb:165:in `standard_exception_handling'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/lib/rake/application.rb:75:in `run'
/usr/local/lib/ruby/gems/2.0.0/gems/rake-10.1.1/bin/rake:33:in `<top (required)>'
/usr/local/bin/rake:23:in `load'
/usr/local/bin/rake:23:in `<main>'

I have 2 questions:

1.if installed rubyzip gem, export attachments can be selected, and click quick export, there will be a zip file to export, but open the zip file, the file in it called workbook cannot opened, seems broken.
2.exported xls file has 2 repeated info. in the 1st, 2nd column, they are both issue ID.

Can the 2 be resolved?

Thanks, I am using it in redmine 2.3.2.

li an wrote:

I have 2 questions:

I don't know like them.

What version of the plugin do you use?
And please issue them to https://github.com/two-pack/redmine_xls_export/issues and write more information to reproduce them if you can.

Hi, I remove the plug-in and re setup with ur guide, but still fail with the 2 issues I submit.

1. I put the plug-in with the latest version in redmine plugins directory, and the plugin name is "redmine_xls_export", I run the installation like below:

1)I remove the rubzip lines in gemfile.lock
2)bundle install --no-deployment
3)although bundle install is done, rubyzip1.1.6 and zip-zip 0.3 are not installed automatically, so I download them from rubygems.org and installed the 2 gems.
4)migrate the plug-in

Then in the gemfile.lock there are 2 lines:
Line 175: rubyzip (1.1.6)
Line 243: rubyzip (>= 1.0.0)

5)I set the configuration of redmine, make exported attachment be selected in the plug-in configuration.

2.For export attachments cannot be used, I unselect export attachments option from the configuration and export xls using "quick",but 2 repeated columns of issue id shown.

Thanks,do bundle install at redmine\htdocs and use the latest release, all the issues are fixed.

But there are another issue and feature request I have submitted on github. Hope to get more guide. Thanks much about your effort.

Hi, I have attach the exported xls date snapshot compared with defalut display format in redmine.

I have tested 2 format, yyyy.mm.dd, yyyy/mm/dd, the same issue, though it shows as yyyy/mm/dd, yyyy.mm.dd, click the cell, the content still has hh:mm:ss, so for analysis statistics, still needs to deal with the date format to remove hh:mm:ss info.