Project

General

Profile

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

  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 Lajish Lakshmanan over 10 years ago

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>'

RE: XLS export plugin - Added by Karel Pičman over 10 years ago

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?

RE: XLS export plugin - Added by Lajish Lakshmanan over 10 years ago

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)

RE: XLS export plugin - Added by Karel Pičman over 10 years ago

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

RE: XLS export plugin - Added by Lajish Lakshmanan over 10 years ago

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.

RE: XLS export plugin - Added by Lajish Lakshmanan over 10 years ago

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.

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

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

RE: XLS export plugin - Added by Lajish Lakshmanan over 10 years ago

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

RE: XLS export plugin - Added by Lajish Lakshmanan over 10 years ago

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

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

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.

RE: XLS export plugin - Added by Lajish Lakshmanan over 10 years ago

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.

RE: XLS export plugin - Added by Lajish Lakshmanan over 10 years ago

Ok Tatsuya,

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

RE: XLS export plugin - Added by Lajish Lakshmanan over 10 years ago

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.

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

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?

RE: XLS export plugin - Added by Ivan Rapekas over 10 years ago

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) }))

in file redmine_xls_export/init.rb I commented 2 lines (38 and 43, identical):
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.

redmine_xls_export.zip (33 KB) redmine_xls_export.zip 0.2.1 without detailed export, improved russian translate

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

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?

RE: XLS export plugin - Added by Ivan Rapekas over 10 years ago

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)

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

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

RE: XLS export plugin - Added by Ivan Rapekas over 10 years ago

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>'

So, I am really satisfated with hiding Detailed Export. It is enough for me...

RE: XLS export plugin - Added by li an almost 10 years ago

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.

RE: XLS export plugin - Added by Tatsuya Saito almost 10 years ago

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.

RE: XLS export plugin - Added by li an almost 10 years ago

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.

RE: XLS export plugin - Added by li an almost 10 years ago

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.

RE: XLS export plugin - Added by li an almost 10 years ago

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

RE: XLS export plugin - Added by li an almost 10 years ago

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.

(226-250/276)