ABOUT THE PROJECT

This project was to create an Ombudsman Portal to be used in all counties throughout New Jersey to insure an easy and efficient way of helping visitors. They have the ability check in, record data, and generate reports based off the statistics of users. It replaced an aging product, and required a data migration of over 200k records from a Microsoft SQL database into Sharepoint. This was performed by using a Python script to recursively query each table, consume and inject it into another system. By using this script, it allowed the use of both systems while in the migration period since moving over any new content would be an automated procedure.

FEATURES

• Developed using Angular which utilized Sharepoint PnP for service providers
• Python Script using negotiate authentication, MSSQL connector to migrate content and remap fields
• Created local Sharepoint Rest Proxy to allow for local development to avoid CORS issues
• Custom view filtering
• Client side PDF generator from statistical analysis
• Date Range Picker that allows for creating reports during a certain time-frame
• Sorting / Filtering using custom angular pipes
• Built with Material Design components
• Compatible with older browsers by taking advantage of polyfill libraries

MADE FOR

New Jersey Courts