Using Java with TablePress

  • jpechon

    (@jpechon)


    12 years, 1 month ago

    Hi,

    I really like TablePress and I have a question about the row filtering mod. I am a novice programmer who is new to WordPress and I have limited knowledge of Java.

    What I would like to do is have one large generated excel file uploaded to the site. This will contain proprietary information on past jobs. Then based on the user I will filter it for that users past jobs.

    As of now I can’t find a good login plugin for wordpress that is not made for the actual wordpress login. I would like an independent one. Therefore I am writing some basic html and java code to check the user and password entered to an uploaded csv.

    How can I have a Java variable entered into the shortcode or call a function so that it can filter the wordpress.

    I am also concerned with the security of this method. Is there another way someone would recommend doing this.

    Here is the code:

    <FORM NAME="user" ACTION="" METHOD="GET">
UserID: <BR>
<INPUT TYPE="text" NAME="userbox" VALUE=""><P>
</FORM>
<FORM NAME="pass" ACTION="" METHOD="GET">
Password: <BR>
<INPUT TYPE="text" NAME="passbox" VALUE=""><P>
<INPUT TYPE="button" NAME="loginbutton" Value="Submit" onClick="loginbuttonclick(this.form)">
</FORM>
<script language="javascript">
/*Check for user and password match to csv then pass user to shortcode filter or tablepress function
*/
</script>
[table id=1 filter=User /]

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

    (@saurabhshukla)

    12 years, 1 month ago

    What you are trying here is very confusing.

    DO I understand it correctly when I say that you have data that you want to filter using the currently logged in user and then only display data that’s relevant to them?

    https://codex.ww.wp.xz.cn/Function_Reference/wp_get_current_user

    will give you the logged in user’s information that you can then use to filter the data. I believe you’d need to add this data into the WordPress database if you need to display it dynamically. Excels and tablepress is not the way to go.

    It will also require programming skills higher than a novice. have you considered hiring someone for this?

    Thread Starter jpechon

    (@jpechon)

    12 years, 1 month ago

    Thanks for the response. You got it I’m trying to dynamically filter the TablePress table based on the user. I didn’t like using the wordpress login because it gives even the lowest level users a bunch of extra stuff on the webpage and it will be a pain to enter all the users manually.

    As of now I’m just making a password protected page for each customer that already has the shortcode filter manually typed. There are 100s of customers but I’m just doing it on an as need basis and showing others how to add a new customer. Thanks to TablePress’s very simple shortcode anyone can add a new page with a filtered table easily.

    I have some decent experience programming but not professionally. Mainly this HTML and Java world is new to me. Java is pretty easy to pick up though. Mainly its learning how it all can and can’t interact.

    Tobias Bäthge

    (@tobiasbg)

    12 years, 1 month ago

    Hi,

    thanks for your question, and sorry for the trouble.

    Sorry for the late answer, but I only saw your post just now, because it was not properly tagged initially.

    To be honest, I don’t really recommend TablePress for this, as integrating something like you want is not that easy, while keeping security in mind. Basically, the main problem is that you can not do this with JavaScript code (neither the check for the login nor changing the table Shortcode parameter). Instead, this has to be done on the server, e.g. with PHP. Then, you should use a custom mySQL table for the check if a user is logged-in and also for what jobs to display in a table.
    But that’s not really something that TablePress can help with, I’m afraid.

    Regards,
    Tobias

    Thread Starter jpechon

    (@jpechon)

    12 years, 1 month ago

    Thanks again Tobias

    TablePress is working so seamlessly besides the login that I am working around it.

    I will go with adding a new page with a typed in “user” for each page’s short code. Though we have 100s of customers only a handful will be really wanting to use this service.

    The simplicity of the setup after I built the table allows our sales to make a new customer page as a customer requests it.

    Tobias Bäthge

    (@tobiasbg)

    12 years, 1 month ago

    Hi John,

    very nice! That sounds like a good solution. Even though it might require some extra manual work, it should indeed work nicely! 🙂

    Best wishes,
    Tobias

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

The topic ‘Using Java with TablePress’ is closed to new replies.