Support » Fixing WordPress » How to batch upload users?

  • I’d like to upload a set of user data from a CSV file. Does anyone have any examples of file format and code to do this?

    I can craft the INSERTS to add a single user to wp_users with the correct entries in wp_usermeta, but my PHP/SQL skills aren’t quite up to the task of adding 500 users efficiently, so I was hoping to find someone’s sample code.


Viewing 1 replies (of 1 total)
  • The solution I ended up with is documented at

    I’ll repost when I convert this to php instead of using the shell and phpMyAdmin.

    But thought that might be helpful for other PHP novices to review — and for you PHP/MySQL experts to comment on.

    My performance fears seemed unfounded –everything (adding users, logging in with 500+ users, finding a particular user to edit) seems pretty snappy. The only piece that was really slow was the piece using the shell – and running that on the server instead of my Windows box made that pretty quick, too.

Viewing 1 replies (of 1 total)
  • The topic ‘How to batch upload users?’ is closed to new replies.