RMI workbook in RMI seems outdated

[Ghislain Hachey]

We get the error “Error Uploading File: Index was outside the bounds of the array.” as shown below.

‌

The version of the provided workbook in the EMIS rollover seems outdated. When doing the rollover from within the EMIS what we get is version 20200102.

But in FSM the version is 20221026.

‌

[Ghislain Hachey]

Looking at the code it seems the data in the workbooks sheets SchoolList, List (lookups) and metaData now all get dynamically generated during the rollover from within the web app (as oppose to using data connections in the workbook as before). So I have simply copied FEDEMIS_CENSUS.xlsx to MIEMIS_CENSUS.xlsx. The only difference I could see from both those files are the “Fax” vs “HF Radio” fields in the “Schools” sheet. So I changed this in the MIEMIS_CENSUS.xlsx (though this is not rolling over correctly but this is different issue).

I then did a rollover to retrieve a clean version of the latest workbook for MIEMIS. I removed all data and merged in the data as completed in a slightly older version of the workbook by the RMI PSS team. This now loads with the originally reported error in this issue.

However, as the EMIS is now even stricter then before with data quality validation the result of loading the data in its current shape is many errors (as shown below). They are almost entirely very easy to fix by following the feedback.

‌

[Ghislain Hachey]

Resolved by https://bitbucket.org/softwords/pineapples/commits/c1b0cf799d3b34b408d0ac1368f6ca68c769e57d

[Ghislain Hachey]

fix(assets): MIEMIS_Census.xls

Resolves #1336

→ <<cset 4a2c279b48a0>>