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

[Brian Engert]

I like this answer. I tweaked it some to call the api to pull the list of domains and to use my crowd cookie and curl to call the api.

curl --request GET --url https://confluence/rest/migration/latest/email/domains --cookie 'crowd.token_key=asdf;' | jq -c '.availableDomains[].domainName' | while read i; do curl --request PUT --url https://confluence/rest/migration/latest/email/domain-rules --header 'Content-Type: application/json' --header 'Cookie: crowd.token_key=asdf;' --cookie 'crowd.token_key=asdf;' --data "{\"domainName\":$i,\"rule\":\"TRUSTED\"}" ; done

[Kalin U]

Did the Atlassian support suggest another solution?

[Salim Richa]

I didn't contact Atlassian support yet