I have a new installation of MW, set to private. Trying to use this extension to embed a sheet. I've tried various iterations of the url between the "link" and "embed" options from google sheets, but no matter what I try, I get:
Sorry, unable to open the file at this time.
Please check the address and try again.
Get stuff done with Google Drive
I have the sheet set to "Anyone with a link" access, and it's published to the web. Any idea what I'm doing wrong?
I met with the same issue. and finally get it working by putting the google doc "ID" instead of the published link into the <googlespreadsheet> tag. The google doc ID is the string in your url: like docs.google.com/spreadsheets/d/<ID>/edit#....
Hi,
I would like to pull only specific cells from the Google Sheet. Is it possible to use some formula to pull the data and display in wikimedia?
Thanks.
Evrim
Hey guys, I was wondering if anyone can suggest me some solution. Thanks
I suggest to do the sorting in a new sheet, and then, link this new sheet to your wiki.
File > Publish to Web...
And then, on my wiki (private), it is "Spreedsheat.google.com n'autorise pas la connexion" (in English: connection is not authorized).
How to fix it?
Open GoogleDocs4MW.class.php with a text editor and find line 32 and 33 which shjould be
'" src="http://spreadsheets.google.com/pub?key=' . $key .
'&output=html&widget=true"></iframe>';
and replace it with
'" src="https://docs.google.com/spreadsheets/d/e/' . $key .
'/pubhtml?widget=true"></iframe>';
and save the file and the extention should now work
This doesn't seem to work for me: I've followed the install instructions and have double checked I'm using the right key, but all I get on my page is a blank box. Any suggestions?
This is because only the iframe is being drawn, the content is not being brought in.
You must first make sure that you share to web the spreadsheet and the follow the instruction in this comment:https://www.mediawiki.org/w/index.php?title=Topic:Uqvolfisau2pq127&topic_showPostId=uqvolfisay0ry50f#flow-post-uqvolfisay0ry50f
You'll need to edit the GoogleDocs4MW.class.php file. In the $output section (bottom) you'll need to replace the last two lines above the return $output;.
//'" src="http://spreadsheets.google.com/pub?key=' . $key .
'" src="https://docs.google.com/spreadsheets/d/' . $key .
//'&output=html&widget=true"></iframe>';
'/htmlembed?widget=true"></iframe>';
The old format no longer works: http://spreadsheets.google.com/pub?key= $your_doc_key &output=html&widget=true
The purpose of the change is to use the new format required by Google: https://docs.google.com/spreadsheets/d/ $your_doc_key /htmlembed?widget=true
Still getting the "Sorry, the file you have requested does not exist. Make sure that you have the correct URL and that the file existed." message.
| Product | Version |
|---|---|
| MediaWiki | 1.28.0 |
| PHP | 7.0.15-1ubuntu4 (fpm-fcgi) |
| MySQL | 5.7.17-0ubuntu1 |
| ICU | 57.1 |
| GoogleDocs4MW | 1.2 (f3631f9)01:02, 25 October 2016 | GPL-2.0+ | Adds <googlespreadsheet> tag for Google Docs\' spreadsheets display |
Jack Phoenix |
I noticed that GoogleDocs4MW creates an iframe with an URL like this:
http://spreadsheets.google.com/pub?key=XXX&output=html&widget=true
Is this kind of URL still valid in Google world? I can't make it working. The correct URL form for public Google spreadsheet seems to be this:
https://docs.google.com/spreadsheets/d/XXX
Also this form seems to be correct:
http://spreadsheets.google.com/ccc?key=XXX&output=html&widget=true
I modified the GoogleDocs4MW.class.php source code and it works now.
Will the wiki's internal site search display results from the embedded Google sheet?