SharePoint integration

The following information relates to content processed from SharePoint repositories.

SharePoint processing

When processing Microsoft Office items from SharePoint, File Analysis Suite uses the last modified date in the de-duplication calculation. Due to the way modified dates are handled in Office items and in SharePoint (including OneDrive), File Analysis Suite will not identify documents with different dates as duplicates.

  • When an Office item is uploaded to a SharePoint or OneDrive site web interface, the item's modified date is changed.

  • When an Office item is added to a local system and is then synchronized to the SharePoint site, the item's modified date is not changed.

SharePoint Lists are comprised of form records, called items in SharePoint, that contain various text fields and can have attachments. When deleting SharePoint files, File Analysis Suite does not delete attachments to items from SharePoint Lists.

SharePoint item counts

The document and item counts in File Analysis Suite may differ from the "item" count as seen in the SharePoint site interface. This difference relates to the following.

  • In File Analysis Suite, a document is an original file processed by File Analysis Suite and an item is an attachment to an original file. In SharePoint, an item is a row in a table, or a record in a database and a document is a type of item.

  • In SharePoint, item counts are derived from the total number folders, documents, and items (each entry in a SharePoint Item List). In File Analysis Suite, document counts are derived from the total number of documents from SharePoint Document Libraries and attachments in a SharePoint Item List. File Analysis Suite does not process the field, or entry, in an Item List, only the attachments from the Item List.

    For example, if SharePoint Item has zero attachments, SharePoint records this as one item. If a SharePoint Item has 10 attachments, SharePoint also records this as one item.

  • The item count listed on the SharePoint Site Contents page for libraries includes all items in the library, including folders. Folders in which files exist in SharePoint are not included in counts in File Analysis Suite.

  • When processing SharePoint content, File Analysis Suite does not process SharePoint library items that include the UIVersion field. These SharePoint items are SharePoint UI elements and are skipped. For example, the Form Templates and List Template Gallery library items are UI elements and therefore not processed by File Analysis Suite. However, when viewing the SharePoint Site Contents page, these SharePoint items are included in the item count.