Title: Import Users Last modified: August 22, 2016 --- # Import Users * Resolved [ahd261](https://wordpress.org/support/users/ahd261/) * (@ahd261) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/) * Hi * as a test 1/ export my users 2/ make some changes to avoid duplicated datas 3/ Re-Import them * Get an error message : need to specify “Role” … But i don t see this file in the export file ??? How to ? * Thx * [https://wordpress.org/plugins/wp-ultimate-csv-importer/](https://wordpress.org/plugins/wp-ultimate-csv-importer/) Viewing 11 replies - 1 through 11 (of 11 total) * Plugin Author [Smackcoders Inc.,](https://wordpress.org/support/users/smackcoders/) * (@smackcoders) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372500) * Just map the column wp_user_level to roles will work for you. * Thread Starter [ahd261](https://wordpress.org/support/users/ahd261/) * (@ahd261) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372511) * not enough… Could you send us the entire mapping plz * below is the csv header from your export file and we have just 11 fields to map from the wp fields list (user-login -> description) Thx for your help * **CSV HEADER :** ID user_login user_pass user_nicename user_email user_url user_registered user_activation_key user_status display_name nickname first_name last_name description rich_editing comment_shortcuts admin_color use_ssl show_admin_bar_front wp_capabilities wp_user_level dismissed_wp_pointers show_welcome_panel session_tokens package_selected _package_select wp_dashboard_quick_press_last_post_id user_favourite_post wp_user- settings wp_user-settings-time closedpostboxes_listing metaboxhidden_listing managenav-menuscolumnshidden metaboxhidden_nav-menus closedpostboxes_page metaboxhidden_page edit_listing_per_page nav_menu_recently_edited linkedin twitter facebook user_phone url user_google user_fname profile_photo * Plugin Author [Smackcoders Inc.,](https://wordpress.org/support/users/smackcoders/) * (@smackcoders) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372576) * Verify this [image for user import mapping options](http://demo.smackcoders.com/user-import-mapping.jpg) for clear understanding. * Thread Starter [ahd261](https://wordpress.org/support/users/ahd261/) * (@ahd261) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372579) * Hi thx for the print screen. I ve done exactly the same setup but fall in the next step on “fill all mandatory field” error message… * The source file provides from your plugin export users file ? * Thx for your help * Thread Starter [ahd261](https://wordpress.org/support/users/ahd261/) * (@ahd261) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372619) * Hi could u reply me plz i m really stuck thx * Plugin Author [Smackcoders Inc.,](https://wordpress.org/support/users/smackcoders/) * (@smackcoders) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372622) * Add a snap of what you are mapping. some thing is missed it seems. If correctly done it should work. * Thread Starter [ahd261](https://wordpress.org/support/users/ahd261/) * (@ahd261) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372623) * Hi Thx * 1/ all plugins are disabled 2/ i create manually a user 3/ i export this user from your plugin see it from this link [ 4/ i delete this user 5/ I import this user from the csv file see the mapping [ 6/ i get always this error message : [](https://www.dropbox.com/s/gq07at299zmn8m4/error.png?dl=0) * Thx to confirm that u get the same message from your side ? Thx for your help * Thread Starter [ahd261](https://wordpress.org/support/users/ahd261/) * (@ahd261) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372624) * sorry for the previous message * 1/ all plugins are disabled 2/ i create manually a user 3/ i export this user from your plugin see it from this link below [Lien](https://www.dropbox.com/s/n8zcgjmy91cix4b/user.csv?dl=0) * 4/ i delete this user 5/ I import this user from the csv file see the mapping below [Lien](https://www.dropbox.com/s/e0wrtzjdzbnqvfe/mapping.png?dl=0) 6/ i get always this error message : [Lien](https://www.dropbox.com/s/gq07at299zmn8m4/error.png?dl=0) * Thx to confirm that u get the same message from your side ? Thx for your help * Plugin Author [Smackcoders Inc.,](https://wordpress.org/support/users/smackcoders/) * (@smackcoders) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372627) * Watch it, you have missed the rows per server request field. Fill this with value e.g. 3 or 5 * Thread Starter [ahd261](https://wordpress.org/support/users/ahd261/) * (@ahd261) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372631) * I can only set up this value to “1” What does this value mean ? how can we set up the 2 following fields : dismissed_wp_pointers & wp_capabilities ? Is it correct if these values are always the same for all imported suscriber users ? thx * Plugin Author [Smackcoders Inc.,](https://wordpress.org/support/users/smackcoders/) * (@smackcoders) * [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372664) * This is the value set to import no. of rows per server request, to ensure server load in control. wp_capabilities is not necessary as you can set the role for each user. dismissed_wp_pointers need to be handled with care as it should be properly escaped. Other wise both are not needed or much important for user import. Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘Import Users’ is closed to new replies. * ![](https://ps.w.org/wp-ultimate-csv-importer/assets/icon.svg?rev=3131703) * [WP Ultimate CSV Importer – Import CSV, XML & Excel into WordPress](https://wordpress.org/plugins/wp-ultimate-csv-importer/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-ultimate-csv-importer/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-ultimate-csv-importer/) * [Active Topics](https://wordpress.org/support/plugin/wp-ultimate-csv-importer/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-ultimate-csv-importer/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-ultimate-csv-importer/reviews/) ## Tags * [users](https://wordpress.org/support/topic-tag/users/) * 11 replies * 2 participants * Last reply from: [Smackcoders Inc.,](https://wordpress.org/support/users/smackcoders/) * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/import-users-2-2/#post-5372664) * Status: resolved