DEECD SharePoint Data Integration

Work Undertaken

The Data Integration project involved the design, development and implementation of an intuitive and customer friendly application for the DEECD eduGate portal. This portal is used by over 80,000 users at multiple levels from headmasters to students within the Victorian schools system.

The application enables DEECD business users to import data supplied by 3rd party contractors into the SharePoint site on both a scheduled and an on-demand basis. 

The major tasks performed by the application included:

  • Importing contractor provided data, transforming/converting it  and storing it as InfoPath forms in the SharePoint site.
  • Assigning item level permissions to each InfoPath form.
  • Assigning read-only and edit sections inside each InfoPath form for the target audience.
  • Providing functions for DEECD business users to approve or reject work proposals.
  • Workflows to send appropriate notifications to required individuals and groups.

 

Complexity

This project enabled DEECD business users to import and update various work details carried out across hundreds of schools in Victoria on a scheduled and on demand basis to ensure that the stakeholders have real-time information about the progress of works at their site.

The project involved custom InfoPath forms and sophisticated process workflows, incorporating a complex hierarchy of permissions,  security constraints and business rules.