XF 1.5 Export users

[arriej]

Hello people,

I currently host a xenforo forum with about 340sers, me and a friend are going to fuse our forums together, and start fresh. But and we don't want that our users have to re-register.
So I was wondering if there is a way to export users, And then only profile related info, like: User ID, Username, email, Gender, Language,Timezones, UDer group ID, Secondary groups, Avatar, profile settings, custom title, etc etc. But not the things as in amount of posts, trophy points Basically the xf_user Table but without a few collums. Does anyone know if there is an addon or anyone willing to write a little query with me to export our user?

Then I need to import the users into a new database. Only thing that needs to be done is place all imported uses in the default usergorup (don't know the ID right now) and the user ID counts need to be 340+ current ID


I know I Will need xf_user_authenticate for the password. For importing this would also be 340+current id.

Thanks in advance!

 

[Chris D]

XenForo has a built in XenForo to XenForo import system (assuming both forums are on XenForo).

 

[arriej]

Yes they are both xenforo. So I don't have to worry about importing then awesome!

Whats the best way to export?

 

[Chris D]

You just need to decide which forum you're going to export from and which one you are going to import to, first. I guess whichever server you are keeping which currently hosts one of the forums will be the one you import into.

Roughly you would:

• Close the other forum
• Move the content, files, database over to the server which currently hosts the forum you're importing into
• Go to Admin CP > Tools > Import External Data
• Select XenForo from the list and follow the on-screen prompts

That's it. If the forum you are exporting isn't very big then it shouldn't take too long.

 

[arriej]

is it also possible to only have certain tables? or is it just the whole forum I would import?

 

[Chris D]

You can see a screenshot of the process here:

https://xenforo.com/community/threads/pre-sales-faq.4951/

You just run through each of these steps in sequence. You can omit certain steps if you don't need them, though of course some steps require some of the others to be run before you run them

At minimum you'll need user groups, users, forums, threads and posts, but you might be able to skip the rest.