The Update List View app can be used to update the email views of existing SharePoint lists and libraries to include EML files.
This is a free app and does not require a license.
Pre-requisite
To install and use this app, MacroView DMS v8.9.491 or later must be installed.
Download
Close Microsoft Outlook, DMS Explorer (if applicable) and the MacroView DMS Local Service, then download and run the Update List View installer.
Update List View 1.0.0 for 64-bit Windows
Minimum requirements
- MacroView DMS or MacroView Message 8.9.491+
How to update library views
The Update List View app is setup with a default configuration designed to update the Email Messages view in SharePoint document libraries to include EML files in addition to MSG files.
Important: the library must already contain the MacroView email management columns.
Run MacroView DMS and right-click on a site collection in the tree-view that contains libraries with views you would like to update and select "Update List Views".
Clicking on the Update List Views command will launch the Update List View app and pass through the URL of the site collection.
The Update List View app will search for libraries in the site collection that match the following search criteria.
View name: Email, Emails or Email Messages
View filter:
<Where>
<Contains>
<FieldRef Name="FileLeafRef" />
<Value Type="File">.MSG</Value>
</Contains>
</Where>
The following test site collection has been setup with four libraries that match the above search criteria.
Below is the result of launching the Update List View app for the test site collection.
Click the Review button to display library details in tabular format.
Note that the Report Only checkbox is ticked, this means that the Update List View app will run in read-only mode to check if there are any issues, prior to updating the views.
Click the Run button in the header or footer.
As the Report Only checkbox is ticked the app runs in read-only mode and displays the following result.
Click the Export to CSV button in the footer.
This will display the file system Save As dialog. Give the file a name and save it to a location on your file system.
Click the Import CSV button in the header and select the file you just saved.
Untick the Report Only checkbox and click the Run button in the footer.
Result: the Email Messages views have been updated to include EML files.
It is recommended to use the Report Only and Export to CSV approach in order to retain a record of libraries have been updated in case of failure or to assist with troubleshooting.
It also makes is easy to run the update routine again, if one or two libraries fail to update.
To run the update again click the Import CSV button, select the CSV file, untick the Report Only checkbox, then click the Run button.
The Email Messages view in each library should now include both MSG and EML files.
<Where>
<Or>
<Contains>
<FieldRef Name="FileLeafRef" />
<Value Type="File">.MSG</Value>
</Contains>
<Contains>
<FieldRef Name="FileLeafRef" />
<Value Type="File">.EML</Value>
</Contains>
</Or>
</Where>
Test
Test that a library has been successful updated by uploading an email in EML format to the library. In MacroView DMS change the library view to Email Messages and verify that the EML file is displayed in the file list.