{"action":"opened","issue":{"url":"https://api.github.com/repos/18F/calc/issues/1021","repository_url":"https://api.github.com/repos/18F/calc","labels_url":"https://api.github.com/repos/18F/calc/issues/1021/labels{/name}","comments_url":"https://api.github.com/repos/18F/calc/issues/1021/comments","events_url":"https://api.github.com/repos/18F/calc/issues/1021/events","html_url":"https://github.com/18F/calc/issues/1021","id":188048145,"number":1021,"title":"Bulk upload data / price lists can contain duplicate rows with different SIN numbers","user":{"login":"toolness","id":124687,"avatar_url":"https://avatars.githubusercontent.com/u/124687?v=3","gravatar_id":"","url":"https://api.github.com/users/toolness","html_url":"https://github.com/toolness","followers_url":"https://api.github.com/users/toolness/followers","following_url":"https://api.github.com/users/toolness/following{/other_user}","gists_url":"https://api.github.com/users/toolness/gists{/gist_id}","starred_url":"https://api.github.com/users/toolness/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/toolness/subscriptions","organizations_url":"https://api.github.com/users/toolness/orgs","repos_url":"https://api.github.com/users/toolness/repos","events_url":"https://api.github.com/users/toolness/events{/privacy}","received_events_url":"https://api.github.com/users/toolness/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-11-08T17:04:06Z","updated_at":"2016-11-08T17:04:06Z","closed_at":null,"body":"@jseppi just noticed [on Slack](https://gsa-tts.slack.com/archives/calc/p1478616897000083) that the CSV data for region 10 contains rows that are duplicates except for the SIN numbers in them.\r\n\r\n[Here's an example on the current production CALC instance.](https://calc.gsa.gov/?sort=current_price&q=Budget%2FPolicy+Analyst&query_type=match_exact&education=BA&min_experience=5&max_experience=5&contract-year=current&experience_range=5%2C5)\r\n\r\nWe might want to add some logic to bulk / price list upload that notices such duplicate rows and merges their SIN numbers (since the SIN column is messy and some entries already contain e.g. SIN numbers separated by commas, we can just \"merge\" them through string concatenation)."}}
{"actor":{"display_login":"toolness"}}