Unable to Edit Table & Save on Auto Import Data

Hi,

thanks for your post, and sorry for the trouble. Also thanks for the video, this really helps a lot!

So, from what I can see, we are facing two distinct issues here. Let’s fix that second one, the UI not doing anything, first:

For that, please go the “Modules” screen and click the “Save Changes” button at the bottom (no actual changes need to be made, just clicking the button is enough). That will clear some internal caches, which have run stale and lead to a JavaScript problem here, it looks like.

Now, for the import: Unfortunately, the “Publish to Web” link from inside Google Spreadsheets is not the correct one. This will create HTML output which however has that extra first column and first row. Instead, we’ll need to use the public CSV export URLs from Google Spreadsheets. To get that please use the “Share with others” menu item in the spreadsheet. This should give you a public sharing URL like

https://docs.google.com/spreadsheets/d/.../edit#gid=0

(with a letter/number string in the middle). The, please modify that to

https://docs.google.com/spreadsheets/d/.../pub?output=csv

If you then open that URL in an “incognito”/”private browsing” tab in your browser (so that you are not logged-in to Google), you should directly get the table data in the CSV format). That URL is then what you’ll have to use for the automatic import. Could you please try that?

By the way: As a TablePress Max user, please feel free to email via to the address on the “About” screen of TablePress, to get direct personal email support ??

Best wishes,
Tobias

Thank you sir. You are a genius.

Your second solution didn’t work for me exactly as you had it as I have multiple tabs on my sheet, but I was able to send the data as csv (which was the missing link for me as, as you correctly stated, I was exporting the auto update via web rather than csv, which my original table creation was set up as).

So essentially, the flow that worked for me was to share the tab under Publish to web, set it as csv, copied that url and created my table using it. Then I went to the auto import and pasted the same url into the appropriate field there, and now all is working as it should ??

Thank you. Love your product and it has saved countless hours of tedious data manipulation ??

Hi,

ah, my bad, I had missed that you had multiple tabs. Indeed, that uses another URL parameter then, which is added by that Share to Web dialog then. Great to hear that you found this!

And thanks for the kind words, I really appreciate it ??

Best wishes,
Tobias