I’ve found your premium extension “Automatic Periodic Table Import” and I’m trying to get it to work. We’re hoping to be able to have a Google Drive spreadsheet updated by specific staff members, then have the auto table import happen every 15 minutes or every hour.
My issue is finding the correct URL for the CSV file. I set the permissions for the file so everyone can view the file, but only specific people can edit. (The Google Drive spreadsheet is here.)
I tried a simple import first, but again, I have no idea of the proper URL. TablePress failed the import since it was not a recognized file. Of course, I can download the file and upload the CSV the “old way” and it does work.
I’ve also tried using Dropbox, which seems to have a URL with a .CSV extension. You can access that file here, but that did not import correctly either.
Straight, standard iFile Upload works with no issue for this CSV file, and it pulls in the correct HTML in the cells.
I think a solution would be to provide them access via FTP to upload a CSV on a web server, but that involves more steps. Preferred solution would be for them to just log into Google Drive (they use that all the time now) and upload the file there, and have the table auto-update in 15 minutes or an hour.
- The topic ‘Auto-Import Google Drive Spreadsheet’ is closed to new replies.