Monthly Archives

June 2016

Using Excel for Nonprofit Data Migration

By | CRM & Salesforce, Salesforce shortcuts and tips

Thomas Edison famously said that “Genius is 99% perspiration and 1% inspiration.”  If he’d been a Salesforce user, he would have said, “Data upload is 99% preparation and 1% migration.” Data migration is the task of transferring large amounts of data into Salesforce from another platform. To accomplish this you will typically use Microsoft Excel or another spreadsheet program that allows you to create “common-separated value” or CSV files.  In this blog we will review some of the commonly used tools that are built into Excel to make it easier to prepare your data BEFORE you mass-migrate it into Salesforce, ensuring that the data you migrate is as accurate as possible.  After all, you don’t need to be a genius to know the expression, “Garbage in, garbage out”!

Read More

Case Management in NPSP: A Hidden Gem

By | Case Management

The case management functions of Salesforce are a hidden gem. These functions make any case manager’s work easier, more efficient and certainly more effective. The case management function offers a one-stop ability to track a client’s entire interaction with the organization. It is used for recording interactions between case management staff and program participants. Nonprofits that operate call centers, drop in centers, shelters, and client services use this convenient tool for tracking client engagement and progress throughout the lifetime of the client’s interaction with the organization.

Read More