Users XLS import/export plugin

Added by Vitaly Klimov over 6 years ago

Up to date plugin page

http://www.redmine.org/plugins/redmine_users_xls_impex:

Main features

  • Ability to export users to XLS
  • Ability to add/update users from XLS

Replies (16)

RE: Users XLS import/export plugin - Added by Steven Wong about 6 years ago

Hi, I installed the plugin in Redmine 1.2.X
but when I use it to export the userlist, it seems not work, could you tell me what's the problem it is. Thanks.

the error message as follows:

Processing UsersXlsImpexController#export_start (for 192.168.3.99 at 2011-10-10 18:13:39) [POST]
Parameters: {"name"=>"", "action"=>"export_start", "authenticity_token"=>"8LzHb5SC3OMtf14713JqJQGnUwKbCiV4IdOOwwT8zjk=", "controller"=>"users_xls_impex", "export_status"=>""}

NoMethodError (undefined method `each' for nil:NilClass):
vendor/plugins/redmine_users_xls_impex/app/controllers/users_xls_impex_controller.rb:447:in `retrieve_columns'
vendor/plugins/redmine_users_xls_impex/app/controllers/users_xls_impex_controller.rb:517:in `users_to_xls2'
vendor/plugins/redmine_users_xls_impex/app/controllers/users_xls_impex_controller.rb:83:in `export_start'
/usr/local/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/local/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/local/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/local/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start'
/usr/local/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/local/ruby/lib/ruby/1.8/webrick/server.rb:95:in `start'
/usr/local/ruby/lib/ruby/1.8/webrick/server.rb:92:in `each'
/usr/local/ruby/lib/ruby/1.8/webrick/server.rb:92:in `start'
/usr/local/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start'
/usr/local/ruby/lib/ruby/1.8/webrick/server.rb:82:in `start'

Rendering /usr/local/redmine-1.2/public/500.html (500 Internal Server Error)

RE: Users XLS import/export plugin - Added by Steven Wong about 6 years ago

I use centos 5.x
mysql 5.X

Ruby version 1.8.7 (i686-linux)
RubyGems version 1.3.7
Rack version 1.1.2
Rails version 2.3.11
Active Record version 2.3.11
Active Resource version 2.3.11
Action Mailer version 2.3.11
Active Support version 2.3.11
Application root /usr/local/redmine-1.2
Environment production
Database adapter mysql
Database schema version 20110818135620

RE: Users XLS import/export plugin - Added by Steven Wong almost 6 years ago

Anyone Who Could help me? Thanks

RE: Users XLS import/export plugin - Added by Vitaly Klimov almost 6 years ago

It seems that you do not have any custom fields in Redmine. Please create at least one (no matter issue or user one) in order for this plugin to work. It is a bug that will be fixed in the next release.

RE: Users XLS import/export plugin - Added by Steven Wong almost 6 years ago

Hi, Vitaly Klimov

I tried.
Yes, it seems there's a bug. So I add a custom field for user, then it's OK.
Thanks.

RE: Users XLS import/export plugin - Added by Vitaly Klimov over 5 years ago

Plugin updated to version 0.0.3 and compatible with the Redmine 1.3.x

Download it from the plugin page: http://www.redmine.org/plugins/redmine_users_xls_impex

Please do remove plugin folder completely before installing new version!

RE: Users XLS import/export plugin - Added by Steven Wong over 5 years ago

Good. I test it in redmine 1.4.X. and it could be used in this version.

RE: Users XLS import/export plugin - Added by Vitaly Klimov over 5 years ago

Version 0.1.1 released.

Support for Redmine 2.x added

RE: Users XLS import/export plugin - Added by Steven Wong over 5 years ago

Hi, Vitaly Klimov

Thanks.
I've updated the newest zh.yml file for 0.1.1.

zh.yml Magnifier - zh.yml file for 0.1.1 (2.2 KB)

RE: Users XLS import/export plugin - Added by Steven Wong about 5 years ago

Hi, Vitaly Klimov

I used the plugin with redmine 2.0.3 but it seems having some bug.

I opened the configuration page - users and can not find the filter. or the plugin could not be used on redmine 2.0.3? please check it.

Thanks so much.

RE: Users XLS import/export plugin - Added by Vitaly Klimov about 5 years ago

Steven Wong wrote:

I opened the configuration page - users and can not find the filter. or the plugin could not be used on redmine 2.0.3? please check it.

Have you installed plugin Plugin views with revisions and ran rake task rake redmine:plugins:process_version_change RAILS_ENV=production?

RE: Users XLS import/export plugin - Added by Steven Wong about 5 years ago

Hi, Vitaly Klimov

Thanks.
I have installed Plugin views with revisions.
I will try it later, maybe I missed the rake command.

Vitaly Klimov wrote:

Steven Wong wrote:

I opened the configuration page - users and can not find the filter. or the plugin could not be used on redmine 2.0.3? please check it.

Have you installed plugin Plugin views with revisions and ran rake task rake redmine:plugins:process_version_change RAILS_ENV=production?

RE: Users XLS import/export plugin - Added by Ralf Hupe over 4 years ago

Hi,

in my enviroment on a testing host
Redmine version 2.2.3.stable
Ruby version 1.8.7 (i386-linux)
Rails version 3.2.12
Environment production
Database adapter PostgreSQL

the plugin version 0.1.1 could not access /users_xls_impex/import

i got these errors in production.log
[XLSI] Loading file 130326122614__uxlsie.xls
Rendered plugins/redmine_users_xls_impex/app/views/users_xls_impex/import.html.erb within layouts/base (172.1ms)
Completed 500 Internal Server Error in 265ms

ActionView::Template::Error (undefined method `link_to_remote' for #<#<Class:0xb67adb84>:0xb6471ca4>):
25: <%= submit_tag l(:label_users_xlsie_button_back), :name => 'back_to_import' >
26: <
= submit_tag l(:label_users_xlsie_button_validate) >
27: <
= submit_tag l(:label_users_xlsie_button_import), :name => 'create_imported_users' >
28: <
= link_to_remote l(:label_preview),
29: { :url => { :controller => 'users_xls_impex', :action => 'import_preview' },
30: :method => 'post',
31: :update => 'preview',

after a quick research i added these lines to /redmine/app/helpers/application_helper.rb to get the plugin back on track

def link_to_remote(name, options = {}, html_options = nil)
url = options[:url] || {}
link_to_remote(name, options, html_options) if authorize_for(url[:controller] || params[:controller], url[:action])
end

RE: Users XLS import/export plugin - Added by m p almost 3 years ago

for some reason i cannot the see the links mentioned:

"Plugin adds two links - 'import' and 'export' to the users admin page (/redmine/users)"

Environment:
Redmine version 2.3.0.stable
Ruby version 1.8.7 (x86_64-linux)
Rails version 3.2.13
Environment production
Database adapter Mysql2
Redmine plugins:
projects_tree_view 0.0.8
redcase 1.0 beta 2.0
redmine_extended_spent_time 0.0.3
redmine_graphs 0.1.0
redmine_impasse 1.2.2
redmine_knowledgebase 3.0.4
redmine_plugin_views_revisions 0.0.1
redmine_spent_time 2.6.4
redmine_timesheet_plugin 0.7.0
redmine_users_xls_impex 0.1.1
redmine_watcher_groups 1.0.0
redmine_wktime 1.6

RE: Users XLS import/export plugin - Added by m p over 2 years ago

m p wrote:

for some reason i cannot the see the links mentioned:

"Plugin adds two links - 'import' and 'export' to the users admin page (/redmine/users)"

Environment:
Redmine version 2.3.0.stable
Ruby version 1.8.7 (x86_64-linux)
Rails version 3.2.13
Environment production
Database adapter Mysql2
Redmine plugins:
projects_tree_view 0.0.8
redcase 1.0 beta 2.0
redmine_extended_spent_time 0.0.3
redmine_graphs 0.1.0
redmine_impasse 1.2.2
redmine_knowledgebase 3.0.4
redmine_plugin_views_revisions 0.0.1
redmine_spent_time 2.6.4
redmine_timesheet_plugin 0.7.0
redmine_users_xls_impex 0.1.1
redmine_watcher_groups 1.0.0
redmine_wktime 1.6

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

after that everything was fine!

(1-16/16)