Step 3b: We Migrate the Data

Our responsibility

Your Sumac data migration expert formats and imports your data, as outlined in the approved Data Mapping document. When the migration is complete, we will install your database and provide you with instructions for accessing it.

Standard Time frame

3 weeks

Guidelines

In addition to following any instructions specified in the Data Mapping document, your Sumac data migration expert will make the following changes to the formatting of your data so that it conforms with Sumac’s requirements:
  • Mandatory Fields: Mandatory fields in Sumac must contain data. If any of your incoming records do not have data for mandatory fields, we will populate the field with a default value. For a complete list of mandatory fields and their default values, please consult the Data Migration Terminology and Defaults Guide.
  • Defaults for Fields Requiring a Specific Format: Certain fields in Sumac require data to be entered in a specific format. If any of your incoming records are not correctly formatted, we will re-format it according to set defaults in order to conform with the field requirements. For a complete list of default formats, please consult the Data Migration Terminology and Defaults Guide.
  • Duplicate Contacts: Because we cannot make assumptions about client data, we are unable to identify and completely remove duplicate records from incoming data. We will, however, employ some measures, at the time of migration, to reduce the number of duplicate contacts. For details on how we deal with duplicate contacts, please consult the Data Migration Terminology and Defaults Guide.
All other data will be left as is. This means that any data errors already existing in your current system will be transferred to Sumac, unless they have been specifically addressed in the data mapping document. We encounter small data problems in virtually every data migration we perform. Any problems encountered during migration (e.g. missing mandatory data, ambiguous data) will be noted in the Data Mapping document, and we will provide reports for you to review with your Sumac guru during the implementation phase.

Limitations

We cannot make any assumptions about your data. This means that, unless specified in the Data Mapping document, we will not address the following data problems:
  • Duplicates Contacts: if the same name appears several times in your data, we cannot assume that it is the same person. You will be responsible for merging duplicates during the Implementation Phase.
  • Lookup Lists: All field values (drop-down menus options, multiple checkboxes options, etc.) will be imported as is. For example, if a column of data contains the contact type values “board”, “board member”, and “board mber”, your Sumac data migration expert is not in a position to decide that these three values mean the same thing. All three values will thus appear in your Sumac list of Contact Types. You will be responsible for cleaning up Lookup Lists during the Implementation Phase.
Scroll to Top

Premium Memberships Package

Take your program further by integrating fundraising.
Includes:

All Basic features:

  • Manage member lifecycles
  • Member & membership tracking
  • Custom membership level definition
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

All Standard features:

  • Membership registration webforms

Plus:

  • Donations & fundraising
  • Donation webforms
  • Pledges & monthly donations
  • Fundraising campaigns
  • Event management
  • Automatic receipting
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Standard Memberships Package

Membership purchases flow from your web forms, through payment processing, and into your database, so there's less effort and less errors.
Includes:

All Basic features:

  • Manage member lifecycles
  • Member & membership tracking
  • Custom membership level definition
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

Plus:

  • Membership registration webforms
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Premium Donations Package

Manage complex donations for planned giving and larger gifts.
What's Included

All Basic features:

  • Donor & donation tracking
  • Email marketing
  • Fundraising campaigns
  • Pledges & monthly donations
  • Event management
  • Receipting
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

All Standard features:

  • Donation webforms

Plus:

  • Grant Management
  • Major Gift Proposals
  • Prospecting
  • Volunteer Management with online signup

Includes: Up to 750 contacts; Up to 5GB of storage capacity (cloud-based); Up to 3 concurrent users

Need more contacts, storage, or users? Just ask us!

Standard Donations Package

Donations flow from your website forms, straight through payment processing, and to your database, so there's less effort and less errors.
What's Included
All Basic features:
  • Donor & donation tracking
  • Email marketing
  • Fundraising campaigns
  • Pledges & monthly donations
  • Event management
  • Receipting
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support
Plus:
  • Donation webforms
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Basic Memberships Package

Manage your members and membership campaigns, engage members, and increasing revenue.
Includes:
  • Manage member lifecycles
  • Member & membership tracking
  • Custom membership level definition
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Basic Donations Package

Manage your donations and fundraising campaigns, engage donors, and increase revenue.
What's Included
  • Donor & donation tracking
  • Email marketing
  • Fundraising campaigns
  • Pledges & monthly donations
  • Event management
  • Receipting
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Premium Case Management Package

Take your program to the next level by integrating your fundraising.
Includes:

All Basic features:

  • Client profile & case intake definition
  • Complete case lifecycle tracking
  • Resource management
  • Service tracking
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

All Standard features:

  • Specialized Case Management setup (configured for health & social services, transition & emergency shelters, hospice & palliative care)
  • Client registration & intake webforms

Plus:

  • Donor management
  • Donation webforms
  • Pledges & monthly donations
  • Automatic receipting
  • Fundraising campaigns
  • Event management

Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 13 concurrent users

Need more contacts, storage, or users? Just ask us!

Standard Case Management Package

Pre-configured client management modules fit your exact program and make your administration even easier.
Includes:

All Basic features:

  • Client profile & case intake definition
  • Complete case lifecycle tracking
  • Resource management
  • Service tracking
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

Plus:

  • Specialized Case Management setup (configured for health & social services, transition & emergency shelters, hospice & palliative care)
  • Client registration & intake webforms

Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 8 concurrent users

Need more contacts, storage, or users? Just ask us!

Basic Case Management Package

Manage intake forms and client data securely so data transitions seamlessly from when a case opens to its close.
Includes:
  • Client profile & case intake definition
  • Complete case lifecycle tracking
  • Resource management
  • Service tracking
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Wait, don't go away empty handed.

Join 50,000 other nonprofits in getting the BEST nonprofit tips, tools, and how-to guides delivered right to your inbox!

Subscribe to our newsletter: