What Business Software Runs Your Office?
bardkerbie asks: "I work as a webmaster and sysadmin for a small computer services shop (4 employees including the owner). We're to a point in the growth of our business where we need a system for tracking work orders as they come in and out of the shop, specifically inventory used and time spent. We use Quickbooks Pro 2006 for our accounting and payroll software. I've played around with a number of issue-tracking and CRM suites, including Bugzilla, Eventum, SugarCRM and vTiger, but all seem like they lack one critical piece to handle the workload we have. What do you use for tracking the work you do? Is it something you wrote yourself? Is there an open-source project that works well, or is there a Quickbooks plug-in we can purchase?"
Seriously? You know Macs have had programs for that for about, um, twenty-some years?
Now you're scaring me. Let's say you're pretty good and you code the thing in just 30 business days. Let's also say your time is "only" worth $320/day. You're going to take that $10K investment in a critical system and stick it on a "beater"? If you go this route, please at least take backups like HOURLY and have a second server standing by when the beater craps out.
Trac might be worth checking out, although I don't think it will handle inventory and time spent. Maybe it does - I'm just an end user on one project (bug reporting and feature requests) - what do I know?
Well, speaking about CRM because I've been looking for something for some time... There doesn't seem to be any such thing as a generic shop. Or if there is, there's no such thing as a generic CRM system in the opensource world. I'll use vTiger as my example as it's the best solution I've seen.
Someone always comes up with an idea which they'd like to follow through with but is somehow difficult with vTiger.
Yes, I know there's the "it's open source, modify it yourself!" argument. I took one look at the vTiger code and ran away screaming.
Don't get me wrong, I couldn't code something like that up myself - but even so, I think the standards the folk behind vTiger have for what they describe as a "stable" release are a little slack. Just to put it into context, I don't consider "stable" release to mean "most of the core features are there and stable but there's a whole lot of stuff (including the "upgrade from earlier version" function) which isn't particularly stable at all, is not specifically marked as being unstable so you may not know until it's too late and hasn't been disabled for the release.
Further, I was particularly interested to note that the failure mode in much of vTiger (particularly if there's something even relatively minor amiss with the database) seems to be "return a completely blank page to the user's browser and don't log the issue".
I run a much smaller business and our office is running ubuntu. We have a server which was originally random cobbled together hardware but has been replaced by a proper server.
The main applications are LAMP based and I wrote them myself originally, although they have been extended quite a bit since then.
Any of the growing number of thin clients can access our database through the LAN.
At the moment not having to pay for software licences, and being able to add new clients at the low cost of just a mobo, RAM, input devices and LCD screen IS a big deal for us, but later down the line this setup should have other advantages too.