vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   BB Code Enhancements - BBCode - Embed Google Documents Collection (BB Code) (https://vborg.vbsupport.ru/showthread.php?t=250780)

willie53 04-16-2017 04:49 PM

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 08-31-2017 06:12 AM

Quote:

Originally Posted by Grimholtt (Post 2519092)
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:

Quote:

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

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

GET ht tps://docs.google.c om/sharing/init?id=14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAn fM&foreignService=ritz&gaiaService=wise&shareServi ce=ritz&subapp=10&popupWindowsEnabled=true&shareUi Type=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
Code:

<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 08-31-2017 09:50 AM

Add
HTML Code:

headers=false
to your bbcode remove the toolbars.

Eg:

HTML Code:

<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 09-01-2017 02:15 AM

Quote:

Originally Posted by Kane@airrifle (Post 2589682)
Add
HTML Code:

headers=false
to your bbcode remove the toolbars.

Eg:

HTML Code:

<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 09-01-2017 06:58 AM

Quote:

Originally Posted by IggyP (Post 2589687)
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.

Code:

<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 09-01-2017 11:41 AM

works if you take the /e out thanks

BirdOPrey5 10-21-2018 09:03 AM

Someone PMed me this question-

Quote:

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 10-21-2018 05:24 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2596919)
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 05-23-2021 10:47 PM

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 05-24-2021 12:32 AM

Try this:
Code:

File/Publish to the web/Embed
<iframe src="https://docs.google.com/document/d/e/2PACX-1vSP991tBybGIo8Y8EsLbsRi2QUmuugQC85slx153HELeU_0qgy4V0a9PB1zJ08_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:[gd]2PACX-1vSP991tBybGIo8Y8EsLbsRi2QUmuugQC85slx153HELeU_0qgy4V0a9PB1zJ08_TBDuz51_32ESLUhH[/gd]
Description: Embed a Google Document.
Use Option: No
Button Image: (optional)
Remove Tag If Empty: Yes
All Disable Options: Yes



All times are GMT. The time now is 09:57 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01205 seconds
  • Memory Usage 1,764KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (4)bbcode_html_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete