Re: Business contact manager for SOHO use?

Gilles Ganault wrote:
Hello

I'd like to find a basic PHP+MySQL contact manager, so that we can
keep a list of our customers, and a contact history (ie. whenever they
call us for a problem, it'll be in the file). There may be other nice
features I should know about, but I don't want any of those enterprise
softwares like SugarCRM etc. that are just too complicated.

Actually, I'm thinking of a cross between a contact manager and a
bugtracker, since customers usually call for issues and (more rare)
suggestions.

Seen anything like this?


Sure, but usually written by me.

Its really not hard.

In my case there are four tables

Customers
==========

Full contact details

Employees
=========

The people handling the problems,


Tickets
=======

A support ticket for every issue that is raised, with a status, who started it, which customer its associated with,which manager is responisble for it, and which support person its currently assigned to. Date when opened, date last action taken. Urgency.

Notes
=====

Free form text associated with an interaction between a support person and a problem, time stamped, and with employees stamp on it too. Possibly also a BLOB field fotr an upladed file.

E.g.
June Bloggs
1/1/2008
"Tried to replicate problem and found bug. See attached file.
Referred to Muggins for code fix."

Thats the basic SQL database details.

Then a few forms to add a ticket,
review selections of tickets, buy customer, by support person, by urgency, by age, etc etc.

Plus a ticket updating system to add further notes.

You need a login system for employees and a way to distinguish support staff from support manaagers as well.









Thank you.
.

Relevant Pages

  • Re: Help Desk App - Need ideas or directions
    ... Free Web Based Help Desk Software, ... Support Software ... Hot Help Desk is a free ticket management and100% web-based help desk ... so you can offer your customers different options to ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Tech support
    ... When I was a customer and was unpleased with the support I got, ... you paying customers complain loudly. ... or two times I asked the dork on the line to connect me with their manager ... And that is not just with VMS!! ...
    (comp.os.vms)
  • Re: Displaying Version Number
    ... Microsoft MSDN Online Support Lead ... Delighting our customers is our #1 priority. ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to Display NO Title Bar
    ... As for effectively getting Microsoft support at the managed newsgroup, ... Microsoft customers and are delightful to provide assistance on resolving ... Please feel free to let my manager ...
    (microsoft.public.access.forms)
  • Re: browsers textbox auto complete not working
    ... Microsoft MSDN Online Support Lead ... Delighting our customers is our #1 priority. ... You can send feedback directly to my manager at: ... As for IE AutoComplete settings, you can check through the following ...
    (microsoft.public.dotnet.framework.aspnet)