ABOUT THE PROJECT

This project was to create an Ombudsman Portal V2 to be used in all counties throughout New Jersey to insure an easy and efficient way of helping visitors. Staff have the ability check-in, record data, and generate reports based off the statistics of court 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 after negotiating authentication. By using this script, it allowed for the use of both systems while in the migration period since moving over any new content would be an automated procedure.

The application used audience targeting by inspecting the users AD properties through Sharepoint's User Profile Service Application. This allowed for a completely customized experience for each user by automatically filtering clients by location. Users with a higher title would also have access to more tools and utilities, like generating statewide reports for all vicinages. Reports were rendered client side by utilizing the library "Canvas2PDF" which will render an entire page to a PDF document.

FEATURES

• Developed using JavaScript in conjunction with Sharepoint for its RESTful web services.
• Python Script using negotiate authentication, MSSQL connector to migrate content and remap fields
• Custom view filtering based on users status (Waitlist, Being Seen, Completed)
• Multi-field form validation with custom error handling and messages
• Client side PDF generator from statistical analysis utilizing "Canvas2PDF"
• Date Range Picker that allows for creating reports during a certain time-frame

MADE FOR

New Jersey Courts