RSS

Mapping user accounts from Confluence to SharePoint

This blog post shows a basic user mapping.

In this blog post we’ll create a Confluence page, look at author and editor, migrate the page, configure user mappings, look at the resulting SharePoint page, and update the page’s metadata - to demonstrate how to map users from Confluence to SharePoint.

We start with at a single Confluence source page.

Confluence Source Page

This Confluence page was created by Admin, and last edited by Parzival.

Here are those users in the Confluence administration:

Those users are local Confluence users, so not synchronized with Entra ID or other external directories.

However, note that the email address of Parzival corresponds to the email address of their Entra ID user. We’ll come back to that fact at a later point.

Migrating the Source Page to SharePoint

We now migrate the page to SharePoint.

When migrating pages, WikiTraccs looks at each page and “collects” user accounts from metadata fields and page restrictions.

Information about those user accounts will be stored in the Confluence User and Group Mapping (WikiTraccs) table, in the WikiTraccs site in SharePoint:

This list contains information like:

  • Principal Type (user or group)
  • Display Name
  • Internal Name
  • Key
  • Email Address (note: only if one could be gotten)
  • Principal Source (note: the source is either onprem for Confluence Server and Data Center, or cloud for Confluence Cloud; it does not refer to specific user directories or their location)

The column WT_Setting_MapForDataAndMentions is where the corresponding Entra ID account has to be entered.

Filling in the WT_Setting_MapForDataAndMentions column is a manual task, but can also be automated via PowerShell. Clients also had success filling that via Excel.

There is an automapping feature built into WikiTraccs, though. WikiTraccs tries to find a matching Entra ID account based on the Confluence account’s email address.

That is why (in above screenshot) the mapping for Parzival is already filled in; this account has the same email address in Confluence and Entra ID.

For all other accounts the mapping has to be filled in manually (by you).

Looking at the Migration Result

What we’ve got so far is:

  • one page migrated from Confluence to SharePoint
  • the page author in Confluence is Admin, page editor is Parzival
  • the user mapping for Parzival has been automapped by WikiTraccs in the Confluence User and Group Mapping (WikiTraccs) table
  • the user mapping for Admin is yet to be done
  • the migration account used to log in to SharePoint was WikiTraccs

The metadata of the resulting SharePoint page will look like this:

The creator of the SharePoint page is the Entra ID account WikiTraccs, not Admin. That is because there is no mapping configured for Admin, yet. So, the creator is set to the account doing the migration.

The editor of the SharePoint page is set to Parzi Val, which is the Entra ID account that matches (via email address) the Confluence account Parzival.

We now want to update the mapping for Admin.

Updating Mappings, Updating Pages

So far everything is going as planned.

We migrated some content and got a mapping to do.

Let’s configure the mapping for the Confluence Admin account which we map to the Heinrich Entra ID account:

But how to update the SharePoint page?

WikiTraccs has an update mode built-in for this specific case. In the blue WikiTraccs window, choose it in the Settings dialog:

Update mode that updates page metadata based on configured account mappings

Leave all other settings in place and start the migration again.

WikiTraccs will now run over all migrated pages where a mapping was missing and update the page metadata.

How does WikiTraccs know where a mapping was missing? Those pages have been marked via the Check Principal Mapping column, in the Site Pages library:

After successfully updating author and editor metadata of a page (and only then), WikiTraccs removes this check mark. (Note: If you ever want to force an update of author and editor, set the check mark again before running the migration in update mode.)

After WikiTraccs is finished with the update mode run the SharePoint page should now look like this:

Creator and author are properly set to what was configured via the Confluence User and Group Mapping (WikiTraccs) table.