Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
BBCode - Embed Google Documents Collection (BB Code) Details »
BBCode - Embed Google Documents Collection (BB Code)
Mod Version: 1.00, by BirdOPrey5 (IB Staff) BirdOPrey5 is offline
Developer Last Online: Nov 2018 I like it Show Printable Version Email this Page

vB Version: 4.0.x Rating: (4 votes - 5.00 average) Installs: 66
Released: 19 Sep 2010 Last Update: 19 Sep 2010 Downloads: 210
Not Supported Re-usable Code Translations External Content  

Embed Various Google Docs

Live Demo: Here

Google Docs 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 [img] 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)
[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]

Google Spreadsheet
[gs]0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc[/gs]

Google Presentation
[gp]dcjktv94_1fcpptwqc[/gp]

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...
[IMG]https://docs.google.com/drawings/pub?id=1C1arwoUzUyzxnzk9yD7ysx6vyMfcDuDXXzQTqnngh2c&w=640&h=480[/IMG]

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Example:[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]
Description: Embed a Google Document.
Use Option: No
Button Image: (optional)
Remove Tag If Empty: Yes
All Disable Options: Yes

------

Add a New BB Code

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

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Example: [gs]0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc[/gs]
Description: Embed a Google Spreadsheet.
Use Option: No
Button Image: (optional)
Remove Tag If Empty: Yes
All Disable Options: Yes

------

Add a New BB Code

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

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Example:[gp]dcjktv94_1fcpptwqc[/gp]
Description: Embed a Google Presentation.
Use Option: No
Button Image: (optional)
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 "Mark as Installed" if you use this.
Donations always appreciated.
Nominate MOTM if you LOVE it!

Check My Profile for other BB Code enhancements. They work on all versions.

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

Screenshots Attached:

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	ss_googledocs.png
Views:	636
Size:	28.2 KB
ID:	122130   Click image for larger version

Name:	ss_googlespreadsheet.png
Views:	694
Size:	20.5 KB
ID:	122131   Click image for larger version

Name:	ss_googlepresentation.png
Views:	543
Size:	17.9 KB
ID:	122132  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
BB Code Enhancements Jigzone.com BB Code - Embed Puzzles in your forums - (BBCode) BirdOPrey5 vBulletin 4.x Add-ons 30 27 Apr 2015 15:43
BB Code Enhancements BB Code - Twitvid - Twitter Videos - Embed (BBCode) BirdOPrey5 vBulletin 3.8 Add-ons 5 31 Mar 2012 06:05
BB Code Enhancements BB Code embed Videos from Google into posts. Vaupell vBulletin 3.8 Add-ons 2 31 Jan 2010 03:52

  #76  
Old 01 Sep 2017, 14:41
IggyP IggyP is offline
 
Join Date: May 2012
works if you take the /e out thanks
Reply With Quote
  #77  
Old 21 Oct 2018, 12:03
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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.
__________________
-Joe
Former vBulletin.org Staff Member

(@BirdOPrey5) Former vb.org Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
  #78  
Old 21 Oct 2018, 20:24
edgeless edgeless is offline
 
Join Date: Mar 2013
Originally Posted by BirdOPrey5 View Post
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.


Last edited by edgeless; 22 Oct 2018 at 23:01.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 18:55.

Layout Options | Width: Wide Color: