I tried publishing to web but the options may have changed since you built the tutorial. Now the default format to publish to the web is just an html file and creates this link:
But this just hangs wpdatatables on the preview (doesn't give an error though).
Other choices are csv, tsv, pdf, xlsx, and ods. In your screen shot you don't show the extra dialog box that has all the options.
I am referencing the same Google Doc spreadsheet successfully in the WordPress Google Spreadsheet Inline Viewer. The link I'm using successfully there is this:
I've just created a page using a google spreadsheet and have it working fine. File > publish to web > "entire document" & "webpage" > publish. I believe this is what you did as well as my link produces a similar page. It works fine for me though.
Thanks! Yeah, it's weird. After I paste the link the correct columns all show up for me down below on the page where I set up the wpdatatable and customize what I want for the columns, so my guess is that at least this part of wpdatatables is having no problem reading the published Doc, but when I hit preview it just hangs.
After watching the video version of the tutorial I know now that the pubhtml format is the right format for wpdatatables so the errors I was getting when trying to reference the Google Doc directly are no longer relevant, so I'm okay on the errors, but I still don't have a table that works correctly.
Since the preview was hanging I also tried creating a test page where I just referenced the wpdatatable and tried viewing it. What I got there was a blank page.
Please provide me the ID of created table and a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check PRIVATE so nobody can see it except us.
I have tried to create table from your spreadsheet and now it's working. After every update you will have to add this line of code because it will be overwritten.
Hi!
I'm trying to create a wpdatatable from a Google Doc spreadsheet. I ran through the tutorial you had on your website here:
http://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/
for doing this but get an error when trying to preview the wpdatatable:
wpDataTables backend error: Failed to connect to 2607:f8b0:400f:802::200e: Network is unreachable
The Google Doc spreadsheet's URL I'm trying to reference is here:
https://docs.google.com/spreadsheets/d/1fp5nlJe0J-Ojp91fAzLz1mDx6IkxrUsI1wCK6A-NO1A/edit#gid=0
I tried publishing to web but the options may have changed since you built the tutorial. Now the default format to publish to the web is just an html file and creates this link:
https://docs.google.com/spreadsheets/d/1fp5nlJe0J-Ojp91fAzLz1mDx6IkxrUsI1wCK6A-NO1A/pubhtml
But this just hangs wpdatatables on the preview (doesn't give an error though).
Other choices are csv, tsv, pdf, xlsx, and ods. In your screen shot you don't show the extra dialog box that has all the options.
I am referencing the same Google Doc spreadsheet successfully in the WordPress Google Spreadsheet Inline Viewer. The link I'm using successfully there is this:
https://docs.google.com/spreadsheets/d/1fp5nlJe0J-Ojp91fAzLz1mDx6IkxrUsI1wCK6A-NO1A/edit?usp=sharing
but that didn't work correctly for wpdatatables either.
Thanks for any help!
Mike
I've just created a page using a google spreadsheet and have it working fine. File > publish to web > "entire document" & "webpage" > publish. I believe this is what you did as well as my link produces a similar page. It works fine for me though.
Thanks! Yeah, it's weird. After I paste the link the correct columns all show up for me down below on the page where I set up the wpdatatable and customize what I want for the columns, so my guess is that at least this part of wpdatatables is having no problem reading the published Doc, but when I hit preview it just hangs.
After watching the video version of the tutorial I know now that the pubhtml format is the right format for wpdatatables so the errors I was getting when trying to reference the Google Doc directly are no longer relevant, so I'm okay on the errors, but I still don't have a table that works correctly.
Since the preview was hanging I also tried creating a test page where I just referenced the wpdatatable and tried viewing it. What I got there was a blank page.
Hi Mike,
Thank you for your purchase.
Please provide me the ID of created table and a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check PRIVATE so nobody can see it except us.
Hi Mike,
This issue is sometimes happens on websites that are using Bluehost.
I have added one line of code in file ../wp-content/plugins/wpdatatables/source/class.wdttools.php on line 67
I have tried to create table from your spreadsheet and now it's working. After every update you will have to add this line of code because it will be overwritten.
You can take a look at wpDataTable with ID 2 and on this draft page: http://mikesandrik.com/?page_id=614&preview=true
You should delete table with ID 1 and create it from scratch or rename table with ID 2 because I used this file - https://docs.google.com/spreadsheets/d/1fp5nlJe0J-Ojp91fAzLz1mDx6IkxrUsI1wCK6A-NO1A/pubhtml - to create table with ID 2.
Thanks Milos, this is great! I took a look at php file and know where to add it. I have the wpdatatable up and running on my site.
Thanks for the great help!
Mike
Hi Mike,
You are welcome. We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
Done!
5 star review.