Purpose

The Map Folder Name to Field plugin will automatically set a default value of a metadata column based on the name of the SharePoint folder a file is being saved to.

An example of where this can be useful would be if your libraries have a sub folder for each document type (e.g. Memo or Letter) and you would like all files saved to that folder to have their Document Type choice metadata column set automatically as you save to that location.

How it works

Map Folder Name to Field can be configured to set the value of any of the following field types to the name of the folder where a document is being saved.

• Choice
• Lookup
• Managed Metadata
• Multiple lines of text
• Multi Choice
• Multi Lookup
• Multi Managed Metadata
• Number
• Single Line of Text

When a document is saved to SharePoint using DMF or Message, if all the conditions configured in the registry are met the default value of the configured columns will be set to match the name of the folder or document set it is being saved to.

Configuration

The settings that dictate when the Map Folder Name to Field plugin will take affect are specified under the following branch in the registry:

HKEY_CURRENT_USER\Software\MacroView\DMF\Customizations\MacroView\MapFolderNameToFieldValue

Root Registry Settings

The root key “MapFolderNameToFieldValue” has two available settings:

• Disable
  • 0 = Enables the extension (default).
  • 1 = Disables the extension.

• EnableMultiple
  • 0 = Will only attempt to map and set 1 Field for the targeted Content Type (default).
  • 1 = Will attempt to map multiple Fields (if the mapping matches the filter criteria).

The root key also has a subkey named “TargetContentTypes”.

Targeted Content Types Subkey

The TargetContentTypes subkey is a container for each target Content Type the user wishes to use for the Field mappings.

Each Content Type Field map must be in its own subkey. The mapping subkeys can have arbitrary names, however when searching for a matching ContentType->Field map, the search is performed in sequential order. If “EnableMultiple” is disabled (set to 0); the extension will select the first available map that matches. Therefor it’s recommended to name the subkeys in a fashion that represents preferential ordering (i.e. 1, 2, 3 ,4 etc).

Targeted Content Types Registry Settings

Each target Content Type subkey has 14 configurable settings.

Note - If any of the “Allowed” settings are left blank, all Sites, hosts, container types or Lists that are not in the corresponding “Ignore” setting will pass the filtering process.

If an “Allowed” setting is not blank (contains one or more items); only those specified in the “Allowed” setting will pass the filtering process.

• AllowedContainerTypes

A list of allowed container types where the folder name value can be “pulled” from (i.e. Folder, Document Set, Matter Document Set) (default = blank).

• AllowedHosts

A list of allowed servers / hosts, to limit which host the extension will function on (do not include protocol of server; http or https) e.g. (contoso.com or localhost:8080) (default = blank).

• AllowedLists

A list of allowed SharePoint Lists the extension will trigger on (default = blank).

• AllowedRootContainerTypes

A list of allowed container types for the “Allowed Container”. This setting is used to restrict mapping to subfolders within a folder or document set (i.e. Site->Library->…/…./RootContainer->Container) it is NOT recursive, and will only restrict the parent of the “Allowed Container”.

• AllowedSites

A list of SharePoint Webs using the web server relative URL (e.g. /sites/TestSite) (default = blank).

• ContentTypeName

ContentType name for the mapping (i.e. Document, or Matter Document).

• Disable

Boolean trigger to disable the individual mapping (useful for a temporary disable) (default = 0).

• IgnoreCase

Boolean trigger to enable / disable case sensitive matching (default = 0), set to 1 for ignore case sensitivity.

• IgnoredContainerTypes

List of container type to ignore (e.g. Folder, Document Set).

• IgnoredHosts

List of hosts / servers to ignore.

• IgnoredLists

List of SharePoint Lists to ignore.

• IgnoredRootContainerTypes

List of Root / Parent container types to ignore (see AllowedRootContainerTypes for more information).

• IgnoredSites

List of SharePoint Webs to ignore (using server relative URL).

• MapToFieldInternalName

Internal Field name of the target ContentType Field to map the folder name value on success. 

Note: this value is case sensitive e.g. mvDocumentType 

Compulsory Registry Settings

The only compulsory / required Registry settings for each targeted Field map are:

• ContentTypeName
• MapToFieldInternalName

Default Configuration

By default Map Folder Name to Field is configured for use with MacroView Case and Matter so that it only applies when saving documents to folders within a Matter Document Set using the Matter Document content type containing a metadata or choice column for Document Type. 

Installation

Important: This plug-in will only function once they are added to your MacroView DMF or Message license. Contact services@macroview.com.au to obtain a license for these plug-ins.  

Close Microsoft Outlook, DMF Explorer (if applicable) and the MacroView DMF Local Service then download and run the Map Folder Name to Field installer that corresponds with your installation of Windows.

 Map Folder Name to Field 1.0.3 for x64 Windows

 Map Folder Name to Field 1.0.3 for x86 Windows

Minimum requirements

• MacroView DMF or MacroView Message 8.5.1088 or later

If after installing the plug-in is not available refer to how to activate a licensed DMF or Message plug-in.