Blank Header Issue in Automatic Update from Google Sheet

  • Resolved sadafhot

    (@sadafhot)


    6 years, 7 months ago

    Hi,

    The first row of my google sheet is the header titles. When I import google sheet data using tableppress the first row appears as blank and the second row becomes the first row values of my google sheet.

    I could simply delete the first blank row and everything works beautifully. But I am using tablepress-table-auto-update extension and whenever it updated the data the first row appears as blank again.

    What is the solution to this issue? How can I setup my table such that the header titles never change?

    Thanks

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

    (@tobiasbg)

    6 years, 7 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    What’s the exact URL that you are using for the import? Is it directly returning a CSV file?

    The only chance here is that the table is correctly exported by Google Spreadsheets. The import can not keep certain rows, it will always replace the full table.

    However, you might be able to use a trick: Simply mark the first row has “hidden” (using the “Selected rows: Hide” button). That way, the blank row would technically still be there, but hidden from the visitor.

    Regards,
    Tobias

    Thread Starter sadafhot

    (@sadafhot)

    6 years, 7 months ago

    Thanks for your reply,

    I’ve checked csv and excel formats and they work well. But in my table there are some cells with hyperlinks so I have too set the google sheet and the plugin settings to HTML format.

    Here is the URL of my google spreadsheet:

    https://docs.google.com/spreadsheets/d/e/2PACX-1vTiPJv4iTZXCzas8hO2HiJGkeoSSQq39KtUsVu__G78n9LNG4mRTOajrspn_Y-D5UerxpHE_pFnbzGo/pubhtml

    I tried to hide the first row. It works but it didn’t update the table after 2 hours yet. I set the update period to every 15 min.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 7 months ago

    Hi,

    ok, this import format should work, but it does indeed contain an empty header row. There’s nothing that we can do about that. So, the trick with the hidden first (empty) row should be a good solution.

    For the auto import: Remember that the WordPress Cron system, which is used here, requires active, not logged-in site visitors, to trigger the cron job. Alternatively, you could try replacing the WP Cron job with a real server cron job (if your hosting provider allows this). See e.g. https://www.siteground.com/tutorials/wordpress/real-cron-job/

    Regards,
    Tobias

    Thread Starter sadafhot

    (@sadafhot)

    6 years, 7 months ago

    Thanks Tobias,

    I really appreciate it.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 7 months ago

    Hi,

    no problem, you are very welcome! 🙂

    Best wishes,
    Tobias

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

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

The topic ‘Blank Header Issue in Automatic Update from Google Sheet’ is closed to new replies.