Users XLS import/export plugin
Added by Vitaly Klimov about 13 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 almost 13 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 almost 13 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 13 years ago
Anyone Who Could help me? Thanks
RE: Users XLS import/export plugin - Added by Vitaly Klimov almost 13 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 13 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 12 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 12 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 Steven Wong over 12 years ago
not support redmine 2.0.2 just see the url
RE: Users XLS import/export plugin - Added by Vitaly Klimov over 12 years ago
Version 0.1.1 released.
Support for Redmine 2.x added
RE: Users XLS import/export plugin - Added by Steven Wong over 12 years ago
Hi, Vitaly Klimov
Thanks.
I've updated the newest zh.yml file for 0.1.1.
RE: Users XLS import/export plugin - Added by Steven Wong about 12 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 12 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 12 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 11 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 10 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 9 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!