1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 User import via PHPMyAdmin with CSV file

Discussion in 'Troubleshooting and Problems' started by Freelancer, Feb 21, 2016.

  1. Freelancer

    Freelancer Well-Known Member

    I finally managed to import users (testing) into the "xf_user" table via PHPMyAdmin import. I copied the entries from another user and adjusted them (new eMail, new user_id etc). It worked. So far, so good.

    When in the frontend, the user is only displayed as "guest" instead of having the user group ids reflected as setup in the database.

    In the backend, I can not edit the user because if I click on the user from the user list, it jumps to the "create user" page and if I want to save changes, it follows an "user already exists" error... obviously.

    What am I missing? Are there other tables in the database that have influence on the board recognizing a new user? Or is there a cron job that needs to be done first?

    Please advise.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    You can't import/create users like that as there are multiple tables involved per user.

    It would require a custom script, which would correctly populate all of the relevant tables.
    Freelancer likes this.
  3. Freelancer

    Freelancer Well-Known Member

    Thanks for the fast answer. When a plan sounds to good to be true, it is too good to be true... :unsure:
    I need to import about 300 members. Unfortunately my knowledge is limited in regard of PHP and MySQL.
  4. Mouth

    Mouth Well-Known Member

    Freelancer likes this.
  5. Freelancer

    Freelancer Well-Known Member

    Thanks @Mouth ... I am a little bit skeptic in regard of the feedback the add-on got... but I will try it anyway and go back to a backup if not working.
  6. Freelancer

    Freelancer Well-Known Member

    Tried it but it doesn't work as expected ...which is as expected... :cautious:
  7. Freelancer

    Freelancer Well-Known Member

    Claudio and Mouth like this.

Share This Page