Trouble getting Auto Update to work

  • Resolved cjholdsworth

    (@cjholdsworth)


    3 years, 9 months ago

    Hello,
    I have a Google sheet that auto updates with data on gold prices. It is working fine and I have set it to publish to the web and it’s accessible to anyone with the link.
    I have installed TablePress and Auto Update extension 1.3
    But I can’t get the plug-in to auto update. It is set to update every 15 minutes.
    I’ve added the export?format=CSV to the end of the url name (replaced the edit…), set the format to CSV and source to URL. But the ‘last auto import’ column stubbornly stays with a -.
    A manual import (to replace) works fine.
    Is there an error log I can check somewhere? Even just to confirm it’s failing, but at least trying.
    I’ve read the help and the forum previous issues. I don’t really understand CRON jobs? I’m very new at this and the plug-in has only been running a couple of hours, I’m sure we don’t have heaps of traffic, maybe it just needs that to work?
    (A ‘force update’ button in the plug-in import section could be a good addition, to help with issues!)
    Thank you!
    Chris

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    3 years, 9 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    If the manual import via that URL works, and if you directly get a CSV file when going to that URL in the browser, the import source is not the culprit here. More likely, it will indeed be something with the WordPress Cron system (see e.g. https://developer.wordpress.org/plugins/cron/ for technical details).
    Unfortunately, debugging this is rather tricky (I’m working on finding better ways for this), because the cron execution runs asynchronously, i.e. separately from the current request.
    My recommendation would be to look into this with the available WordPress Cron plugins (from the links that you already mentioned), and to set up a real server cron job for better reliability (you will not be dependent on active site visitors then).

    Regards,
    Tobias

    Thread Starter cjholdsworth

    (@cjholdsworth)

    3 years, 9 months ago

    Thank you. I will look in to this. The table did autoupdate overnight, so it must be to do with site traffic.
    Thanks for your help!
    Chris

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    3 years, 9 months ago

    Hi,

    yes, if the auto import ran over night, this indicates that some site traffic caused this 🙂 For better reliability, that mentioned server cron job might help.

    And regarding that “force update” button (forgot to answer that in the first reply — sorry): Normally, the “Save Auto Import configuration” button should do that, as it kind of “resets” the cron configuration. I’ll have to check this to maybe find a way to also make that more robust…

    Best wishes,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Trouble getting Auto Update to work’ is closed to new replies.