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)

Uninstall XLS export plugin - Added by IT Admin about 10 years ago

Hi all,

I'm trying to migrate to 2.6 of redmine from 2.5, however this plugin is causing me an issue.

I don't need the plugin in the new version of redmine so have tried unistalling it usign the below command

rake redmine:plugins:migrate NAME=redmine_xls_export VERSION=0 RAILS_ENV=production

If I trace the above I get the following:

(in /opt/bitnami/apps/redmine/htdocs)
  • Invoke redmine:plugins:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
  • Execute redmine:plugins:migrate
    Migrating redmine_xls_export (Issues XLS export)...
  • Invoke db:schema:dump (first_time)
  • Invoke environment
  • Invoke db:load_config (first_time)
  • Execute db:load_config
  • Execute db:schema:dump

Now at this point I would assume that the plugin was now un-installed, so I then remove the plugin dir (rm -rf redmine_zls_export), though when I restart redmine I get a big error saying 'Ooops something went wrong'. So can only assume the rake update missed some things.

The version of the plugin I am using is 0.2.1.t6

Has anyone else experienced this as it is hampering my task of upgrading to a latest redmine.

Cheers

RE: XLS export plugin - Added by Pavel Potcheptsov about 10 years ago

There is no migration for this plugin, it doesn't use database, so you can skip migration to version=0 step and just delete it and maybe redmine_plugin_views_revisions that comes with last version of xls plugin.
The error was provided by you is not clear, clean production log, then restart redmine and provide log here.

RE: XLS export plugin - Added by IT Admin about 10 years ago

Hi Pavel,

Cheers for the update, I have now simply removed redmine_xls_export and the redmine_views_revisions from the plugins folder and cleared the production.log file, though redmine still complains that something has gone wrong but please find below the log file (have seperated the log file out so you can see at each bit I've done).

It doesn't seem to show anything wrong to me...

  • PRODCUTION LOG CLEARED - THIS SECTION IS THE LOG WHEN NO CHANGES HAVE BEEN MADE AND REDMINE WORKS AS REQUIRED - JUST FOR INFO PURPOSES ***
    Connecting to database specified by database.yml
    XLS export controller: rubyzip gem not available
    Creating scope :system. Overwriting existing method Enumeration.system.
    Creating scope :sorted. Overwriting existing method Group.sorted.
    Creating scope :sorted. Overwriting existing method User.sorted.
    Started GET "/redmine" for 127.0.0.1 at 2014-11-04 13:56:07 +0000
    Started GET "/redmine" for 127.0.0.1 at 2014-11-04 13:56:07 +0000
    Processing by WelcomeController#index as HTML
    Processing by WelcomeController#index as HTML
    Current user: anonymous
    Redirected to http://127.0.0.1/redmine/login?back_url=http%3A%2F%2F127.0.0.1%2Fredmine%2F
    Filter chain halted as :check_if_login_required rendered or redirected
    Completed 302 Found in 236.7ms (ActiveRecord: 17.0ms)
    Current user: anonymous
    Redirected to http://127.0.0.1/redmine/login?back_url=http%3A%2F%2F127.0.0.1%2Fredmine%2F
    Filter chain halted as :check_if_login_required rendered or redirected
    Completed 302 Found in 188.7ms (ActiveRecord: 12.8ms)
  • SECTION OF THE LOG ONCE THE redmine_plugin_views_revision PLUGIN HAS BEEN REMOVED AND SERVER REBOOTED ***

Connecting to database specified by database.yml
XLS export controller: rubyzip gem not available
Creating scope :system. Overwriting existing method Enumeration.system.
Creating scope :sorted. Overwriting existing method Group.sorted.
Creating scope :sorted. Overwriting existing method User.sorted.
Started GET "/redmine" for 127.0.0.1 at 2014-11-04 14:00:41 +0000
Started GET "/redmine" for 127.0.0.1 at 2014-11-04 14:00:41 +0000
Processing by WelcomeController#index as HTML
Processing by WelcomeController#index as HTML
Current user: anonymous
Redirected to http://127.0.0.1/redmine/login?back_url=http%3A%2F%2F127.0.0.1%2Fredmine%2F
Filter chain halted as :check_if_login_required rendered or redirected
Completed 302 Found in 248.3ms (ActiveRecord: 19.8ms)
Current user: anonymous
Redirected to http://127.0.0.1/redmine/login?back_url=http%3A%2F%2F127.0.0.1%2Fredmine%2F
Filter chain halted as :check_if_login_required rendered or redirected
Completed 302 Found in 202.7ms (ActiveRecord: 6.3ms)

  • SECTION WHEN THE redmine_xls_export PLUGIN IS REMOVED AND THE SERVER HAS BEEN REBOOTED **

Started GET "/redmine/admin/plugins" for 192.168.7.115 at 2014-11-04 14:02:48 +0000
Processing by AdminController#plugins as HTML
Redirected to http://redmine.url/redmine/login
Filter chain halted as :session_expiration rendered or redirected
Completed 302 Found in 106.3ms (ActiveRecord: 0.3ms)
Started GET "/redmine/login" for 192.168.7.115 at 2014-11-04 14:02:48 +0000
Processing by AccountController#login as HTML
Current user: anonymous
Rendered account/login.html.erb within layouts/base (77.9ms)
Completed 200 OK in 190.5ms (Views: 185.1ms | ActiveRecord: 2.4ms)
Started POST "/redmine/login" for 192.168.7.115 at 2014-11-04 14:02:49 +0000
Processing by AccountController#login as HTML
Parameters: {"utf8"=>"✓", "authenticity_token"=>"6hZmB/cTAAjm9j9WvyZ5kjMt5jo+5SaXCq08ryxeJV8=", "back_url"=>"http://redmine.url/redmine/admin", "username"=>"admin", "password"=>"[FILTERED]", "login"=>"Login »"}
Current user: anonymous
Successful authentication for 'admin' from 192.168.7.115 at 2014-11-04 14:02:49 UTC
Redirected to http://redmine.url/redmine/admin
Completed 302 Found in 69.7ms (ActiveRecord: 50.1ms)
Started GET "/redmine/admin" for 192.168.7.115 at 2014-11-04 14:02:49 +0000
Processing by AdminController#index as HTML
Current user: admin (id=1)
Rendered admin/_menu.html.erb (4.0ms)
Rendered admin/index.html.erb within layouts/admin (7.4ms)
Rendered layouts/base.html.erb (146.1ms)
Completed 200 OK in 240.2ms (Views: 142.5ms | ActiveRecord: 52.6ms)

RE: XLS export plugin - Added by Pavel Potcheptsov about 10 years ago

I don't see errors in your log.
I've just tested on my 2.6.0 installation: I removed xls and view_revision folders and then restarted redmine. And all works as expected: I'm able to go to Administration, browse installed plugins, browse projects and issues.

RE: XLS export plugin - Added by IT Admin about 10 years ago

Hi Pavel,

Cheers for the update, I gave it another go and still no joy. However I started from scratch with the bitnami redmine appliance and did the following:

1. updated the system to the latest updates and updated both rake and gem
2. deleted the bitnami_redmine db and then simply recreated it.
3. imported in my backed up db via rake migrate, however this kept breaking so in the end I ran the below mysql (in total) and the rake finally migrated everything.

use bitnami_redmine;
drop table queries_roles;
ALTER TABLE `queries` DROP `visibility`;
ALTER TABLE `queries` ADD `is_public` BIT NOT NULL DEFAULT b'1' ;
drop table custom_fields_roles;
ALTER TABLE `queries` DROP `options`;
ALTER TABLE `users` DROP `must_change_passwd`;
ALTER TABLE `repositories` DROP `created_on`;
ALTER TABLE `custom_fields` DROP `format_store`;
ALTER TABLE `custom_fields` DROP `description`;

Granted the above are probably only for my version 2.5.2 to make it 2.6 - have checked it through and all looks ok.

Thank you for pointing me in right direction.

regards.

RE: XLS export plugin problem ckeditor - Added by Nguyen Ba Tan almost 10 years ago

I use ckeditor for wiki and home page.
But it affect to issus (description and comment).
So XLS export plugin out xls file include html tab.
Please help me resolve problem.
Thanks.

141231_Redmine_issues_export.xls (13 KB) 141231_Redmine_issues_export.xls file export problem with including tab html

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

Nguyen Ba Tan wrote:

I use ckeditor for wiki and home page.
But it affect to issus (description and comment).
So XLS export plugin out xls file include html tab.
Please help me resolve problem.

Does description on issue page have html tags like <p>?
If yes, it's not problem of this plugin.

RE: XLS export plugin - Added by Nikolay Baranov almost 10 years ago

Hello!

It works, but with some troubles.
First the configuration page (via administration -> configure) looks wrongly (without checkboxes). See attach
Secondary, I can not activate rubyzip functionality. Gem installed, everithing looks like OK, but log says
XLS export controller: rubyzip gem not available
and I can not check it in detailed export page.

Thank you for any suggestions

Nikolay

XLSexport.jpg (155 KB) XLSexport.jpg Settings page

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

Nikolay Baranov wrote:

First the configuration page (via administration -> configure) looks wrongly (without checkboxes). See attach

What's name of directory which you installed the plugin?
If not redmine_xls_export, you should change to redmine_xls_export.
See https://github.com/two-pack/redmine_xls_export/issues/64

Secondary, I can not activate rubyzip functionality. Gem installed, everithing looks like OK, but log says
XLS export controller: rubyzip gem not available
and I can not check it in detailed export page.

What version of the plugin do you use?
Did you success bundle install if you use github version?

RE: XLS export plugin - Added by Nikolay Baranov almost 10 years ago

Thank you for quick answer, Tatsuya!

Yes, directory name is redmine_xls_export exactly.

I use version 0.2.1 (probably latest?)
Yes, I tried "bundle install" from both redmine root and plugin directory.

root@bugzilla:/var/www/redmine/plugins/redmine_xls_export# bundle install --without development test RAILS_ENV=production
Using rake (10.1.1)
Using i18n (0.6.9)
Using multi_json (1.8.2)
Using activesupport (3.2.16)
Using builder (3.0.0)
Using activemodel (3.2.16)
Using erubis (2.7.0)
Using journey (1.0.4)
Using rack (1.4.5)
Using rack-cache (1.2)
Using rack-test (0.6.2)
Using hike (1.2.3)
Using tilt (1.4.1)
Using sprockets (2.2.2)
Using actionpack (3.2.16)
Using mime-types (1.25.1)
Using polyglot (0.3.3)
Using treetop (1.4.15)
Using mail (2.5.4)
Using actionmailer (3.2.16)
Using arel (3.0.3)
Using tzinfo (0.3.38)
Using activerecord (3.2.16)
Using activeresource (3.2.16)
Using coderay (1.1.0)
Using daemon_controller (1.1.8)
Using rack-ssl (1.3.3)
Using json (1.8.1)
Using rdoc (3.12.2)
Using thor (0.18.1)
Using railties (3.2.16)
Using jquery-rails (2.0.3)
Using mysql2 (0.3.14)
Using net-ldap (0.3.1)
Using passenger (4.0.29)
Using ruby-openid (2.3.0)
Using rack-openid (1.4.1)
Using bundler (1.3.5)
Using rails (3.2.16)
Using rmagick (2.13.2)
Using ruby-ole (1.2.11.7)
Using rubyzip (1.1.0)
Using spreadsheet (1.0.1)
Your bundle is complete!
Gems in the groups development, test and RAILS_ENV=production were not installed.
Use `bundle show [gemname]` to see where a bundled gem is installed.
root@bugzilla:/var/www/redmine/plugins/redmine_xls_export# bundle show rubyzip
/usr/local/lib/ruby/gems/2.0.0/gems/rubyzip-1.1.0
root@bugzilla:/var/www/redmine/plugins/redmine_xls_export# gem list rubyzip

  • LOCAL GEMS ***

rubyzip (1.1.7, 1.1.0)
root@bugzilla:/var/www/redmine/plugins/redmine_xls_export#

What else I should check?

Nikolay

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

Nikolay Baranov wrote:

I use version 0.2.1 (probably latest?)

Did you install from github or plugins page?
If you did from github, which version is 0.2.1.tX?

What else I should check?

I have no idea ;(
Cloud you issue your problem with details like redmine verison, os, installed plugins, etc?
https://github.com/two-pack/redmine_xls_export/issues

RE: XLS export plugin - Added by Nikolay Baranov almost 10 years ago

I installed it from plugin page (redmine_xls_export_v021.zip file) and not tried from GitHub.

RE: XLS export plugin - Added by Nikolay Baranov almost 10 years ago

I tried version 0.2.1.t7 from GitHub.
After inatallation some additional gems it works!

Thank you

Nikolay

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

I fixes this plugin for Redmine 3.0.0 on following GitHub now.
https://github.com/two-pack/redmine_xls_export

RE: XLS export plugin - Added by Pavel Potcheptsov over 9 years ago

And Plugin views with revisions still have to be installed?

Update: I've just checked and it doesn't require this second plugin.

Many thanks!!

RE: XLS export plugin - Added by Sunny Song over 9 years ago

Set instruction can not configure the plugin (see screenshot)

Redmine version: 2.6.5
spreadsheet (1.0.4)
rubyzip (1.1.7)

redmine_xls_export_v021

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

Sunny Song wrote:

Set instruction can not configure the plugin (see screenshot)
redmine_xls_export_v021

Please install it from here
https://github.com/two-pack/redmine_xls_export

If the problem again, Please tell more information to reproduce it.

RE: XLS export plugin - Added by Sunny Song over 9 years ago

Install the your link and run. Thanks.

RE: XLS export plugin - Added by Alex Kenzi almost 9 years ago

Are there any plans to update this plugin for 3.2 version?

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

Alex Kenzi wrote:

Are there any plans to update this plugin for 3.2 version?

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

RE: XLS export plugin - Added by Pavel Potcheptsov over 8 years ago

Does it work with redmine 3.3.x ?

update. I've just tested and it works with redmine 3.3.0.

RE: XLS export plugin - Added by Doan Phuoc over 8 years ago

i don't think it support v3.3.0

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

Doan Phuoc wrote:

i don't think it support v3.3.0

I also check working of this plugin on Redmine 3.3.0 with following repositoty.
https://github.com/two-pack/redmine_xls_export

I don't have problem for exporting. If you have it yet, please issue the problem above repository if you can. Thanks.

RE: XLS export plugin - Added by Pavel Potcheptsov over 8 years ago

I've also tested with 3.3 and I can confirm that it works.

RE: XLS export plugin - Added by Dario Laera about 8 years ago

Hi Vitaly,

I'm an happy user of your plugin, but I was wondering if it's possible to schedule an automatic export of an xls. In other words, I need to generate weekly an xls with the issues of some projects. Do you think it's feaseble within redmine using your plugin?

Thank you in advance,
Dario

(251-275/276)