software or database to manage customers?

ViviTheMage

Lifer
Dec 12, 2002
36,189
87
91
madgenius.com
We currently use a very large CSV document to manage information ... server names associated with URLs, and versions, etc. It's getting really clunky and not very viable, what do you guys use that is possibly opensource for stuff like that?
 

Cerb

Elite Member
Aug 26, 2000
17,484
33
86
I don't do any of that specifically, but know a couple people (very small businesses :)) using vtiger (SugarCRM fork) for a CRM, including keeping track of that kind of info, and love it. I've used it some for actual support tickets, and it works well. IE, bring up a ticket that you have access to, and you can easily (well, after getting used to the UI a little :)) get info on the customer, what they're running, their whole ticket history, etc.. It's supposed to also have all the features you seem to be looking for, but I've only used it for keeping track of support tickets.
 

ViviTheMage

Lifer
Dec 12, 2002
36,189
87
91
madgenius.com
I'll give it a shot, we only want it for tracking that information I listed, we're already invested in other support ticket systems and the like.

The other huge thing is it HAS to have the ability to import from a csv so I do not have to redo these thousands of entries by hand.
 

Cerb

Elite Member
Aug 26, 2000
17,484
33
86
It's kind of driving a tack with a sledgehammer, but the other options I'm aware of would be a custom CRUD program, and/or spending as much, if not more, time making a major CMS work, unless somebody knows of something else that amounts to a multi-client Access DB system :). It definitely does support CSV import and export, including with custom fields.

It could be done with a CMS like Drupal, FI, but external data importing tends to be a pain, IME, and you'd likely end up spending hours in Views to massage it to your liking, after you use feeds to import it--and that's assuming you won't have the learning curve of just getting Drupal and up and working. OTOH, more blog/gallery-oriented CMSes like WP or Joomla, you'd have to spend your time elsewhere, to make it not so annoying to use.

Ready to go VM, to at least see if it's easy enough for such limited use:
http://www.turnkeylinux.org/vtiger
 

Berryracer

Platinum Member
Oct 4, 2006
2,779
1
81
we use Salesforce at the current company that I work for and my previous company also

IT is a cloud based CRM system and you can try the demo for free for 30 days
 

EagleKeeper

Discussion Club Moderator<br>Elite Member
Staff member
Oct 30, 2000
42,589
5
0
Import your CSV into MySQL and develop a simple GUI for it; Access/Open Source or roll your own
 

Emulex

Diamond Member
Jan 28, 2001
9,759
1
71
The only decent office integrated is Dynamics CRM, it is a badass RAD tool as well.
 

IndyColtsFan

Lifer
Sep 22, 2007
33,655
687
126
Do you have SharePoint? If not, you could load the free Foundation version and accomplish what you need with standard SharePoint lists. If you wanted to get really fancy, you could build a slick front-end with InfoPath too.
 

KentState

Diamond Member
Oct 19, 2001
8,397
393
126
Been responsible for many different types of CRM systems in my career. SugarCRM isn't too bad for open source software and can support a good size business. SalesForce may be overkill and is a pricey solution. Even something like MS Dynamics would be rather pricey.

I like the idea of Sharepoint, plus it is easy to import/export out of. If you have SQL Server, there are connectors for SSIS which make reading/writing very easy.

If you do go with something like SugarCRM, Synology offers it in their application store and you can get a small, self contained NAS to run the entire product. The configuration is very minimal so you could be up an running in a short amount of time.
 

ViviTheMage

Lifer
Dec 12, 2002
36,189
87
91
madgenius.com
we do use sharepoint right now, with a displayed xls basically, and it sucks.

this is just for our internal use to take existing data and make it easier to view/query.

what does sugarcrm need to run exactly?