I can't autoupdate table using url about tablepress HOT 8 CLOSED

Hi @iamkanp,

thanks for your post, and sorry for the trouble.

Does the import from that URL in JSON format work with a manual import (i.e. on the "Import" screen)?
Does everything work with e.g. a CSV file?

Note that TablePress can only import its own JSON format, but no arbitrary JSON formats. Can you therefore maybe give me the URL of the file that you are trying to import?

Regards,
Tobias

from tablepress.

Hi @TobiasBg ,
Could you send me your email (my email is [email protected])? i will give you that url. Sorry for inconvinience
I try it manually. it works and also, i just create a php file that echo the json. it works as well.
just failed when getting from url directly. Is there any problem with time delay when the server querying data?
Regards,
Kan P.

from tablepress.

Hi @iamkanp,

thanks for the link! I have tested your URL on my site (with the manual import), and that is working fine. The JSON format is correct, too.

Because of that, I can only assume that your server is not properly connecting to the URL, for some reason. One reason might be that it's a Punycode/internationalized domain, or that it takes quite a while for the URL to return the content.
Unfortunately, finding out the exact cause is beyond what I can help with here, as the issue very likely is on the server level :-(

Regards,
Tobias

from tablepress.

from tablepress.

Hi,

yes, it's the same code for the import. However, there are same differences in the background, that could play a role. For example, as the auto import uses the WP Cron feature, it runs as a non-logged-in user in WordPress. This could result in different parameters being used, for things like memory limit or HTTP requests. The developer tools in Chrome will not help with this, you would have to directly add debugging/testing to the PHP file of the Extension. Then, instead of relying on the cron job to run, you could use plugins like https://wordpress.org/plugins/core-control/ to manually run the import cron job.

Now, trying the auto import with a direct file import (from the server) could of course also work, but you would have to test it (first with a static file maybe).

Of course, if your PHP script runs on the same server as the WordPress installation, and if it has access to the database, you could directly update the data in the database.

Regards,
Tobias

from tablepress.

from tablepress.

Hi @iamkanp,

any new findings here?

Regards,
Tobias

from tablepress.

from tablepress.