[TH] User Import and Export [Deleted]

[Jon W]

Waindigo submitted a new resource:

User Import and Export by Waindigo - Import users from XML or CSV file and export users to CSV file.

​

This add-on adds the ability for administrators to import users from XML or CSV file and export users to CSV file from the Admin Control Panel.

Thanks to squirrly for contributing to the development of this add-on.

View attachment 77132View attachment 77133

Read more about this resource...

 

[Paul]

Hiya Waindigo,

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

Cheers
Paul

 

[doublespaces]

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

 

[squirrly]

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

 

[doublespaces]

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.

 

[Swimmy]

Mine says, "Import Users" and "Create User".

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

 

[Swimmy]

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?

 

[doublespaces]

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

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

 

[Swimmy]

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

 

[doublespaces]

What version of XF do you have? I'm on 1.3.3

 

[Jon W]

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

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

 

[Jon W]

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

Version 1.0.1 released

New features:

• Failed imports now produce a form to correct any errors and re-import.

Bug fixes:

• Fixed bug that unable to import new users due to no password being present. A password field is now accepted, or if no field is set then no password is set (i.e. user is unable to login). Default user group and language are also set if user_group_id and language_id are not set.

Read the rest of this update entry...

 

[tharealness]

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

 

[Jon W]

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

 

[tharealness]

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?

 

[tharealness]

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

username - email - password

Worked like a charm.

 

[doublespaces]

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

AH! There it is, thank you.

 

[lmnop]

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!

 

[squirrly]

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.

 

[lmnop]

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.