AGTEK R & D Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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     |         |        | <del>Add telemetry history for each tracker channel, 5 min per channel, 1 week history</del> 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 <del>When referencing public url for ".html" file, post file contents, not file object.</del> |
| 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.
AGTEK R & D Wiki

User Tools

Site Tools

Page Tools
