====== Sprint 5A - 2015 Maintenance ====== **Start** 2015-04-10 ^ Task Number ^ Owner ^ Estimate ^ Actual ^ Status ^ Description ^ | **5.2** | | | | | **WebApplcation** | | 5.2.1 | Mike A | | 0.0 | Done | Add ".kml" to track download | | 5.2.2 | Mike A | 3 | | | Better display of vehicle configuration. | | 5.2.3 | Mike A | 3 | 0.5 | Done | Allow for edit of alias on trackers. | | 5.2.4 | Mike A | 2 | | | Implement "Map All Trackers" button on trackers page | | 5.2.5 | Mike A | | 0.0 | Done | Tacks page, remove "Name", change Vehicle to source, V or T, entry should href to vehicle or tracker entry | | 5.2.6 | Mike A | | 0.0 | Done | Track statistics, remove NAME column | | 5.2.7 | Mike A | 0.5 | 1.25 | Done | Vehicle page, associate with Tracker, edit details, file Clean up, need set job? Also link to tracker. | | 5.2.8 | Mike A | 0.5 | 1.25 | Done | Tracker page, edit associate with Vehicle (perhaps vehicle page?), clean up tracker page in general, add sorting| | **5.3** | | | | | **Reports** | | 5.3.1 | Mike A | 0.5 | 0.5 | Done | Fix writing of products to be fixed width, w/ leading zeros. See if there is a way of retrofitting existing db. | | 5.3.2 | Mike A | 5 | 2 | Done | Fix utilization report for John | | **5.4** | | | | | **API** | | 5.4.1 | Mike A | 3 | | | Fix getConfiguration to include some filtering args (serial) | | 5.4.2 | Mike A | 0.5 | 0.8 | Done | Test and verify "out of space" exception for Windows clients | | 5.4.3 | Mike A | 0.5 | 0.7 | Done | Test and verify lastMod setting from client (And & Windows) | | 5.4.5 | Mike A | 3 | 0.4 | Done | Lock out application update API, support tool iface | | **5.6** | | | | | **Bugs** | | Accserv-17 | Mike A | 0.5 | 0.1 | Done | Prevent slashes (both kinds) in file and folder names | | 5.6.1 | Mike A | 0.5 | 0.5 | Done | Fix uptime to be after midnight next day instead of just 24 hours + delta. To prevent drift of uptime snaps. | | **5.7** | Mike A | | | | **Access client** | | Accclt-13 | Mike A | 0.5 | 0.1 | Done | Make sure out of space is dealt with | | Accclt-8 | Mike A | 3 | | | Drag-n-drop to windows explorer | | Accclt-15 | Mike A | 0.5 | | | Windows install sets install to 0.0.0 | | 5.7.1 | Mike A | 5 | | | Archive project to zip file. **Specify what gets zipped etc** | | **Total** | | **32** | **7.6** | | | Story Velocity Complete Prediction: The only stories with velocities are Story 1 (1.5) and Story 2 (1.4). Using an average velocity of 1.45 the predicted end of work is May 13, 2015 (30 work days). How to archive a project: * Project contents are placed in a zip file, named same as project * A new folder is created /Projects/Archived to hold zip files once complete. * Zip archives are built, then stored in S3, only then are project items removed. * All file system items for the project are stored in same path in zip; e.g. Photos/picture12345.jpg, etc. * KMZ tracks etc. are stored in Tracks/foo.kmz (per previous rule) * Track system tracks are stored in Tracks/gps/date/serial/YYYY/MMDD.txt (same as server file system). * Track stats are stored in Tracks/gps/date/serial/YYYY/MMDD.stats.txt (from MySQL) * upon completion and storage of project archive, the following items are deleted from normal stores: * Project removed from project table * Track entries removed from track table * Track statistics for associated tracks are removed from trackstats table * All files in the project folder, AND the project folder will be deleted from the file store. * A complementary API method will exist allowing the project zip to be restored. * Sanity/legality tests for table based data will be undertaken to prevent sql injection attacks. * The zip file is not modified during a restoration. * Both archive and restore methods are to be atomic. * It is possible that some data may not be able to be deleted during archive, but this will not affect the state of the zip archive. * The customer file store may exceed their storage quota during archive or restore processing. * After archive or restore the customer quota may be exceeded. * The customer is responsible for deleting files to restore the quota balance. * All functionality occurs via a single API call (part of project API) * User must be CustomerAdmin in order to execute. * Archived project is just like any other file, may be deleted by anyone. * Project archiving will be available via menu options in the access client. ======== Sprint 6 - 2015 Maintenance / Track support ====== **Start** 2015-08-06 ^ Task Number ^ Owner ^ Estimate ^ Actual ^ Status ^ Description ^ | **6.1** | | | | | **Tracks** | | 6.1.1 | | 1 | 1 | Done | Add multiple telemetry channels per tracker | | 6.1.2 | | 0 | | | Add telemetry history for each tracker channel, 5 min per channel, 1 week history This is a tracker task | | 6.1.3 | | 1 | 0.5 | Done | Add TZ to point upload msg to allow for local break @ midnight. | | 6.1.4 | | 2 | | | GPS Track point orphan detector. | | **6.2** | | | | | **Architecture** | | 6.2.1 | Mike A | 1 | 3 | Done | Characterize current file store performance (track, file ) | | 6.2.2 | Mike A | 5 | | N/A | Design HSM flow and table structure | | 6.2.3 | Mike A | 5 | | N/A | Implement HSM for files | | 6.2.4 | Mike A | 3 | | N/A | Implement HSM for tracks | | 6.2.6 | | new | 7 | Done | Implement streaming of file upload | | 6.2.5 | Mike A | 3 | 0 | Defer | Test dual server install, requires HSM, rollover DNS | | 6.3 | | 2 | 4 | Done | Add archive project to Access Client. (cust admin only)| | 6.4 | | | | | **Files** | | 6.4.1 | | 1 | 0 | N/A | Can't be done When referencing public url for ".html" file, post file contents, not file object. | | 6.5 | | 3 | | Done | Characterize file / track upload performance | | 6.6 | | 3 | | | Investigate and scope a REST API, minimal file and track | | 6.7 | | new | 2 | Done | Add track/cust-active bits to control access to server functionality | | Accclt-15 | Mike A | 0.5 | | | Windows install sets install to 0.0.0 | | **Total** | | **34.5** | **17.5** | | | Prediction: 24 actual, using velocity of 1.45.