Thanks! Upgrade to 1.8.7 realy solved this problem!

Attached please find version 008 of the plugin.

Redmine versions prior to 1.0.1: attachment#redmine_xls_export_v008_before_101.zip
Redmine version 1.0.1 and higher: attachment#redmine_xls_export_v008_101_only.zip

Changes:

• German translation added (thanks to Terence Mill)
• Russian translation added (thanks to Alexander Sapozhnikov)
• Sort order now favored for exports from 'XLS+' page
• Minor export bugfixes

Version 009. More sort order fixes.

Bug-Report:

When using group (eg. per project) function and exorting, i only get the tickets from the first group, but no more.

Hello,

I have a small problem with the plugin. I have a role defined, which is not allowd to see the spent time on tickets. But if I make an xls export of a list of tickets there is a column with the spent time, thus a person who is not allowed to see the spent time can manage to see it by exporting list of tickets to a xls file.

Would it be possible to implement this kind of permissions?

Best regards...

Felix

Hi, Vitaly! I recently switched to Redmine 1.0.3 ruby version 1.8.7. XLS export plugin version 009 (and earlier) shows Internal error when trying to upload the report. Please tell me that this can be done?
Have you thought about extending the plugin to the list of projects?
Thank you.
Привет, Виталий! Я недавно перешел на Redmine 1.0.3 ruby version 1.8.7. XLS export plugin version 009 (и ранние версии) показывает Internal error при попытке выгрузить отчет. Пожалуйста, подскажите что с этим можно сделать?
Вы не думали о распространении действия плагина на список проектов ?
спасибо вам.

I have a role defined, which is not allowd to see the spent time on tickets. But if I make an xls export of a list of tickets there is a column with the spent time, thus a person who is not allowed to see the spent time can manage to see it by exporting list of tickets to a xls file.

Felix, i do check for permission when exporting time entries, thus if the person which does not have permission to view time entries on the project tries to export time column, that column would be empty.

XLS export plugin version 009 (and earlier) shows Internal error when trying to upload the report.

Mihail, are you using proper version of 009 plugin (redmine_xls_export_v009_101_only.zip)? If so, can you please post me logs with Internal error so i will be able to see what's going on?

When using group (eg. per project) function and exorting, i only get the tickets from the first group, but no more

Terrence, can you check if you have option Split by grouping criteria enabled? In this case each group will be in the separate XLS sheet inside file

Vitaly Klimov wrote:

Mihail, are you using proper version of 009 plugin (redmine_xls_export_v009_101_only.zip)? If so, can you please post me logs with Internal error so i will be able to see what's going on?

redmine_xls_export_v009_101_only.zip

Processing IssuesController#index to xls (for 192.168.15.85 at 2010-11-23 14:38:08) [GET]
Parameters: {"format"=>"xls", "action"=>"index", "controller"=>"issues"}
Iconv::InvalidCharacter ("\320"):
spreadsheet (0.6.4.1) lib/spreadsheet/encodings.rb:29:in `iconv'
spreadsheet (0.6.4.1) lib/spreadsheet/encodings.rb:29:in `internal'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/biff8.rb:43:in `_unicode_string'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:508:in `_write_sst'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:502:in `each'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:502:in `each_with_index'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:502:in `_write_sst'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:489:in `write_sst'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:439:in `write_from_scratch'
spreadsheet (0.6.4.1) lib/spreadsheet/excel/writer/workbook.rb:620:in `write_workbook'
spreadsheet (0.6.4.1) lib/spreadsheet/writer.rb:12:in `write'
spreadsheet (0.6.4.1) lib/spreadsheet/workbook.rb:106:in `write'

Rendering C:/bitnami2/apps/redmine/public/500.html (500 Internal Server Error)

Terrence, can you check if you have option Split by grouping criteria enabled? In this case each group will be in the separate XLS sheet inside file

I just noticed that the group feature is done by seperating on sheets in one excel file. I overlooked thios the first time. So there is no bug, its perfectly working! Tx for help!

BUG Report

Redmine 1.01 and Plugin Version 0.0.9

When i click XLS+ in Issue List, e.g /projects/spielwiese/issues/xls_export_action i get a Internal Error and this log entries:
BTw. does this plugin has github or other source repository?

ActionView::TemplateError (undefined local variable or method `xlse_list_of_columns'

ActionView::TemplateError (undefined local variable or method `xlse_list_of_columns' for #<ActionView::Base:0x7fe1108236d0>) on line #3 of vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:
1: 
2: <% fields_all = [] %>
3: <% fields_all << xlse_list_of_columns %>
4: <% fields_all << xlse_list_of_options %>
5: <% fields_all.each do |c|%>
6:     <div class="box tabular">

    vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:3
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:9:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:7:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    passenger (2.2.14) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
    passenger (2.2.14) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:441:in `start_request_handler'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:381:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/utils.rb:252:in `safe_fork'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:377:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:163:in `start'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:222:in `start'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

I've created Czech locale, find it attached to this post.

Thanks for a good plugin. Would you consider putting it into official Redmine plugin repository?

Best Regards,
Lubor Nosek

Lubor Nosek wrote:

I've created Czech locale, find it attached to this post.

Thanks!

Thanks for a good plugin. Would you consider putting it into official Redmine plugin repository?

Sure, no problem - just tell me how to do it. I've asked Jean-Philippe about the way one can get theirs plugins listed on plugins page some time ago, but got no answer so far.

Version 0.1.0¶

• From now on plugin compatible only with Redmine 1.0.1 or higher.
• Links to XLS export moved to issues index hook so index.rhtml not modified by plugin, thus removing conflicts with plugins which modified index.rhtml.
• Plugin adds two links with 'XLS export' prefix at the bottom of the page under 'Also available in' bar.

Hi,

I am translating the plugin to Bulgarian. What is the meaning of

label_plugin_xlse_issues_limit: "Overwrite export limit" 

Ivan Cenov wrote:

I am translating the plugin to Bulgarian. What is the meaning of
[...] and what is the context it is used in?

There is a global setting in Redmine which controls how many issues you can export at once. This option allows you override this value.

Here is attached Bulgarian translation.

P.S. en.yml. What about

label_plugin_xlse_issues_limit: "Overwrite export limit" 

label_plugin_xlse_issues_limit: "Override export limit" 

Regards,
Ivan

Ivan Cenov wrote:

Here is attached Bulgarian translation.

Thank you

I think the latter is more suitable, by my opinion.

Yes, you are right i fixed it.

Version 0.1.1

• Added Bulgarian translation
• Fixed typos
• Added to plugin base - http://www.redmine.org/plugins/redmine_xls_export

@Processing IssuesController#xls_export_action (for 89.175.182.222 at 2011-02-08 12:01:05) [GET]
Parameters: {"project_id"=>"allprojects", "action"=>"xls_export_action", "controller"=>"issues"}
SQL (0.5ms) SELECT max("settings".updated_on) AS max_updated_on FROM "settings"
User Load (0.9ms) SELECT * FROM "users" WHERE ("users"."id" = 3) AND (users.status = 1) AND ( ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) )
Project Load (0.5ms) SELECT * FROM "projects" WHERE ("projects"."identifier" = E'allprojects') LIMIT 1
EnabledModule Load (0.4ms) SELECT name FROM "enabled_modules" WHERE ("enabled_modules".project_id = 10)
Setting Load (0.2ms) SELECT * FROM "settings" WHERE ("settings"."name" = E'plugin_redmine_xls_export') LIMIT 1
Rendering template within layouts/base
Rendering issues/xls_export_action

ActionView::TemplateError (undefined local variable or method `xlse_list_of_columns' for #<ActionView::Base:0x7f8c988253a8>) on line #3 of vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:
1:
2: <% fields_all = [] >
3: < fields_all << xlse_list_of_columns >
4: < fields_all << xlse_list_of_options >
5: < fields_all.each do |c|%>
6: <div class="box tabular">

vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:3
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:9:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:7:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    thin (1.2.7) lib/thin/connection.rb:76:in `pre_process'
    thin (1.2.7) lib/thin/connection.rb:74:in `catch'
    thin (1.2.7) lib/thin/connection.rb:74:in `pre_process'
    thin (1.2.7) lib/thin/connection.rb:57:in `process'
    thin (1.2.7) lib/thin/connection.rb:42:in `receive_data'
    eventmachine (0.12.10) lib/eventmachine.rb:256:in `run_machine'
    eventmachine (0.12.10) lib/eventmachine.rb:256:in `run'
    thin (1.2.7) lib/thin/backends/base.rb:57:in `start'
    thin (1.2.7) lib/thin/server.rb:156:in `start'
    thin (1.2.7) lib/thin/controllers/controller.rb:80:in `start'
    thin (1.2.7) lib/thin/runner.rb:177:in `send'
    thin (1.2.7) lib/thin/runner.rb:177:in `run_command'
    thin (1.2.7) lib/thin/runner.rb:143:in `run!'
    thin (1.2.7) bin/thin:6
    /usr/bin/thin:19:in `load'
    /usr/bin/thin:19

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

This error appeared after trying to make a "detailed export" all my issues.

Konstantin Rudenkov wrote:

@Processing IssuesController#xls_export_action (for 89.175.182.222 at 2011-02-08 12:01:05) [GET]
Parameters: {"project_id"=>"allprojects", "action"=>"xls_export_action", "controller"=>"issues"}
SQL (0.5ms) SELECT max("settings".updated_on) AS max_updated_on FROM "settings"
User Load (0.9ms) SELECT * FROM "users" WHERE ("users"."id" = 3) AND (users.status = 1) AND ( ("users"."type" = 'User' OR "users"."type" = 'AnonymousUser' ) )
Project Load (0.5ms) SELECT * FROM "projects" WHERE ("projects"."identifier" = E'allprojects') LIMIT 1
EnabledModule Load (0.4ms) SELECT name FROM "enabled_modules" WHERE ("enabled_modules".project_id = 10)
Setting Load (0.2ms) SELECT * FROM "settings" WHERE ("settings"."name" = E'plugin_redmine_xls_export') LIMIT 1
Rendering template within layouts/base
Rendering issues/xls_export_action

ActionView::TemplateError (undefined local variable or method `xlse_list_of_columns' for #<ActionView::Base:0x7f8c988253a8>) on line #3 of vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:
1:
2: <% fields_all = [] >
3: < fields_all << xlse_list_of_columns >
4: < fields_all << xlse_list_of_options >
5: < fields_all.each do |c|%>
6: <div class="box tabular">

vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:3
vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:9:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:7:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
thin (1.2.7) lib/thin/connection.rb:76:in `pre_process'
thin (1.2.7) lib/thin/connection.rb:74:in `catch'
thin (1.2.7) lib/thin/connection.rb:74:in `pre_process'
thin (1.2.7) lib/thin/connection.rb:57:in `process'
thin (1.2.7) lib/thin/connection.rb:42:in `receive_data'
eventmachine (0.12.10) lib/eventmachine.rb:256:in `run_machine'
eventmachine (0.12.10) lib/eventmachine.rb:256:in `run'
thin (1.2.7) lib/thin/backends/base.rb:57:in `start'
thin (1.2.7) lib/thin/server.rb:156:in `start'
thin (1.2.7) lib/thin/controllers/controller.rb:80:in `start'
thin (1.2.7) lib/thin/runner.rb:177:in `send'
thin (1.2.7) lib/thin/runner.rb:177:in `run_command'
thin (1.2.7) lib/thin/runner.rb:143:in `run!'
thin (1.2.7) bin/thin:6
/usr/bin/thin:19:in `load'
/usr/bin/thin:19

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

This error appeared after trying to make a "detailed export" all my issues.

I use last version, 011

Updates german translation for 0.1.1

some fixes

BUG Report for 0.1.1

When clicking on Detailed XLS Export i get "Internal Error" and following message in log

# Logfile created on Tue Feb 08 12:32:15 +0100 2011
ActionView::TemplateError (undefined local variable or method `xlse_list_of_columns' for #<ActionView::Base:0x7fa6d68bc200>) on line #3 of vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:
1: 
2: <% fields_all = [] %>
3: <% fields_all << xlse_list_of_columns %>
4: <% fields_all << xlse_list_of_options %>
5: <% fields_all.each do |c|%>
6:     <div class="box tabular">

    vendor/plugins/redmine_xls_export/app/views/settings/_xls_export_settings.html.erb:3
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:9:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    vendor/plugins/redmine_xls_export/app/views/issues/xls_export_action.rhtml:7:in `_run_rhtml_vendor47plugins47redmine_xls_export47app47views47issues47xls_export_action46rhtml'
    passenger (2.2.14) lib/phusion_passenger/rack/request_handler.rb:92:in `process_request'
    passenger (2.2.14) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:441:in `start_request_handler'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:381:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/utils.rb:252:in `safe_fork'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:377:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:163:in `start'
    passenger (2.2.14) lib/phusion_passenger/railz/application_spawner.rb:222:in `start'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:262:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:256:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
    passenger (2.2.14) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:154:in `spawn_application'
    passenger (2.2.14) lib/phusion_passenger/spawn_manager.rb:287:in `handle_spawn_application'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
    passenger (2.2.14) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'

Version 0.1.2¶

• DE translation updated
• Hopefully fixed bug with 'xlse_list_of_columns' variable (obsolete helpers removed)

IMPORTANT! Please remove whole redmine_xls_export folder before unpacking new version, since this version have some old files removed

Hi,

The plugin page is not updated, 0.1.1 is there. http://www.redmine.org/plugins/redmine_xls_export