{"action":"created","issue":{"url":"https://api.github.com/repos/rgrp/csv2sqlite/issues/18","repository_url":"https://api.github.com/repos/rgrp/csv2sqlite","labels_url":"https://api.github.com/repos/rgrp/csv2sqlite/issues/18/labels{/name}","comments_url":"https://api.github.com/repos/rgrp/csv2sqlite/issues/18/comments","events_url":"https://api.github.com/repos/rgrp/csv2sqlite/issues/18/events","html_url":"https://github.com/rgrp/csv2sqlite/issues/18","id":169219852,"number":18,"title":"Floats being converted to integer (Unable to convert value)","user":{"login":"ryanjones","id":350391,"avatar_url":"https://avatars.githubusercontent.com/u/350391?v=3","gravatar_id":"","url":"https://api.github.com/users/ryanjones","html_url":"https://github.com/ryanjones","followers_url":"https://api.github.com/users/ryanjones/followers","following_url":"https://api.github.com/users/ryanjones/following{/other_user}","gists_url":"https://api.github.com/users/ryanjones/gists{/gist_id}","starred_url":"https://api.github.com/users/ryanjones/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryanjones/subscriptions","organizations_url":"https://api.github.com/users/ryanjones/orgs","repos_url":"https://api.github.com/users/ryanjones/repos","events_url":"https://api.github.com/users/ryanjones/events{/privacy}","received_events_url":"https://api.github.com/users/ryanjones/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-08-03T19:58:17Z","updated_at":"2016-08-09T09:28:24Z","closed_at":null,"body":"I tried running this to create an SQLite DB from a CSV, but I'm getting this error for all of my floats (negative and positive). \r\n\r\nUnable to convert value '39.99' to type 'integer' on line 5304\r\n\r\nHere's an example of the row:\r\n```\r\n2016-01-07 0:00,\t16:15,\t56: Edmonton Manning,\ttest,\ttest213,\ttest111,\t0,\t39.99,\t<Unknown>,\t<Unknowon>,\t\t<Unknown>,\t<Unknown>,\t\r\n```\r\n\r\nI'll try and dig into the issue, but my python isn't very strong, any help would be much appreciated."},"comment":{"url":"https://api.github.com/repos/rgrp/csv2sqlite/issues/comments/238501273","html_url":"https://github.com/rgrp/csv2sqlite/issues/18#issuecomment-238501273","issue_url":"https://api.github.com/repos/rgrp/csv2sqlite/issues/18","id":238501273,"user":{"login":"rgrp","id":180658,"avatar_url":"https://avatars.githubusercontent.com/u/180658?v=3","gravatar_id":"","url":"https://api.github.com/users/rgrp","html_url":"https://github.com/rgrp","followers_url":"https://api.github.com/users/rgrp/followers","following_url":"https://api.github.com/users/rgrp/following{/other_user}","gists_url":"https://api.github.com/users/rgrp/gists{/gist_id}","starred_url":"https://api.github.com/users/rgrp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rgrp/subscriptions","organizations_url":"https://api.github.com/users/rgrp/orgs","repos_url":"https://api.github.com/users/rgrp/repos","events_url":"https://api.github.com/users/rgrp/events{/privacy}","received_events_url":"https://api.github.com/users/rgrp/received_events","type":"User","site_admin":false},"created_at":"2016-08-09T09:28:24Z","updated_at":"2016-08-09T09:28:24Z","body":"@ryanjones thanks for the report and glad you find this library useful. What's happening here is that the library has misguessed one of your columns as integers when in fact it is a float/decimal. My guess is that the first 1000 or so lines or your data (which we use for type guessing) only has stuff in that column that looks like integers.\r\n\r\nOne way to fix this is to explicitly set the types as per #16 - or you could even use a more powerful library and setup using JSON Table Schema - see http://frictionlessdata.io/guides/json-table-schema/"}}
{"actor":{"display_login":"rgrp"}}