HTML tables and SQL queries

  • Resolved Mads Phikamphon

    (@madsphi)


    10 years, 11 months ago

    Hi,

    1) On the description page it says that HTML tables can be imported. Does that mean that my normal HTML tables in posts/pages are automatically converted to Tablepress? (it would be awesome if the plugin does that).

    2) Can the table data be based on SQL query, so I can fill the table based on the results of a SELECT SQL query.

    Thanks,
    Mads

    https://ww.wp.xz.cn/plugins/tablepress/

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

    (@tobiasbg)

    10 years, 11 months ago

    Hi Mads,

    thanks for your post, and sorry for the trouble.

    1) No, those tables will not be converted automatically, but you can import the HTML code into TablePress manually and then replace it with the Shortcode of the imported table.

    2) Sorry, but I’ll have to disapppoint you here. TablePress does not support making SQL queries, it uses a custom data storage.

    Regards,
    Tobias

    Thread Starter Mads Phikamphon

    (@madsphi)

    10 years, 11 months ago

    Thanks a lot for the reply.

    1) That’s fantastic. Then it will not be a problem at all.

    2) Guess I can use CSV instead. Will the table contents change automatically when the data in the associated CSV change?

    Thanks again,
    Mads

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    10 years, 11 months ago

    Hi,

    yes, you could import CSV files, by either uploading them or retrieving them from a URL. The table will however not update automatically when the CSV file changes, it’s a one-time import. You can of course import the file again and replace the existing table.
    Doing this in an automated fashion is also possible with a TablePress Extension (see https://tablepress.org/extensions/table-auto-import/ ) but in most scenarios where tables rarely change, that would be overkill.

    Regards,
    Tobias

    Thread Starter Mads Phikamphon

    (@madsphi)

    10 years, 11 months ago

    Thanks.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    10 years, 11 months ago

    Hi,

    no problem, you are very welcome! 🙂

    Best wishes,
    Tobias

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

The topic ‘HTML tables and SQL queries’ is closed to new replies.

Tags