BBCode - Embed Google Documents Collection (BB Code)

[BirdOPrey5]

Embed Various Google Docs

Live Demo: Here (http://www.juot.net/forums/showthread.php?p=872381#post872381)

Google Docs (https://docs.google.com/) is a free service by Google. Google Docs are a professional collection of "Office" applications like a Word Processor, Spreadsheet, Presentation Designer, and Drawing tool. Google Docs is a serious alternative to the very expensive Microsoft Office. Documents are stored online, can be shared among users, and in the case of this BB Code they can be embedded in other web pages.

There are several BB Codes in this collection, Google Doc (Document), Google Spreadsheet and Google Presentation. Google Drawings can be embedded using the standard tags but I will give an example here anyway.

You may get a warning message saying the {param}s aren't enclosed in quotes. You can hit "continue" to ignore this error. As you can see in the code there are eventually double-quotes.

When working on any Google Document in the top right of the window will be a "Share" button with drop-down arrow. Click on this arrow and choose "Publish to Web" or "Publish / Embed" and you will be given code to link to and/or embed the document. You will be given a URL such as:
https://docs.google.com/document/pub?id=1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc

What you need is the document ID which is the long string of characters after "id=" or "key=" and before the ampersand (&) if present, in this case your id is:
1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc

In all cases you put the ID between the appropriate tag for the type of document.

Google Document (Word Processor Document)
1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc

Google Spreadsheet
0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc

Google Presentation
dcjktv94_1fcpptwqc

Google Drawing
No special BB Code is needed to embed a drawing because it's rendered as any other image. Just put the URL given between IMG tags...
https://docs.google.com/drawings/pub?id=1C1arwoUzUyzxnzk9yD7ysx6vyMfcDuDXXzQTqnngh2 c&w=640&h=480

To add one or more of these BB Codes follow any of the below instructions:

Add a New BB Code

Title: Google Document
BB Code Tag Name: gd
Replacement:

<div align="center"><iframe src="https://docs.google.com/document/pub?id={param}&amp;embedded=true&gid=0&output=html&widget=true" width="95%" height="500">IFRAME Not Available. <a href="https://{option}.google.com/document/pub?id={param}">Direct Link to Google Document</a>.</iframe></div>

Example:1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc
Description: Embed a Google Document.
Use Option: No
Button Image: (optional) https://vborg.vbsupport.ru/external/2010/09/33.jpg
Remove Tag If Empty: Yes
All Disable Options: Yes

------

Add a New BB Code

Title: Google Spreadsheet
BB Code Tag Name: gs
Replacement:

<div align="center"><iframe width='95%' height='500' frameborder='0' src='https://spreadsheets.google.com/pub?key={param}&hl=en&single=true&gid=0&output=html&widget=true'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key={param}&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>

Example: 0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc
Description: Embed a Google Spreadsheet.
Use Option: No
Button Image: (optional) https://vborg.vbsupport.ru/external/2010/09/33.jpg
Remove Tag If Empty: Yes
All Disable Options: Yes

------

Add a New BB Code

Title: Google Presentation
BB Code Tag Name: gp
Replacement:

<div align="center"><iframe src="https://docs.google.com/present/embed?id={param}" frameborder="0" width="700" height="559">IFRAME Not Available. <a href="https://docs.google.com/present/view?id={param}">Direct Link to Presentation.</a></iframe></div>

Example:dcjktv94_1fcpptwqc
Description: Embed a Google Presentation.
Use Option: No
Button Image: (optional) https://vborg.vbsupport.ru/external/2010/09/33.jpg
Remove Tag If Empty: Yes
All Disable Options: Yes

------

In any of the above codes you can edit the height and width attributes to suit your needs.

------

------------------------------------------------------

Please "[I]Mark as Installed" if you use this. :)
Donations always appreciated. :up:
Nominate MOTM if you LOVE it! ;)

Check My Profile (https://vborg.vbsupport.ru/member.php?u=258922) for other BB Code enhancements. They work on all versions.

Download the .txt file for a copy of the Install instructions.

Screenshots Attached:

[sulasno]

tagged and thanks

very good indeed

[abumohamed]

great work

[Mellow]

Make sure you put double quotes around the {parms}

[BirdOPrey5]

Always good to keep a lookout for BB Codes that don't properly enclose {param}'s in double quotes but if you look closely all of these are in double quotes, just with additional code in them.

For example:


<div align="center"><iframe src="https://docs.google.com/present/embed?id={param}" frameborder="0" width="700" height="559">IFRAME Not Available. <a href="https://docs.google.com/present/view?id={param}">Direct Link to Presentation.</a></iframe></div>

The param is between these quotes:
"https://docs.google.com/present/view?id={param}"

[Cyamia]

Thank you BirdOPrey5 so much!!

I have been always wanted a tool like this that would allows my community to share their presentation files. Your work is a great solution to my needs.

A quick question: when I setting up this BB code, that is a warning that say lthat some of the html attributes are not enclosed in " ". Is it fine to let it go like that? I just pushed the continue button but I am not sure if there would not be any issues some time in the future. Any thought?

[BirdOPrey5]

Cyamia-

Yes I believe it is OK to "continue" in that warning. Although {param} itself isn't in quotes, such as "{param}", there are indeed quotes a little later on in the code as explained in my post above yours. I believe this is sufficient to keep the code safe and I use it myself.

[Cyamia]

Thank you; I trust you.

[Mellow]

Thanks, I'll try the continue as well.

[fluidswork]

This will save me from lot of trouble .....

[riskreward]

I am very new to all of this. Hence this may sound silly.

But where do I insert the new BB code?

[BirdOPrey5]

In the Admin Control Panel. On the menu on the side scroll down to Custom BB Codes -> Add A New BB Code.

[riskreward]

Thank you.

[Alfa1]

This stuff should be default.

[Rofo]

Can't get this to work for a spreadsheet, would love to have it though!

4.1.1

[BirdOPrey5]

Can't get this to work for a spreadsheet, would love to have it though!

4.1.1

If you're getting the warning:
The following BB Code replacement may not be properly formed. All HTML attributes should be enclosed within double quotes.

You can safely hit continue and it will work.

Otherwise maybe re-read the instructions, it is still working for me, just made a new spreadsheet and re-confirmed in 4.x.

The example I just made is:
0AmOHO6Cm8vvAdGRyZUNhWnZCSWVKdjM0WUpfM2FzeFE

You should see a simple, small spreadsheet.

[Rofo]

Got it to work, don't really know exactly what I changed to make it work... Thats ok :)

I have been wondering how i could get my spreadsheet on forums for a very long time, thank you very much for this.

Installed, rated.

[Gamelobby]

This only works for Google correct.?

What if we host it seperately, & use Logicians Webtemplates..? (any possibility in iframe) also to be able to update.

[VanHuek]

How can I get it too work for google forms?

[BirdOPrey5]

This only works for Google correct.?

What if we host it seperately, & use Logicians Webtemplates..? (any possibility in iframe) also to be able to update.

I don't know how you'd host it separately or anything about Logician's Webtemplates... But yeah, only google, only hosted in google. Anywhere you can use BBCode you can use this.

How can I get it too work for google forms?

I never heard of Google Forms, do you have a link to them?

[VanHuek]

http://docs.google.com/support/bin/answer.py?hl=en&answer=87809

https://spreadsheets.google.com/viewform?authkey=CIvB0_QM&hl=en_GB&formkey=dDJOem12WkkzRm9JdnlSWXZheWJ0Q0E6MQ#gid=0

[BirdOPrey5]

OK, to do a Google Form:

Demo: http://www.juot.net/forums/showthread.php?t=47896

Example:
dDNJRFdVaXRxM2FTVXpnQlVlMHBZVnc6MQ


Add a New BB Code

Title: Google Form
BB Code Tag Name: gf
Replacement:
<iframe src="https://spreadsheets.google.com/embeddedform?formkey={param}" width="760" height="1021" frameborder="0" marginheight="0" marginwidth="0">Loading...</iframe>
Example: dDNJRFdVaXRxM2FTVXpnQlVlMHBZVnc6MQ
Description: Embed a Google Form.
Use Option: No
Button Image: (optional)
Remove Tag If Empty: Yes
All Disable Options: Yes

[Gamelobby]

BirdOPrey, I got this..?
The following BB Code replacement may not be properly formed. All HTML attributes should be enclosed within double quotes.

•<iframe src="https://spreadsheets.google.com/embeddedform?formkey={param}" width="760" height="1021" frameborder="0" marginheight="0" marginwidth="0">Loading...</iframe>
{param} is in bold

I hit continue, & it seems fine except it works for Google spreadsheets, but not Google docs.

*edit*
nevermind, i just realized this mod was originally for docs, so i need to try it first.



*edit2*
Whats the difference between a Doc, a Presentation, & a Form.?

Here is what im trying to make work.
https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B299LfK4JhZkODJiNzVhMWUtZDUyZC00NzE3LTkxZTU tOGEwMmE2MDIxOWQ0&hl=en&authkey=CIPAqvoP

[BirdOPrey5]

Google has various types of "documents."

Docs - which are like word documents, usually text mostly
Spreadsheets
Presentations
Drawings
and now Forms

It looks like yours is a "docs" document, you should try the instructions for the very first bbcode in this thread "Google Document."

[FReeSTER]

Man this sucks, Im trying out the spread sheet and is showing just a blank iframe

Any ideas Bird?

thanks mate I really need this

[BirdOPrey5]

Does the example spreadsheet show on your forum?

0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc

You can see how the example should look here (http://www.qapla.com/mods/showthread.php/27-Google-Docs-BBCodes-Google-Documents-Presentations-Spreadsheets-and-Forms.).

[FReeSTER]

Does the example spreadsheet show on your forum?

0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc

You can see how the example should look here (http://www.qapla.com/mods/showthread.php/27-Google-Docs-BBCodes-Google-Documents-Presentations-Spreadsheets-and-Forms.).

yes the sample works mate. Im trying this one in bold https://docs.google.com/spreadsheet/ccc?key=0AuZfwFwa96-AdEpiTzFCX1Z6YWRpOEFZcXBRTXZNZ0E&hl but all I get is a white iframe on the post.

[BirdOPrey5]

I get the message: We're sorry. This document is not published.

Here is how to Publish your document: https://docs.google.com/support/bin/answer.py?hl=en&answer=37579&topic=1360911

Note: It is NOT the same as setting your document's visibility.

[FReeSTER]

Thank you Joe, I fix the link sorry. I have try so many ways to add the link or the
{param} 0AuZfwFwa96-AdEpiTzFCX1Z6YWRpOEFZcXBRTXZNZ0E and it doesnt
work at all I was wondering if this is cause because that document have a - on the param?

[BirdOPrey5]

If the sample works on your forum th BBCode is entered correctly.

Your problem is you need to "Publish" your document in Google Docs- instructions were in the link in my previous post.

The dash (-) in the param doesn't matter.

[FReeSTER]

If the sample works on your forum th BBCode is entered correctly.

Your problem is you need to "Publish" your document in Google Docs- instructions were in the link in my previous post.

The dash (-) in the param doesn't matter.

Thank you very much, it worked thanks for your time Joe as always

[sweetpotato]

Thank you for the nice mod. The SpreadSheet work well for single sheet but for multisheets I have to strip out
&single=true
in your code.
May I suggest that you use full link and put double quotes for the security purpose like this
<div align="center"><iframe width="95%" height="500" frameborder="0" src="{param}">IFRAME Not Available. <a href="{param}">Direct Link to Spreadsheet.</a></iframe></div>

[BirdOPrey5]

Thanks for the info on the multi-sheet.

However your second suggestion is a HUGE security risk. Anyone could use the code to open an IFRAME of an arbitrary website.

My original implementation is safe- the warning VB gives can be ignored- VB itself doesn't have a great way of scanning for the {param} between quotes.

[beduino]

I will use in my boards
Thank you joe

[grc]

Does this still work? The GD shared link no longer has id= in it and I'm getting a "not found" message when the id section of the link is used with the tags.

[BirdOPrey5]

it still works...

http://www.qapla.com/mods/showthread.php/106-Google-Spreadsheet-test

Instead of the id you take the long string before /edit:

Example:
https://docs.google.com/document/d/1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc/edit

Take the code in red and pot it between:

1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc

[grc]

it still works...

http://www.qapla.com/mods/showthread.php/106-Google-Spreadsheet-test

Instead of the id you take the long string before /edit:

Example:
https://docs.google.com/document/d/1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc/edit

Take the code in red and pot it between:

1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc

Thanks. I hadn't gone to File/Publish to the Web -- missed that step.

[JabirA]

Does it work in 4.1.12?

[BirdOPrey5]

BBCodes work in all VB versions.

[JabirA]

Thanks for the info on the multi-sheet.

However your second suggestion is a HUGE security risk. Anyone could use the code to open an IFRAME of an arbitrary website.

My original implementation is safe- the warning VB gives can be ignored- VB itself doesn't have a great way of scanning for the {param} between quotes.

I have this problem too.
Do you have a safer suggestion?

[BirdOPrey5]

Just use my original code with the &single=true removed.

[JabirA]

Thank you! Why don't make it default than?

[BirdOPrey5]

Just did. :)

[UK CHI3F]

Been using this mod for a while but all of a sudden the spreadsheets dont appear anymore, no changes have been made tried other sheets as well but to no avail

Any ideas?

[BirdOPrey5]

The spreadsheets still work on the demo page: http://www.qapla.com/mods/showthread.php/27-Google-Docs-BBCodes-Google-Documents-Presentations-Spreadsheets-and-Forms

So I don't think Google changed anything...

Can you post an example of one of yours that isn't working as well as copy the replacement code from the bbcode into a [code] box here?

[UK CHI3F]

Here is our main sheet on our site.
http://www.xboxplayers.co.uk/site/showthread.php?451-XBXP-F1-2012-Standings

this is the bb code it has always had
0AjKwY3XXQSBvdGlrdjg4cjdDS1Y2Vm80S2p6b0FXV0E

this is the original document
https://docs.google.com/spreadsheet/ccc?key=0AjKwY3XXQSBvdGlrdjg4cjdDS1Y2Vm80S2p6b0FXV 0E#gid=7

This is the replacement code
<div align="center"><iframe width='95%' height='400' frameborder='5' src='https://spreadsheets.google.com/pub?key={param}&hl=en&&gid=0&output=html&widget=true'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key={param}&hl=en&&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>

Thanks for your help

[BirdOPrey5]

I don't know why you can't open it but my suggestion is to download a copy, reupload it, publish the new copy to the web and get the new code and use that- it worked for me.

You can edit your post with the new bbcode code.

[insidegames]

Doesn't work for me under 4.2. Always there are now Spreedshet. It's says "Sorry, it's not public now"

[BirdOPrey5]

It works on my 4.2.0 forum. Are you sure the documents are still public?

Demo: http://www.qapla.com/mods/showthread.php/27-Google-Docs-BBCodes-Google-Documents-Presentations-Spreadsheets-and-Forms

[kylek]

It works on my 4.2.0 forum. Are you sure the documents are still public?

Demo: http://www.qapla.com/mods/showthread.php/27-Google-Docs-BBCodes-Google-Documents-Presentations-Spreadsheets-and-Forms


Your spreedsheet example is not showing on your site right now, sames as what we get, just blank space.

[BirdOPrey5]

Resolved the above- it was a browser issuer.

[Chivster]

I keep getting an error to it saying that the key is incorrect.
I followed the guidelines, can anyone help me out ?

[BirdOPrey5]

Can you pste a key and document type here? Like spreadsheet 3ff456d75g5ge3wsdghjh?

[MarineColorado]

so it loads up for me fine with the code but it keeps telling me sorry the file you requested is unavailable. Any thoughts?

[MarineColorado]

edited NM i hade the code wrong I changed a ' to " originally before html in the code. I changed it back to a ' and it works great!!! Thank you for the mod

[kylek]

It looks like the share code for google spreadsheets has changed now. Trying to use it again but it just shows blank.

Looking at a link last month and the new share link the ccc?key= is now /d/

Last month link:

https://docs.google.com/spreadsheet/ccc?key=0Aj2WwLTFuln9dE5OZWozV2hLVXN6Q0xKTkZVVHZ0V UE&usp=sharing

Latest link:

https://docs.google.com/spreadsheets/d/1y-eShX7W9YJnDt7ysw2iBmL8nXPCP2To28euwCQMM6c/edit?usp=sharing

[XSV_4ce]

I am also getting a blank page. Your sample code works perfect. here is what I am using.

1QEWFbs0iRPHNZaMuoKnzO_zv6if2Rudt8Zx8AtgbPzI

Just blank frame.

[kylek]

Just surfing on google and found this: https://support.google.com/drive/answer/3541068

"Starting in March and April 2014, Google Sheets users creating new spreadsheets will be automatically directed to the new Sheets. All previously created spreadsheets will remain in the older version of Sheets for now. If you need to create a spreadsheet using the old Sheets, you can do so at g.co/oldsheets (https://g.co/oldsheets)"

[whodah]

Oops - just noticed you had this mod in the 4.x area. Pretty cool, thx! Like some users above, , I removed the "single=true" portion of the GS tag so that users could click multiple sheets.

Any hints on how to do a google chart? I see the publish code on a chart is a bit different than the docs/spreadsheets.

Thx!

[DemOnstar]

Google docs also has a PDF viewer.
How do we get this to display? Do we click share and take the link, change who has access to 'public on the web'?

Sorry, new to google docs but I have some PDF's that may well prove useful.

Ta...

[whodah]

OK - so for Google charts, we are a bit stuck because ideally we would have 4 {param}'s available. As it stands now, we have two:
{param}
{option}

So I've set option = google charts "oid", and param = google charts chart number. I've hard coded the width to 800 and height to 600, and let users know they need to size their published charts to this size. Shy of installing a mod allowing multiple {param}'s, this is where we are. But it works well.
:)

Title: Google Chart
BB Code Tag Name: BB Code Tag Name
Replacement:


<iframe height=600 width=800 src="http://docs.google.com/spreadsheets/d/{param}/gviz/chartiframe?oid={option}" seamless frameborder=0 scrolling=no></iframe>


Example:

1enPIPGRIyIHTYF2-IJokCPVUXWsRw7v_ZZUljfGAyTo


Description:

Embed a Google Spreadsheet Chart. The chart will render at 800x600, so be sure to size your chart accordingly at Google Docs/Drive/Charts. This one is a bit tricky to use... The 'oid' of the link needs to be the option (i.e. [gc=oid_number]) and the chart number the parameter. It is just the way google charts does it.


Use {option}: yes
Button Image (Optional): -- create an image if you desire --
Remove Tag If Empty: yes
All other Disable options: yes

Feel free to clean it up more, but that gets it going at least. :)

[klaush]

Thanks; this made my day!

Just surfing on google and found this: https://support.google.com/drive/answer/3541068

"Starting in March and April 2014, Google Sheets users creating new spreadsheets will be automatically directed to the new Sheets. All previously created spreadsheets will remain in the older version of Sheets for now. If you need to create a spreadsheet using the old Sheets, you can do so at g.co/oldsheets (https://g.co/oldsheets)"

[Pittski]

Hmm, I tried messing around with it but can't seem to get it to work. The new spreadsheet link that is.

Anyone else get it working?

Key= has been replaced with /d/ now


Edit: I think I fixed it. Not positive. But here is the new code.

<div align="center"><iframe width='95%' height='500' frameborder='0' src='https://docs.google.com/spreadsheets/d/{param}/edit#gid=0&hl=en&single=true&output=html&widget=true'>IFRAME Not Available. <a href="https://docs.google.com/spreadsheets/d/{param}/edit#gid=0&hl=en&single=true&output=html">Direct Link to Spreadsheet.</a></iframe></div>

I replaced the /Key= part with /d/{param}/edit#gid=0 in both html lines, and it worked for me.

Edit 2:when it loads the spreadsheet it sends you to the top of the page. also if you click in the spreadsheet after clicking out of it, it will send you to top of the page. No idea how to stop that.

[Grimholtt]

Can anyone assist with this? After the changes were made by Google, I use the /d/ now and it loads the spreadsheet just fine, but now instead of just the cells appearing, I get the entire Spreadsheet including the Tools at the top.

For example:

I'm looking to see just this:

https://vborg.vbsupport.ru/external/2014/10/9.png

What I'm actually seeing:

https://vborg.vbsupport.ru/external/2014/10/10.png

Any way to clean this up that anyone knows about?

[kylek]

Does the same for me shows everything, guess will stick to using the iframe code they give for the embed share link.

[willie53]

Ok tried for about 3 weeks to get google spreadsheets working on vb 5.2.6 then on vb 5.3.0 alpha as it is something i really needed the way i was getting them to display the sheet was to embed it with iframe and to do this i had to enable html which is not a good idea so it was left to me do update the sheets.
I finally got it working the solution was staring me in the face i got the google docs working no problem but the spreadsheet would not so i compared the 2 sets of replacement code the spreadsheet code used single qoute ' instead of double qoute " so this is the amended code i am using now and works a treat

<div align="center"><iframe width="95%" height="500" frameborder="0" src="https://spreadsheets.google.com/pub?key={param}"&hl=en&single=true&gid=0&output=html&widget=true'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key={param}"&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>
Many thanks for this.
Regards Willie

[willie53]

Here is a quick and easy way to install these bbcodes it can be done in admincp or in phpmyadmin simply run the sql query below i have tested this method on all versions of vbulletin from vb3.6.8 through 5.3.0 and it works on all versions though you may need to edit 1 word depending if you set a prefix for db tables the simply put the prefix in front of bbcode example is vbbbcode


INSERT INTO `bbcode` (`bbcodeid`, `bbcodetag`, `bbcodereplacement`, `bbcodeexample`, `bbcodeexplanation`, `twoparams`, `title`, `buttonimage`, `options`) VALUES

(3, 'gd', '<div align="center"><iframe src="https://docs.google.com/document/pub?id=%1$s&amp;embedded=true&single=true&gid=0&output=html&widget=true" width="95%%" height="500">IFRAME Not Available. <a href="https://{option}.google.com/document/pub?id=%1$s">Direct Link to Google Document</a>.</iframe></div>', '1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc', '1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc', 0, 'Google Docs', '', 31),
(5, 'gs', '<div align="center"><iframe width="95%%" height="900" frameborder="0" src="https://spreadsheets.google.com/pub?key=%1$s"&hl=en&single=true&gid=0&output=html&widget=true\'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key=%1$s"&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>', '14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAnfM', '', 0, 'Google Spreadsheet', '', 31),
(6, 'gp', '<div align="center"><iframe src="https://docs.google.com/present/embed?id=%1$s" frameborder="0" width="700" height="559">IFRAME Not Available. <a href="https://docs.google.com/present/view?id=%1$s">Direct Link to Presentation.</a></iframe></div>', 'dcjktv94_1fcpptwqc', '', 0, 'Google Presentation', '', 31);

[BirdOPrey5]

Here is a quick and easy way to install these bbcodes it can be done in admincp or in phpmyadmin simply run the sql query below i have tested this method on all versions of vbulletin from vb3.6.8 through 5.3.0 and it works on all versions though you may need to edit 1 word depending if you set a prefix for db tables the simply put the prefix in front of bbcode example is vbbbcode


INSERT INTO `bbcode` (`bbcodeid`, `bbcodetag`, `bbcodereplacement`, `bbcodeexample`, `bbcodeexplanation`, `twoparams`, `title`, `buttonimage`, `options`) VALUES

(3, 'gd', '<div align="center"><iframe src="https://docs.google.com/document/pub?id=%1$s&amp;embedded=true&single=true&gid=0&output=html&widget=true" width="95%%" height="500">IFRAME Not Available. <a href="https://{option}.google.com/document/pub?id=%1$s">Direct Link to Google Document</a>.</iframe></div>', '1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc', '1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc', 0, 'Google Docs', '', 31),
(5, 'gs', '<div align="center"><iframe width="95%%" height="900" frameborder="0" src="https://spreadsheets.google.com/pub?key=%1$s"&hl=en&single=true&gid=0&output=html&widget=true\'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key=%1$s"&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>', '14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAnfM', '', 0, 'Google Spreadsheet', '', 31),
(6, 'gp', '<div align="center"><iframe src="https://docs.google.com/present/embed?id=%1$s" frameborder="0" width="700" height="559">IFRAME Not Available. <a href="https://docs.google.com/present/view?id=%1$s">Direct Link to Presentation.</a></iframe></div>', 'dcjktv94_1fcpptwqc', '', 0, 'Google Presentation', '', 31);


VB 5.x doesn't have a plugin system to which this code would be compatible, FYI.

[willie53]

VB 5.x doesn't have a plugin system to which this code would be compatible, FYI.

It is actually running on my main site which can be seen @ this post https://cometbar.co.uk/forum/darts/464-premiership-and-championship-stats

also have it installed on various versions of vb

[BirdOPrey5]

My bad I thought you were supplying plugin code. Your code makes direct alterations to the BBCode table. Guess I should have looked closer.

I would still advise caution, there are reasons manual edits to database tables are last resorts. People shouldn't get in the habit of inserting BB Codes via direct queries. One mistake/typo and you can screw up your site.

[willie53]

I do agree there if you are not comfortable altering the database then leave it alone this is why i always use one of my my testing sites on my laptop before i put anything on my live site also i backup the database beforehand.

[IggyP]

Can anyone assist with this? After the changes were made by Google, I use the /d/ now and it loads the spreadsheet just fine, but now instead of just the cells appearing, I get the entire Spreadsheet including the Tools at the top.

For example:

I'm looking to see just this:

https://vborg.vbsupport.ru/external/2014/10/9.png

What I'm actually seeing:

https://vborg.vbsupport.ru/external/2014/10/10.png

Any way to clean this up that anyone knows about?

i am curious of this too....the extra header can be a security concern would be nice to hide it....also it now added a chat as well, which we dont really want....i tried hiding them by css, even tho its loading the main sheet from google, but fail...not sure what else to even try...

also have got errors loading spreadsheets like this:

GET filesystem:htt ps://docs.google.c om/persistent/docs/fonts/cCwcoZCh95jEfkePtzfl9_k_vArhqVIZ0nv9q090hN8.woff2 net::ERR_FILE_NOT_FOUND

Refused to display 'htt ps://docs.google.c om/sharing/init?id=14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAn fM&foreignService=ritz&gaiaService=wise&shareService=ritz&subapp=10&popupWindowsEnabled=true&shareUiType=default&hl=en&authuser=0&rand=1504167017294' in a frame because it set 'X-Frame-Options' to 'sameorigin'.

GET ht tps://docs.google.c om/sharing/init?id=14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAn fM&foreignService=ritz&gaiaService=wise&shareService=ritz&subapp=10&popupWindowsEnabled=true&shareUiType=default&hl=en&authuser=0&rand=1504167017294[/url] net::ERR_BLOCKED_BY_RESPONSE


be nice to clean it up and secure it a little better but seems to basically work..vb4.2.5 php 5.6


oh and btw, that is result by using this replacement code which is the one that seemed to work for me
<div align="center"><iframe width="95%" height="800px" frameborder="0" src="https://docs.google.com/spreadsheets/d/{param}"&hl=en&single=true&gid=0&output=html&widget=true'>IFRAME Not Available. <a href="https://docs.google.com/spreadsheets/d/{param}"&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>

[Kane@airrifle]

Add headers=false to your bbcode remove the toolbars.

Eg:

<div align="center"><iframe width='95%' height='600' frameborder='0' src="https://docs.google.com/spreadsheets/d/{param}/pubhtml?widget=true&amp;headers=false"></iframe></div>

[IggyP]

Add headers=false to your bbcode remove the toolbars.

Eg:

<div align="center"><iframe width='95%' height='600' frameborder='0' src="https://docs.google.com/spreadsheets/d/{param}/pubhtml?widget=true&amp;headers=false"></iframe></div>

that works perfectly thank you....i tried the same however for the google docs and didnt seem to work..is it slightly different there? i know that first part at least is the same with the updated "htt ps://docs.google.co m/document/d/{param}" format but the after part i tried matching your ss code then a few other ways and still failed..

[Kane@airrifle]

that works perfectly thank you....i tried the same however for the google docs and didnt seem to work..is it slightly different there? i know that first part at least is the same with the updated "htt ps://docs.google.co m/document/d/{param}" format but the after part i tried matching your ss code then a few other ways and still failed..

Try this for a Google Doc.

<div align="center"><iframe width='95%' height='600' frameborder='0' src="https://docs.google.com/document/d/e/{param}/pub?embedded=true"></iframe></div>

[IggyP]

works if you take the /e out thanks

[BirdOPrey5]

Someone PMed me this question-

Hi BOP5...

This mod seems to work beautifully to embed Google Docs spreadsheets on my vB4 test forum, as long as I'm on something with a large screen. When I view an embedded sheet on the vB mobile style on a small device, the rendering seems all compressed. On my S7 phone it displays only the cells containing text (in this case, the first 4 rows) and the sheet's footer bar is strangely right across the middle of them. Have you seen this before? Do you know of an easy fix?

...
Thanks in advance!

There was a screenshot.

Unfortunately I do not know of any fix. It was never intended for mobile devices, sorry.

If anyone finds a mobile friendly bbcode feel free to release it here or as your own mod, no permission needed.

[edgeless]

Unfortunately I do not know of any fix. It was never intended for mobile devices, sorry.Thanks for taking the time to respond, BOP.

All I know is the problem seems to stem from something vB's default directives are controlling. This seems so because I can alter the replacement code parameters in a multitude of ways but the footer bar & tab across the content area issue persists no matter what changes I make. I should also note that it's the 'height' aspect that's compressed and frozen when a sheet is viewed on a narrow, mobile screen. That results in the footer bar and the sheet tab perpetually obstructing the sheet's content. They remain there even when using Google's own generated embedment code, and even with the widget directive set to false (which should toggle off the sheet tab that appears on the overlapping footer bar). Also, when the mobile style is viewed on a larger screen, all aspects become rendered correctly (i.e., the footer bar, the sheet tab, etc. are each in place). So it seems vB is restricting the height of the display area for embedded documents on the mobile style. As such, if I could learn how to get my vB4 to allow mobile style height flexibility I'm guessing it would fix the problem. Someone smarter then I would have to determine how that might be done, though.

Edit: Just some further information. The scope of this problem is somewhat different from my initial assumption. I've tested the issue on two Samsung mobile devices. As it turns out, when in vB full desktop version mode the iframed sheets display in the identically compressed and distorted state that I'm seeing in vB mobile mode. Oh, and the issue is browser independent as well... at least among the three mobile browser versions I have tested (i.e., Google Chrome, Firefox, and the browser that comes pre-loaded on Samsung devices). So to summarize, the iframed Google sheets simply will not render properly on these mobile devices - through iframes on vBulletin forum sites at least. But they render amazingly well with full synch'ing/linking control and visibility on my desktop and laptop computers. They even present quite well in vB mobile mode on those computers. Therefore, the screen dimensions on my phone are obviously not the issue. I can't imagine what it would take to get this working on these phones.

Edit2: I've been able to get it to display on my mobile device without the obstructive sheet tab bar blocking the sheet's content on the phones. However, sheet cells are not editable under the required configuration. It is thus exclusive to displaying the sheet's data. So for editing the sheets, I've employed a workaround by adding another bbcode item that can quickly and easily be toggled and saved through a post edit, then switched back to the frozen data display mode using the original bbcode tags, allowing the data to again be seen on mobile devices. I can also add some buttons to the editor, making it even a bit more convenient.

https://vborg.vbsupport.ru/external/2018/10/5.png

[Hostboard]

I have not been able to get this to work with the original code nor the code provided by others. Does anyone have this working or know how to? The Google Docs is my primary need.

[lange]

Try this:

File/Publish to the web/Embed
<iframe src="https://docs.google.com/document/d/e/2PACX-1vSP991tBybGIo8Y8EsLbsRi2QUmuugQC85slx153HELeU_0qg y4V0a9PB1zJ08_TBDuz51_32ESLUhH/pub?embedded=true"></iframe></div>
Google Docs
gd
Replacement: <div align="center"><iframe src="https://docs.google.com/document/d/e/{param}/pub?embedded=true"></iframe></div>
Example:2PACX-1vSP991tBybGIo8Y8EsLbsRi2QUmuugQC85slx153HELeU_0qg y4V0a9PB1zJ08_TBDuz51_32ESLUhH
Description: Embed a Google Document.
Use Option: No
Button Image: (optional)
Remove Tag If Empty: Yes
All Disable Options: Yes

[Hostboard]

Thank you for the code. Unfortunately when used I get "docs.google.com refused to connect." Any ideas why?

***NM I got it to work.***

Thank you again