ABOUT THE PROJECT

This was a multi-step project which gave the ability for over 500 municipalities statewide to post closings via messages to the public at a moment’s notice. It utilized SharePoint to control permissions through AD groups, while also utilizing the user’s AD location property to audience target individual personnel. This resulted in a clean and simple UI which would only show information that pertained to each individual content provider.

The application featured smart form validation which would catch any potential errors before each item would be submitted. It also had the ability to batch edit and submit items for all municipal courts in a single click, which greatly reduced overhead and user error. It used CRUD operations through Sharepoint’s REST API endpoints to manage all of the content within the list. It also featured a full text search that was built into the app, along with drop down filters by county.

After a user creates or modifies an item, a python service would utilize “negotiate” to authenticate to a Sharepoint server and would check for any changes in the dataset. This means the actual password was never stored in plain text, but was generated during the authentication process for increased security. If the information was changed it would export the Sharepoint list to a JSON file. This would then be moved to our production webserver through SFTP where the Municipal Closings page would fetch and display this information to the public. The service consisted of a python script that was bundled as an executable and ran off a Windows Server through a service account. It utilized a built in schedule which would run and scan for changes every few minutes.

FEATURES

• Python script bundled as an executable and ran as a service
• Bootstrap, JavaScript Form Validation, Sharepoint's REST API, SharePlum Library
• Utilized SFTP for exchanging content to different servers
• Batch processes for adding, editing, and deleting of items
• Dynamic and completely self-maintained, allowing users to add new counties
• Negotiate authentication

MADE FOR

New Jersey Municipalities