Increasingly our clients are seeking ways to share data both internally with other tools they use, as well as externally with one or more partners.
An example of connecting internal tools would be a client of ours connect their phone system with iCarol both to facilitate “screen pops” when a call is routed to a particular phone worker and iCarol appears prepopulated with information about that caller, as they answer the phone; as well as to combine the data collected by both systems to answer operational questions like “what is our average handling time for calls related to different help seeker needs?”.
And an example of sharing data externally would be giving access to your resource database so a third party can build a mobile app or a website targeted at a certain sub-population in your area, like immigrants or job seekers.
Enabling these data sharing relationships, whether internally or externally, is where API’s come to the rescue.
An Application Programming Interface (API) allows electronic systems to interact with each other without the need for the direct human intervention. That is, with an API no person needs to direct data traffic between two systems, say via a website or other screen – the systems just talk directly to each other behind the scenes. In this way, the data that resides in the main system can be searched, retrieved and even modified by other authorized computer systems connecting to it.
To do this, a software vendor writes an API and makes it available securely on the internet, and also publishes documentation about how other developers can use it. They can be one-way APIs, also known as “read only” because the software consuming the data from the API cannot modify it. Or they can be two-way APIs, where the consumer software can make modifications, like creating new records, or modifying or deleting existing ones.
At iCarol, we’ve had an API for a number of years now and are actively expanding its capabilities – it is used by quite a number of our clients to enable real-time data transfers both internally and externally. And we also consume quite a few API’s published by other software systems. Some of them enhance iCarol’s capabilities, like Google Maps or tools that let us send and receive SMS messages within iCarol. Others let us push client data to their partners, for example client or call data that needs to transfer into a partner’s electronic medical record systems.
APIs have been around for a long time in the software world, and will only grow in importance in the years to come. We continue to be excited about their possibilities and will certainly be expanding our use of them.
On Friday May 12, 2017 we were notified by Infrastructure Engineers that a massive global attack was underway which had already infected hundreds of thousands of computers and servers worldwide. This attack was known as the WannaCry virus and it targeted a vulnerability in Windows-based operating systems by encrypting the contents of a hard drive and any shared drive that computer was provided access. To decrypt the contents and return the hard drive back to a normal state, users were presented with a message demanding a ransom payment in Bitcoins, a virtual online currency that is difficult to trace.
Microsoft had recently released a patch to secure this vulnerability, which we had scheduled to deploy with our next patching cycle on June 11, 2017 after validation in our labs. However with news of this attack and following the recommendation from Microsoft Support and our Infrastructure Engineers, we acted swiftly and began the patching process of our external perimeter servers, considered to be at the highest risk of being targeted. By the end of the day Saturday May 13th, our exterior perimeter was secured in our production environments. We continued the process Sunday May 14th to secure our Disaster Recovery sites and by the end of the day Monday May 15th we completed the securing of our desktops, internal application and database servers. Following these actions, we can confidently say that all servers have now been secured in the iCarol infrastructure against the WannaCry virus.
Guidance for our users
We advise all of our users to be sure you stay up-to-date on browser and operating system updates on your machines. If you are running a Windows-based operating system please be sure to run the latest updates (Control Panel > Windows Update > Check for Updates) to make sure you pick up the latest patches and protect yourself from WannaCry and other viruses.
We take our role as stewards of your data, including sensitive information about the people you serve and the important work you do, very seriously. Should you have any questions about system security in the wake of the WannaCry Ransomware attack, please do not hesitate to reach out to our Support Team.
I’m excited to be attending the upcoming United Way CEO 2-1-1 Summit and Community Leadership Conferences next week in Orlando! Of the many big ideas and opportunities we can advance collectively, some of my favorites are those that contribute to 2-1-1’s operating as a coordinated national network, and that increase our relevance in key areas like social determinants of health. I’m looking forward to formal presentations and “hallway talks” about:
- Deeper engagements with medical and behavioral health entities
- Technology standards to harmonize the distribution of social and human services data to trusted partners
- Coordination of the National Texting Platform
- Greater use of “syndromic survellience” (love that term) to alert our leaders to emerging crises and issues
If these topics are of interest to you too, please let’s make sure we connect in a session or during a break to explore how we can advance 2-1-1’s overall, and your 2-1-1 network in particular, in the near term.
As 2016 winds down, we’d like to reflect on the year that was both at iCarol and in the industry we serve, and look ahead to exciting things on the horizon for our clients and partner organizations.
We continue to take advantage of the fluid nature of web-based software by regularly enhancing iCarol. In 2015, we were proud to have released over 1,600 coding changes and enhancements to your iCarol systems. But for 2016, we’re on track to more than double that with a release of over 4,000 improvements. This is a reflection of our expanded Technology team at the direction of our new Product Management team. We’re with you on this journey, and this exemplifies our commitment to ongoing innovation and building iCarol to evolve and grow with the needs of your service and your community.
As we add on capabilities and as our user base grows, we know the importance of our infrastructure providing a stable foundation for the work you do in iCarol. Therefore, this summer we installed a state-of-the-art network storage appliance and fine-tuned our code for performance, which resulted in our total system uptime being on track to hit 99.975% for the year, well exceeding our stated target of 99.9% and considered by the industry to be excellent. Nothing is more important to us than helping you help people, and we know that a reliable connection to our software is critical to your mission. We will continue to invest in tools and technologies over the coming year that allow our infrastructure to scale and perform well, as we expect 2017 to be another year of growth for us.
In our travels to conferences and ongoing conversations with helpline industry leaders, we took note of the major trends either emerging or magnifying, including:
- Identifying and addressing “social determinants of health” so that people in need can be more systematically helped across the spectrum of medical, health, human and social services. We’re seeing partnerships in our client base and directly ourselves with other firms to help contribute to this trend and advance it in the years to come.
- Greater focus on “outcomes” rather than “outputs” – while this has been in motion for quite a few years, we’re seeing an increased focus on what composes a true “outcome”, as well as the use of much more advanced analytic tools like business intelligence to glean insights about the true outcomes that help seekers experience as a result of being served by you.
- The continued increased use of channels other than phone to seek help, like live chat, text messaging and social media.
So with 2016 almost in our rearview, what comes next? Looking forward to 2017, we intend to invest heavily in iCarol’s product capabilities in the following areas to stay ahead of the progress we’re seeing:
- Dramatically improved reporting
- Support for continuity of care
- Revised and improved follow-ups and outcome tracking
- Continued improvements to iCarol’s already robust support for popular channels like chat and text
- Enabling resource search and initiation of chats from the most popular social media venues
- Increased accuracy of resource data and search results for help seekers
In closing, we hope that 2016 has been a good year for you personally and also for your agencies. The work you do continues to be a source of inspiration and motivation for us, and we wish you nothing but the best this holiday season. We remain deeply honored to serve you, our clients, and look forward to another year of service and giving in 2017 and beyond.
Neil and Jacqueline McKechnie
CTO and CEO, Co-founders of iCarol Helpline Software
Last week I had the privilege of attending the United Way CEO 2-1-1 summit hosted in Denver, Colorado. It’s important to us that iCarol continue to be involved and at the forefront of developing initiatives and thoughts in this industry, hence our attendance at this summit and the Alliance of Information and Referral Systems conference next month, including our own all-day training just before AIRS which we hope you’ve heard about by now. We’d love to see you at that event, or at our usual User-group open session that we’ll hold at about 2:30pm on May 22nd. For information on all our activities at AIRS next month, check out our web site.
In Denver last week, Stacey Stewart, President of United Way, opened the CEO 2-1-1 summit with an emphatic speech about the importance of 2-1-1 to United Way. It seemed clear to me that United Way wishes to continue bolstering 2-1-1 as a national initiative and several thoughts were put forth to support those plans. My additional takeaways and interpretations about United Way’s position on 2-1-1 after listening to the speech include:
That the major focuses for 2-1-1 should be…
- Self-service options that are intelligent and accurate
- Providing predictive trending to community and national leaders and decision makers
- Meeting help-seekers where they are, notably on mobile devices
And that the 2-1-1 Brand promises access to:
A note on Outcomes: there is a growing chorus of support for 2-1-1 ensuring not just that a quality referral is made but that the person actually received the help they needed. This of course means added emphasis on follow-up, surveys, and the like.
In her opening remarks Ms. Stewart also left us with the thought that 2-1-1 should, “Be the barometer of human need in America.” We know this to already be true; 2-1-1’s have long been on the front lines of hearing directly from help-seekers about what is needed, and having first-hand knowledge of the gaps between needs and availability and accessibility of services to fulfill those needs. This is one of the reasons why reporting and other information about the Needs as tracked with the Taxonomy, as well as documentation on Unmet needs and why those needs go unsatisfied, have long been a part of iCarol software.
In her closing speech on Day Two, she clarified an earlier mention of a “National Platform” to make sure people did not think it equated to one specific software ‘platform’. Although software and technology will certainly be a component, by “Platform” they mean an encompassing suite of services and initiatives from UWW that will advance 2-1-1 at the national level. Examples included:
- Develop marketing materials like commercials, videos, websites, etc. to both provide as turnkey items for local 2-1-1’s as well as execute their own national campaigns
- Strategy setting
We’d be interested in hearing from those of you who also attended to get your thoughts on all of this, and any other takeaways you had from this summit. Leave us a comment below to keep the discussion going. As for us at iCarol, we’ll continue to stand strongly behind our 2-1-1 users, who make up about one-third of all 2-1-1’s in North America, as these initiatives by UWW move forward. We’ll be there to support you with all the latest tools and innovation and strong infrastructure that will help you meet and exceed these big ideas put forth by UWW.
2015 will be remembered in our minds as iCarol’s best year ever by just about every metric. More non-profit help lines joined than in any previous year, making our adoption rate for crisis lines, information and referral agencies, and topic-specific help lines as high as it’s ever been. Along with several large statewide, multi-state and provincial projects, we’ve helped implement many dozens of new clients.
The industry trend towards offering multiple channels of communication continues to surge. The majority of our existing and new clients are choosing to implement live chat, texting, or both to augment their phone-based services. Fortunately, iCarol handles these channels very well via iCarol Messaging, embedded directly in the platform.
And we continue investing in iCarol’s capabilities, releasing over 1,600 coding changes and enhancements this year to advance and refine its capabilities. Our product roadmap is full of great new ideas driven largely by our clients which means many years of continued improvements to come. With just a month left in the year, our total uptime is 99.955%, which exceeds our annual goal. We’re planning to migrate our Canadian data centers early in 2016 to bring even more performance and stability.
We’ve hired a number of bright experts from the non-profit help line world and our total staff has nearly doubled in size from the end of last year. You can expect to see expanded self-service tools, content and training as next year progresses.
From all of us here at iCarol, thank you so much for traveling this journey with us and best wishes for your new year.
CEO and Co-founder, iCarol
We mentioned recently that at this year’s AIRS conference a workshop called Resource Database Assembly: The Next Generation provided some inspiration in making a measurement available within iCarol that calculates the complexity of your resource database. We have now added this tool to iCarol.
Resource Complexity is a concept first suggested by several AIRS luminaries. By using approximations, it is used to calculate how complex your resource database is and how many hours per year it would take to manage them using the AIRS standards. For each Agency record, it gets 1 point for every Site record and 2 points for every Program record belonging to it. The Agencies are then grouped by their point score into the following categories:
Simple: 0-10 points
Moderate: 11-20 points
Difficult: 21-40 points
Complex: 41 points and higher
Once grouped and counted, you then assume an average number of hours per year for a trained worker to manage those resources, as follows:
Simple: 1-5 hours (average of 2.5 hours)
Moderate: 5-10 hours (average of 7.5 hours)
Difficult: 10-20 hours (average of 15 hours)
Complex: 20-40 hours (average of 30 hours)
With the total number of hours calculated to manage your entire database, you can then estimate how many Full Time Equivalent employees you may need to manage your database. There are 2,080 hours in a standard work year (40 hours per week for 52 weeks) but the hours available to an employee are usually less than that to account for vacation, sick days, training, meetings and other administrative work that will reduce their hours available to do resource database management.
To use this tool, simply navigate to Statistics and click on the Resources tab. The values for the assumptions of Resource Database Complexity described earlier obviously greatly affect the calculations. They have been in use by a major US 211 center since 2009, who claim they very accurately predict workload. Your own results may vary. If you would like this tool to allow you to modify these assumptions, you can contact our Support team using the Case Management tool found in the Help section of your iCarol system.
A large chunk of time spent managing records according to AIRS standards involves keeping those resources up-to-date. When records are regularly checked for accuracy and updated, you know your clients are receiving helpful, good information. This reduces the frustration and feelings of being overwhelmed experienced by those who may already be in crisis or an otherwise difficult situation. Even a database full of records rated as “simple” will take thousands of work hours to manage.
If you check your database’s complexity and feel overwhelmed at the number of hours it may take to keep your database in check, then it’s time to consider iCarol’s Automated Verification tool. With this upgrade you can seek out the resource records that need to be verified using the same search tools as you would to give referrals, with the additional tool of date parameters showing when the records were last verified. Next, automatically send an authorized worker of that agency or program an email asking them to review the information you have on file and make suggestions or updates. They’ll be given a peek at the information as it exists in your live database so they can make those suggestions. Finally, your Resource Manager can review this information and choose to accept what’s been submitted or make some of their own tweaks first, and then apply the update to the resource record. What might have taken weeks of phone tag to accomplish has been squashed down to a fraction of the time. To find out more about Automated Verification and how it can assist you with keeping your resources updated, sign in to your iCarol system and check out the video.
We hope you enjoy this new ability to view the complexity of the resources in your iCarol database and that it helps you analyze your staffing needs pertaining to keeping your Resource Database accurate and up-to-date.
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.
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.