Page 2 of 2

Re: Hesk Client database and login

Posted: Sat Jan 28, 2012 7:35 pm
by ictconsulting
Yes, why show us how good was his job without sharing it? Why spend time posting screenshots? I'll newer know...

Re: Hesk Client database and login

Posted: Sat Apr 21, 2012 2:19 pm
by seanieboy02
I don't think that it's a feasible idea to create this one as an 'add-on' since you have to rewrite the way hesk actually works.

I've had to add new tables to mine, change the ticketing section and update any page that references these fields to integrate the same sort of thing. So far I've added separate tables for the customers and the company they work for which links them to the ticket then in turn to the company with ticket summaries per company. From this you can add a login section which reads from the customers table etc. (oh, to mention that it gets more complicated as some of the customers actually work for multiple companies supported but I haven't crossed that bridge just yet)

Image

On top of that inserting a ticket has been simplified using a little jQuery magic to read the customer name from the database so you only need to start typing in the customer name field and it pulls down everything else (contact details, email addresses, company info etc) in milliseconds and links it to the ticket.

Image

Also some improvements to the notes, adding an Action / Time spent field for each action which totals up to time spent on each ticket.

Image

One of the actions is to schedule something, which allows downloading of an iCal for the appointment with the ticket details on. (works well from the iPhone)

Image

In case anyone is interested in the DB mods for the Notes / Actions / Scheduling...
Image

Re: Hesk Client database and login

Posted: Sat Apr 21, 2012 2:59 pm
by Lisaweb
This is an awesome contribution! Thanks much for all your effort. :-)

Re: Hesk Client database and login

Posted: Sun Apr 22, 2012 11:38 am
by Klemen
Indeed a great mod, I'm sure a lot of users would benefit from it.

Feel free to post the mod (best create a new topic) and I will mirror it on hesk.com.

Re: Hesk Client database and login

Posted: Wed Aug 01, 2012 9:31 am
by lukasz
Hi!

Is this mod available anywhere? I cannot find this nowhere on forum.

Thanks in advance

Re: Hesk Client database and login

Posted: Wed Aug 15, 2012 4:28 pm
by toomanylogins
Hello,

I am also looking for client login. I cant see a link anywhere to download this ?
Plesae advise.
Thanks
Paul

Re: Hesk Client database and login

Posted: Fri Sep 28, 2012 6:54 am
by voeslauer
Hi!

I could also need this mod - please share it.
Thanks!

Re: Hesk Client database and login

Posted: Thu Feb 06, 2014 4:04 pm
by rex_to
I started using HESK for my Support Portal a couple weeks ago, and so far it seems great! However, I was disappointed at the lack of a way to restrict access to the add a ticket area. I searched high and low for a simple solution to implementing a client login, and would like to share what I ended up using in the hopes that it might help someone else too.

I didn't need heaps of security (after all, I only wanted select clients to login, and they are only submitting a ticket) but, I just didn't want any Joe to be able to submit, and this solution allows ME to administer logins which I can revoke after their XX-days of support has ended.

I found a free to modify, one-page user authentication script (http://www.zubrag.com/scripts/password-protect.php) It's really simple, you can modify the form to look like the rest of your site, user/password is stored in the php file, uses cookies to track sessions, etc..

I renamed the script, uploaded it to my web server, and placed the <?php include /path/to/your/password-protect.php ?> in HESK's index.php file immediately following "function print_add_ticket()" around line 68.

After that, I added a logout button next to the "view ticket" button in the submit_ticket.php file around line 405

CONS: :twisted:
Doesn't integrate with the rest of the HESK back-end
-Customers can't view tickets associated with their logon.
Static Username/Password / No user control panel.

I'm sure there is a more elegant way of doing this our there, but this is what I found and what worked for me. If anyone has comments or suggestions, I'm all ears :)

Happy coding! :D

Re: Hesk Client database and login

Posted: Fri Feb 07, 2014 9:41 pm
by Klemen
Thanks for sharing your efforts!

Note that HESK was designed specifically for the purpose NOT to use customer logins, so it may take quite some work to get it all to work properly with password protection.