How to generate Public Folder Pathways

Before starting your import from Public Folders to CMap Mail, you will need to generate a CSV of pathways. This CSV is key to the import process as it will tell the tool where the emails are currently stored in Exchange. 

1. If you haven't so already, make sure you have Exchange Online PowerShell installed on your machine. If you do not have it installed, ask a local admin to install it for you. 

2. Using an account that has Exchange Admin rights, run this PowerShell command in Exchange Online PowerShell:

   Connect-ExchangeOnline

   Get-PublicFolder -Recurse | Select-Object Name, ParentPath, Identity, MailEnabled | Export-Csv -Path "O365PublicFolders.csv" -NoTypeInformation --Result Unlimited

3. This will generate the output CSV. You'll need to tidy up the CSV so that it looks like this:

   

   Include Column Headers highlighted in yellow 

   Column A for Project Codes (Project)

   Column B for Public Folder Pathways (PublicFolderPath)

You can either use Visual Studio or Excel to tidy up the CSV. If you are using Excel, make sure to remove any speech marks (") at the start and end of your project codes and Public Folder paths. 

The importer will copy all emails in the folder and the folders below. The CSV will include the subfolders, so you can delete these from the file if you wish.