Mac user cannot upload TAGS URL to Orange

[dariasin]

What's wrong?

The red exclamation point shows on top of the "File" widget because the info through the Google sheet won't load. When I load the google sheet link, nothing generates in Orange. The link is not broken. However, there might be a problem with the URL path as well. Maybe it shouldn't say edit? Or maybe it has to do something with Orange running on mac, and something needs to be changed in the privacy settings on Mac?

How can we reproduce the problem?

Here's the URL link I am uploading.

https://docs.google.com/spreadsheets/d/1HLkURuJyrMt38cG88bFI6HZBbqVtojyBBiOjI9F4bSc/edit?usp=sharing

The .ows zip file is attached.

Plat.ows.zip

Looking forward to hearing back from you soon!

[wvdvegte]

IIRC it should work correctly if you remove everything from the last "/": try https://docs.google.com/spreadsheets/d/1HLkURuJyrMt38cG88bFI6HZBbqVtojyBBiOjI9F4bSc

[ales-erjavec]

I cannot duplicate this on latest released version of Orange. Which version are you using?

This looks like a duplicate of https://github.com/biolab/orange3/issues/5723 which should be fixed since version 3.32.0.

[wvdvegte]

I could actually duplicate what I reported in Orange 3.33.0: https://docs.google.com/spreadsheets/d/1HLkURuJyrMt38cG88bFI6HZBbqVtojyBBiOjI9F4bSc/edit?usp=sharing produces an error https://docs.google.com/spreadsheets/d/1HLkURuJyrMt38cG88bFI6HZBbqVtojyBBiOjI9F4bSc/ loads the data https://docs.google.com/spreadsheets/d/1HLkURuJyrMt38cG88bFI6HZBbqVtojyBBiOjI9F4bSc loads that data, too

[ales-erjavec]

I some times get intermittent read time out errors but that is it.

Can you please post the error message (click on the Read error: in the bottom right of the File widget and copy the full text).

[wvdvegte]

Can you please post the error message

Read error: The read operation timed out

[ales-erjavec]

This happens every time? I get them sometimes but on both https://docs.google.com/spreadsheets/d/1HLkURuJyrMt38cG88bFI6HZBbqVtojyBBiOjI9F4bSc/edit?usp=sharing as well as https://docs.google.com/spreadsheets/d/1HLkURuJyrMt38cG88bFI6HZBbqVtojyBBiOjI9F4bSc. A Reload solves them.

[wvdvegte]

You're right - I tried again and it doesn't happen all the time. Perhaps it's just a responsiveness issue in Google Docs.

[wvdvegte]

I'm getting a different read error now: when inserting the URL https://drive.google.com/file/d/1Nyi0VnyOGDg5WeRzDJt3K6F8Xu_9ZwWq/view?usp=share_link ("anyone with the link can view"), I'm getting "Read error: No readers for file "/var/folders/59/db8x75gs6nq0y62dk2pvn1vmn5nd3m/T/tmphlp3d6i8"" I have no idea what this path is referring to, iot doesn't bear any resemblance with the link to Google Drive. Edit/update: every time I hit Reload, the part after the last / is different.

[ales-erjavec]

I'm getting a different read error now: when inserting the URL https://drive.google.com/file/d/1Nyi0VnyOGDg5WeRzDJt3K6F8Xu_9ZwWq/view?usp=share_link ("anyone with the link can view"), I'm getting "Read error: No readers for file "/var/folders/59/db8x75gs6nq0y62dk2pvn1vmn5nd3m/T/tmphlp3d6i8"" I have no idea what this path is referring to, iot doesn't bear any resemblance with the link to Google Drive. Edit/update: every time I hit Reload, the part after the last / is different.

That is a google drive link that is not currently supported (only google sheets and dropbox share links are supported). Use https://sites.google.com/site/gdocs2direct/ to convert the link to a direct download link and use that .

[wvdvegte]

That is a google drive link that is not currently supported (only google sheets and dropbox share links are supported). Use https://sites.google.com/site/gdocs2direct/ to convert the link to a direct download link and use that .

Thanks, that helped! Perhaps a good idea to add this information to the help page on the File widget.