Difference between revisions of "Google Documents Embedded in MediaWiki Pages"

From PKC
Jump to navigation Jump to search
BenKoo>Benkoo
 
(41 intermediate revisions by 5 users not shown)
Line 1: Line 1:
This page demonstrates that one can include Google Document, Google SpreadSheet, Google Presentation, and Google Form in this website. One must remember to '''[https://support.google.com/a/users/answer/9308870?hl=en publish]''' the document on your Google pages.
This page demonstrates that one can include Google Document, Google SpreadSheet, Google Presentation, and Google Form in this website. One must remember to '''[https://support.google.com/a/users/answer/9308870?hl=en publish]''' the document on your Google pages.


'''Note''': There will be visible delay of content synchronization from Google Documents, Google SpreadSheets, Google Presentations, and Google Forms to pages that embed the same document.  
'''Note''': There will be human observable delay of content synchronization from Google Documents, Google SpreadSheets, Google Presentations, and Google Forms to pages that embed the same document.  
=Google Presentation=
=Google Presentation=
The '''published''' Google Slide can be viewed and edited [https://docs.google.com/presentation/d/1TkzbKQzjpytoOtPDRBNN4PGD479Cqpgt/edit#slide=id.gd398d10917_1_0 here].
The '''published''' Google Slide can be viewed and edited [https://docs.google.com/presentation/d/1GJSCiWOs5ug0cZ81rXM6hETw02t7JoXn/ here].


To add this to the page, one just need to extract the <code>docid</code>.
{{#widget:Google Presentation|docid=1GJSCiWOs5ug0cZ81rXM6hETw02t7JoXn|size=medium}}


For example, the original [[wikipedia:URL|URL]] looks like this:
For example, the original Google Docs [[wikipedia:URL|URL]] should appear in your browser's URL field like this:
<pre>
<pre>
https://docs.google.com/presentation/d/1TkzbKQzjpytoOtPDRBNN4PGD479Cqpgt/edit#slide=id.gd398d10917_1_0
https://docs.google.com/presentation/d/1TkzbKQzjpytoOtPDRBNN4PGD479Cqpgt/
</pre>
</pre>
To add this to the page, one just need to extract the <code>docid</code> that has the value: <code>1TkzbKQzjpytoOtPDRBNN4PGD479Cqpgt</code> .


You just need to use the following string to denote that you want this file displayed on the page:
You just need to use the following string to denote that you want this file displayed on the page:
Line 20: Line 22:


=Google Form=
=Google Form=
If you are familiar with Google Form, you can create one and publish the form here using the following strings:
<pre>
{{#widget:Google Form
|key=1FAIpQLSfUdZgjtgndZALNNRkuDzr757KedXaK_EH45dFjoRrsOKPKNw
|width=760
|height=500
}}
</pre>
{{#widget:Google Form
{{#widget:Google Form
|key=1FAIpQLSfUdZgjtgndZALNNRkuDzr757KedXaK_EH45dFjoRrsOKPKNw
|key=1FAIpQLSfUdZgjtgndZALNNRkuDzr757KedXaK_EH45dFjoRrsOKPKNw
Line 27: Line 38:


=Google Document=
=Google Document=
The '''published''' Google Document: https://docs.google.com/document/d/1yRD3hYPNsvjeyugoSDl-6x3QeAFRbXaOUNH1nh4bIP8/edit#heading=h.aczyuw2yex2w
In case your team is writing up some document using Google Doc, the document can be linked [https://docs.google.com/document/d/1yRD3hYPNsvjeyugoSDl-6x3QeAFRbXaOUNH1nh4bIP8/here].
The original URL looks like this:
<pre>
https://docs.google.com/document/d/1yRD3hYPNsvjeyugoSDl-6x3QeAFRbXaOUNH1nh4bIP8/
</pre>
 
You may display the content using the following string, and specifying its corresponding <code>id</code> as <code>1yRD3hYPNsvjeyugoSDl-6x3QeAFRbXaOUNH1nh4bIP8</code>.
 
<pre>
{{#widget:Google Document
|id=1XI2FqPo7If4vrjflPTJh1nAmEBQQfGNj
|width=800
|height=600
}}
</pre>
 
{{#widget:Google Document
{{#widget:Google Document
|id= 1yRD3hYPNsvjeyugoSDl-6x3QeAFRbXaOUNH1nh4bIP8
|id= 1yRD3hYPNsvjeyugoSDl-6x3QeAFRbXaOUNH1nh4bIP8
Line 35: Line 61:


=Google SpreadSheet=
=Google SpreadSheet=
Google SpreadSheet can also be embedded here, notice that the content synchronization between Google server and your page will have visible delays.
The original URL of the SpreadSheet is:
<pre>
The '''published''' Google SpreadSheet: https://docs.google.com/spreadsheets/d/10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I/
</pre>


The '''published''' Google SpreadSheet: https://docs.google.com/spreadsheets/d/10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I/edit#gid=904881138
To display the Google Sheet in this page, use the following string:
<pre>
{{#widget:Google Spreadsheet
|key=10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I
|width=400
|height=300
}}
</pre>


{{#widget:Google Spreadsheet
{{#widget:Google Spreadsheet
|key=10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I
|key=10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I
|width=600
|width=400
|height=400
|height=300
}}
}}


Line 47: Line 86:


==GoogleDocs4MW==
==GoogleDocs4MW==
This example demonstrates the use of GoogleDocs4MW,
Another MediaWiki extension, namely [[MW:Extension:GoogleDocs4MW|GoogleDocs4MW]], will serve the same function as the extension [[MW:Extension:Widgets| Widgets]]:
<googlespreadsheet width="600" height="200" style="width: 50%">10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I</googlespreadsheet>
<pre>
<googlespreadsheet  
width="600"  
height="300"  
style="width: 50%">10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I</googlespreadsheet>
</pre>
 
<googlespreadsheet
width="600"
height="300"
style="width: 50%">10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I</googlespreadsheet>
 
=Other UI Technologies=
It is worth noting that [[Apollo Spreadsheet]] can do the same thing, and is open source.

Latest revision as of 00:24, 29 January 2022

This page demonstrates that one can include Google Document, Google SpreadSheet, Google Presentation, and Google Form in this website. One must remember to publish the document on your Google pages.

Note: There will be human observable delay of content synchronization from Google Documents, Google SpreadSheets, Google Presentations, and Google Forms to pages that embed the same document.

Google Presentation

The published Google Slide can be viewed and edited here.

For example, the original Google Docs URL should appear in your browser's URL field like this:

https://docs.google.com/presentation/d/1TkzbKQzjpytoOtPDRBNN4PGD479Cqpgt/

To add this to the page, one just need to extract the docid that has the value: 1TkzbKQzjpytoOtPDRBNN4PGD479Cqpgt .

You just need to use the following string to denote that you want this file displayed on the page:

{{#widget:Google Presentation|docid=1TkzbKQzjpytoOtPDRBNN4PGD479Cqpgt|size=medium}}

Google Form

If you are familiar with Google Form, you can create one and publish the form here using the following strings:

{{#widget:Google Form
|key=1FAIpQLSfUdZgjtgndZALNNRkuDzr757KedXaK_EH45dFjoRrsOKPKNw
|width=760
|height=500
}}

Google Document

In case your team is writing up some document using Google Doc, the document can be linked [1]. The original URL looks like this:

https://docs.google.com/document/d/1yRD3hYPNsvjeyugoSDl-6x3QeAFRbXaOUNH1nh4bIP8/

You may display the content using the following string, and specifying its corresponding id as 1yRD3hYPNsvjeyugoSDl-6x3QeAFRbXaOUNH1nh4bIP8.

{{#widget:Google Document
|id=1XI2FqPo7If4vrjflPTJh1nAmEBQQfGNj
|width=800
|height=600
}}

Google SpreadSheet

Google SpreadSheet can also be embedded here, notice that the content synchronization between Google server and your page will have visible delays.

The original URL of the SpreadSheet is:

The '''published''' Google SpreadSheet: https://docs.google.com/spreadsheets/d/10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I/

To display the Google Sheet in this page, use the following string:

{{#widget:Google Spreadsheet
|key=10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I
|width=400
|height=300
}}


GoogleDocs4MW

Another MediaWiki extension, namely GoogleDocs4MW, will serve the same function as the extension Widgets:

<googlespreadsheet 
width="600" 
height="300" 
style="width: 50%">10nJZX6UKeg3FgT8OVfzDUSEIj-H_VeVZkwbEfXRnH7I</googlespreadsheet>

Other UI Technologies

It is worth noting that Apollo Spreadsheet can do the same thing, and is open source.