Rake task for merging users

Announcements
,
1

As of Discourse 2.5.0.beta3, site admins can merge non-staff users without needing to access the console. For security, staff users will still need to be merged via the console.

Visit the user admin page, and select “Merge” at the bottom of the page.
image

Enter the username you want the account to be merged into, and click “Transfer & Delete @username” to start the merge process.
image

The rake task for merging users is now available on tests-passed. :sunny:

Users can be merged by executing

rake users:merge['source_username','target_username']

(note: ensure there is no space before/after the comma)

This merges the data of the source user into the target user before it deletes the source user. The content of 45 tables gets merged, so depending on the amount of data associated with the source user this process can take a while.

Plugin authors can hook into the merge process by handling the :merging_users event. I’ve already implemented it for the polls plugin, which merges the votes of the two merged users.

Known problems:

  1. Incoming links that still reference the source user (e.g. https://talk.example.com/t/some-topic/17/3?u=source_username) won’t be associated with the target_user.

  2. A user can have only one shadow user (from the allow anonymous posting feature). So, if both merged users had a shadow user, then the one owned by the source user will be lost… well, it’s still there, but not associated with an existing user anymore.

55 Likes
2

Ooh… That’s the most exciting part of this to me.

3 Likes
3

We should try this out on some of the accounts at rubytalk.org … a great little test site, Matz has like 5 emails.

7 Likes
4

Thank you for this feature, it is huge for my use case! I am currently porting our forums from phpBB to Discourse and wanted to use SSO via a custom provider. Since we could not easily link SSO accounts to our legacy accounts and works flawlessly!

If anyone else is going to use this make a note of this:

rake users:merge['mattbr_sso', 'mattbr_legacy'] will not work as expected, the SSO will not go through. However:

rake users:merge['mattbr_legacy', 'mattbr_sso'] works perfectly and allows you to migrate all the posts into the SSO account.

Thanks for the feature :slight_smile:

8 Likes
5

I’m super excited about this, but can’t see any mention of webhooks in this topic. Is this planned @gerhard?

6

How are webhooks relevant to this?

7

When using the ‘User Event’-webhook created or login (or approved?) the duplicates will be existent on a connected site as well and one might want an automatism to clean them up as well, if the connected site supports that.

I haven’t used webhooks yet but plan to. On my connected site (using Discourse as SSO provider) the users are only created at first login for now.
+ I had duplicate users in my old forum before migrating to Discourse which I was looking forward to consolidate once this feature becomes available.

8

I had another user question about this today, He also asked about the “Created” field in his profile.

  1. Is this function going to be implemented in the GUI, or will it stay a rake task?
  2. Will (or has) the rake task be(en) changed to handle mentions and quotes?
  3. Would it be possible to set “Created” to the date of the oldest owned post?
9

It will stay a rake task for now.

Yes, it will. I should be able to make this happen for the 2.0 release.

You will have to update the user’s created_at manually if you want to set it to the oldest post. The merge process uses the created_at from either the source or target user – whatever date is earlier.

4 Likes
10

This being the case, if as a hosted customer I have accounts to be merged, should I ping the details through to the Discourse team for actioning?

5 Likes
11

Sure that sounds fine. We also need to exercise the feature internally to make sure it is working right.

4 Likes
12

Quick update: Merging users now updates mentions, quotes and avatars in posts and revisions. :tada:

31 Likes
13

Any chance the staff action log could better show what happens to users when they are merged? Here’s how it looks now - just shows that system has deleted the user but no context. The details only show some info about the user that got deleted as a result of the merge.

06%20PM
Screen Shot 2018-05-18 at 2.03.06 PM.png1234×401 34.8 KB

8 Likes
14

Sure what do you think @gerhard?

4 Likes
15

How about adding a staff note along the lines of “Username with email was merged to this account, date”

This is what I did when I was merging accounts manually. Probably more work than a staff action log entry, but might be useful information at some point later.

4 Likes
16

@gerhard we should make sure the task is logged in the staff logs if possible, per above ↑ ↑

2 Likes
17

I’m currently writing my todo list for this week and it’s already on it. :slight_smile:

5 Likes
18

Is there an easy way to change which email address is primary?

Here’s my use case:

imported user with email user@defunctdomain.com emails from user@fancynewemail.com which creates a staged user. After a few PMs with the staged user, I merge the accounts, but the primary address is still the old one. And from the web interface I can’t change the email in his profile because it’s already taken. By him.

Perhaps this is a bug in the multiple email address model and not a complaint for here.

The simple solution, which took me much to long to come up with, is to delete the old address.

2 Likes
19

Merging users always preserves the existing data of the target_user, so the email address of the source_user is only added as secondary email address.

Yeah, that’s the solution.

2 Likes
20

Is there something easier that I should do?
I need to keep the old username with the new email. The staged user is the real problem. Perhaps I should just delete the staged user, but then I don’t have an easy way to reply to them to tell them what happened.

It’s pretty cumbersome to merge[‘newname_newemail’,'oldname_bogusemail"] and then have to do something like

u=User.find_by_username['oldname_bogusemail']
ue=UserEmail.where(user_id: u.id)
ue[0].destroy
ue[1].active=true
ue[1].save

is there some easier way that I’m missing?

1 Like