{"action":"created","issue":{"url":"https://api.github.com/repos/aaronjplatt/tester/issues/17","repository_url":"https://api.github.com/repos/aaronjplatt/tester","labels_url":"https://api.github.com/repos/aaronjplatt/tester/issues/17/labels{/name}","comments_url":"https://api.github.com/repos/aaronjplatt/tester/issues/17/comments","events_url":"https://api.github.com/repos/aaronjplatt/tester/issues/17/events","html_url":"https://github.com/aaronjplatt/tester/issues/17","id":134738622,"number":17,"title":"Missing data for Hugh Bigwood","user":{"login":"aaronjplatt","id":6790983,"avatar_url":"https://avatars.githubusercontent.com/u/6790983?v=3","gravatar_id":"","url":"https://api.github.com/users/aaronjplatt","html_url":"https://github.com/aaronjplatt","followers_url":"https://api.github.com/users/aaronjplatt/followers","following_url":"https://api.github.com/users/aaronjplatt/following{/other_user}","gists_url":"https://api.github.com/users/aaronjplatt/gists{/gist_id}","starred_url":"https://api.github.com/users/aaronjplatt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aaronjplatt/subscriptions","organizations_url":"https://api.github.com/users/aaronjplatt/orgs","repos_url":"https://api.github.com/users/aaronjplatt/repos","events_url":"https://api.github.com/users/aaronjplatt/events{/privacy}","received_events_url":"https://api.github.com/users/aaronjplatt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"aaronjplatt","id":6790983,"avatar_url":"https://avatars.githubusercontent.com/u/6790983?v=3","gravatar_id":"","url":"https://api.github.com/users/aaronjplatt","html_url":"https://github.com/aaronjplatt","followers_url":"https://api.github.com/users/aaronjplatt/followers","following_url":"https://api.github.com/users/aaronjplatt/following{/other_user}","gists_url":"https://api.github.com/users/aaronjplatt/gists{/gist_id}","starred_url":"https://api.github.com/users/aaronjplatt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aaronjplatt/subscriptions","organizations_url":"https://api.github.com/users/aaronjplatt/orgs","repos_url":"https://api.github.com/users/aaronjplatt/repos","events_url":"https://api.github.com/users/aaronjplatt/events{/privacy}","received_events_url":"https://api.github.com/users/aaronjplatt/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2016-02-19T00:30:56Z","updated_at":"2016-02-19T00:30:59Z","closed_at":null,"body":"RIO-25: About 22k in the system, expect 800k"},"comment":{"url":"https://api.github.com/repos/aaronjplatt/tester/issues/comments/185993065","html_url":"https://github.com/aaronjplatt/tester/issues/17#issuecomment-185993065","issue_url":"https://api.github.com/repos/aaronjplatt/tester/issues/17","id":185993065,"user":{"login":"aaronjplatt","id":6790983,"avatar_url":"https://avatars.githubusercontent.com/u/6790983?v=3","gravatar_id":"","url":"https://api.github.com/users/aaronjplatt","html_url":"https://github.com/aaronjplatt","followers_url":"https://api.github.com/users/aaronjplatt/followers","following_url":"https://api.github.com/users/aaronjplatt/following{/other_user}","gists_url":"https://api.github.com/users/aaronjplatt/gists{/gist_id}","starred_url":"https://api.github.com/users/aaronjplatt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aaronjplatt/subscriptions","organizations_url":"https://api.github.com/users/aaronjplatt/orgs","repos_url":"https://api.github.com/users/aaronjplatt/repos","events_url":"https://api.github.com/users/aaronjplatt/events{/privacy}","received_events_url":"https://api.github.com/users/aaronjplatt/received_events","type":"User","site_admin":false},"created_at":"2016-02-19T00:30:59Z","updated_at":"2016-02-19T00:30:59Z","body":"aaronjplatt:  Roger,\n\nI have traced the data for Hugh from source files and into the database. I have uploaded the results to the SFTP site (it contains his transactions). \n\nThe file is split into DATABASE and SOURCE. Under each heading are the relevant rows/tables from the files/database.\n\nThere are only 46 transactions for employee 9207542 in the 6 Spendvision files. I can only find 5 flights for Hugh in the BTA AMEX files as well. There are no transactions for him the RTIO data (checked just in case). \n\nAll this data has made it into the database, approx. 22k USD in total.\n\nIf Leigh Ann says there are more rows in Spendvision then do we have a problem with the extracts????\n\nA\n"}}