There are a few options to consider when adding resources to your database in bulk, which is considered a Resource Import.
Option 1: Resource Import Template:
We have standard templates (a custom Excel spreadsheet) for you to use to bring over your resources from another source. These templates have been built with the complexity or levels of the resource data in mind and can be provided upon request by our Support or Client Solution team, or accessed from within your iCarol system depending on your settings. The following templates are available:
- Agency Only – This will provide one level for your resource data.
- Agency/Site/Program/ProgramAtSite – This will provide to most flexibility for resource data to include Program and Site specific information. Complexity of the data depends on your source data and it may be 2 Levels (Agency & Program) or 3 Levels (Agency/Site/Program).
Option 2: Custom Import Project:
If you don't have an easy way of getting your information into our standard import templates, then we will propose a special paid project. We will work with you to understand the structure and size of your current database to scope a Custom Import Project. This would include a quote and estimated time frame for the work.
Option 3: Database sharing with another Agency:
Your agency may have a relationship with another agency in your area who is willing to grant you access to their database on an ongoing basis. This can include making referrals, running statistics and making the resources visible via your public resource directory published on your public website. This feature may have an additional cost associated with it, so if you're interested in learning more about sharing resources with another agency, have a designated Support Contact from your organization submit a case from the Help area to request more information about pricing.
Edit Resource Record(s)
When you're 'Editing' your resources in iCarol, you can determine which level of the resource you're in by looking at the top of the page, where you'll see the following, depending on the resource level selected:
- Agency will appear with a Gray bar at the top of the page, above the 'Agency Name' field
- Site will appear with a Blue bar at the top of the page, above the 'Site Name' field
- Program will appear with a Green bar at the top of the page, above the 'Program Name' field
- Program-At-Site will appear with a Yellow bar at the top of the page, above the 'ProgramAtSite Name' field; note, this level is only accessible after you select a Program offered at one or more Sites, and if you have the setting enabled in your system to be able to edit Program-at-Site records. Most organizations don't choose to edit this resource level.
Impact when making changes to Resource name
When you make changes to a name of a resource record it impacts statistics in the following ways:
Calls that were referred to resources prior to the name change, will still show the old resource name (when viewing call reports and in resource & referral statistics)
The new resource name will only apply to any referrals made after the name change was made
Move a program to another agency (Agency/Site/Program hierarchy only)
You can re-assign a Resource Program to another Agency as follows:
First, find the resource you want to modify. You can do this by performing a search on the main Resources page. Or you can click on Manage Resources, List all Resources and find it on the list. Then:
- Click on the Edit button
- Click on 'change agency to which this program belongs' (bottom right in box).
You should now see a pop-up box (if your blocker is not on) called 'Change Parent Agency'
- Type in new Agency name and click on 'search'
- Click on 'Change to this Agency now' to save the change.
- Click on 'Close Window'.
Inactive or Deleting a Resource Record
Sometimes you need to remove a resource from your database for many reasons, including but not limited to the resource is: a seasonal service (ex. holiday meals, school supplies, etc.), temporarily out of funding, a disaster response or relief resource, or unable to be verified.
You can decide set the resource to 'active, but do not refer', set it to 'inactive', or delete it entirely. Review the following information, and complete the steps after you've determined how to handle when resources need to be removed from your database.
Steps to make a resource 'Inactive' or 'Active, but do not refer':
- When viewing the details of an active resource, click the 'Edit' button at the top of the page
- Under the Agency Information section, set the 'Status' field to 'Inactive' or 'Active, but do not refer'
- At the top or bottom of the page click the 'Save' or 'Save and view resource' button
Important notes about setting resources to 'Inactive' or 'Active, but do not refer'
- It is best practice in iCarol to mark resources with either of these statuses, rather than deleting the resource entirely from your database
- When resources are marked with either of these statuses, they will still be available everywhere in iCarol (ex. Data Exports, Statistics, Resource searches)
- Users can adjust their filters to include or exclude resources marked as 'Inactive' or 'Active, but do not refer' when searching for resources
Steps to delete a resource:
- When viewing the details of an active resource, click the 'Edit' button at the top of the page
- Under the Agency Information section, set the 'Status' field to 'Inactive' or 'Active, but do not refer'
- At the top or bottom of the page click the 'Save' or 'Save and view resource' button
Note, you must delete the lowest level of the record first before deleting higher level records. For example, if your organization uses a 3 level structure (Agency, Site, Program), you must delete all Programs attached to a Site before you can delete the Site, then you must delete all Sites attached to an Agency before you can delete the Agency.
Important notes about deleting resource records
If you decide to delete a resource rather than making it inactive, then information about the resource record will no longer be available in certain areas of iCarol. Before deleting a resource, consider the following:
- After deleting a resource, information will still be available in the following:
- Admin Tools 'Call Reports Data Export' files; resource name will be prefixed with ‘DELETED’
- Call Reports where a referral was saved
- Statistics 'Resources and Referrals'; resource name will be prefixed with ‘DELETED’
- Statistics 'Caller Needs based on Taxonomy' reports; resource name will be prefixed with ‘DELETED’
- After deleting a resource, information will not be available in the following:
- Admin Tools 'Resource Data Export' files
- Statistics 'Resources Added or Updated' report
- Statistics reports (any) when the 'Referred Resources' filter is used
- After deleting a resource record you cannot un-delete it
Users with permission to edit resources can highlight selected resources as 'Preferred Providers/Referrals'. Enabling this setting makes it so when searching for resources, these records appear at the top of any list of search results, and the heading will have a green background; when this setting is not selected the (default) background color is blue.
Steps to make a resource a Preferred Provider:
- When creating or editing a resource, under the 'Temporary Message' section, select the setting 'Preferred provider - show at top of browse and search results'
- Click 'Save' and the resource will appear at the top of any list of search results, and the heading will have a green background
Users with permission to edit resources can highlight resources to appear by default on the main Resources search page, including when searching for resources from the link in the left side menu, or from within a call report.
After you complete a search, these highlighted resources no longer appear; they only appear the first time the main Resources search page loads.
Steps to highlight resource:
- When creating or editing a resource, under the 'Temporary Message' section, select the setting 'Show on highlighted list on main resource page'
- Click 'Save' and the resource will be highlighted when you the main Resources search page first loads