Extension talk:GoogleDocs4MW

Previous page history was archived for backup purposes at Extension talk:GoogleDocs4MW/LQT Archive 1 on 2015-07-10.

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?

I am having this same issue also in 2019

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

Did you ever get this to work?

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?

Is there a way I could link to an individual Google Sheet in a wiki article? Now I'm aware I could just publish a single sheet of a multi-page spreadsheet, and only that sheet will show in a wiki article ... but what if I want to publish the entire doc, and only link to individual sheets? I see no "sheet" parameter or the like for this <googlespreadsheet> tag.

- Matt