The company was having a legacy system to manage projects and proposals with SQL as a backend and Oracle as weekly update source. So the idea was to have a Knowledge Management system on SharePoint that will replace the legacy system.
- Migrate data from SQL
- Automate weekly update process to migrate data from Oracle
- Manage large amount of data more than 5000 by leveraging SharePoint Search
- Export search results to excel
- Configure advanced search
- Reminder emails to furnish the information
- Configure custom search refiners, display templates.
- Leverage SharePoint out of the box forms to provide consolidated views
We used CSOM for migration of the data from Oracle as well as SQL. We created consolidated views for representing project and proposal information along with their documents and descriptions by leveraging connected webparts feature of SharePoint. The volume of data was very large (more than 5000 in each list) so we had created event receivers for associating entities to their parent.
In the legacy system client had poor search capabilities, so we worked towards providing a satisfying search experience. We customized search display templates for search results as well for refiners. We also created custom refiners. We provided export to excel functionality for search result by creating JSON Search Query from search page and passed it to Rest api.
At many places we have provided type in textboxes for the benefits of the users.
We also created search results webparts to pass this knowledge to other systems thus fulfilling the purpose of a Knowledge Management System.
- Better Search
- Out of the box consolidated views to display information
- Lifting burden from users of remembering the information by providing typeins
- Knowledge sharing with other system
Products and services used
- SharePoint Online
- .NET Framework 4.5
CSOM, JSOM, Remote Event Receivers, SharePoint REST API, Workflows