{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/2010","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2010/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2010/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2010/events","html_url":"https://github.com/CartoDB/cartodb/issues/2010","id":56168227,"number":2010,"title":"importing csv file results in corrupted numeric data","user":{"login":"clhenrick","id":161748,"avatar_url":"https://avatars.githubusercontent.com/u/161748?v=3","gravatar_id":"","url":"https://api.github.com/users/clhenrick","html_url":"https://github.com/clhenrick","followers_url":"https://api.github.com/users/clhenrick/followers","following_url":"https://api.github.com/users/clhenrick/following{/other_user}","gists_url":"https://api.github.com/users/clhenrick/gists{/gist_id}","starred_url":"https://api.github.com/users/clhenrick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/clhenrick/subscriptions","organizations_url":"https://api.github.com/users/clhenrick/orgs","repos_url":"https://api.github.com/users/clhenrick/repos","events_url":"https://api.github.com/users/clhenrick/events{/privacy}","received_events_url":"https://api.github.com/users/clhenrick/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"juanignaciosl","id":932968,"avatar_url":"https://avatars.githubusercontent.com/u/932968?v=3","gravatar_id":"","url":"https://api.github.com/users/juanignaciosl","html_url":"https://github.com/juanignaciosl","followers_url":"https://api.github.com/users/juanignaciosl/followers","following_url":"https://api.github.com/users/juanignaciosl/following{/other_user}","gists_url":"https://api.github.com/users/juanignaciosl/gists{/gist_id}","starred_url":"https://api.github.com/users/juanignaciosl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanignaciosl/subscriptions","organizations_url":"https://api.github.com/users/juanignaciosl/orgs","repos_url":"https://api.github.com/users/juanignaciosl/repos","events_url":"https://api.github.com/users/juanignaciosl/events{/privacy}","received_events_url":"https://api.github.com/users/juanignaciosl/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/CartoDB/cartodb/milestones/33","labels_url":"https://api.github.com/repos/CartoDB/cartodb/milestones/33/labels","id":957061,"number":33,"title":"Guarrate","description":"- [x] Chalecos (@zenitram)\r\n- [ ] Perf. Editor (@rtorre)\r\n- [ ] Kepler integration (@rtorre)\r\n- [ ] Medusa v2 (@zenitram)\r\n- [ ] New Dashboard bugfixing (@jmedina)\r\n- [ ] Perf. Editor (@rtorre)\r\n- [ ] Odyssey fixes (@javierarce)\r\n- [ ] URL rewrite (@kartones)\r\n- [ ] fixes mobile (@xapy)\r\n- [ ] On premise AMI (@azamorano)\r\n\r\n\r\n\r\n","creator":{"login":"saleiva","id":132149,"avatar_url":"https://avatars.githubusercontent.com/u/132149?v=3","gravatar_id":"","url":"https://api.github.com/users/saleiva","html_url":"https://github.com/saleiva","followers_url":"https://api.github.com/users/saleiva/followers","following_url":"https://api.github.com/users/saleiva/following{/other_user}","gists_url":"https://api.github.com/users/saleiva/gists{/gist_id}","starred_url":"https://api.github.com/users/saleiva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/saleiva/subscriptions","organizations_url":"https://api.github.com/users/saleiva/orgs","repos_url":"https://api.github.com/users/saleiva/repos","events_url":"https://api.github.com/users/saleiva/events{/privacy}","received_events_url":"https://api.github.com/users/saleiva/received_events","type":"User","site_admin":false},"open_issues":117,"closed_issues":10,"state":"open","created_at":"2015-01-29T17:08:30Z","updated_at":"2015-02-19T17:57:56Z","due_on":"2015-03-04T23:00:00Z","closed_at":null},"comments":1,"created_at":"2015-02-01T16:16:02Z","updated_at":"2015-02-19T17:57:56Z","closed_at":"2015-02-19T17:57:56Z","body":"When importing a CSV file CartoDB changes the data values in the numeric bbl column to negative values that don't resemble the original:\r\n\r\n![screen shot 2015-02-01 at 11 09 49 am](https://cloud.githubusercontent.com/assets/161748/5992717/09f75bf6-aa03-11e4-9290-cdddcd3100eb.png)\r\n\r\nOriginal Data:\r\n\r\n![screen shot 2015-02-01 at 11 11 45 am](https://cloud.githubusercontent.com/assets/161748/5992718/25206706-aa03-11e4-9a5b-4c0a82789016.png)\r\n\r\nThis does not happen when I import the data to Postgres locally.\r\n\r\n![screen shot 2015-02-01 at 11 13 37 am](https://cloud.githubusercontent.com/assets/161748/5992724/66a3bf48-aa03-11e4-985d-25b654a7f2c8.png)\r\n\r\n![screen shot 2015-02-01 at 11 14 06 am](https://cloud.githubusercontent.com/assets/161748/5992728/790a2e9c-aa03-11e4-8f57-247e467b335b.png)\r\n\r\n[Here's a dropbox link to my CSV file.](https://www.dropbox.com/s/7fo7occ9z534cwb/bushwick_survey_qgis.csv?dl=0)\r\n"},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/comments/75102174","html_url":"https://github.com/CartoDB/cartodb/issues/2010#issuecomment-75102174","issue_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2010","id":75102174,"user":{"login":"juanignaciosl","id":932968,"avatar_url":"https://avatars.githubusercontent.com/u/932968?v=3","gravatar_id":"","url":"https://api.github.com/users/juanignaciosl","html_url":"https://github.com/juanignaciosl","followers_url":"https://api.github.com/users/juanignaciosl/followers","following_url":"https://api.github.com/users/juanignaciosl/following{/other_user}","gists_url":"https://api.github.com/users/juanignaciosl/gists{/gist_id}","starred_url":"https://api.github.com/users/juanignaciosl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanignaciosl/subscriptions","organizations_url":"https://api.github.com/users/juanignaciosl/orgs","repos_url":"https://api.github.com/users/juanignaciosl/repos","events_url":"https://api.github.com/users/juanignaciosl/events{/privacy}","received_events_url":"https://api.github.com/users/juanignaciosl/received_events","type":"User","site_admin":false},"created_at":"2015-02-19T17:57:56Z","updated_at":"2015-02-19T17:57:56Z","body":"This is duplicated: #2035 \r\n\r\nWorkaround until is fixed: quote the data that gets corrupted (*\"*12345688900*\"*) or import it with the api disabling type guessing."}}