Project

General

Profile

XLS export plugin

Added by Vitaly Klimov almost 15 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 Ki Won Kim over 14 years ago

Thanks a lot Vitaly Klimov

I attached "Korean" translated locale file.
and some suggestions...

  1. exported file's "description" context are not converted from wiki
    ex) wiki context : p>.!attachmentImageFile! that p>.!attachmentImageFile! exported by raw text.
  2. "Suggest export name" check and project was not only English name
    then suggested export file name was not recognition.
    ex) Project name : Issue Tracker 테스트용 => suggested name : Issue_Tracker__뚯뒪_몄슜_issues_export.xls

I hope you understand what I am not familiar with English. :-)

ko.yml (986 Bytes) ko.yml Korean translated file

RE: Exchage Korean translated file - Added by Ki Won Kim over 14 years ago

Exchage Korean translated file.

"export name suffix" was asia language character then
exported file name are broken above [No 2.] symptoms.

ko.yml (949 Bytes) ko.yml Korean translated file

RE: XLS export plugin - Added by Vitaly Klimov over 14 years ago

I attached "Korean" translated locale file.

Thank you for the translation

Regarding your suggestions:

exported file's "description" context are not converted from wiki

Unfortunately right now it is not possible to apply any formatting individual characters inside XLS cell and XLS cell format not support nested tables so this is the best export can do for now

"Suggest export name" check and project was not only English name then suggested export file name was not recognition.

Actually, i was able to save file with Russian characters in it (name of the tracker) on my filesystem and the open it with no problems.

RE: XLS export plugin - Added by strexy strexy over 14 years ago

Thanks Vitaly, this plugin is very useful!
One question: is there a way to export other lists like those in project report/details? Not only the issues list..

RE: XLS export plugin - Added by Frode Marton Meling over 14 years ago

First of all, does the plugin utilize local filestorage?
If, yes, it should use memcache instead, then it will be usable on heroku as well.

I tried to use this, but it blows up while exporting. Here is the error:

Note, I have a issue that start with "Setup new email..."

 Iconv::IllegalSequence in IssuesController#xls_export_action

"\223setup new email"...

RAILS_ROOT: /Users/marton/development/rails_apps/smpro_redmine
Application Trace | Framework Trace | Full Trace

/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/encodings.rb:29:in `iconv'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/encodings.rb:29:in `internal'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/biff8.rb:43:in `_unicode_string'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:508:in `_write_sst'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/activerecord/lib/active_record/base.rb:2197:in `each_with_index'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:502:in `each'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:502:in `each_with_index'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:502:in `_write_sst'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:489:in `write_sst'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:439:in `write_from_scratch'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:620:in `write_workbook'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/writer.rb:12:in `write'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/workbook.rb:106:in `write'
/Users/marton/development/rails_apps/smpro_redmine/vendor/plugins/redmine_default_columns/lib/xls_export.rb:203:in `issues_to_xls2'
/Users/marton/development/rails_apps/smpro_redmine/vendor/plugins/redmine_default_columns/lib/issues_controller_xls_patch.rb:43:in `xls_export_action'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `send'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `perform_action_without_filters'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:617:in `call_filters'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/benchmark.rb:308:in `realtime'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in `perform_action_without_flash'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/flash.rb:146:in `perform_action'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `send'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/base.rb:532:in `process_without_filters'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/base.rb:391:in `process'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/base.rb:386:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:437:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in `dispatch'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:121:in `_call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:130
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in `cache'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in `call'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/head.rb:9:in `call'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/methodoverride.rb:24:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/session/cookie_store.rb:93:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in `call'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/lock.rb:11:in `synchronize'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:114:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/reloader.rb:34:in `run'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:108:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/railties/lib/rails/rack/static.rb:31:in `call'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/urlmap.rb:46:in `call'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in `each'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in `call'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/railties/lib/rails/rack/log_tailer.rb:17:in `call'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/content_length.rb:13:in `call'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/handler/webrick.rb:50:in `service'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/webrick/server.rb:162:in `start'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/webrick/server.rb:95:in `start'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/webrick/server.rb:92:in `each'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/webrick/server.rb:92:in `start'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/webrick/server.rb:23:in `start'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/1.8/webrick/server.rb:82:in `start'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/rack-1.0.1/lib/rack/handler/webrick.rb:14:in `run'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/railties/lib/commands/server.rb:111
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
/Users/marton/.rvm/rubies/ruby-1.8.7-p249/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
script/server:3

/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/encodings.rb:29:in `iconv'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/encodings.rb:29:in `internal'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/biff8.rb:43:in `_unicode_string'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:508:in `_write_sst'
/Users/marton/development/rails_apps/smpro_redmine/vendor/rails/activerecord/lib/active_record/base.rb:2197:in `each_with_index'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:502:in `each'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:502:in `each_with_index'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:502:in `_write_sst'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:489:in `write_sst'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:439:in `write_from_scratch'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:620:in `write_workbook'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/writer.rb:12:in `write'
/Users/marton/.rvm/gems/ruby-1.8.7-p249/gems/spreadsheet-0.6.4.1/lib/spreadsheet/workbook.rb:106:in `write'
/Users/marton/development/rails_apps/smpro_redmine/vendor/plugins/redmine_default_columns/lib/xls_export.rb:203:in `issues_to_xls2'

RE: XLS export plugin - Added by Vitaly Klimov over 14 years ago

Actually, i am using StringIO stream, not the local file storage. Also i noticed that you installed plugin to the folder named redmine_default_columns.

Folder in which plugin should be installed should have name redmine_xls_export. Attached is the repack of the plugin that contains this folder by default.

RE: XLS export plugin - Added by Vitaly Klimov over 14 years ago

strexy strexy wrote:

One question: is there a way to export other lists like those in project report/details? Not only the issues list..

So far it is possible to export issue lists only

RE: XLS export plugin - Added by Vitaly Klimov over 14 years ago

I tried to use this, but it blows up while exporting. Here is the error:
"\223setup new email"...
Note, I have a issue that start with "Setup new email..."

It seems that you have characters in the text which are not into UTF-8 charset which is used by plugin.

Same issue discussed here:

http://rubyforge.org/forum/forum.php?thread_id=44946&forum_id=2920

So far you can change spreadsheet encoding to the compatible one by changing line 48 in file lib\xls_export.rb

Spreadsheet.client_encoding = 'UTF-8'

from UTF-8 to the compatible encoding

RE: XLS export plugin - Added by Erika Unverfährt over 14 years ago

Folder in which plugin should be installed should have name redmine_xls_export.
Attached is the repack of the plugin that contains this folder by default.

Hi Vitaly,

I've tried the redmine_xls_export_v003b.zip, but the error no such file to load -- xls_export remains. I'm running redmine 0.9.3 with the plugins:-

acts_as_... {activity_provider,attachable,customizable,event,list,searchable,tree,versioned,watchable}
awesome_nested_set
budget_plugin
chantra-redmine_newissuealerts
classic_pagination
coderay-0.7.6.227
customer_plugin
engines
gravatar
kumudhachari-global_filter_redmine_plugin
open_id_authentication
prepend_engine_views
redmine_rate
redmine_xls_export
rfpdf
ruby-net-ldap-0.0.4
timesheet_plugin

What can I do to get it working?

Thanks, sultansofswing.

RE: XLS export plugin - Added by Vitaly Klimov over 14 years ago

I've tried the redmine_xls_export_v003b.zip, but the error no such file to load -- xls_export remains.

Erika, at what point do you get this error? Does it happen when you press 'XLS' or 'XLS+' link?

RE: XLS export plugin - Added by Oleg Shiff over 14 years ago

Виталий!
У меня такая же, как в предыдущем посте, ошибка. Возникает при установке:

rake db:migrate_plugins RAILS_ENV=production
(in /opt/redmine/redmine-0.8.6)
rake aborted!
no such file to load -- xls_export

--trace

rake db:migrate_plugins RAILS_ENV=production --trace
(in /opt/redmine/redmine-0.8.6)
rake aborted!
no such file to load -- xls_export
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/dependencies.rb:510:in `require'
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/dependencies.rb:355:in `new_constants_in'
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/dependencies.rb:510:in `require'
/opt/redmine/redmine-0.8.6/vendor/plugins/redmine_default_columns/init.rb:5:in `evaluate_init_rb'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/rails/plugin.rb:95:in `evaluate_init_rb'
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/core_ext/kernel/reporting.rb:11:in `silence_warnings'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/rails/plugin.rb:91:in `evaluate_init_rb'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/rails/plugin.rb:44:in `load'
./config/../vendor/plugins/engines/lib/engines/plugin.rb:77:in `load'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/rails/plugin/loader.rb:33:in `load_plugins'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/rails/plugin/loader.rb:32:in `each'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/rails/plugin/loader.rb:32:in `load_plugins'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/initializer.rb:292:in `load_plugins'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/initializer.rb:142:in `process'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/initializer.rb:97:in `send'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/initializer.rb:97:in `run'
./config/environment.rb:20
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/dependencies.rb:510:in `require'
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/dependencies.rb:355:in `new_constants_in'
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/dependencies.rb:510:in `require'
/opt/redmine/redmine-0.8.6/vendor/plugins/redmine_whining/lib/tasks/whining.rake:30
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/dependencies.rb:503:in `load'
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/dependencies.rb:503:in `load'
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/dependencies.rb:355:in `new_constants_in'
/opt/redmine/redmine-0.8.6/vendor/rails/activesupport/lib/active_support/dependencies.rb:503:in `load'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/tasks/rails.rb:7
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/tasks/rails.rb:7:in `each'
/opt/redmine/redmine-0.8.6/vendor/rails/railties/lib/tasks/rails.rb:7
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/opt/redmine/redmine-0.8.6/Rakefile:10
/home/aum/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2383:in `load'
/home/aum/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2383:in `raw_load_rakefile'
/home/aum/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2017:in `load_rakefile'
/home/aum/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/home/aum/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2016:in `load_rakefile'
/home/aum/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2000:in `run'
/home/aum/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/home/aum/.gem/ruby/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/home/aum/.gem/ruby/1.8/gems/rake-0.8.7/bin/rake:31
/usr/local/bin/rake:19:in `load'
/usr/local/bin/rake:19

gems

gem list

*** LOCAL GEMS ***

actionmailer (2.3.5)
actionpack (2.3.5)
activerecord (2.3.5)
activeresource (2.3.5)
activesupport (2.3.5)
fastthread (1.0.7)
gemcutter (0.5.0)
hoe (2.5.0)
json_pure (1.2.3)
multi_rails (0.0.4)
passenger (2.2.9)
rack (1.1.0, 1.0.1)
rails (2.3.5)
rake (0.8.7)
rcov (0.9.8)
ruby-ole (1.2.10.1)
rubyforge (2.0.4)
spreadsheet (0.6.4.1)

redmine 0.8.6 + Passenger + ubuntu 9.10
ruby 1.8.7

plugin в каталоге redmine_default_columns

Поможете?
Заранее спасибо.

RE: XLS export plugin - Added by Vitaly Klimov over 14 years ago

Please remove folder redmine_default_columns and extract contents of the redmine_xls_export_v003b.zip archive to the vendors/plugins folder. See if it helps.

Unfortunately i am not able to edit my own posts so there is still an error in the folder name in the original description of the plugin.

RE: XLS export plugin - Added by Erika Unverfährt over 14 years ago

Vitaly,

I get the error when trying to migrate the database:

redmine@devel:~/redmine-0.9.3$ rake db:migrate_plugins --trace
(in /var/redmine/redmine-0.9.3)
** Invoke db:migrate_plugins (first_time)
** Invoke environment (first_time)
** Execute environment
rake aborted!
no such file to load -- xls_export
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'
/var/redmine/redmine-0.9.3/vendor/rails/activesupport/lib/active_support/dependencies.rb:158:in `require'
/var/redmine/redmine-0.9.3/vendor/plugins/redmine_xls_export/init.rb:5:in `evaluate_init_rb'
/var/redmine/redmine-0.9.3/config/../vendor/rails/railties/lib/rails/plugin.rb:158:in `evaluate_init_rb'
/var/redmine/redmine-0.9.3/vendor/rails/activesupport/lib/active_support/core_ext/kernel/reporting.rb:11:in `silence_warnings'
/var/redmine/redmine-0.9.3/config/../vendor/rails/railties/lib/rails/plugin.rb:154:in `evaluate_init_rb'
/var/redmine/redmine-0.9.3/config/../vendor/rails/railties/lib/rails/plugin.rb:48:in `load'
/var/redmine/redmine-0.9.3/config/../vendor/plugins/engines/lib/engines/plugin.rb:44:in `load'
/var/redmine/redmine-0.9.3/config/../vendor/rails/railties/lib/rails/plugin/loader.rb:38:in `load_plugins'
/var/redmine/redmine-0.9.3/config/../vendor/rails/railties/lib/rails/plugin/loader.rb:37:in `each'
/var/redmine/redmine-0.9.3/config/../vendor/rails/railties/lib/rails/plugin/loader.rb:37:in `load_plugins'
/var/redmine/redmine-0.9.3/config/../vendor/rails/railties/lib/initializer.rb:369:in `load_plugins'
/var/redmine/redmine-0.9.3/config/../vendor/rails/railties/lib/initializer.rb:165:in `process'
/var/redmine/redmine-0.9.3/config/../vendor/rails/railties/lib/initializer.rb:113:in `send'
/var/redmine/redmine-0.9.3/config/../vendor/rails/railties/lib/initializer.rb:113:in `run'
/var/redmine/redmine-0.9.3/config/environment.rb:20
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'
/var/redmine/redmine-0.9.3/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
/var/redmine/redmine-0.9.3/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in'
/var/redmine/redmine-0.9.3/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require'
/var/redmine/redmine-0.9.3/vendor/rails/railties/lib/tasks/misc.rake:4
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:636:in `call'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:636:in `execute'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:631:in `each'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:631:in `execute'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain'
/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:607:in `invoke_prerequisites'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:604:in `each'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:604:in `invoke_prerequisites'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:596:in `invoke_with_call_chain'
/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:583:in `invoke'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:2029:in `each'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:2001:in `run'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/var/redmine/gems/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/var/redmine/gems/gems/rake-0.8.7/bin/rake:31
/var/redmine/gems/bin/rake:19:in `load'
/var/redmine/gems/bin/rake:19

And it doesn't matter if I extract the file into vendor/plugins/redmine_default_columns or vendor/plugins/redmine_xls_export folder.

BTW, could it be of importance that I have modified the base URL so that any URLs are based on <hostname>/redmine/ ?

Redmine::Utils::relative_url_root = "/redmine" 

RE: XLS export plugin - Added by Vitaly Klimov over 14 years ago

I think i know what the problem is - apparently i am on Windows platform where folder names are case insensitive so i made a mistake and named some folders using capital letters. In the Unix environments where names are case sensitive it caused the problem. Please remove plugin folder and extract attached archive (redmine_xls_export_v004.zip) into vendor/plugins and see if it works now.

RE: XLS export plugin - Added by Alex Last over 14 years ago

I was able to load data from Redmine to Microsoft Excel using VBA macros and Redmine REST API. This does not require any plugins installed on Redmine. Is anyone interested in my solution? I can post it somewhere (where?).

RE: XLS export plugin - Added by Carl Pef over 14 years ago

Hello Alexey,

sharing your solution could be very helpfull !

You may upload a zip file, open a projet on github... :)

Keep up the good work,
B.

RE: XLS export plugin - Added by Alex Last over 14 years ago

Thanks, Bertrand. I will polish the scripts and then share them.
I was able to use them to load data from redmine to Microsoft Project and Microsoft Excel.
I created a discussion about other REST API improvements, which are required:
http://www.redmine.org/boards/1/topics/13062

RE: XLS export plugin - Added by Andrew Leaf over 14 years ago

+1 for the VBA scripts!

I'd love to work with these.

Cheers,

Andrew

RE: XLS export plugin - Added by Nicolás P. over 14 years ago

I've just installed the plug in and when I try to export issue via the "XLS" or "XLS+" link I get the following error:

Processing IssuesController#index to xls (for xxxxxxxxx at 2010-04-21 13:02:47) [GET]
  Parameters: {"format"=>"xls", "project_id"=>"xxxxxxxxxx", "action"=>"index", "controller"=>"issues"}

NoMethodError (undefined method `count' for #<Spreadsheet::Row:0xb5db4f24>):
  /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
  /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
  /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
  /usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
  /usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
  /usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:82:in `start'

Rendering /opt/redmine/public/500.html (500 Internal Server Error)

The plug in is installed in vendor/plugins/redmine_xls_export. I've run rake db:migrate_plugins and installed the gem too.

Is this a bug, or an error in the installation?

RE: XLS export plugin - Added by Alex Last over 14 years ago

This is the draft version:
Microsoft project file with VBA scripts to load Redmine data through REST API.

I need someone to convert this into a Visual basic class module / library, which can be reused in other projects or in Excel.
I'm not an expert in Visual Basic or VBA.
Tried to export classes from VBA itself, but looks like VBA used by Microsoft Office 2007 is a total piece of crap. I'm very frustrated with it - it can't import external VB classes from disk, so I have no idea how to reuse them between MSP/Excel or between several independent projects.

redmine_support.mpp (345 KB) redmine_support.mpp Microsoft project file with VBA scripts to load Redmine data through REST API

RE: XLS export plugin - Added by Carl Pef over 14 years ago

Thanks for your script Alexei :)

Yeah, I do understand your frustration with VBA.

What about extracting your code, and using it in a standalone
application ?

The way I see it, it could a tool with a simple GUI using MSProject through COM.
The user may input the redmine Url, the credentials info and other options.
The tool then creates a new MS Project file with the data exported from the
REST API.
The application will be a .Net 2.0 standalone executable (.net framework will be required).
That way, the error management will be easier and we even could target
different versions of MsProject (or even other tools if they expose a COM interface)

I'm a a Office/.Net/VB.Net developer. So if it's ok with you, I can give it
a try and uploading a first draft of the application by the week end.

What do you think ?

Bertrand.

RE: MS Projet Importer - Added by Carl Pef over 14 years ago

It seems that the MsProject importer is already done !
And implemented on the server side.
And supporting GantProject, OpenProj too !

See here : http://www.redmine.org/issues/1460

Bertrand.

RE: XLS export plugin - Added by Alex Last over 14 years ago

Bertrand, I'm afraid that "MSproject importer" only copies data from Microsoft Project to Redmine, while I think the MOST value has the other way around: redmine->MSP.

feel free to extract the VB code from the MSP file (it's here: http://code.google.com/p/redmine-connect/downloads/list ).

my idea was to extract the code into some reusable class library, which could be referenced in VBA scripts in Microsoft project or Excel files.
having an independent application connecting to redmine AND to an MSP file is probably an acceptable solution too, but it can be implemented in any language, including Java.

it actually might be even better to have a desktop app to do that because this way end-user does not have to know any VBA scripting, which is always good. I suggest you upload your experiments to http://code.google.com/p/redmine-connect/ website.

RE: XLS export plugin - Added by strexy strexy over 14 years ago

Hi all,
I've installed gem spreadsheet (0.6.4.1) and the issues xls export plugin with no errors.
I can access to the plugin configuration page but when I click on both XLS and XLS+ link down the issues list page the browser point to http://myredmineinstallation/issues.xls , a blank page. It doesn't download anything (the other links: csv, pdf works correctly).

What's the problem?

redmine 0.9.3 stable
linux /mysql
plugins: redmine charts, redmine schedules plugin, issues xls export

Hope someone help me, thanks.

|s

RE: XLS export plugin strange behaviour - Added by strexy strexy over 14 years ago

I correct myself. When I click on the XLS+ link down in the issues list I obtain a 403 error.
Could someone help me,please?

|s

(1-25/276)