Exports should be prepared server-side

[warrensearle]

Currently we have a number of 'Export to XLSX' buttons in admin and these are all downloading full data to the client and then transforming it into the desired XLSX format. This is clunky. Instead we should be doing this on the server-side and perhaps saving the data to Google Drive as a Google Sheet instead of allowing a direct download.

[KateMJAC]

Assigned to Halcyon in the March WO.

[HalcyonJAC]

There appear to be a number of pages with Export XYZ buttons on them that use the existing client-side downloadXLSX() function, which need moving to a server-side implementation:

• Exercises
• Applications - Export Contacts
• Reports - Diversity Report
• Reports - Handover
• Reports - Outreach
• Reports - Reasonable Adjustments
• Reports - Qualifying Test Report
• Qualifying Tests - Responses

Please confim whether the above list is correct or not

[warrensearle]

Hi @HalcyonJAC and @JeremykJAC the following pages are the ones to optimise (and I believe covers all of them):

• Applications - Export Contacts
• Reports - Handover
• Reports - Reasonable Adjustments
• Qualifying Tests - Responses

The following, mentioned above, are all ok as the data being converted to xlsx is already pre-generated or created server-side:

• Exercises a cloud function does the heavy lifting here. NB this is also being worked on this month
• Reports - Diversity Report report is pre-generated via a cloud function
• Reports - Outreach report is pre-generated via a cloud function
• Reports - Qualifying Test Report report is pre-generated via a cloud function

[warrensearle]

For now I think let's keep them as xlsx downloads.
We can consider exporting to google drive in a future ticket.

[HalcyonJAC]

Thanks @warrensearle !

[KateMJAC]

Please leave for my return on 22/03 for testing and approval for release.

[KateMJAC]

@HalcyonJAC @JeremykJAC I have tested this and found the following:

• Applications - Export Contacts: I was able to export the contacts. There was no refresh button, but i'm guessing that was because it doesn't fall under reports? as is the case with QT - Responses.

• Reports – Handover: Refresh button was there and I was able to download the report.

• Reports - Reasonable Adjustments: Refresh button was there and I was able to download, however the report listed two people within it, while the platform only listed one candidate as having reasonable adjustments (pictures below).

• Qualifying Tests – Responses: Was able to dowload the responses. There was no refresh button - as above for applications - Export Contacts.

[HalcyonJAC]

Hi @KateMJAC

I have spent some time today trying to replicate the problem you found with the Reasonable Adjustments report, on my workstation but have not managed to. This is could be down to my lack of knowledge on the lifecycle of an exercise and system workflow. I would have called one of the developers for help but didn't want to take much of their time up.

In any case I have some changes to the exports so that the export button is no longer enabled unless there is actually data to export at least, to avoid other possible errors.

I will speak to one of the dev team tomorrow and see if they can help me replicate this problem locally so I can get to the bottom of it.

Darrel

[KateMJAC]

Positive result during testing by Tester User Group. I also tested with a positive result. This can move to reviewed,