Final report for "Redevelop School Inventory System" - Project 269


Inventory (asset management) system. Went live on May 2018.

Various problems with old inventory fixed - sync with orders files, handling systems with no hostnames, switch location oddities, odd hybrid between old CS ordershost code and old DAI inventory code, logic was almost entirely client side and non transactional causing integrity problems. New system, logic is all in the API and makes use of SQL transactions.

Limited code review - particularly of API and web stuff - led to some fixes. Development, and particularly design, was discussed on a weekly basis at MPU meetings.

Clientreport mechanism particularly useful and now used as basis for various reports and processes. Very useful for planning and debugging problems.

Follow on

Improve the quality of the data. Skin the web interface. More clientreport modules - but anybody can produce these. Integration with any asset management system introduced as part of SEP.

Lessons Learnt

Took far too long. Probably spent too much effort on prototype? Practical for Head of Computing to carry out major development projects such as this - particularly ones with no hard deadline. ? Lots of additional effort expended due to context switching. Affected by Bayes, SL7 projects.

Should have split the project. Some of the additional functionality (eg supplier report feed) could have been done as a follown on project.

Much work could have been saved had the project started later - could have used Theon technology.


Period Hours
2015 T1 67
2015 T2 138
2015 T3 109
2016 T1 84
2016 T2 187
2016 T3 102
2017 T1 126
2017 T2 177
2017 T3 90
2018 T1 61
2018 T2 67
2018 T3 31
2019 T1 74
2019 T2 25
2019 T3 26
Total 1364

Total of 39 weeks of effort.

Affected by Bayes, SL7 projects.

-- AlastairScobie - 25 Sep 2019

Topic revision: r7 - 20 Jan 2020 - 15:32:07 - AlastairScobie
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback
This Wiki uses Cookies