Exporting a subset of your referral database to Word and Excel

Neil McKechnie May 23, 2014 211 and Resource Referral, Helplines, iCarol

Often times our clients who do Information & Referral (I&R) need to export some or all of their resource or referral database to share with a third party. And while all Admins have access to the Data Export tool that gives them an Excel-readable export of all records and all fields, a more refined approach is needed for specific requests. For example, you might need to create a nicely formatted Microsoft Word document of just the Child Day Care providers in a particular city and just with a handful of informational fields. Or you might need to create an Excel listing of Food Pantries that serve Veterans in a three-county area. As well, you need to produce both of these files once per month and distribute them to your partners.

You can imagine that laboriously exporting all of your resource data and then laboriously removing fields and rows, then formatting it just the way you want to, could be very time consuming – especially if you have to do it on an ongoing basis.

That’s where iCarol’s Specialized Resource Exports to Word and Excel comes to the rescue. With it, you can create an unlimited number of “templates” with a targeted set of conditions and formatting to export just the resource data you want to Word or Excel, and have it formatted in the font type and size of your choice.

You start by naming a new template, choosing either Word or Excel, and indicating what record types (Agency, Program, Site) you want to be included.

Next you specify which standard and custom fields you want included.

Then you add any filters you would like to limit the exported records. Geographic filters indicate that records physically located within, or that are designated to serve, one or more areas are the records to be included. These areas can be as small as single postal codes, towns, cities, counties, regions, states/provinces or entire countries. You can even mix and match a number of different types of geographic areas.

Depending on what sort of categorization scheme you use – the AIRS Taxonomy or your own custom categorization – you can also add filters to include only those resources that area assigned to one or more of those categories.

In addition to the many standard fields available for resources in iCarol, many of our clients add their own custom fields. For any that are either drop-down lists or check-boxes, they too can be added as filters to confine the resources included in the export down to just those assigned to one or more of these custom fields.

After you’ve saved one of these templates, at any time you can tell iCarol to perform an export based on its definition and within a few minutes you’ll have the file ready for your download, use and distribution. As well, we’ve structured the Word documents to make it easy for you to add your own title pages, tables of content, indexes, headers, footers and more. That makes it easy to include the content in a larger document and brand it with your agency’s identifying information.

If you’d like to add Specialized Resource Exports to your iCarol system and provide your community with targeted resource directories, contact our for more information.

Introducing iCarol Folksonomy

Neil McKechnie May 13, 2014 211 and Resource Referral, iCarol, iCarol Features, Enhancements, and Updates

When people in the public are searching your public website for a resource that can help them, it can sometimes lead to frustration that they are getting no results. When you look closer at how they are searching, it becomes clear that they aren’t familiar with the way that resources are named or categorized. In other words, they are expressing a need, like “I am hungry” but the resources in your database are represented as services, like “Food pantries”.

In fact in commonly used categorization schemes, such as the AIRS Taxonomy or a custom categorization scheme built directly by your helpline, you won’t find the word “hungry” in any of the categories, terms or definitions. Multiply this by all the possible needs people have, and you can quickly see how a great deal of the population won’t get connected to valuable services. Other example searches are “I need a ride to work”, “My family needs a place to stay” and “I lost my job yesterday”.

So how can these help seekers, who are expressing a need, be connected with the services that can assist them? Clearly, we need to build a bridge between the two approaches. The solution we’re employing in iCarol’s Public Resource Directory is called the Folksonomy (an intentional mashup of the word Folk, as in “colloquial”, and Taxonomy).

In a nutshell, it helps find results if the search did not match an Agency or Program name, a taxonomy term or the officially defined synonyms for taxonomy terms (called “use references”). It does this by picking up colloquial words or phrases in a search and corresponds them to taxonomy terms, and then performs the search for resources assigned to those taxonomy terms.

A perfect example would be if someone typed “I am really hungry” into the search box. The Folksonomy fills the gap that normally would be mediated by a helpline’s phone worker on a call by connecting the expressed need to one or more taxonomy terms, like Food Pantries and Ongoing Emergency Food Assistance.

We have been testing this approach with clients and it is yielding exceedingly good results. Those clients also have an administrative interface to find recent searches yielding no results, and then to make Folksonomy entries so that future such searches will instead yield the right results.

Here is a scenario where the word “ride” is a Folksonomy entry corresponding to several taxonomy terms. If you had performed this search before we implemented the Folksonomy you would have gotten zero results. Instead you now get a number of transportation-related resources:

By building that bridge between the layman’s terms used by your web visitors and the detailed categorization of the 211 Taxonomy, iCarol’s Folksonomy will greatly improve the ability for your Public Resource Directory searchers to find what they are looking for and ultimately get the services they need.

We’ll have more information to share about implementing iCarol’s Folksonomy in the coming weeks. Want to learn more about managing your Resources with iCarol? Join us for our Resource Management Webinar on May 20th at 2pm EST.

Continue Reading