Cannot import table from this site

Hi,

thanks for your question, and sorry for the trouble.

I can confirm that this source does not import 🙁 Unfortunately, I don’t really know why, it seems that the server is not sending proper return types.
In addition to that, this is actually not a JSON format that TablePress expects, it’s more of a key/value format than a table format. This is by default not supported, I’m afraid.

Regards,
Tobias

Hi,

then the reason most likely is that they either changed the responses from their servers or the format :-/

Regards,
Tobias

Hi,

no, sorry, offering XML import is not something that I’m considering at the moment. Most public API services are moving away from it, in favor of JSON, and it would require specifying how to map the XML fields to a table again. This is not really feasible and it would not offer any flexibility at all. Thus, there’s simply no benefit here.

The best way to import data from such different sources would be to write a custom importer that converts the data to e.g. JSON, which TablePress can then import.

Regards,
Tobias

Hi,

wow, that is indeed an absolutely stupid response! And even if it where insecure that would never affect their product…
I hope that you can maybe convince them otherwise.

Best wishes,
Tobias

Hi,

that could indeed be a neat trick.
Doing this should be possible by using a WP filter hook and e.g. placing this in your theme’s “functions.php” file:

add_filter( 'http_headers_useragent', 'snezhko_change_http_user_agent' );
function snezhko_change_http_user_agent( $user_agent ) {
  $user_agent = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.28 Safari/537.36';
  return $user_agent;
}

Of course, you can set any user agent there.

Regards,
Tobias

Hi,

no problem, you are very welcome! 🙂 Good to hear that this helped!

Best wishes,
Tobias

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

HI David,

if at all, TablePress would only import the first table on that page, but even that might be problematic, due to the combined cells in the first row. Can you therefore please try if importing from this URL works if you use the regular “Import” screen and perform a manual import (instead of using the Auto Update Extension)?

Regards,
Tobias

Hi David,

how exactly is it not working? Are you getting error messages?
What’s the import source that you tried?

Regards,
Tobias