{"id":4787,"date":"2020-09-05T05:49:58","date_gmt":"2020-09-05T05:49:58","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=4787"},"modified":"2020-09-04T06:16:00","modified_gmt":"2020-09-04T06:16:00","slug":"migrate-mailguard-active-whitelist-to-mimecast-managed-senders","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/migrate-mailguard-active-whitelist-to-mimecast-managed-senders","title":{"rendered":"Migrate Mailguard active whitelist to Mimecast managed senders"},"content":{"rendered":"

Both Mailguard and Mimecast have a list of allowed emails for users. When migrating from one platform to another you will need to copy these over.<\/p>

Mailguard does not have an export function for its “Active Whitelist” so you will need to copy the Table produced in the Admin Panel into Excel and remove all but your two columns of emails.<\/p>

These two columns will need some more manipulation as they mix up Senders and Receivers in the lists and Mimecast needs one Column for Each. But the First Column in A in Excel and he Second in B<\/p>

In C1 add the following ( If A1 does has @domain.com in it list it , if B1 has @domain.com in it list it )\u00a0<\/p>

=IF(ISNUMBER(SEARCH(“@domain.com”,A1)),A1,””)&IF(ISNUMBER(SEARCH(“@domain.com”,B1)),B1,””)<\/strong><\/p>

In D1 add the following ( If A1 does not have @domain.com in it list B1 , if B1 has @domain.com in it list A1)\u00a0<\/p>

=IF(NOT(ISNUMBER(SEARCH(“@domain.com”,A1))),,B1)&IF(NOT(ISNUMBER(SEARCH(“@domain.com”,B1))),,A1)<\/strong><\/p>

Example<\/a><\/p>

Once one , create a .xls file with columns<\/p>
# address<\/td>trusted_senders<\/td>blocked_senders<\/td>approved_senders

\"\"<\/p><\/td><\/tr><\/tbody><\/table>

Add the domain.com to #Address<\/p>

Add the other domain field to either trusted_senders ( Allow Spam and Attachments ) or Approved Senders ( Allow Spam )\u00a0<\/p>

Import into Mangaed Senders using the PostIni Option\u00a0<\/p>

\"\"<\/p>","protected":false},"excerpt":{"rendered":"

Both Mailguard and Mimecast have a list of allowed emails for users. When migrating from one platform to another you will need to copy these over.Mailguard does […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3339,3338,3340,1797],"class_list":["post-4787","post","type-post","status-publish","format-standard","hentry","category-research","tag-active-whitelist","tag-mailguard","tag-manager-senders","tag-mimecast"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=4787"}],"version-history":[{"count":1,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4787\/revisions"}],"predecessor-version":[{"id":4791,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4787\/revisions\/4791"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=4787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=4787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=4787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}