Build ability to load XML census in addition to workbook [2021:HPR]

[Ghislain Hachey]

Build ability to load XML census in addition to workbook (e.g. a switch in the UI). The is already a transformation of the workbook to XML before being processed further and into the SQL backend. Provide a means to bypass this step and load directly an XML of the same format. Modify permissions to allow individual school to submit their own census (whether a workbook or XML dump from OpenSIS), use tied to given school and load that school's annual census)

Not part of this work below included for informational purposes only.

This would be useful in streamlining integration from a SIS into the EMIS. An export from the SIS as this standard XML could be manually loaded into the EMIS submitting all data. Of course this requires the proper usage of the SIS. The final goal could be the retrieval of the SIS data automatically from the EMIS. It’s a long shot but I think this steps completes the EMIS sides of this (minus any final adjustments/refinements)

[Brian Lewis]

Starting work.

Clearly we need to build the bridge from both sides of the river here - and we will have some open issues without a definite format arriving from the SIS ( or possibly multiple formats).

[Brian Lewis]

Aim is to spend enough time on this to reach a proof of concept:

– fabricate an XML file ( by dumping from an Excel census)

• be able to load that file into the file Db
• adapt the process endpoint - which takes a fileId (ie key into the file db) - to recognize the Xml as well as the census workbook Excel and process it accordingly.

Will investigate using Xslt to process an incoming xml file into the standard formats ( 1 per census page) that are consumed by the census load - and particular by the census load stored procedures which themselves take a standard Xml.

‌

[Brian Lewis]

feat(census): refactor to support loading from xml, xml in zip or Excel source

Resolves #1025

→ <<cset 6a4d197a4de8>>