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:

• 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

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.

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)

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.

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.

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.

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.

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

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?

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

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

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

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

Thank you

Nikolay

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

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

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

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.

Install the your link and run. Thanks.

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

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

Does it work with redmine 3.3.x ?

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

i don't think it support v3.3.0

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.

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

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