{"action":"created","issue":{"url":"https://api.github.com/repos/mpinsky/OceanAdapt/issues/42","labels_url":"https://api.github.com/repos/mpinsky/OceanAdapt/issues/42/labels{/name}","comments_url":"https://api.github.com/repos/mpinsky/OceanAdapt/issues/42/comments","events_url":"https://api.github.com/repos/mpinsky/OceanAdapt/issues/42/events","html_url":"https://github.com/mpinsky/OceanAdapt/issues/42","id":105417352,"number":42,"title":"GMEX station not reading into R","user":{"login":"mpinsky","id":6370532,"avatar_url":"https://avatars.githubusercontent.com/u/6370532?v=3","gravatar_id":"","url":"https://api.github.com/users/mpinsky","html_url":"https://github.com/mpinsky","followers_url":"https://api.github.com/users/mpinsky/followers","following_url":"https://api.github.com/users/mpinsky/following{/other_user}","gists_url":"https://api.github.com/users/mpinsky/gists{/gist_id}","starred_url":"https://api.github.com/users/mpinsky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mpinsky/subscriptions","organizations_url":"https://api.github.com/users/mpinsky/orgs","repos_url":"https://api.github.com/users/mpinsky/repos","events_url":"https://api.github.com/users/mpinsky/events{/privacy}","received_events_url":"https://api.github.com/users/mpinsky/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"mpinsky","id":6370532,"avatar_url":"https://avatars.githubusercontent.com/u/6370532?v=3","gravatar_id":"","url":"https://api.github.com/users/mpinsky","html_url":"https://github.com/mpinsky","followers_url":"https://api.github.com/users/mpinsky/followers","following_url":"https://api.github.com/users/mpinsky/following{/other_user}","gists_url":"https://api.github.com/users/mpinsky/gists{/gist_id}","starred_url":"https://api.github.com/users/mpinsky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mpinsky/subscriptions","organizations_url":"https://api.github.com/users/mpinsky/orgs","repos_url":"https://api.github.com/users/mpinsky/repos","events_url":"https://api.github.com/users/mpinsky/events{/privacy}","received_events_url":"https://api.github.com/users/mpinsky/received_events","type":"User","site_admin":false},"milestone":null,"comments":6,"created_at":"2015-09-08T16:21:48Z","updated_at":"2015-09-08T19:32:00Z","closed_at":null,"body":"Heads up to @rBatt @danfarns \r\n\r\nThere are quotation issues in the current Data_Updated/gmex/station.csv file, I think because it was read in by update.data.R and then written out without quotes. The same problem appears in data_download/Data_Vis_2015_09_04.zip (for gmex_station.csv). R spits an EOF error when it tries to read it in.\r\n\r\nI believe I've fixed the problem by copying STAREC.csv rather than manipulating it in R. The file in Data_Updated/gmex_newstation.zip should be fine, and I will upload it to the website... once the website is ready to accept new files."},"comment":{"url":"https://api.github.com/repos/mpinsky/OceanAdapt/issues/comments/138677496","html_url":"https://github.com/mpinsky/OceanAdapt/issues/42#issuecomment-138677496","issue_url":"https://api.github.com/repos/mpinsky/OceanAdapt/issues/42","id":138677496,"user":{"login":"mpinsky","id":6370532,"avatar_url":"https://avatars.githubusercontent.com/u/6370532?v=3","gravatar_id":"","url":"https://api.github.com/users/mpinsky","html_url":"https://github.com/mpinsky","followers_url":"https://api.github.com/users/mpinsky/followers","following_url":"https://api.github.com/users/mpinsky/following{/other_user}","gists_url":"https://api.github.com/users/mpinsky/gists{/gist_id}","starred_url":"https://api.github.com/users/mpinsky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mpinsky/subscriptions","organizations_url":"https://api.github.com/users/mpinsky/orgs","repos_url":"https://api.github.com/users/mpinsky/repos","events_url":"https://api.github.com/users/mpinsky/events{/privacy}","received_events_url":"https://api.github.com/users/mpinsky/received_events","type":"User","site_admin":false},"created_at":"2015-09-08T19:32:00Z","updated_at":"2015-09-08T19:32:00Z","body":"Hi Dan,\n\nPerhaps, though, part of the problem is that R can't read in a file with\nescaped double quotes (\\\"). I'd prefer to strip these out before they go in\nthe database.\n\nThanks for doing the update. I take it that the upload function isn't ready\nyet on the website?\n\nOn Tue, Sep 8, 2015 at 3:11 PM, danfarns <notifications@github.com> wrote:\n\n> @mpinsky <https://github.com/mpinsky>\n> The data in the database should still be fine, but outputting appears to\n> be the primary problem.\n> I will take the following to confirm and fix where appropriate:\n> 1. Double check the station file in\n> /master/data_updates/Data_Updated/gmex_newstsation.zip versus the rows in\n> the database and confirm that the data has been uploaded correctly. If not,\n> refresh table with the rows stored in this zip file.\n> 2. Force raw download to place quotes around fields as listed in the\n> station CSV file. This should solve the issue here.\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/mpinsky/OceanAdapt/issues/42#issuecomment-138673252>.\n>\n"}}