{"action":"created","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/2476","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2476/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2476/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2476/events","html_url":"https://github.com/CartoDB/cartodb/issues/2476","id":58749927,"number":2476,"title":"Reformat URL for importing public Dropbox, GDrive and Carto files","user":{"login":"cshirky","id":226500,"avatar_url":"https://avatars.githubusercontent.com/u/226500?v=3","gravatar_id":"","url":"https://api.github.com/users/cshirky","html_url":"https://github.com/cshirky","followers_url":"https://api.github.com/users/cshirky/followers","following_url":"https://api.github.com/users/cshirky/following{/other_user}","gists_url":"https://api.github.com/users/cshirky/gists{/gist_id}","starred_url":"https://api.github.com/users/cshirky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cshirky/subscriptions","organizations_url":"https://api.github.com/users/cshirky/orgs","repos_url":"https://api.github.com/users/cshirky/repos","events_url":"https://api.github.com/users/cshirky/events{/privacy}","received_events_url":"https://api.github.com/users/cshirky/received_events","type":"User","site_admin":false},"labels":[],"state":"open","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/34","html_url":"https://github.com/CartoDB/cartodb/milestones/ElSoto","labels_url":"https://api.github.com/repos/CartoDB/cartodb/milestones/34/labels","id":978370,"number":34,"title":"ElSoto","description":"- [ ] Named places on Import (@rtorre)\r\n- [ ] Medusa v2 (@zenitram)","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":25,"closed_issues":4,"state":"open","created_at":"2015-02-13T13:00:32Z","updated_at":"2015-02-25T09:59:52Z","due_on":"2015-03-18T23:00:00Z","closed_at":null},"comments":4,"created_at":"2015-02-24T14:59:15Z","updated_at":"2015-02-26T11:00:27Z","closed_at":null,"body":"Carto breaks on Dropbox and Google Drive URLs that could be trivially reformatted (part of a larger set of issues with difficulties in sharing data user-to-user.) It also fails to import public Carto tables.\r\n\r\n**Steps to Reproduce for Dropbox**\r\n\r\n1. Create a new table.\r\n2. Select Dropbox as an upload method. \r\n3. There is no option to paste a Dropbox link. (This is confusing for the user.)\r\n4. Select Data File.\r\n5. Paste in the following public;y shared Dropbox URL: https://www.dropbox.com/s/d12sa2t9hrrpahv/street_food_morning.kml?dl=0\r\nIt will fail.\r\n6. Modify the URL so that 'dl=0' is changed to 'dl=1' and re-submit. It will load the file.\r\n\r\nCarto should assume that users will try to upload public Dropbox files using the Dropbox option, not the Data File option, and that if they paste a Dropbox link, assume that dl=1 is the desired behavior.\r\n\r\n**Steps to Reproduce for Google Drive**\r\n\r\nAs above. The Google Drive option does not offer any way to paste a public Google Drive link, and using the Data file upload, a public Google Drive URL of the form\r\nhttps://drive.google.com/open?id=0B92EO2NYQ7JgdFNSRlRmT2RaUGM&authuser=0\r\nwill fail but a simple transformation of that URL to the form\r\nhttps://drive.google.com/uc?export=download&id=0B92EO2NYQ7JgdFNSRlRmT2RaUGM \r\nwill succeed.\r\n\r\n**Steps to reproduce for Carto**\r\n\r\nAs above. Select Data file upload for a new table, and enter the URL of a public Carto table (e.g. https://cshirky.cartodb.com/tables/street_food_evening) Upload fails. \r\n\r\n\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/comments/76159405","html_url":"https://github.com/CartoDB/cartodb/issues/2476#issuecomment-76159405","issue_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2476","id":76159405,"user":{"login":"cshirky","id":226500,"avatar_url":"https://avatars.githubusercontent.com/u/226500?v=3","gravatar_id":"","url":"https://api.github.com/users/cshirky","html_url":"https://github.com/cshirky","followers_url":"https://api.github.com/users/cshirky/followers","following_url":"https://api.github.com/users/cshirky/following{/other_user}","gists_url":"https://api.github.com/users/cshirky/gists{/gist_id}","starred_url":"https://api.github.com/users/cshirky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cshirky/subscriptions","organizations_url":"https://api.github.com/users/cshirky/orgs","repos_url":"https://api.github.com/users/cshirky/repos","events_url":"https://api.github.com/users/cshirky/events{/privacy}","received_events_url":"https://api.github.com/users/cshirky/received_events","type":"User","site_admin":false},"created_at":"2015-02-26T11:00:27Z","updated_at":"2015-02-26T11:00:27Z","body":"I'm not trying to solve <i>my</i> problem -- I wouldn't be posting to Issues for that. I'm trying to solve a problem for every novice user (of whom I currently have 300 at my institution.) The idea that a first-time user needs to understand SQL calls <i>to upload a public table</I> seems like overkill.\r\n\r\nThe general issue is one of UI confusion. The upload box won't take Google Drive URLs in the Google Drive tab, it won't take Dropbox URLs in the Dropbox tab, and it can't even figure out how to get data from Carto given a Carto URL.\r\n\r\nIf this revision is supposed to be to help novice users, then both some communication about how to share tables and some bending towards making sense of sharing URLs would seem to align with that goal."}}