Add more Customer field

[csaba911]

Script URL:
Version of script:
Hosting company: Self
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution: Custom Customer field, Customer

Great tool you made here, HESK is so mush what Im looking for but need lots of work and customization to sale it to my director of operations.
#1 would be I need more info for the 'Customer' table, need address, business name, phone number, contact person, profile image, digital agreement (would be great) and maybe a few (5 max) custom field like equipment-type-model-serial, software-type-version....

I'm a Python dev myself and have not worked with PHP since 2007, gathering material for my app when I found HESK, if I could get some help to speed up dev to make the necessary changes I would be able to buy this instead of spending my time to develop a mediocre version with Python. There is a lots of work when it to this and looks/works pretty good, the lack of customer details would be a deal breaker.
Could someone highlight the changes need to be made ?

Thanks in advance...

Code: Select all

CREATE TABLE `".hesk_dbEscape($hesk_settings['db_pfix'])."customers` (

[Klemen]

That would be quite a task and, unfortunately, not something we can guide you through here.

For what it's worth we do plan on adding custom fields for customers in the future (customer accounts were just introduced in version 3.5.0), but don't have any timeline to give when this will be available.

[csaba911]

Thanks for the fast response, unfortunate that you can't be a part of that upgrade, I'll try myself to hack something together this week while staying in the outlined Licensing agreement "You are not allowed to remove or modify the Powered by links in the Software without a valid License Key." assuming I can change anything else I want.
I'm anticipating a disaster for sure but otherwise won't be useful for us.
Another very useful future would be a SSO implementation especially MS O365 (for us at least)....

Is anyone else have made customisation in the Users/Customers table ?

Thanks

[Klemen]

You can customize Hesk to fit your needs, yes: https://www.hesk.com/knowledgebase/index.php?article=20

Regarding custom fields for customers; I didn't see anyone do this yet. As mentioned, customer accounts are a relatively new feature which didn't receive any mods that I know of yet.

[csaba911]

I was looking for a created_at or updated_at for users and customers but I guess also not implemented so as the last_logged_in timestamp, there is a table hesk_logins but unsure of its purpose.

[Klemen]

Nope, as mentioned, the customer accounts feature is new and still quite elementary.

The hesk_logins table is used in brute-force protection (trying to guess login credentials), it doesn't store any permanent user data.