18F uses Tock to track past staff project allocations and uses Float to predict future staff project allocations. Both systems contain very similar information but with very different temporal aspects: Tock contains historical data, while Float contains projected future data. However, the data elements are very similar.
Since both applications are used for managing the business of 18F, it is critical that the common data elements between the two are regularly reconciled. For instance, analysis quickly breaks down if a project in Float has a
name attribute that varies from the project
name attribute in Tock.
This issue seeks to provide a command-line script that pulls data from Tock and Float and returns a list of possibly-duplicate project names. The primary user of this application is 18F's internal manager of Tock and Float. The primary use case is running the on-demand via command line that checks for inconsistencies between Tock and Float across the following fields:
(1) person names;
(2) project names;
(3) client names; and
(4) project --> client associations.
Both applications have straightforward APIs.
Registered users on micropurchase.18f.gov may bid to deliver the requirements in this auction. The lowest bidder at the time the auction closes shall receive the award. The awarded bidder shall have five business days after notice of award to deliver the requirements. Upon successful completion of the requirements, 18F shall pay the winning bidder.
Also see our policies and guidelines page.
Then it should return a list of project names that appear in both Tock and Float in any of the following portions of the Tock/Float
1) person names;
2) project names;
3) client names;
(4) project --> client
and that the project names must be similar but not exact matches.
The fuzziness of the similar matches should be able to be set by a command line parameter.
A single pull request submitted to https://github.com/18F/tock with clear, descriptive commits that satisfy all of the above acceptance criteria.
|Christian G. Warden||080033077||$1,649.00 *||February 26, 2016 12:59:47 PM EST|
|Dan Siddoway||080014807||$1,650.00||February 26, 2016 12:59:46 PM EST|
|Evan Rose||07-944-1444||$1,700.00||February 26, 2016 12:59:29 PM EST|
|Christian G. Warden||080033077||$1,749.00||February 26, 2016 12:59:25 PM EST|
|Dan Siddoway||080014807||$1,750.00||February 26, 2016 12:59:08 PM EST|
|Christian G. Warden||080033077||$1,895.00||February 26, 2016 12:57:59 PM EST|
|Evan Rose||07-944-1444||$1,896.00||February 26, 2016 12:57:57 PM EST|
|Christian G. Warden||080033077||$1,897.00||February 26, 2016 12:57:18 PM EST|
|Evan Rose||07-944-1444||$1,898.00||February 26, 2016 12:57:04 PM EST|
|Christian G. Warden||080033077||$1,899.00||February 25, 2016 08:22:22 PM EST|
|Ry Bobko||080024708||$1,900.00||February 25, 2016 07:20:59 PM EST|
|Christian G. Warden||080033077||$1,999.00||February 24, 2016 06:21:33 PM EST|
|Ry Bobko||080024708||$2,000.00||February 24, 2016 01:52:37 PM EST|
* - winning bid
Bidding for this auction closed on February 26, 2016 01:00:00 PM EST.
February 24, 2016 01:00:00 PM EST
February 26, 2016 01:00:00 PM EST
March 04, 2016 01:00:00 PM EST
June 17, 2016 02:37:07 PM EDT
March 04, 2016 01:00:00 PM EST