Document Management

Leveraging Office365 Document management capabilities by migrating all documents from on premise file share to office 365 (OneDrive, SharePoint)

United Kingdom
Document Management & Migration
Document Management & Migration
Document Management & Migration

Business Need

The customer required Office 365 as their Document repository to store all their documents. This would add value to features provided by SharePoint. This would require migrating existing files from file share to SharePoint Online, using a new platform for all new documents.

Technical Objective

  • Custom PowerShell script is developed to read metadata from a file share and export CSV files.
  • PowerShell covers file attributes, folder attributes, file ACLs and more.
  • Exported CSV files are then imported to the SQL database on Azure.
  • Once data is loaded into SQL, transformation of data into the expected report format.
  • Power BI report is created to connect to the data and present relevant results.