Solved

Free or open source case/investigation software

Posted on 2012-04-12
11
2,139 Views
Last Modified: 2012-11-26
I have an old client who is looking for investigation (or case) management software, but they don't have much of a budget and I don't have time to write anything from scratch for them. They're interested in something free or open source, but I really don't know anything about this kind of software. As they've explained it to me, they don't need anything complex or high-end. They just need a software system that will let them do the following:

- Create and maintain individual case records
- Link or track contacts and associates related with a particular case
- Link investigators who are assigned to a particular case
- Allow for the entry of notes, information, and updates for a particular case

If I had more time, I could probably write something to do the trick for them, but at this point I don't, so I'm looking for existing solutions. Free (or open source, requiring some minor customization work on my part) is preferred. Web-based, Windows, or Mac are all fine. Does anyone have recommendations for this purpose?
0
Comment
Question by:elorc
11 Comments
 
LVL 38

Expert Comment

by:younghv
ID: 37847314
I don't personally use this, but many of my customers do and it may be what your client needs:
http://www.openoffice.org/
0
 
LVL 26

Expert Comment

by:MidnightOne
ID: 37847429
While it's for case management, that sounds like there's a lot of commonalities with help desk software.

Are they currently using Microsoft Office, specifically a version that has MS Access?
0
 
LVL 1

Author Comment

by:elorc
ID: 37847485
MidnightOne: They've been using Excel. It's not pretty, but it apparently has gotten them this far. One of the things I'm looking at as a possible option is CiviCRM. It looks like it might (kind of) do what they're looking for, so I'm setting up a test site for them to play with.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 38

Expert Comment

by:younghv
ID: 37848104
elorc,
If they are already using MS Excel, why are you ignoring my suggestion about OpenOffice?

They should be able to directly import the work they have already done.
0
 
LVL 1

Author Comment

by:elorc
ID: 37848737
Because OpenOffice isn't really the solution they're looking for. They're looking to get away from the spreadsheet system they're using now in favor of a more proper case/investigation management system. Switching from MS Office to OpenOffice really wouldn't be much of a change or improvement.
0
 
LVL 38

Expert Comment

by:younghv
ID: 37848902
Thank you for responding.
I will unsubscribe and let others more familiar with the options continue to help you.
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 37849570

they don't need anything complex or high-end. They just need a software system that will let them do the following:

- Create and maintain individual case records
- Link or track contacts and associates related with a particular case
- Link investigators who are assigned to a particular case
- Allow for the entry of notes, information, and updates for a particular case

I have built and used systems like what you have described. IMHO, what you have described is a lot more complex (high-end) than your client realizes.

I do think a good CRM  and/or project management system woudl be a good start.

Here are some other to check out:

If their business is really important then they will invest in

http://www.salesforce.com/
or
Zoho - There is a free version
http://www.zoho.com/collaboration-apps.html   
http://www.zoho.com/business-apps.html
http://www.zoho.com/productivity-apps.html

other alternatives:

http://www.sugarforge.org/content/open-source/

http://www.dotproject.net/
0
 
LVL 11

Expert Comment

by:sparab
ID: 38631976
I've requested that this question be closed as follows:

Accepted answer: 500 points for TheHiTechCoach's comment #a37849570

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
We often encounter PDF files that are pure images, that is, they do not have text characters, but instead contain only raster graphics. The most common causes of this are document scanning software and faxing software/services that create image-only…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question