Hesk Client database and login

[ictconsulting]

Yes, why show us how good was his job without sharing it? Why spend time posting screenshots? I'll newer know...

[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)



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.



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



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)



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

[Lisaweb]

This is an awesome contribution! Thanks much for all your effort.

[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.

[lukasz]

Hi!

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

Thanks in advance

[toomanylogins]

Hello,

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

[voeslauer]

Hi!

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

[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:
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!

[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.