Table not displaying all data rows

  • Resolved mikehermary

    (@mikehermary)


    1 year, 6 months ago

    Hello,

    I am using this plugin to replace the outdated Inline Google Spreadsheet Viewer plugin. I have imported the data from Google Sheets and have the table displaying on the website. Unfortunately, not all of the data rows are being displayed. The table is only displaying rows one through ninety-nine. The previous plugin was successfully displaying all one hundred and twenty data rows from the sheet. You can see it here.

    The following config settings are set for the table:
    – Table Head Row: The first row of the table is the table header is checked
    – Table Features for Site Visitors: all values were left as defaults
    – The first column and empty columns have been hidden

    Is there a max data row limit for the free version of the plugin?

    Cheers,

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    No, there’s no limit for the number of rows in TablePress. The problem here is that you will need to use a different URL for the import. By default, Google gives you an HTML URL, which only contains that subset of rows. To get all rows, using the CSV format is recommended. Please see https://www.ads-software.com/support/topic/tablepress-import-from-url-of-a-google-spreadsheet-only-101-rows/ for an example of the correct format.

    Regards,
    Tobias

    Thread Starter mikehermary

    (@mikehermary)

    Hello,

    Thanks for the prompt reply and the answer.

    I will get the client to publish the sheet and will let you know if the issue is resolved.

    Cheers,

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    I believe that the sheet is already “published” (otherwise importing wouldn’t be possible even in the HTML format). Your client will just need to use a modified URL, I think.

    Regards,
    Tobias

    Thread Starter mikehermary

    (@mikehermary)

    Hello,

    The table has been published as a csv and is working now.

    Cheers,

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    great! That is good to hear!

    Best wishes,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Table not displaying all data rows’ is closed to new replies.