Import Users from CSV

설명

This plugin allows you to import users from an uploaded CSV file. It will add users with basic information as well as meta fields and user role.

You can also choose to send a notification to the new users and to display password nag on user login.

Check out our other free plugins.

Features

  • Imports all users fields
  • Imports user meta
  • Update existing users by specifying ID field
  • Allows setting user role
  • Sends new user notification (if the option is selected)
  • Shows password nag on user login (if the option is selected)

For feature request and bug reports, please use the forums.
Code contributions are welcome on Github.

Import Users From Any CSV/Excel/XML with WP All Import Pro

WP All Import Pro can import WordPress users, WooCommerce products, ACF, custom post types, custom fields, taxonomies, and everything else:

  • Drag & Drop to Import Any File: Give any CSV or XML to WP All Import, then drag and drop to map data from your file into WordPress.
  • Any Custom Post Type, Every Data Type: Import data to custom post types, with support for WooCommerce, ACF, custom fields, taxonomies, and everything else.
  • Import Images & Galleries: Images can be uploaded, downloaded, or matched to media already in WordPress. Full support for WooCommerce product images and variation galleries.
  • Import Files from URL: Download and import files from external websites, even if they are password protected. URL imports are can be re-run to add, edit, and delete posts.
  • Scheduled Imports: WP All Import Pro can check periodically check a file for updates and then add, update, or delete to the imported posts accordingly.
  • Developer Friendly: Pass data through custom PHP functions. For example, use something like [my_function( {user_email[1]} )] in your template, to pass the value of {user_email[1]} to my_function and display whatever it returns.
  • Priority Support: Personal support from our team of expert developers with over a decade of experience importing and exporting WordPress data.
  • 90 Day Money Back Guarantee: Not 100% happy? Let us know, and we’ll promptly send you a refund. No questions asked.

Check out WP All Import today.

스크린샷

  • User import screen

설치

워드 프레스를 통해 자동 설치 :

  1. 당신의 워드 프레스 관리자 영역에서 ‘추가 새로운’플러그인 화면으로 이동
  2. Search for ‘Import Users from CSV’
  3. ‘지금 설치’를 클릭하고 플러그인을 활성화
  4. Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’

FTP를 통해 수동 설치 :

  1. Upload the import-users-from-csv directory to the /wp-content/plugins/ directory
  2. 당신의 워드 프레스 관리자 영역에서 ‘플러그인’화면을 통해 플러그인을 활성화
  3. Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’

대신 FTP의, 워드 프레스를 통해 플러그인을 업로드하려면 :

  1. 당신의 워드 프레스 관리자 영역에서 ‘추가 새로운’플러그인 화면 ( ‘업로드’탭 참조)에 다운로드 한 zip 파일을 업로드하고 활성화합니다.
  2. Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’

FAQ

How to use?

Click on the ‘Import From CSV’ link in the ‘Users’ menu, choose your CSV file, choose if you want to send a notification email to new users and if you want the password nag to be displayed when they login, then click ‘Import’.

Each row in your CSV file should represent a user; each column identifies user data or meta data.

If a column name matches a field in the user table, data from this column is imported in that field; if not, data is imported in a user meta field with the name of the column.

Look at the example.csv file in the plugin directory to have a better understanding of how the your CSV file should be organized.

You can try importing that file and look at the result.

Credits

Thanks to Ulrich Sossou for initially creating this plugin. Be sure to check out his other WordPress plugins or GitHub profile.

후기

2024년 4월 9일
The external plug-in used to work perfectly, since they force us to use this plugin for Paid Memberships Pro I have had nothing but failures. Constantly exceeds the memory of the server, error 500 constantly, I deleted the import_membership_id field damaging many logical programming that I have on my site with this field … They should give the option to use this or the previous one.
2022년 9월 1일
Worked really well. Two tips for new users: 1) Use the example CSV file to get your data formatted for import 2) Ensure you use ALL the columns required (you don’t need to worry about the custom ones) Thanks for saving me loads of pain importing multiple users.
2022년 5월 18일
I downloaded this plugin in desperation yesterday and it did exactly what I needed it to. The sample of what the csv file should look like enabled me to merge data from MailChimp and WooCommerce to add user to the site, so they could log in. Terrific plug-in!
2021년 8월 11일
It met my need immediately. Thank you for creating and maintaining this plugin.
2019년 1월 21일
Update 1.0.1 works great, definitely recommend this plugin. Thanks
2017년 2월 19일
Hello, Just I want to say thanks very much for your plugin. it helps me to develop my custom plugin to import a custum database. BIG thanks :))
모든 42 평가 읽기

기여자 & 개발자

“Import Users from CSV”(은)는 오픈 소스 소프트웨어입니다. 다음의 사람들이 이 플러그인에 기여하였습니다.

기여자

“Import Users from CSV”(이)가 6 개 언어로 번역되었습니다. 기여해 주셔서 번역자님께 감사드립니다.

자국어로 “Import Users from CSV”(을)를 번역하세요.

개발에 관심이 있으십니까?

코드 탐색하기는, SVN 저장소를 확인하시거나, 개발 기록RSS로 구독하세요.

변경이력

1.3.1

  • bug fix: restore missing notice file

1.3

  • bug fix: don’t instantiate serialized objects

1.2

  • BUG FIX: Ensure user running import has the ability to add users
  • Update tested to
  • minor UI update

1.1

  • ENHANCEMENT: Added support for WPCLI (@mircobabini)
  • ENHANCEMENT: Added support for multiple roles during import, use comma-separated value for multiple roles (@mircobabini)
  • ENHANCEMENT: Removed password nag option as this is no longer supported.
  • ENHANCEMENT: New filter added ‘is_iu_errors_filter’ for throwing error messages. Helpful for third party developers extending onto IUCSV functionality.

1.0.1

  • Fixed timeout bug on import.
  • Improved settings area layout.
  • General code refactor and improved security.
  • Screenshot update.

1.0.0

  • Fixed bug where importing fields with “0” value doesn’t work
  • Added option to update existing users by username or email

0.5.1

  • Removed example plugin file to avoid invalid header error on
    installation

0.5

  • Changed code to allow running import from another plugin

0.4

  • Switched to RFC 4180 compliant library for CSV parsing
  • Introduced IS_IU_CSV_DELIMITER constant to allow changing the CSV delimiter
  • Improved memory usage by reading the CSV file line by line
  • Fixed bug where any serialized CSV column content is serialized again
    on import

0.3.2

  • Fixed php notice when importing

0.3.1

  • Don’t process empty columns in the csv file

0.3

  • Fixed bug where password field was overwritten for existing users
  • Use fgetcsv instead of str_getcsv
  • Don’t run insert or update user function when only user ID was
    provided (performance improvement)
  • Internationalization
  • Added display name to example csv file

0.2.2

  • Added role to example file
  • Fixed bug with users not imported when no user meta is set

0.2.1

  • Added missing example file
  • Fixed bug with redirection after csv processing
  • Fixed error logging
  • Fixed typos in documentation
  • Other bug fixes

0.2

  • First public release.
  • Code cleanup.
  • Added readme.txt.

0.1

  • First release.