Solved

Free or open source case/investigation software

Posted on 2012-04-12
11
2,462 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

691 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