TablePress Search results output

  • Resolved cypruswp

    (@cypruswp)


    9 years, 7 months ago

    Hi Tobias,

    This will be complicated, and as I noticed on the support forums, it is an ongoing matter which concerns many users, so sorry in advance …

    I am working on a locally installed website using the x theme (with all the latest versions of software). I managed to upload several excel files using tablepress, and i have hidden all tables/rows and information i do not need to show on the website. I also managed to make the search box search only after a click. So far so good, relatively easy and straightforward for a person with no development knowledge whatsoever.

    I spent the last 4-5 days trying to find solutions on the search and presentation of the data which are found in these excel files. It seems there is are no available extensions for what i need. For example:

    1. I need to place a search box within a footer widget (on all pages), which will need to read these hidden tables found on the same and other pages.
    2. Display results on another section of the same page or even better on a results page, using the styling of the tables.
    3. I have been reading posts and your replies about the process of creating a custom search results page in wordpress but I am not sure if this will help me display the data i need, as the default search mechanism does not read data within custom databases / excel files.

    Yesterday i came across your softball related website, where you maintain multiple league tables, have a search box within a widget (i think), and show results in different page sections or even different pages (the default results page of wordpress i suppose). I also noticed that you wrote that your website incorporates additional mechanisms that are not available for download on your tablepress plugin website.

    I though of many options on how to proceed, but i am stuck. Can you make a recommendation on what will be better for my case?

    – Find additional custom data search and display plugins which would read these tables and help me display the search results as I need them to? I prefer not to use extra plugins if I can make this work with tablepress only.
    – Any easy to follow and implement instructions on the creation of a search results page with the incorporation of tablepress data?
    – Possibility for any related additional extensions from your side? (the way your softball website works for example). Would be happy to donate if these can help me deal with my problem.

    Once more, sorry for the long post .. I hope your reply helps many of your tablepress followers.

    Regards

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

    (@tobiasbg)

    9 years, 7 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    I understand what you mean, but unfortunately, I don’t have solutions here, other than those that you have already found 🙁
    TablePress can only show search results in the table on the same page, but not in other ways or layouts.

    Regarding that “softball website”: I’m not sure what you mean here. Can you post a link? While I use TablePress on my club’s site at http://www.poorpigs.de/ that doesn’t use any fancy stuff besides regular TablePress features (ok, plus some small custom JavaScript).

    Regards,
    Tobias

    Thread Starter cypruswp

    (@cypruswp)

    9 years, 7 months ago

    Thx for the fast reply Tobias,

    really appreciated.

    I thought the search box on your website returned table information, in addition to website pages/categories etc. Sorry for the misunderstanding.

    Will certainly use tablepress for uploading and displaying some of my needed tables (game results, coupons of the day), but I will also need to find another appropriate solution for custom data search and presentation.

    Best Regards

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    9 years, 7 months ago

    Hi,

    yes, that will be the best way. TablePress is only good at tables, but it’s not really suitable as a data storage for other search/presentation needs.

    Regards,
    Tobias

    tusansan

    (@tusansan)

    9 years, 7 months ago

    Hello, Tobias!
    I have the wrong table in the format “* .xlsx”.
    The table has a combined cell in the first column.
    When loading a table on site – merged cells are broken down into individual, and then search on my table is not working properly!

    Is it possible to work with the search in the table without breaking the merged cells?

    http://tusan.ru/tablitsa/

    What I want to achieve:
    1) search using the first and second column, but not to ignore blank lines in the first column
    or
    2) “find” with merged cells

    How to do it?

    tab

    Thank you for your hard work!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    9 years, 7 months ago

    Hi,

    thanks for your question, and sorry for the trouble.

    Unfortunately, I’ll have to disappoint you here. The DataTables JS library does not support merged cells. So, if you want to use the Search, you can not have any merged cells in the table.

    If you want to be able to search for “Audi” in these rows (without writing it into the first column), I suggest to add a second column where you do write it, but then hide that using CSS (like

    .tablepress-id-1 .column-2 {
  display: none;
}

    Regards,
    Tobias

    tusansan

    (@tusansan)

    9 years, 7 months ago

    Thank you Tobias!
    I will change the table “.xlsx” I will decide this issue!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    9 years, 7 months ago

    Hi,

    no problem, you are very welcome! 🙂

    Best wishes,
    Tobias

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

The topic ‘TablePress Search results output’ is closed to new replies.