How do you Append ignoring header?

  • Resolved therber2

    (@therber2)


    4 months, 3 weeks ago

    I have a csv on my Google drive that self updates daily.
    I am able to import it to tablepress (from URL as csv file on google drive) correctly.

    I am also able to refresh my csv file (externally) and append it to the same table — which I want to automate daily.

    The problem is that the append to table function is keeping the header row, and should ignore it for import appends after the original import that creates the table.

    How can I do this?

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

    (@tobiasbg)

    4 months, 3 weeks ago

    Hi!

    Thanks for your post and sorry for the trouble!

    I see what you mean, but unfortunately, I’ll have to disappoint you here 🙁 At this time, the “Append” mode during the table import can only append the full set of rows that it retrieves, and it can’t skip e.g. a header row. Sorry for not having better news here.

    Now, there might be workarounds: Using the Row Filtering feature module in the TablePress premium versions, you could instruct TablePress to show the table with those rows being hidden (they would still be in the table data, but not shown). Another option (a bit more complex, and involving some custom coding) could be to use a “proxy” PHP script on your server that retrieves the original CSV data, but only forwards the table body rows (minus the header) to TablePress. Or of course you could construct the full table externally (maybe also on Google Drive) and then use the “Replace” option for the full table instead of “Append” for the new rows.

    Best wishes,
    Tobias

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.