Table based on published Google Spreadsheet fails to update

  • Resolved ecoevolver

    (@ecoevolver)


    10 years, 9 months ago

    Hi TablePress users,
    I’m retrieving data stored in a published google spreadsheet. If I import the data into a new table, I paste the URL to the google spreadsheet, and everything works perfectly.

    However, if I update the google spreadsheet and republish it, the data in the table doesn’t update. Any ideas about why that is?

    Thank you!

    http://wordpress.org/extend/plugins/tablepress/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    10 years, 9 months ago

    Hi,

    thanks for your post, and sorry for the late answer. As I was on vacation, I didn’t have a chance to reply earlier.

    The reason for this is that TablePress will only do a one-time import. There’s no steady connection to the Google Spreadsheet file, so that that will not be imported again when it changes.

    You will either need to import it again (and choose the “replace” option), or you could try the TablePress Extension from http://tablepress.org/extensions/table-auto-import/ that will periodically re-import the table.

    Regards,
    Tobias

    Thread Starter ecoevolver

    (@ecoevolver)

    10 years, 9 months ago

    Hi Tobias,
    Thank you very much for the suggested solutions.

    One further clarification question. If my source is a published google spreadsheet with a fixed URL for the .csv data, will the “table-auto-import” work? Not entirely clear if that is the case.

    Cheers,

    Plugin Author TobiasBg

    (@tobiasbg)

    10 years, 9 months ago

    Hi,

    yes, that’s correct. If you configure the Auto Import Extension with that fixed URL, the periodic import should work just fine.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Table based on published Google Spreadsheet fails to update’ is closed to new replies.