Extension talk:GoogleDocs4MW

About this board

The widget is there, but doesn't load the sheet. Instead I get

2
71.244.211.32 (talkcontribs)

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?

128.250.116.165 (talkcontribs)

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#....

Reply to "The widget is there, but doesn't load the sheet. Instead I get"

Where's an example?

1
This post was hidden by 87.91.51.235 (history)
Reply to "Where's an example?"

Can I use some formula? (importrange?)

3
89.66.184.47 (talkcontribs)

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

89.66.184.47 (talkcontribs)

Hey guys, I was wondering if anyone can suggest me some solution. Thanks

87.91.51.235 (talkcontribs)

I suggest to do the sorting in a new sheet, and then, link this new sheet to your wiki.

Reply to "Can I use some formula? (importrange?)"

Connection not allowed

1
87.91.51.235 (talkcontribs)

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?

Reply to "Connection not allowed"

To fix extention to google's current URL format

1
87.48.23.112 (talkcontribs)

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

Reply to "To fix extention to google's current URL format"
121.127.212.56 (talkcontribs)

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?

69.11.16.154 (talkcontribs)

I am having this same issue also in 2019

2601:646:8100:11E3:3452:41FE:23BA:4288 (talkcontribs)
Reply to "Not working"

Fix for Google updates

1
2601:646:8100:5E79:5149:17E0:4DB3:C649 (talkcontribs)

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

Reply to "Fix for Google updates"
2A02:390:674C:600:138:3E6F:2964:97DD (talkcontribs)

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
70.130.76.113 (talkcontribs)

Did you ever get this to work?

Reply to "Still not working"

Are URLs in form "http://spreadsheets.google.com/pub?key=XXX" still valid?

2
C veronesi horta (talkcontribs)

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

C veronesi horta (talkcontribs)
Reply to "Are URLs in form "http://spreadsheets.google.com/pub?key=XXX" still valid?"

Will the wiki search index the Google sheet text?

1
Bibliovorous (talkcontribs)

Will the wiki's internal site search display results from the embedded Google sheet?

Reply to "Will the wiki search index the Google sheet text?"
Return to "GoogleDocs4MW" page.