Support » Plugin: TablePress » Associating table data with certain members of my site

  • Resolved danie.ludick

    (@danieludick)



    Good day,

    Excellent work on creating tablepress! I want to use it on my site to capture (and therefore display) different data for each member on my site, e.g. monthly electricity readings. How would I go about that?

    One would probably have to use some form a unique key (associated with each member) for a table. To display the table for a logged-in member, I can then generate and use this key to get the correct table to put on the page. I would appreciate your thoughts and advice!

    Kind Regards,
    Danie

    http://wordpress.org/extend/plugins/tablepress/

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

    (@tobiasbg)

    Hi Danie,

    thanks for your post.

    Unfortunately, I don’t really see a good way to achieve this. What you need is some sort of dynamic access to the tables, but that’s not something that TablePress can offer. It just wants to give users a simpel way to show static tabular data.
    Connecting this with outside information (like a member or unique key) is not possible. This should be done with a custom PHP/mySQL solution, i.e. you should use a custom database for that. You could then develop a custom plugin that uses PHP to access that database and print the corresponding data for a member to the page.
    If you want, you can then manually add the features like sort, search, and pagination, by loading the DataTables JavaScript library from http://www.datatables.net by hand.

    Regards,
    Tobias

    Thank you Tobias!

    I quite like this suggestion of this custom PHP/mySQL route, whereby the data for each member is stored in an external data-base under a unique table-ID (that one can link with the membership ID). To package this as a WordPress plugin would be great!

    I know this is not entirely related to this support query then, but seeing that I have no experience in plugin design, are you perhaps interested in undertaking such a project? (Or know of someone that might be interested)?

    Kind Regards,
    Danie

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Danie,

    I actually meant one “big” database table with all entries, and not one table per user, but ok, that’s just a question of designing the database.

    Unfortunately, I have to decline your offer. Even if I wanted to, I just don’t have the time for such professional work. I’m no a professional developer and TablePress is just a hobby for me (though it’s very time consuming), so that there’s just no capacity for such projects left. I’m sorry.
    You might want to try http://jobs.wordpress.net/

    Regards,
    Tobias

    Thank you Tobias!

    All the best with you work and thanks again for a great plugin.

    Danie

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi Danie,

    sure, no problem! You are very welcome!

    Best wishes,
    Tobias

    P.S.: If you want, you can rate TablePress here in the plugin directory. Thanks!

    Sev

    (@severindauvergne)

    One solution could be to have a column in your big table that precise which role can read which row. Then you create different pages calling the table with direct filtering on this column (using the shortcode with filter). And then you manage the access to those different pages by “User Role Editor”.
    The problem of that method is that if you want this information to be personalized, you have to create a page for each user.
    Or else you could change the code of the plugin to force the filtering based on the user name (that WP can retrieve) => but each time Tobias will update his plugin you will have to update. I don’t think that you could manage this via custom templates which are independent from the plugin, but this could be the best way to stop displaying columns. I don’t know if you master Custom templates.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your feedback on this! Well, this could maybe work, but as you already say, it would not be a reliable way. And it also doesn’t really scale for many users, so that a custom database table should be better for this.

    Best wishes,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Associating table data with certain members of my site’ is closed to new replies.