Sync to GoogleSheets-hosted XLSX file
-
Hi, I’ve been working with wpdatatables and I’m quite happy with it overall. One thing I was hoping was that I’d be able to sync tables from Google Sheets without having to publish them.
After a few times trying different solutions, I gathered actual GoogleSheets work fine with the GoogleSheetsAPI solution your documentation mention, but trying to sync data from a GoogleSheets-hosted XLSX file (shared with my appropriate API account) gets me a “Bad Request” notification from the plug-in, and nothing is imported.
I really prefer XLSX files over GoogleSheets files, for backup reasons, so it would be ideal to be able to sync that way. I am still able to sync local XLSX imported on my website, but it would be much better for me to be able to edit my sheets both online and on my computer.
Is there any solution for this, or any plan to make such a solution or add OneDrive support for auto-sync tables?
Thank you very much ??
-
Hello.
When it comes to data source as XLSX file ( and other Excel formats),
in our Lite version we have the option to link the data source to output the dataTable. We will elaborate in more details :When we Create a table linked to an existing Excel file,
if you choose to Create a wpDataTable and upload the Excel file to the WordPress Media Library:
in this case you get to select the file (upload it) that’ll be used to pull the data.
This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder.
The file on that location can be changed/edited, but the column structure can’t.
So, if you have the file with the same name,
the same number of columns, same headers, and the same order of columns – you’d be able to replace the original file with the new file, and wpDataTables would pick that up.
–
Alternatively, if you select “URL from any domain”,
Creating a table linked to an Excel file by providing its URL is pretty much the same as it is for creating a table by uploading an Excel file.
The only difference is that you would choose the URL from any domain option instead of the WordPress Media Library option under File location when creating the table,
and when you want to edit the source file, you don’t have to edit the one that is now in your Media Library folder,
but you can edit on the original source file.
Please note:? For the option of “URL from any domain”,
this source file needs to be accessible online in order to create a table from it, and the path to the file has to end with the file extension, for example, with “.XLSX” or other Excel formats.
If the URL path to the source file does not end with a dot followed by its extension,
it will not work.
–
In regards to OneDrive as data source, at the moment, as you know, that is not possible, and we can’t promise an exact ETA if or when it might be added.
You can certainly add a development suggestion for us – and our devs will do their best to work on this as soon as possible.Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you’d like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you’re informed about new features, bug fixes, freebies, etc.
Kind regards.
- The topic ‘Sync to GoogleSheets-hosted XLSX file’ is closed to new replies.
