TablePress-Extensions: tablepress-table-auto-update

Hi,

thanks for this information!

Looks like the Extension is using a function that is not available at all times.
I’ll fix that and release a new version. I’m actually already working on the Extension, as it will be getting a user interface, so that it’s no longer necessary to edit that tables.php file ??

Regards,
Tobias

Hi Tobias:

Thanks for the reply. Much appreciated.

Look forward to the update extension.

I’ll be more that happy to test it out and provide feedback.

Regards,

GolferDude

Hi,

thanks, great to hear that! ??

I’ll let you know here once the next version is ready.

Regards,
Tobias

Hi,

good news: I was able to fix that problem, and also implemented a nice user interface, so that manually editing that tables.php file is no longer necessary ??

I’d be more than happy if you would test the new version. To do that, please
1. Deactivate the current version of the Extension (in case it is still activated).
2. Download the new version from https://tablepress.org/download/extension/tablepress-table-auto-update.zip and replace your current version with that.
3. Activate the new version.

You will then see the user interface in the lower part of the “Import” screen. You can activate auto import for each table individually there and make the necessary settings. Additionally, you can use this screen to check when the last auto update happened.

Please let me know if you have problems!

Regards,
Tobias

Hi Tobias:

Thanks for the update.

Deactivated and deleted the old extension

Installed and activated. the new one

Unfortunately the Import Tab/Import a Table Menu does not load when this extension is activated.

Tried it with Chrome and Opera browsers

I deactivated the extension and now the Import tab works.

regards,

GolferDude

Hi,

thanks for testing this. Not sure what I did wrong this time…

With “does not load”, do you mean that it is completely white?
That indicates that there’s a PHP problem somewhere.
Can you please try again after setting the “WP_DEBUG” constant to true in your wp-config.php file? After that, there should at least be an error message visible on that page.

Thanks!
Tobias

Hi Tobias:

Yes, the page is completely white.

Here’s the message (after WP-debug enabled)

Fatal error: Call to undefined method TablePress_Auto_Import_View::process_action_messages() in xyz/plugins/tablepress-table-auto-update/view-auto-import.php on line 42

Hope this helps.

GolferDude

Hi,

argh, of course… I’ve been developing the Table Auto Update Extension while already using the current development version of TablePress. And I’ve used a function that is not yet part of TablePress 0.8.1-beta, which you are using.

So, to use the Table Auto Update Extension, one more step is necessary:
First, download the current development version of TablePress from https://tablepress.org/download/tablepress-dev.zip, extract it, and replace the folder on your server with this new one.
Then, download https://tablepress.org/download/extension/tablepress-table-auto-update.zip again (I added another feature this morning: You can now choose how often the auto update shall happen.) and re-install that.

If you don’t see any errors then, you can also set WP_DEBUG back to false.

Regards,
Tobias

Hi Tobias:

Sorry for the delay in getting back to you.

The Auto Update extension now works great.

The new UI to select the update interval is brilliant.

AMAZING plugin and great support.

I have an automated task that creates and updated CSV file every night and uploads to my host.

Now with the TablePress plugin this data is published automatically.

Thank you very much.

Best Regards,

GolferDude

Hi,

ah, that’s great news ?? Thanks for testing this! Good to hear that it works, and that you like it ??

Best wishes,
Tobias

P.S.: In case you haven’t, please rate the plugin here in the plugin directory. Thanks!

Hello again Tobias! Can you perhaps add a force update button that the user can press? Is that doable? Also, I think I need the auto updating to be lesser than 15 mins if possible ??

Hello Tobias I am sorry if I am asking question after question. But I think my Auto update extension isn’t working.

I have the URL that points directly to a csv file. I even imported a table using the URL import method and it worked with the same URL. Now I also used the said URL in the auto update configuration and 23 mins have passed not even a single auto update triggered.

Any thoughts on how to check what is the problem?

Hi,

thanks for your question.

A “Force update” button is not really necessary, as an update is triggered every time that the configuration is saved. So that’s basically a “Force update” button.

To have the auto update take place in shorter intervals, you can simply modify the code of the Extension.

Now about the actual update process: The Extension uses the WP_Cron functionality to trigger the update check, i.e. the check whether the interval has passed. This WP_Cron method requires users visiting the site, as then a page view triggers the code for the check.
What you describe is therefore the expected behavior for sites on local test servers or “new” sites that don’t have regular visitors. If nobody visits the site, no update is performed.

Regards,
Tobias

I see.. how can a new site manage to trigger the auto update? Do I have to update the table manually first and wait for the site to get about a handful of regular visitors for the trigger to happen? Because currently the site is getting about 2 visitors? me (the admin) and a friend. ??

Also you mentioned that whenever the configuration is saved, the tables get updated? Is this true even if I have a “new” site?

Hi,

you could also set up a real server cron job to replace the WP_Cron functionality. That would give the best results.

A quick search found these tutorials:
https://wpdailybits.com/blog/replace-wordpress-cron-with-real-cron-job/74
https://bitswapping.com/2010/10/using-cron-to-trigger-wp-cron-php/
I have never done this before though, so I can’t help with specifics.

Regards,
Tobias