Sprint 47 Review (2018-05-02)

Availability

(assume Team Availability Calendar is up to date, otherwise, everyone is available for 12 days: 3 week Sprint, but with 2 Bank Holidays):

Andy Alistair Ashley Ify Joanne John S	-7 -3 -1 -2 -3 -2

Sprint Priorities

The following list was the prioritisation output from Sprint Planning - largely a stabilisation Sprint:

Product Management

Developer Support

North East & Y&H team support

Prep for remaining roll-out

Development

TIS → NDW ETL

ESR

Bulk upload

Document management

User Management

Enable UserAdmins to update user roles and local offices via key cloak
Add new HEE Roles for live users. Migration of current users still pending.

DevOps

Document Storage
Logging corrections

Item	Owner	Description of work	Loom video of completed work https://www.useloom.com/
Production Application releases / updates:	Simon Meredith (Unlicensed) Oladimeji Onalaja (Unlicensed) (and anyone else that needs to conduct a release)	Releases TIS-40.3 (Fixes in posts, placements. ESR updates. Performance improvements) TIS-40.10 (Performance improvements to placement create, inactivity timeout redirect to login page) TIS-41 (Bulk uploads)
Product Management	Alistair Pringle (Unlicensed) Joanne Watson (Unlicensed) Former user (Deleted) Ashley Ransoo Matt Leech (Unlicensed)	ESR Integration testing completed, interface signed off and NE going live on 08/05 Bulk Uploads Bulk People Uploads bugs refined, fixed and tested. Bulk Placement being tested in dev - first increment includes creating and updating using composite fields as matching criteria. Bulk Assessment template (draft) created, pending queries with data leads and product owner. Analysis and refinement: Data validation (reference tables TIS UI Fields - Dropdowns, management of delete/inactive values Admin UI - Deletion and BE and FE validation for People) Developer support: Bulk uploads, Rotations North East Support: Bulk uploads, on going support and Trust user training Yorkshire and Humberside roll-out: ongoing support. Main issues around assessment and Post creation and disestablishment functionality Prep for remaining roll-out: BAU tickets (refinement, investigation & reporting), plan for new Jira board and ticketing process agreed (to be tested in next sprint) UAT: Front end testing and ticket raised to supplement automated testing/BAU tickets/ongoing development UX/UI: Matt TIS User guide - Bulk uploads and Templates: TIS User Guide TIS Admin guide - Creating an account in TIS: TIS Admin guide TIS Admin L3 Tabular navigation: TIS Admin UI - UX Enhancement - L3 Tabs in (People) TIS Design to development document - To be scheduled through epic: TIS Design to development: March 2018 - Present: Design files and dev notes TIS update to design files: All files that are relevant have been updated to meet the current state of TIS and have included the UX/UI work that is scheduled. This will hopefully help when development begins on each piece of design work. All design files are listed in the document above.
DevOps	Chris Mills (Unlicensed) John Simmons (Deactivated) Frederic Randriamora (Unlicensed)	Document Storage: Document Storage completed from Operations perspective. Files uploaded in around an hour. Scanned in a day and metadata being patched as of 01/05/18. Workflow Improvements: Keycloak: ESR: go live preparations NDW-ETL and Generic Upload are live Jenkins documentation: Jenkins jobs
TIS Core Services: Back end	Paul Hoang (Unlicensed) Sunil Rochani (Unlicensed) Simon Meredith (Unlicensed) Luís Matos (Unlicensed) Suneet Kamath (Unlicensed) Former user (Deleted) Oladimeji Onalaja (Unlicensed) Jayanta Saha	Paul BAU: fix to national post numbers, speed issues Luis TIS-NDW ETL Refactored most of the queries to get more accurate data Field mapping and Row Count audits of TIS-NDW ETL Document Management Added support to view single document Partially implemented List of Document Consolidated DR ETL Bulk Uploads - People and Placements Reference data refresh Back end field validation improvements Revalidation converted to work against TIS rather than Intrepid Simon Addition of roles, permissions for admin users, doc management, Trust users + general auth db maintenance Bulk Uploads Service Desk user guide Keycloak/DB roles/groups sync Refactor profile service end points for create/update users Andras/Ola Rotations - ETL, endpoints, programme membership validator, integration tests	Updating user Local Offices via KC (fairly pointless video) https://www.useloom.com/share/9fc1c57e4b19401688c76d54ab8d2ca6
TIS Core Services: Front end	Panos Paralakis (Unlicensed) Oladimeji Onalaja (Unlicensed) Matt Leech (Unlicensed) Shivani Rana (Unlicensed) Former user (Deleted)	Panos Programme memberships Site names to siteKnowAs where it was possible Redirect to Log In page when keycloak session is expire Update user details every 15 mins (for receiving updates on user permissions) Fix on time needed to get post results on search on placements Fixed security vulnerability on an NPM dependency Disabled browser autocomplete on latest dropdown component Updated build target environments Bulk Uploads Fixed table row layout issue Improved error styling Code now asks API for data sorted by date Document Management Merged in frontend branch to master, feature is hidden from users John G: Global HTTP error handling strategy now in place Enforces a 40 second timeout on API calls, shows error notification after 40s SpinnerService for showing spinner now works with legacy Http service as well as HttpClient Adds confirmation modal before removing person programme Adds toast notifications service for displaying notifications Multi-Select Widget - Person:Roles Rotations Post - Multi select implemented for rotation Programme Membership - Changes made in-line with Panos Paralakis (Unlicensed)'s updates Slow Loading Messages (shown last sprint review) E2E Testing: TISDEV-4556( Update placement tests as per changed element locator id's and NPN timeout) TISDEV-4484 (Fix 54 failed test cases in E2E test pack due to new changes in UI) TISDEV-4442 (Update Post test cases as per new ribbon functionality and changed UI element locators and timeout for dropdown) Fixed e2e test scenarios failed due to spinner developement by writing new utility methods and used them to fix the scenarios. Fixed other tests failing due to dropdown locators id's were removed across components by finding another way to locate dropdown elements and implemented the changes. Id's of many fields has been modified including post, people and placements so I have done the required changes to fix these scenarios. added more utility method to wait for values to get populated in dropdowns before selecting options. Implemented required changes to capture the NPN from newly added ribbon and working on using this to serach for the created record. Supported release and provided feedback. Implemented review comments and working with Ola to complete the pull request for Cucumber Implementation of User Management login feature.	Rotation - Post https://www.useloom.com/share/2e20ddf29d7e49b5acff0aa2b603b84e Rotation -Programme Membership https://www.useloom.com/share/a58729d7cb9f46b4beedd8d2122af8dc Confirm remove person programme: https://www.useloom.com/share/4be9f9b0e8a642fab49b1f016ccac8ff
ESR Integration	Former user (Deleted) Ashley Ransoo	ESR integration testing, reviews and changes to support the review outcomes. Moving towards the signoff and go live. And below tickets were worked on:
Data Quality	Data_quality colleagues
Resource Planning	Reuben Noot (Deactivated) Andy Nash (Unlicensed)	Agency update Two more FE CVs received - arranging interviews Full Time recruitment