Business contact manager for SOHO use?

Gilles Ganault

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

Subscribe Reply

2078

The Natural Philosopher

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

Gilles Ganault

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

The Natural Philosopher

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

Gilles Ganault

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

Similar topics

3685

Databinding to a business object

by: Tim Jarvis | last post by:

Hi, I have an object that I am binding to a text box, this object exposes a boolean field, and I have implemented a format event handler and a parse event handler for the binding object, where I convert the bool value to some meaningful text. i.e. Binding b = new

C# / C Sharp

6263

design pattern of "Business Layer"

by: Hasan O. Zavalsiz | last post by:

Hi , i am trying to figure out which approach is better to use . let me explain the scenario. i am using the "Nortwind" database . in this database i have "Customers " table .The following is the two different ways to handle this table. CASE 1 : create a struct that encaplusates table "Customers" columns public struct structCustomers { public string CustomerID;

C# / C Sharp

2053

Why is it called "Business Objects"?

by: G. Stewart | last post by:

The word "Business" in the term implies some sort of commercial aspects or connotations. But from what I can see, that is not necesserially the case at all? So what is the reasoning behind the term? Stupid question, I know ... and quite irrelevant in many ways ... but I really would like to know!

ASP.NET

1159

Business Analyst with i2

by: Radhesh Reddy | last post by:

Please here with find the requirement details as follows Business Analyst with i2 Location: Overlandpark,KS Duration: Longterm Startdate: ASAP SCOPE OF WORK: Provide application design direction directly to business user community. Assess business concerns, clarify issues, develop solution

Microsoft SQL Server

1202

Extending Business Object

by: Brandon Miller | last post by:

All, I have an existing business object (VB.Net) which returns user IDs for our locations in our regions. One of the properties objReg.Manager returns the manager's user id (integer) for a given location. What I'd like to do is implement something similar to .ToString, so I might call - objReg.Manager.GetUser() This would return a User object (which we already have written) representing

Visual Basic .NET

1896

Too many imports to use a business class library?

by: Sanjay | last post by:

Hi all, I am new to python. Sorry if this is too novice question, but I could not find an answer yet. While coding a business class library, I think it is preferable to have one class per source file, rather than combining all classes into one file, considering multiple developers developing the classes. So, as per my study of python, a developer using the business class

Python

2995

relocating Outlook Business Contact manager

by: snerscho | last post by:

I am trying to relocate the database folder of Outlook's Business Contact Manager (BCM) to a share directory for easy back-up procedure. I have tried everything but it seems impossible. Already posted this question in BCM discussion group and got the hint that MS-SQL Server (8.00.2039) might not allow the use of a share directory but there might be a way around it. Can anyone help me out here. Running W2K SP4 with Office 2003 SBE with BCM...

Microsoft SQL Server

24561

HowTo: Calculate business days - pure SQL approach.

by: FishVal | last post by:

IMHO, the following is not a how-to-do instruction to solve a particular problem but more a concept-proof stuff demonstrating possibilities of SQL. So, let us say the problem is to calculate business days count which is defined as count of days (optionally inclusive in the current implementation) excluding weekend days and holidays. Let us say periods to calculate are stored in table associated with contacts. keyPeriodID -...

Microsoft Access / VBA

10509

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10281

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10256

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10039

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9095

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6824

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5612

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4152

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2953

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General