Creating SharePoint metadata columns
Who is this article for?Administrators setting up SharePoint to work with the Mail Manager web search.
M365 SharePoint Administrator and Search permissions are required.
When enabled, the Mail Manager web search is able to utilise SharePoint's index capabilities to allow users to find emails from any device.
This article shows you how to create the metadata columns necessary for indexing.
1. Creating a document library
In each SharePoint site, create a new document library using a consistent naming convention (e.g. Emails).
If the library already exists, ensure it doesn't contain more than 5000 items. If it does, you will need to move the email files into a newly created document library with metadata columns to ensure they will be indexed.
To check the number of items in a library:
- Access the SharePoint site in a web browser.
- Open Settings (Cog icon).
- Select Site contents.
You will be taken to the site's Document Library, where the number of items for each library is shown.
2. Creating metadata columns
This setup can only be carried out if the Document Library contains fewer than 5000 items.
- Open the Auto Discovery Tool.
By default, it's located in %localappdata%\Mail Manager\Program Files\x64\MailManager.Autodiscovery.exe. - Select SharePoint.
- Click Auto Discovery.
A new window will appear called SharePoint AutoDiscovery. - Select Load Setup File.
- Create a blank text file.
- Add the required discovery pattern
- Load the file.
- Select Discover Locations.
When finished, a file called UniqueDocLibs.txt will have been created alongside the file. It contains the unique ID of each document library and is used in the next step. - Go back to the Auto Discovery Tool.
- Select SharePoint.
- Click Metadata Iteration.
A new window will appear called Metadata Iterator. - Select Load DocLibs File.
- Choose the UniqueDocLibs.txt created in the previous step.
- Click Open.
- Select Iterate Metadata.
When finished, Mail Manager metadata columns will have been created in each document library. In addition, a file called SampleFile.txt will be created and metadata for the file added.
3. Reindexing a site
To add the new columns to the search index, they first need to be crawled. This can be achieved by reindexing a site that includes the new columns.
To reindex a site:
- Access the SharePoint site in a web browser.
- Open Settings (Cog icon).
- Select Site information.
- Choose to View all site settings.
- Click Search and offline availability.
- Click Reindex site.
- Select a reason for reindexing.
- Click Reindex site.
Depending on the amount of site content and the timing of next scheduled search crawl, it may take some time to complete the reindex (24-36 hours).