Well, all these spreadsheets indeed have no rows. You have only the first row, which is used to generate table headers, so that's why you receive messages that "table in data source contains no rows".
You need to have at least one row below the header section in order for the plugin to pull the data from the spreadsheet.
I don't know what you're trying to do, but if you Create tables linked to Google Spreadsheets, you will not be able to edit those tables from wpDataTables, so you will need to fill it using Google Spreadsheets anyway.
If you're importing Google Spreadsheets, the data source will be read once to create the table, and a manual table will be created, but it will no longer be linked to the Google Spreadsheet, so you can create manual tables in the plugin, no need to go through empty Google Spreadsheets.
I'm also getting the same problem. For some reason, Data Tables licence code was deactivated on my site and the tables stopped working. I have no idea for how long. Now when I try to add back in, I get this error message. And I can't find a way to fix it.
Hey.. i keep getting troubles with importing google sheet..
i keeps getting this error:
Table in data source has no rows.
and ive tried un-installing the plugin.. didnt work. tried making new sheets didnt work.. can you help?
Hello Max
Thank you for your purchase.
Can you please share the URL to that Spreadsheet with me, so I can take a look?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
i want to add the following sheets
https://docs.google.com/spreadsheets/d/1NyKtcMmZ_1XJ81D57Vf7avouxzdgL0GcH0U_wsD9ja8/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1RigVpAHkmxPwVaS_3L-dR_zFWTlBjgm0NCjhH7CuinE/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1LbLzYrQdRVotYMPl5xiF8wNV5NFRXdodGwdJE_IGg4M/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1E5blMi-AGLcQm6N-_yXQk7fo3Q8ORw9NoXgoFjk05lg/edit?usp=sharing
thanks for your quick reply!
Hello Max
Well, all these spreadsheets indeed have no rows. You have only the first row, which is used to generate table headers, so that's why you receive messages that "table in data source contains no rows".
You need to have at least one row below the header section in order for the plugin to pull the data from the spreadsheet.
I don't know what you're trying to do, but if you Create tables linked to Google Spreadsheets, you will not be able to edit those tables from wpDataTables, so you will need to fill it using Google Spreadsheets anyway.
If you're importing Google Spreadsheets, the data source will be read once to create the table, and a manual table will be created, but it will no longer be linked to the Google Spreadsheet, so you can create manual tables in the plugin, no need to go through empty Google Spreadsheets.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I'm also getting the same problem. For some reason, Data Tables licence code was deactivated on my site and the tables stopped working. I have no idea for how long. Now when I try to add back in, I get this error message. And I can't find a way to fix it.
Here's the google spreadsheet
https://docs.google.com/spreadsheets/d/1XNCugbol0zw4NeEyS-DKLSRGGzJBzRA96R08lvI9y1s/edit#gid=397470142
Even tho i filled in the rows for example now.. still doesnt work for me. it gives me the same error
https://docs.google.com/spreadsheets/d/1NyKtcMmZ_1XJ81D57Vf7avouxzdgL0GcH0U_wsD9ja8/edit?usp=sharing
Hello Max
I used the spreadsheet you provided, and created a table without any issues (see attached screenshot).
Having the license active does not affect the tables.
Please open a private ticket, where you can provide us with a temporary wp-admin user, and we'll gladly check your website.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I had to delete the plugin via FTP, upload, deactivate and activate again.
That made it work.
But it's probably been offline for a long time and I missed it. Not good.
Do you recall making any structural changes to the source files?
If you add, remove, rename or reorder columns in the Google Spreadsheet file, the wpDataTable created from this source will break.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables