Confluence Migration: How to Bulk Reviewing and marking email domains as trusted ?

[Salim Richa]

Hello Community,

I am trying to migrate confluence spaces using Confluence Cloud Migration Assistant, but it's mandatory to review all the domains manually to migrate the spaces successfully.

I have around 2700 domains and it would take a lot of time to review them all. Is there a way to bulk review all the domains to save time and effort? 

Attached Screenshots

Thank you,

[Darryl Lee · Accepted solution]

Hi, I was able to accomplish by running a zsh for loop with Bob Swift's CLI:

for x in (`cat domainlist.txt`)
do
acli jira --action renderRequest --requestType PUT --request '/rest/migration/latest/email/domain-rules' --requestParameters "{\"domainName\":\"$x\",\"rule\":\"TRUSTED\"}" --contentType JSON
done

(I generated domainlist.txt by dumping a list of users and emails and then grepping for any domains that were not my domain, and then using cut to remove everything but the domain name.)

[Darryl Lee]

(Note that I only use Bob Swift's CLI because trying to do all the authentication handshaking stuff with Python always makes my head hurt, and all I have to do with CLI is use my username and password or Personal Access Token. :-}

[Salim Richa]

Thank you

[Yves Martin]

And here is a short way to produce domain list from PostgreSQL database:

echo "select distinct (string_to_array(email_address, '@'))[2] from cwd_user" | psql --tuples-only --no-align -U confluence -h localhost confluence > domainlist.txt

[Kalin U]

Did the Atlassian support suggest another solution?

[Salim Richa]

I didn't contact Atlassian support yet