Where's the missing link on non-profit case management

Where's the missing link on non-profit case management


I still haven’t found a free software case management framework for non-profits emerging on the horizon. If you search SourceForge or Freshmeat, you find legal case management systems, but nothing oriented to the general non-profit market for client management. There are electronic health records, CRMs and ERPs... all of which have elements that would be useful, but none alone can do the trick.

I guess that means the field is open to start that free software project. So, with that in mind, I’ve been poking around and thinking about how to approach the development of this idea.

I have looked at free software solutions and investigated blogs and wikis, Joomla, PHProjekt and others... .

Given I am not a developer it’s somewhat second hand knowledge that drives me forward here, but I have found CollabNet who produce a community based on line collaboration system for managing the code base and the distributed development process. Go figure that some group would have come up with a free framework for developing free software projects!

CollabNet’s Community Edition looks pretty cool and may be just what I’ve been looking for.

What was interesting was simply finding CollabNet itself. This is a strong indication as to the direction of the software development business.

Now my next step is to find an existing framework, i.e., what’s really needed is a combination of Pentaho, Medsphere, SugarCRM.

These three products cover the basics of what a case management system needs to be with the demographics and client profile portions, the health information recording and the analysis and reporting. However, the ideal case management system must be able to be adapted to various business processes—organizations shouldn’t have to reorganize the way they do business to adapt to a technology.

If you have a mental health program, the case management system should be able to respect the clinical assessments that you perform and have the ability to have those assessments built into the framework. If you have an employment assistance program, or a clinical counseling program, or a shelter, a sufficiently well designed case management system should be readily customizable to all those programs and enable the transfer of information on unique clients between those organizations, within a shared clinical context.

For example, a shelter will need a bed registration system and an employment service will need an employment placement component. Both may need activities tracking and demographics, but the shelter will need less demographic info than the employment service. This level of feature development can get pretty complex with the addition of more and more types of non-profits. However, it is less efficient, and more prone to error, if you are having to use more than one system to account for client activities across multiple programs within your agency.

So, obviously, the addition of features: assessments, new data collection forms, custom reporting, and changes to existing fields and forms should be a primary consideration in the development of a case management application.

The social services field is undergoing significant changes and will continue to undergo changes as public sector reform initiatives continue to play out throughout governments. These changes will effect the processes, policies, accountability and the reporting requirements of agencies involved. A hard coded application that is not straightforward to change will be out of date quickly. I also believe it should be ASP based so that it facilitates multiple agencies sharing relevant client information.

Much discussion will also need to be had on the security model. So, with all the above necessity of extensibility, wide implementations, and multiple features a CollabNet type environment for distributed development is essential. It may be that it's possible to take a legal case management framework and work with that; but that will take some investigation as well. I'm sure a framework is available out there somewhere that may form the basis for an open system...I'll keep looking.

Category: 

Comments

Anonymous visitor's picture
Submitted by Anonymous visitor (not verified) on

Chances are, if there isn't a package that fits your requirements, you'll need to put some resources into developing a new one. If you do not have the skill, time or knowledge to do it yourself, then you'll need to get someone else to do it for you. Sounds to me like you need to hire a professional software developer - one that is experienced with Free software. If the packages you pointed out are close to what is required, it shouldn't take long for the professional to develop something that'll work.

wilinux's picture
Submitted by wilinux on

What an opportunity! Personally I'd love to contribute & I'm sure many others would too. I imagine there may even be grant money available to help fund some of the work. Let's get serious!

Chris Holt's 1st Free S/w Mag post on this topic -
http://www.freesoftwaremagazine.com/blogs/free_software_for_non-profits

Check out Chris Holt's blog category "case management" (Chris' ideas for the specs & useful background info to be found here) -
http://intuitech.biz/?cat=1

@Chris:
What did you find out about desc.org's system? (from your comments in "Free S/w for Non-profits")

Anonymous visitor's picture
Submitted by Anonymous visitor (not verified) on

Interesting blog entry, we need more feedback like this. Disclaimer: I'm a developer of one free software project aimed at non-profits (LCM).

There was an interesting discussion recently similar to this on the «NOSI» mailing-list. To quote David Geilhufe, from the CiviCRM project, in a message posted on January 5 2007: «With CiviCRM (www.civicrm.org) we found that building a reliable user community took about 18 months since users don't care about what the application could do, they just focus on the 30% that you don't have done.»

That's OK, we can't force users to work without features which are essential to them, but users (or consultants/technicians working with those users) need to get a bit more involved. Submit bug reports, ask questions, be constructive. If you can't invest money, invest time. Not all free software projects have stable sources of funding or full-time developers.

Instead of saying that «I still haven’t found a free software case management framework for non-profits emerging on the horizon», start by describing a list of required specific functions, explore the most suitable solutions, which features would be missing and how much work would it take to improve. Encourage a few organisations to collaborate together, use a wiki and/or a mailing-list to document the evolution of the research, etc.

I would add that the most successful Free Software projects are those who do one specific task and do it well. We usually get those programmes to interoperate in order to build systems that satisfy the requirements of an organisation. We cannot always add every single feature into one software, but we can encourage various software to "talk" to each other. Therefore, if one software is missing one very specific feature, try to see if another software might not be able to complement it. Sometimes it is necessary to modify the two applications so that they work well together, but that's one of the strenghts of free software.

Finally, if you do hire a professional, make sure that the person clearly documents what he/she has done. If any modifications were made to the software, request that those changes were submitted for review and integration by the software developers of that project. This helps the project to go forward, but also avoids being dependent working with only that professional. After all, free software is about freedom!

Happy hacking,

Mathieu Lutfy
mathieu@bidon.ca

Chris Holt's picture
Submitted by Chris Holt on

Thanks for the comment and your points are all well taken.

Anonymous visitor's picture
Submitted by Anonymous visitor (not verified) on

On the contrary, I provide FREE case management software for food pantries and emergency services organizations which provide food, clothing, diapers, HBA items, funds to avoid utility cutoff and eviction, funds for Rxm etc. Since Nov 2004 the software has been installed in 28 501(c)(3) agencies. YOu can learn more about the software and download a trial version here:

http://webpages.charter.net/bobalston/nonprofit_food_pantry.htm

Bob

bobalston9 AT yahoo DOT com

Donald Lobo's picture

I dont think CiviCRM comes close to your needs, but I think it offers you a good start and a decent basis to build a case management system

Drupal: For managing Content
CiviCRM: For managing Data
BIRT (via CiviReport), similar to pentaho: to build detailed reports and analysis as u see fit

lobo

Author information

Chris Holt's picture

Biography

Chris Holt specializes in consulting for Government and NGO public health and social services organizations about software to assist with case management and patient management systems.
Check out his site at http://www.intuitech.biz.

Most forwarded

Interview with Dave Mohyla, of DTIDATA

Dave Mohyla is the president and founder of dtidata.com, a hard drive recovery facility based in Tampa, Florida.

TM: Where are you based? What does your company do?
DTI Data recovery is based in South Pasadena, Florida which is a suburb of Tampa. We have been here for over 10 years. We operate a bio-metrically secured class 100 clean room where we perform hard drive recovery on all types of hard disks, from laptop hard drives to multi drive RAID systems.

Anybody up to writing good directory software?

Since the very beginning, directories (of any kind) have had a very central role in the internet. (I have recently grown fond of Free Web Directory. Even Slashdot can be considered a directory: a collection of great news and invaluable user-generated comments. As far as software is concerned, doing a quick search on Google about software directories will return the free (as in freedom) software directories like Savannah, SourceForge, Freshmeat and so on, followed by shareware and freeware sites such as FileBuzz, PCWin Download Center and All Freeware (great if you're looking for shareware and freeware, but definitely less comprehensive than their free-as-in-freedom counterparts).

Interview with Mark Shuttleworth

Mark Shuttleworth is the founder of Thawte, the first Certification Authority to sell public SSL certificates. After selling Thawte to Verisign, Mark moved on to training as an astronaut in Russia and visiting space. Once he got back he founded Ubuntu, the leading GNU/Linux distribution. He agreed on releasing a quick interview to Free Software Magazine.

Is better education the key to finding better software?

I read David Jonathon's article Anybody Up To Writing Good Directory Software? the other day, which got me thinking about software directories in general. As David mentioned, many of the software directories one finds when doing a quick google search are free as in beer, not as in freedom. But what interests me is the software directories that already exist, providing a combination of both free as in beer software, and open source software. Sites such as Freeware Downloads and Shareware Download don't advertise themselves as providing free as in liberty software, but each of them have a good selection of open source software available... if you know where to look.

Most emailed

Free Open Document label templates

If you’ve ever spent hours at work doing mailings, cursed your printer for printing outside the lines on your labels, or moaned “There has got to be a better way to do this,” here’s the solution you’ve been looking for. Working smarter, not harder! Worldlabel.com, a manufacture of labels offers Open Office / Libre Office labels templates for downloading in ODF format which will save you time, effort, and (if you want) make really cool-looking labels

Creating a user-centric site in Drupal

A little while ago, while talking in the #drupal mailing list, I showed my latest creation to one of the core developers there. His reaction was "Wow, I am always surprised what people use Drupal for". His surprise is somehow justified: I did create a site for a bunch of entertainers in Perth, a company set to use Drupal to take over the world with Entertainers.Biz.

Update: since writing this article, I have updated the system so that the whole booking process happens online. I will update the article accordingly!

So, why, why do people and companies develop free software?

More and more people are discovering free software. Many people only do so after weeks, or even months, of using it. I wonder, for example, how many Firefox users actually know how free Firefox really is—many of them realise that you can get it for free, but find it hard to believe that anybody can modify it and even redistribute it legally.

When the discovery is made, the first instinct is to ask: why do they do it? Programming is hard work. Even though most (if not all) programmers are driven by their higher-than-normal IQs and their amazing passion for solving problems, it’s still hard to understand why so many of them would donate so much of their time to creating something that they can’t really show off to anybody but their colleagues or geek friends.

Sure, anybody can buy laptops, and just program. No need to get a full-on lab or spend thousands of dollars in equipment. But... is that the full story?

Fun articles

Santa Claus - the most successful open source project

It dawned on me the other day, as I was shopping for the dozens of gifts it seems I have to buy every December, that Santa Claus is the most successful open source project in history. (Bridget @ Illiterarty would agree with that). Santa Claus is essentially a marketing development that is embodied by everyone who stuffs a sock, gives a gift, hosts a dinner or wishes Merry Christmas over the holiday season.

Most emailed

Editorial

When I first started thinking about Free Software Magazine, I was feeling enthusiastic about the dream. I had Dave, Gianluca, and Alan willing to help me, I had established members of the free software community willing to help me out, I had writers volunteering their time and energy for free, and I had a generous offer from OpenHosting for servers, all before I'd proved myself. There was a sense of excitement in the air, and I thought maybe, just maybe, I could make this work.

Free Software Magazine uses Apollo project management software and CRM for its everyday activities!