Create Table from Another Table

  • Resolved jaredtwilcox

    (@jaredtwilcox)


    11 years, 1 month ago

    I am hoping to use the Periodic Automatic Import extension to automatically import a .csv file that resides at a specific url.

    The file is very large and leads to relatively slow performance on the website. A lot of the data that is present is not needed. So I have manually removed what I don’t need in Excel and upload the modified file and performance is much better.

    So my question is this: Is there a way that I could create a table in TablePress that would pull data from various rows and columns in another TablePress table to create a table that is formatted exactly as I would like?

    This way I could automatically download the large .csv file to a table in TablePress, but then strip out the data I don’t need in a different table and only display the smaller lighter table.

    Thank you for your help.

    Jared Wilcox

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

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

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    thanks for your post, and sorry for the trouble.

    I can’t really think of a solution where a new/second table is automatically created from that large/first table, unfortunately 🙁
    However, if that table has a fixed structure (that doesn’t change between the periodic imports), you could maybe make use of the feature to hide rows and columns (below the table input fields) to “remove” the unnecessary data? The information about which rows/columns are to be hidden is kept when the table data is replaced by a new import.

    Regards,
    Tobias

    Thread Starter jaredtwilcox

    (@jaredtwilcox)

    11 years, 1 month ago

    Tobias,

    That actually sounds like it will work.

    Is there a way that I can use formulas on all cells in a column? So it will import the data, then use the formula?

    When hiding columns, does it actually not send that data to the page via html or is the column or row simply not displayed using CSS? I ask because I just want to be sure the page is as light as possible.

    Thank you,
    Jared

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    11 years, 1 month ago

    Hi Jared,

    when a row/column is marked as “hidden” on the “Edit” screen, it will indeed not be part of the HTML and it will therefore not be sent to the visitor’s browser.

    Now, using formulas here will be more tricky. The problem is that those would have to be part of the import as well, i.e. they would have to be part of the Excel table. That’s however not really possible, as Excel also interprets those formulas (instead of leaving them as strings). (This is just a problem when Excel is used as the application that generates the table. If one were to use an application that does not evaluate formulas, but can create a CSV file, this would not be a problem.)
    So, if you are using Excel, the best solution would probably be to simply make all calculations in Excel, so that TablePress would simply import the results of the formulas instead of the formulas themselves.

    Regards,
    Tobias

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

The topic ‘Create Table from Another Table’ is closed to new replies.

Tags