Hi,
thanks for your question.
Importing from Google Docs is not supported directly, and likely won’t be in the future. This would require an implementation of an API to access Google Docs, which I can’t do at this time.
The only way that remains is to save the table as a CSV file and import that.
Best wishes,
Tobias
Thread Starter
effgee
(@andreastyrosvoutis)
Hey Tobias,
Google allows publishing the spreadsheet as a csv via a http / https link.
Yes, having the API implemented to reflect dynamic data on the sheet is lots of work.
What about just having wp-tables-reloaded properly retrieve the published csv? For example if I publish a sheet as csv, I get a link to the google file that when I click on it, it downloads to my computer.
But when I enter the same URL to the import screen, it get if I remember correctly a 403 error. Somehow wp-table-reloaded isn’t properly downloading the file. This functionality would not require any API functionality. 🙂
Hi,
that should actually be possible already. If you get a 403 error, then this means that there is a permission error. WP-Table Reloaded uses WordPress’s internal HTTP API to get/download files from URLs. That API is pretty stable and solid, so its not likely that the reason for the problem that the CSV is not downloaded is not within WordPress’s or WP-Table Reloaded’s reach.
Can you maybe test this with a plain CSV file stored somewhere?
Regards,
Tobias
Thread Starter
effgee
(@andreastyrosvoutis)
Sorry Tobias, I’m getting a Bad Request Error 400.
Here is the link from Google Docs
https://docs.google.com/spreadsheet/pub?key=0AlYSGPlCX5cVdFJ1aTZObmtSV3cxcUFGZTRvSmJXQmc&single=true&gid=0&range=A1%3AF38&output=csv
Also, if you remove the s from https:// it also works.
This is a publicly published document, and doesn’t require login.
When I try and import it to tables reloaded I get 400 error.
What do you think?
Hi,
again, the reason for this problem is not within WP-Table Reloaded. It is your server that is seemingly not able to send outgoing HTTP(S) requests.
There’s either a module missing in PHP or the webserver, or the requests are blocked due to security reasons, e.g. by the firewall.
Regards,
Tobias
Thread Starter
effgee
(@andreastyrosvoutis)
Ok, cool Tobias. I’ll look into it.
Thanks for the help.
I’ll try and donate when I get a chance.
Once I figure out what is actually wrong, I’ll try and post back and mark this as resolved.
Hi,
yes, that’s probably the best next step for now.
As mentioned in my previous post, please try with a static CSV file on another server, because one reason might also be that Google Docs is blocking the request, for example, because it is not coming from a real browser.
If you find anything, please let us know.
Also thanks for wanting to donate, I really appreciate it.
Best wishes,
Tobias
