fabacab/inline-gdocs-viewer

:bar_chart: Feature-rich WordPress plugin integrating Google Spreadsheets, Google Query Language, Google Charts API, and jQuery DataTables using a shortcode.

inline-gdocs-viewer's Issues

Save as PDF adds "Facebook" to title

When saving the table to a PDF doc, it automatically adds the word "Facebook" to the title of the document.

Optimize memory usage when parsing CSV data into HTML tables

See this post on the support forums.

Support `chart` attribute for SQL datasources

https://wordpress.org/support/topic/charts-only-with-google-spreadsheets?replies=2

`vistable.php` class is incompatible with PHP 7

See https://wordpress.org/support/topic/not-compatible-with-php-7-0-7/

Bundle third-party resources into the plugin itself

This is both a new WordPress plugin requirement and a best-practice, anyway.

See also https://wordpress.org/support/topic/parser-blocking-cross-origin-script-2/

Support the Responsive plugin's own configuration options in the shortcode.

See https://wordpress.org/support/topic/controlling-child-rows-by-column/

Feature request: Specify summary row (last row) of spreadsheet

Would it be possible for the plugin to allow you to specify a summary row in the same manner it allows you to specify the number of header rows? I believe a WP forum member mentioned something similar in Suggestions for future versions, but they were asking about a single cell. As long as the summary row remained at the bottom of the spreadsheet, is this feasible?

Update all DataTables dependencies to its latest versions

I'm having a lot of trouble with the responsiveness of the generated tables as setup by Inline Gdocs Viewer. A quick look in the source code revealed that the DataTables plugin files haven't been updated in nearly 3 years! Please see for yourself

Please update all files, so that the dataTables plugin will behave better.

Zero results against a MySQL query should allow the user to hide the error

See https://wordpress.org/support/topic/hide-error-message-when-returning-a-null-data-set/

Include ColumnFilterWidgets for DataTables

See https://wordpress.org/support/topic/how-about-filters/#post-8635529

Stylesheet formatting being ignored

For some reason the odd rows will always show the pale blue look, no matter what I have tried. The following 2 lines below were added to both attempted in the theme template and within style tage in the page itself just before the gdocs call. I am at a loss for trying to figure out how to get this blue hint removed.

.members .row-3 {background-color:#eee}
.members tr.odd {background-color:#eee}

http://importchallenge.com/standings/

Hyperlinks Not Displaying

Hyperlinks I have set up in my Google Docs spreadsheet are not displaying. Can you create a patch to include this feature?

Formatting two or more columns together?

Hello! I was very excited to discover this plugin and can't wait to see what my org does with it. An example of the type of thing I'm hoping to do is turn long, difficult to maintain lists like this list of city projects and this (inaccessible!) one for meeting minutes into nice tables.

So far I've got a table, but can't figure out how to format columns quite the way I want. I'd like to be able to take a few columns-- say date, label, and link-- and make them into one column that is something like <a href="the link">{date} {label}</a>.

It seemed like the query API could work but even the most basic query I tried returned an error.

What's the best way to go about this? Do you have any examples for a query?

Feature Request-Hide source Code

In the source you can see the table id for the google doc key.

Any ideas that you know of to possibly hide this data?

I'm offering a page for paid members  of my site, and don't want them to have easy access to my doc.

Any help that you can think of would be great.

WordPress throws error when trying a page with a gdoc query shortcode

Hi,

first of all, I'll quickly state my specs. My site is running on:

• PHP 7.2.29 (Apache)
• WordPress 5.3.2
• the following plugins: Contact Form 7, Events Made Easy, NextGEN gallery, ShortPixel image optimizer, W3 Total Cache, WP-Optimize and Yoast SEO.. and Inline Google Spreadsheet viewer of course. Version 0.13.1

I am an administrator of the website and I've enabled the possibility to SQL query in the settings. However, when I want to insert the [gdoc] shortcode in a normal page, things go awry.

• All goes well when only using [gdoc] shortcode itself
• The moment I want to query with either [gdoc key="wordpress"] or [gdoc key="mysql"] and I want to save the page, a red alert appears, saying: 'The response is not a valid JSON response'.

Checking the POST call WordPress makes when clicking the save button and it returns the following error:
<h1>Error thrown</h1><p>Call to a member function has_cap() on boolean</p>

if the value stored in first row/first column of the google spreadsheet is “0” (number) then it doesn’t retrieve any data from the query

See https://wordpress.org/support/topic/found-an-issue/

Charts are not compatible with 4.9.1

I tried to load up charts of any kind under 4.9.1 and it would not display at all.
Tables are working fine.

"if I pass UTF-8/Unicode string in a SQL query" then "it doesn't work"

See https://wordpress.org/support/topic/found-an-issue/

Support point-and-click "server-side processing" in DataTables

https://wordpress.org/support/topic/search-bar-slowness-pushing-the-limits?replies=2

Sheet with ID `0` inaccessible when it is not the left-most (first) Sheet in a workbook

See https://wordpress.org/support/topic/google-sheet-order-stops-plugin-to-work/

How to turn off headers

I am able to select the data, but it shows more than I needed, how can I turn off the displaying of headers such as "[Column] [visibility] [Copy] [CSV] [Excel] [PDF] [Print] [Show] 102550100 entries Search:, etc and only show my cell?

Thanks,
K

Hypertext showing as URL

Hi,

I've seen this requested by a user on your blog, but not sure if it was actually actioned as a formal request here.

Inline gdocs viewer has been a god-send for my cricket blog, am looking to integrate the spreadsheets I have with Wordpress. The site is under construction, but the page I'm working on at the moment is here:

http://calypsocollapso.info/?page_id=262

The spreadsheet this is based on, and which is pulled in with your plugin is:
https://spreadsheets.google.com/ccc?key=0AvjqINNotWwUdFhCTFhWaWpkSDVmUDJFTlVSUWF0YXc&hl=en

My request is for the Hyperlinks in Column A (the Names) to be clickable on the webpage.

Thank you, Stuart Wales

https://spreadsheets.google.com/ccc?key=0AvjqINNotWwUdFhCTFhWaWpkSDVmUDJFTlVSUWF0YXc&hl=en#gid

Support retrieving PNG images of charts

See https://developers.google.com/chart/interactive/docs/printing

Via https://wordpress.org/support/topic/please-provide-zoom-option-download-as-image-option/

Support Google Data Queries as shortcode attribute

Could Data Queries be applied prior to spreadsheet retrieval as well?

(via)

Reference chart settings externally so a single setting can be applied to multiple charts

See https://wordpress.org/support/topic/making-plugin-easier-for-future-changes