Custom Metadata Retrieval in SharePoint

Discovery Center provides the ability to define Extraction Rules for file property retrieval as part of a skim index using a pre-defined set of SharePoint repository properties. Details on how to configure these rules are included in the Discovery Center help pages and User Guide document.

It is also possible to retrieve other file level properties for content within SharePoint as part of a skim index, with the use of Extraction Rules defined for custom repository properties. To create a rule for one of these custom properties an Extraction Rule should be created of type 'Repository Property', with the property type 'SharePoint Property', and the 'Enter custom property name' option should be checked to allow for a 'Custom Property Name' to be defined.

When entering details for access to a custom SharePoint column you should use the internal name of the column which is not always the same as the displayed name. To check the internal name you should edit the column within the SharePoint web UI and check the name used in the Field argument of the URL.

sharepoint1

The following built-in columns are used to populate basic metadata in the Discovery Center database and hence these are not made available for extraction as repository properties.

SharePoint Display Name SharePoint Internal Name(s)
Created By Author
Created Created/Created_x0020_Date
Modified Modified/Last_x0020_Modified

 

Additionally the following built-in columns are not extracted:

SharePoint Internal Name Notes
CheckedOutUserId provides internal ID, not a user name
Combine field with file information
FileDirRef available via file path regular expressions
IsCheckedoutToLocal Can be inferred from value of CheckoutUser
_IsCurrentVersion AN analysis always works with most recent version
RepairDocument link for repairing document object
ScopeId internal value representing list permissions
SelectFilename available via file path regular expressions
SelectTitle available via vti_title
ServerUrl available via file path regular expressions
_UIVersion version can be accessed with _UIVersionString
WorkflowVersion applies to workflow task objects rather than documents