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)
Uninstall XLS export plugin
-
Added by IT Admin almost 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 almost 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 almost 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 almost 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 almost 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 over 9 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 over 9 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 over 9 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 over 9 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 over 9 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 over 9 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 over 9 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 over 9 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 about 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 about 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
Screenshot_1.png (12.6 KB) Screenshot_1.png |
RE: XLS export plugin
-
Added by Tatsuya Saito about 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 about 9 years ago
Install the your link and run. Thanks.
Screenshot_3.png (33.6 KB) Screenshot_3.png |
RE: XLS export plugin
-
Added by Alex Kenzi over 8 years ago
Are there any plans to update this plugin for 3.2 version?
RE: XLS export plugin
-
Added by Tatsuya Saito over 8 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 about 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 Tatsuya Saito about 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 about 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 almost 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