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

Unmaintained [TH] User Import and Export 1.0.3a

Import users from XML or CSV file and export users to CSV file.

  1. Jon W

    Jon W Well-Known Member

  2. Paul

    Paul Well-Known Member

    Hiya Waindigo,

    Just wondered what information this exports/imports? Just username? Email? etc

    Cheers
    Paul
     
  3. doublespaces

    doublespaces Member

    I don't see where to export users. I clicked users, then what? I see nothing on that screen related to export.
     
  4. squirrly

    squirrly Active Member

    The export is on the user search screen for users who have the proper permission. It's not in the adminCP.
     
  5. doublespaces

    doublespaces Member

    Mine says, "Import Users" and "Create User". I also don't see any user group permission settings for the addon. It says its installed on my dashboard. I'm an admin as well.
     
  6. Swimmy

    Swimmy New Member

    You can manually change the URL to include "&all=1" and you will see the Export Users button

    The full url should end in

    /admin.php?users/list&all=1
     
  7. Swimmy

    Swimmy New Member

    I successfully exported users but I cannot figure out the expected XML format to import users. I tried simply changing the <users_export> to <users_import> to bring a user back, but nothing seems to happen.

    Edit: Getting a little farther. I see that I need to keep it as <users_export>. I hacked a little and discovered the users are reading into the $users array correctly, but nothing is getting inserted into the db.

    It looks like users can be updated with the import, but how do you import new users?
     
    Last edited: Jul 11, 2014
  8. doublespaces

    doublespaces Member

    This worked, but how do I get this button to show up normally?
     
  9. Swimmy

    Swimmy New Member

    I got the new users to successfully import by adding these 3 lines to \library\Waindigo\UserImpEx\Extend\XenForo\Model\User.php at line 183 of massImportUsers()

    $dw->setPassword('randompassword', false, null, true); // apparently a password is needed???
    $dw->setOption(XenForo_DataWriter_User::OPTION_ADMIN_EDIT, true);
    $user['user_group_id']=2; // This is the "registered" groupid
     
    Jon W likes this.
  10. doublespaces

    doublespaces Member

    What version of XF do you have? I'm on 1.3.3
     
  11. Jon W

    Jon W Well-Known Member

    Admin CP -> Users -> List All Users -> Show all matches (at the bottom of the page)
     
  12. Jon W

    Jon W Well-Known Member

    Waindigo updated User Import and Export by Waindigo with a new update entry:

    Version 1.0.1 released

    Read the rest of this update entry...
     
  13. tharealness

    tharealness Member

    What format does the CSV file need to be in for import?

    I used "User Name" "Email Address" and "Password" but only the Password field gets acknowledged. The user name and email address give me an error and ask me to fill in the fields manually
     
  14. Jon W

    Jon W Well-Known Member

    For CSV, you need to use the same column names as in the database. So it will be username and email.
     
  15. tharealness

    tharealness Member

    Thanks I figured it out. However, when I set a password in the CSV file it doesn't seem to import along with the email address.

    I try to log the imported user in with the email and password in the CSV file but get a password error.

    Am I doing something wrong here?
     
  16. tharealness

    tharealness Member

    Figured it out. All header fields needed to be all lowercase with no empty columns (for CSV).

    username - email - password

    Worked like a charm.
     
  17. doublespaces

    doublespaces Member

    AH! There it is, thank you.
     
  18. lmnop

    lmnop Member

    The import new users isn't working for me. When I import a csv file, no one is added. I have tried all suggestions listed here.
    I am able to export a user, make a username change and import it (using XML).
    Help greatly appreciated!
     
  19. squirrly

    squirrly Active Member

    It's not perfect for me, but it's working. Are you getting any error message, or just nothing happening? You have to make sure that your column headers match PERFECTLY so I find that it's best to export a sample record and then use those column headers exactly.
     
  20. lmnop

    lmnop Member

    This is from the exported xml file:

    <user username="test" email="test@test.com" gender="" custom_title="" timezone="America/New_York">

    No error messages. Nothing happens. My headers are username email password.
     

Share This Page