?
Solved

Free or open source case/investigation software

Posted on 2012-04-12
11
Medium Priority
?
2,895 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
8 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
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

If you are like me and like multiple layers of protection, read on!
Rules and regulations were devised in order to maintain the integrity of a system. However, interpretation of rules can be quite tricky.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

862 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