Working with auction software (e.g., Greater Giving) and LGL
In this article:
- Export constituent data from LGL for import to Greater Giving
- Export sales data from Greater Giving for import to LGL
This article describes how to coordinate between your LGL database and your auction software and provides specific examples from Greater Giving on how to do this.
Illustration: How to coordinate between your LGL database and your auction software
Export constituent data from LGL for import to Greater Giving
For your new auction or special event, you'll create a project in Greater Giving, and you can then import a list of invitees (or bidders) into it.
We recommend exporting about 15 fields from LGL for each record you import to Greater Giving.
If you have created multiple records per household in LGL, we recommend exporting only one record per household for import to Greater Giving. Here's why:
Greater Giving uses the concept of "Household" to group individuals together, and every Individual will automatically be part of a household (even if they are the only member of the household). LGL has a flatter structure where all constituents are on the same level, and they can be connected laterally via "relationships". Typically in this situation, the main constituent has a contact type of "primary" and the related constituents have contact types of "spouse/partner" or "dependent".
It gets very complicated to export LGL relationships and to create households in Greater Giving. (We've tried!) So, our recommendation is instead to export from LGL just your "primary" contacts, not the secondary related contacts.
Greater Giving will automatically create a household to house the individual record.
Mapping LGL constituent fields to Greater Giving (See "Resources" below to download the full spreadsheet.)
Export sales data from Greater Giving for import to LGL
When your auction or special event is over, you will likely want to import the results back into your LGL database. Before you move immediately to transferring all sales information, think about how you'll use this data for stewardship. It is probably helpful to track who donated items for your auction (in-kind gifts) and certainly important to capture who "raised the paddle" (donations), but the fact that someone paid $1,800 for a trip to Africa valued at $2,200 might not be an indication of their level of support for your organization. The point is, think about what you're uploading into LGL before you throw it all in there.
Greater Giving has a number of pre-built exports for donor management systems, and the one we recommend using is the Sage-FR50 export.
Excerpt showing how the Sage FR50 export maps to LGL (See "Resources" below to download the full spreadsheet.)
Excel file showing how fields match up between LGL and Greater Giving: Importing and Exporting between LGL and Greater Giving
Greater Giving has an article on how to coordinate your work in Greater Giving with donor management software. Start by going to Greater Giving Online Help, and then navigate to Advanced how-to > Importing and exporting data > Data exchange guide.