By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Business contact manager for SOHO use?

P: n/a
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?

Thank you.
Dec 26 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.
Dec 26 '07 #2

P: n/a
On Wed, 26 Dec 2007 09:15:45 +0000, The Natural Philosopher <a@b.c>
wrote:
>Sure, but usually written by me. Its really not hard.
I know, but I don't have time to write and maintain this. Why didn't
Google return anything simpler than entreprise-grade contact managers
like SugarCRM, Compiere, etc.? SOHO users also need some basic CRM
software.
Dec 26 '07 #3

P: n/a
Gilles Ganault wrote:
On Wed, 26 Dec 2007 09:15:45 +0000, The Natural Philosopher <a@b.c>
wrote:
>Sure, but usually written by me. Its really not hard.

I know, but I don't have time to write and maintain this. Why didn't
Google return anything simpler than entreprise-grade contact managers
like SugarCRM, Compiere, etc.? SOHO users also need some basic CRM
software.
Sure, that's why I am writing what I am writing. ;-)

If you can wait a year...

Dec 27 '07 #4

P: n/a
On Thu, 27 Dec 2007 10:00:01 +0000, The Natural Philosopher <a@b.c>
wrote:
>If you can wait a year...
Unfortunately... :-)

I think I found one, although it's US-centric, so I'll have to make a
few changes so it's locale-independant:

http://www.simplecustomer.com/
Dec 28 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.