thevukaslt

Good tip – I was using Chrome and it cached the redirect pretty heavily even after the fix.

Exactly! Browsers are tend to cache permanent redirects (301) and since WordPress uses 301, so even after fix we wouldn’t see unless would use different browser or incognito mode.

To note: I use Chrome for developing and to clear data for particular domain navigate to Settings -> Show Advanced Settings -> Content Settings (first button under Privacy) -> All cookies and site data ->(new window pops-up)-> Enter your domain into search box and remove data for each domain you worked with. And this way you won’t loose cookies for other sites.
??

I copied and pasted your code at the end of the functions.php file of my theme and nothing changed. Thank you for trying.

Hi Evette,
have you tried it on the same browser and session with same cached data and cookies? If so, try again that code but either clear cached browser data or try in incognito mode. So, you could actually see the result.

Hope it helps.

Thanks Andrew! That helped me a lot.

Today was a day when I begun meeting with nginx and I came across this bug what made me think that I won’t be able to use nginx but you actually saved me. Thanks again! ??

Hi, it works fine with Google’s given public html code.
[gdoc key="https://docs.google.com/spreadsheets/d/1Q3Sp0aoBwFOkODihDxINv5p6_we8sS6fFG0u9I5tp14/pubhtml"]

For limiting output use query. From FAQ documentation:

If you’re using the “new” Google Spreadsheets, you can strip out columns by selecting only those columns you wish to retrieve by passing a Google Charts API Query Language query to the shortcode’s query attribute. For example, to retrieve and display only the first, second, and third columns in a spreadsheet, use a shortcode like this:

[gdoc key=”ABCDEFG” query=”select A, B, C”]
Alternatively, you can hide columns using CSS with code such as, .col-4 { display: none; }, for example.

This time it would look like this:
[gdoc key="https://docs.google.com/spreadsheets/d/1Q3Sp0aoBwFOkODihDxINv5p6_we8sS6fFG0u9I5tp14/pubhtml" query="select C"]

Thanks a lot. I appreciate your, helpful hacker’s, time and effort explaining me those things.

Now I aim to expanding my knowledge. ??

Hi,
well your shortcode is almost written correct. You forgot to add HTML link.
From: Quick start

If using a Google Spreadsheet, the spreadsheet must be shared using either the “Public on the web” or “Anyone with the link” options.
<…>
After saving the appropriate Sharing setting, copy the URL you use to view the Google Spreadsheet from your browser’s address bar into the shortcode.

So the correct looks like this:
[gdoc key=”https://docs.google.com/spreadsheets/d/1DmdR0KlN3N3byIqlCvMguYO90snmztsUUlf2SIyOn-Y/pubhtml”%5D

It works fine for me.

Connection error could be caused by lots of reasons:
(IP which is IPv6 type, belongs to Google servers)
? Google servers were unreachable, what is almost impossible.
? Something in your website interfaces and block this specific connection, sounds weird…
? Your hosting company or your server setup either blocks or doesn’t support IPv6 protocol, possible but kinda weird why at all it’s calling IPv6.
? There is bad configuration and server could not establish any outbound connections.

So these examples are possible and no one can say what exact happened. Who know might Google were updating it’s services. ??
(However if it repeats is something on your end)

Why it’s marked as resolved?!

I have read it including given references again. And now I do understand why we couldn’t understand each other (first four posts). I believe you treated me as somebody who are experienced with the WordPress and coding and while I’m not – your answers (links to documentation) was totally worthless as I just haven’t faces such thing before. Also WordPress references is more less hard to understand as English is my secondary language. No offense on that, for others that would be all what they need but not for newbies. So big Thanks again! ??

Your tutorial was very informative and it, I believe, is helpful for lots beginners.
However I have some questions as I’m trying to fully be clear with the code:

? You used $scripts because it “is just a self-explanatory name” or because you have used such variable writing your plugin (I have looked at the plugin’s files) or it has nothing to do with what you wrote in plugin?

? I’m not sure exactly what is array – is it true to say it is like a library for variables, but on the other hand I know that we can assign anything to $randomword just describing in code page or assigning with the form… I’m confused with this thing but as you said, there is a lot lessons on the Internet so you don’t have to answer.

? Is it right to say that this function takes array (let’s say it library) and let go everything on it except our “unset”?

“I wrote that all out so that it is archived in this forum. Now people who want an example no longer need to ask me for one, they can just read this.”
That’s very smart.

Also I notice that on FAQ page at the very end there is such example I was asking, so it’s my bad I wasn’t focused enough to see it considering it was there for a while.

Earlier I have mentioned that I want two more functions.
? Plugin load only if tag is used, because leaving table and it’s responsive ability cause additional 4 resources to load every time.
? Add defer function to decrease load time for page. Now it has over 3000 rows and takes additional ~23 seconds to load (excluded server response time).
https://www.sperohub.io/games-monetization-database/

So for second I included datatables_defer_render=”true” datatables_defer_loading=”true” in the shortcode:
[gdoc key="https://docs.google.com/spreadsheets/d/16qXL4U92CwMa5QdAIS1tyTKDQNrINo0uvk6dvu10XBI/pubhtml" class="FixedHeader-top" datatables_page_length="25" datatables_defer_render="true" datatables_defer_loading="true"]
As it’s only what I found just reading Other Notes documentation but it does zero influence to load…

But datatables page gives such example:

$('#example').dataTable( {
  "ajax": "sources/arrays.txt",
  "deferRender": true
} );

Source

Assuming either way I need to add something to functions.php for shortcode to work or just add to plugin options something should be changed.
I would change #example to #igsv-MY_TABLE_KEY, right? Also table key is complete URL included in shortcode?
Then what I have to do with ajax?
Documentation says:

when DataTables loads data from an Ajax or Javascript data source

Hmmm… that’s not okay, I need use sheets as source?

Coming back to first function – load plugin only with shortcode:
I have read a lot examples and WordPress guides and it looks like I should edit plugin code? So before going further am I wrong? Maybe this also added though theme functions.php?

Wow, Man, you put a huge smile on my face!

I have read once and will read more to understand and have some questions, but now it’s very late. ??

Don’t get me wrong, I don’t ask and want you to do everything for me. I did read and did tired placing those codes in plugin options, plugin main file, however nothing. I’m not a programmer so when learning I need to see at least one custom example. ??

Start from scratch:
Let’s say I want totally remove pdfmake: URL: https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js
https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js

So I write “gdoc_enqueued_front_end_pdfmake” and “gdoc_enqueued_front_end_pdfmake-fonts”.
Where to place for them to work?

// or I write:
wp_enqueue_style( $handle="gdoc_enqueued_front_end_pdfmake",  $source="false", $dep array(https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js), $ver = false, $media = 'all');
// or maybe just:
wp_enqueue_style( 'gdoc_enqueued_front_end_pdfmake' );

Ok, but could you please give me at least one example? Now I have no idea where to place that code.

Also Documentation would be really useful only if you could example for every other topic. For example, since “DataTables customization options” I have no idea how to insert defer function which is very needed as already loading only 3k+ rows slows down page considerable a lot…

??

I see, thanks for all above anyway. ??

Sorry for that dumb question. I’m trying to insert it to page, so everything looks almost fine except it changes the whole page.

I believe this part should be adjusted to specific rows (which contain: Yes)
$<strong>( "div:contains('Yes')" )</strong>.css( "color", "green" );

When what should I put instead div, to affect only those rows? ??

(I did not saw your last post before posting this out, however that doesn’t change much)

Okay, could you, please, explain what code write to DataTables defaults object box (this is only table I’m using plugin for)? Or should I write it somewhere else? ??