- 08 Jan, 2021 4 commits
-
-
Richard Peach authored
Add opening of spreadsheet during pmos export to the exponential back off (https://gitlab.developers.cam.ac.uk/uis/devops/digital-admissions/applicant-document-management-service/-/issues/81)
-
Richard Peach authored
Sort pmos data by name rather that id (https://gitlab.developers.cam.ac.uk/uis/devops/digital-admissions/legacy-smi/-/issues/97)
-
Richard Peach authored
Freeze the first 3 pmos columns (https://gitlab.developers.cam.ac.uk/uis/devops/digital-admissions/legacy-smi/-/issues/96)
- 07 Jan, 2021 2 commits
-
-
Mike Bamford authored
`gspread_request()` returns None instead of raising an `APIError` - fixing so that it raises an error.
- 06 Jan, 2021 2 commits
-
-
Richard Peach authored
Resolves "Automate the import of pool outcomes into SMI from the PMOSs" Closes uis/devops/digital-admissions/applicant-document-management-service#66 See merge request !47
-
Mike Bamford authored
"Poolside Meeting Outcome Spreadsheet" Google spreadsheet with the SMI. Changes in the sheet result in the creation of pool outcomes in the SMI.
-
- 10 Dec, 2020 2 commits
-
-
Richard Peach authored
Shouldn't sync collegePreference when applicant is in pool (https://gitlab.developers.cam.ac.uk/uis/devops/digital-admissions/legacy-smi/-/issues/84)
- 09 Dec, 2020 2 commits
-
-
Richard Peach authored
Add sync tool end-point `/pmos/import` to import SMI data into PMOSs See merge request !44
-
Dave Hart authored
Add retry and exponential back-off to the Google API calls. Read spreadsheet metadata to determine whether calls to add/update protected or banded cell ranges. This reduces the number of Google API write calls. Gracefully handle PMOSs that have no assigned applications. Increase logging of sync progress. Increase max entries per batch request. Use college descriptions in the PMOS instead of college codes. Sort college, subject and entry year dropdown lists in the PMOS. Change widths of PMOS columns to better fit the contents. Add calculated pool outcome column to the PMOS. Use the greater of the number of SMI applications and the number of application rows in the PMOS when determining the area to cover with formatting (and similar) updates. Get spreadsheet title from metadata that's already been downloaded, rather than calling the spreadsheet object property that potentially fetches the metadata again. Add `pmos import` operation to the command line tool. Correct `applications/` API end-point reference in the example job specification. Remove redundant `pmos_sheets_by_key` dictionary (use the `pmos_sheets` list instead). Use a dictionary when fetching applications, to avoid getting duplicate applications when using overlapping source queries. Detect process timeouts while handling Google Drive API requests, and exit via exception handling mechanics.
-
- 08 Dec, 2020 8 commits
-
-
Mike Bamford authored
Adding poolStatus data from the CamSIS feed... See merge request !43
-
Richard Peach authored
Trash rather than delete applicant folders (https://gitlab.developers.cam.ac.uk/uis/devops/digital-admissions/applicant-document-management-service/-/issues/60)
-
Dave Hart authored
Add module that implements the sync tool end-point `/pmos/import` by fetching applications from an SMI-compatible API, and then creating rows in the appropriate PMOSs to represent the applications. Additional operations are performed on the PMOSs to ensure the data validation (dropdown selectors for outcomes), PMOS names, protected cells, column widths, frozen headers and text formatting are correct. Applications are mapped to PMOSs based on filters specified in the job specification. Update example job specification with a sample PMOS configuration.
-
Mike Bamford authored
-
Mike Bamford authored
3.8-slim container to avoid this kind of problem.
-
Mike Bamford authored
as sub-folders of drives instead of the drive themselves. Currently this is only used when testing locally, however other tools support his and we may move to this configuration in the future.
-
- 07 Dec, 2020 2 commits
-
-
Mike Bamford authored
Add support for drive filters to the sync tool See merge request !42
-
Dave Hart authored
-
- 27 Nov, 2020 1 commit
-
-
Richard Peach authored
Adding poolStatus data from the CamSIS feed (https://gitlab.developers.cam.ac.uk/uis/devops/digital-admissions/legacy-smi/-/issues/43)
-
- 25 Nov, 2020 1 commit
-
-
Dave Hart authored
Each drive specified in the job specification file can have a filter property specified, the value of which is a list of dictionaries of constraints. When the sync tool decides which drive an application should be assigned to, an application that matches all the constraints of one or more entries in the filter list of a particular drive will get assigned to that drive. This overrides the default of only using the application's college when assigning to a drive. Update job specification example file with an example of a drive filter.
-
- 24 Nov, 2020 3 commits
-
-
Mike Bamford authored
Verify PID-like values in file names when running the applicant file verifier Closes uis/devops/digital-admissions/applicant-document-management-service#58 See merge request !40
-
Richard Peach authored
Resolves "Add retry and exponential back-off to the Google Drive API calls when changing drive permissions" Closes uis/devops/digital-admissions/applicant-document-management-service#36 See merge request !37
-
Mike Bamford authored
college shared drive. If they occur, the failed operation are retried with an exponential back-off. This is complicated by the permission updates being sent in batches. Any the failed operations in a batch are re-appended to the operations list to be re-sent.
-
- 23 Nov, 2020 2 commits
-
-
Mike Bamford authored
Delete duplicate applicant folders as soon as the contents have been moved... Closes uis/devops/digital-admissions/applicant-document-management-service#62 See merge request !39
-
Dave Hart authored
Attempt to identify values which are intended to be UCAS PIDs in file names, and flag them as erroneous if they're either not valid PIDs or don't match the applicant folder PID. To account for typos, a PID-like value is a sequence of digits (possibly with hyphens) containing 9, 10 or 11 digits, and possibly with a non-digit non-hyphen value someone in it. 9 digit sequences beginning with 2100 are not treated as PIDs as some colleges are using non-PID IDs that fit this pattern. Remove errors caused by file names with no apparent UCAS PID. Add a test function to verify the PID-like detector with a range of file names.
-
- 18 Nov, 2020 1 commit
-
-
Richard Peach authored
Delete duplicate applicant folders as soon as the contents have been moved (https://gitlab.developers.cam.ac.uk/uis/devops/digital-admissions/applicant-document-management-service/-/issues/62)
-
- 17 Nov, 2020 7 commits
-
-
Mike Bamford authored
min_expected_application_count identation).
-
Mike Bamford authored
-
Mike Bamford authored
-
Mike Bamford authored
while.
-
Mike Bamford authored
-
Mike Bamford authored
- 16 Nov, 2020 2 commits
-
-
Richard Peach authored
Fix: Application count threshold check only counts the applications on one drive (https://gitlab.developers.cam.ac.uk/uis/devops/digital-admissions/applicant-document-management-service/-/issues/61)
- 12 Nov, 2020 1 commit
-