Mapping tribute gifts

NOTE: If you began using Little Green Light before January 2019 and the Tributes link is not available in your Fundraising menu, you will first need to enable Tributes in your account. You can learn more about how to use it here.

Required fields

To import a gift and connect it to tribute, the minimum fields to include are:

  • Constituent first name
  • Constituent last name
  • Gift date
  • Gift amount
  • Tribute Name - the name of the tribute (for example, “Honorary - General”; or, in the case of a named tribute, the actual tribute name, such as “John Doe Memorial”).  Note: tributes must exist in LGL before they are imported.  

Special fields

You can also import the following fields to set notifications for the gift (a notification to a family member, for example):

  • Tribute Hon./Mem. Name - The name of the honoree/deceased
  • Tribute Recipient Name - The name of the person receiving notification about the tribute
  • Tribute Recipient Salutation - The salutation for the notification recipient
  • Tribute Recipient Email - The email for the notification recipient
  • Tribute Recipient Address - The mailing address of the notification recipient
  • Tribute Notification Template - The tribute notification template to be used  Note: This notification template name must exactly match (character for character) the name of an existing tribute notification template in your account.

Example: Tribute data only

To import just the basics, include the fields needed for the gift itself (donor/constituent, amount, date), and then associate that gift with a tribute, either using the “General” tribute name or a named tribute.

Import files

General tribute example

Importing this data will assign the tribute to the gift and connect the gift to a tribute (in this case to the “Honorary - General” tribute).

Instead of assigning the gift to the “General” tribute, you could alternatively connect the gift to a named tribute as shown here:

Named tribute example

Field mapping

Important clarification

These two fields names sound similar, but they are not:

  • Tribute Name
  • Tribute Hon./Mem. Name

Tribute Name is the name of a tribute that you’re tracking. Every account includes two default tribute names: Honorary - General and Memorial General. Those are the ones to use if you aren’t expecting many gifts for the honoree/deceased. Over time, these General tributes will accrue many gifts in them, representing many different honorees or deceased individuals.

Tribute Hon./Mem. Name is the name of the actual person who’s being honored or memorialized. In the case of a named tribute, this name is apt to be exactly the same as the tribute name, but in the case of a General tribute, the Tribute Hon./Mem. Name field is how you can identify the exact person being honored (which can then be pulled into the acknowledgment to the donor and into the notification to a family member).

Example: Tribute plus recipients, notifications, and dedication

Information for one person to notify (i.e., the recipient) can be imported with the tribute information for a gift.  

Import file

Import file column heading titles include:

  • First name
  • Last name
  • Amount
  • Date
  • Tribute Name
  • Tribute Hon./Mem. Name
  • Tribute Dedication
  • Tribute Recipient Name
  • Tribute Recipient Salutation
  • Tribute Recipient Email
  • Tribute Recipient Address
  • Tribute Notification Template

To set the notification mailing/email, a notification template must be part of the import (either as a column in your import file or by setting a default value using the “Add rule” function). IMPORTANT NOTE: The notification template name must match exactly to the name of an existing template in your account.

Field mapping

Record preview

Still need help? Contact Us Contact Us