US flag signifying that this is a United States Federal Government website An official website of the United States Government

De-duplicate data from Tock and Float

Closed
Ended on 02/26/2016
Winning bid (Christian G. Warden): $1,649.00

Skills

Ruby

Description

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.

Auction rules

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.

Acceptance criteria

Given the Float API and the Tock API, https://tock.18f.gov/api/, When a user runs a Ruby command line script,

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.

General acceptance criteria

  • B or better Code Climate grade and 90% or higher test coverage for all modifications.
  • Tests adequately cover any new functionality.
  • Tests run on Travis-CI and do not break the build.

Resources

Deliverables

A single pull request submitted to https://github.com/18F/tock with clear, descriptive commits that satisfy all of the above acceptance criteria.

Bidder DUNS Amount Date (EST)
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 closed

Bidding for this auction closed on February 26, 2016 01:00:00 PM EST.

Auction started at

February 24, 2016 01:00:00 PM EST

Auction ended at

February 26, 2016 01:00:00 PM EST

Delivery deadline

March 04, 2016 01:00:00 PM EST

Eligible vendors

SAM.gov only

Auction type:

Reverse (rules)

Paid at:

June 17, 2016 02:37:07 PM EDT

Accepted at:

March 04, 2016 01:00:00 PM EST

View on GitHub