WordPress.org

Ready to get started?Download WordPress

Forums

Import users from CSV, Passwords getting Hashed (6 posts)

  1. phatpat10
    Member
    Posted 1 year ago #

    Hello all, does anyone know a way to import users from a CSV file without the passwords getting hashed? I am trying out plugins such as "members import" and "import users from csv" and both seem to hash the passwords. These are the fields i'm trying to import and i want the password to be the exact Password when importing:

    first_name
    somebody
    last_name
    anybody
    user_login
    whoever
    user_pass
    password123
    user_email
    something@something.com

  2. jibbius
    Member
    Posted 1 year ago #

    Don't the passwords need to become hashed?

    If they don't get hashed, how will the users login?

    WordPress compares the stored hash, to the hash of what the user enters to validate login.

  3. phatpat10
    Member
    Posted 1 year ago #

    Maybe so, I'm not completely sure how its suppose to work, but am just seeing if there's a way to get a way to set it up so the users can log in with the exact passwords set because there are over 1000 users and they need to be somewhat memorable.

  4. jibbius
    Member
    Posted 1 year ago #

    You need to get that data into the wp_users table.

    Have a look at this as a starting point: http://blog.rickyc.org/2011/01/04/phpmyadmin-import-excel-csv-into-table/

  5. Rachel Baker
    Member
    Posted 1 year ago #

    phatpat10,

    Have you tested the hashed passwords?
    You cannot import users passwords into the database and not have the passwords be hashed.

    You can test the hashed passwords with an MD5 hash generator like this one: http://pajhome.org.uk/crypt/md5/

  6. phatpat10
    Member
    Posted 1 year ago #

    Ok finally got it to work with the "Members Import" Plugin!

    I didn't have the "user_email" field, so I added it and, also switched the order to user_login, user_pass, first_name, last_name, and user_email. Had over 1000 users, such a huge relief.

    Thank you all for your help!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.