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 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 runbundle install
orgem 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.
Xls Export.png (23.2 KB) Xls Export.png |
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.
Xls Export.png (9.33 KB) Xls Export.png |
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 about 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 about 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 about 10 years ago
Tatsuya Saito wrote:
Please try following repository:
https://github.com/two-pack/redmine_xls_exportAnd 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 about 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 about 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.