Extension talk:GoogleDocs4MW

Jump to navigation Jump to search

About this board

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?)"
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"
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?"

Linking to individual sheets

1
69.138.174.227 (talkcontribs)

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

Reply to "Linking to individual sheets"