Making bulk changes to your data

Overview

Within LGL, you can make bulk updates to groups and categories for more than one constituent at a time . But bulk updating your data itself is another matter.

The only way you can update any field for multiple constituents (examples include country, marital status, class affiliation, etc.) is to do so either by hand in each individual record or by:

Exporting the records you want to update
Making any changes in your export spreadsheet
Re-importing the updated data using the Flex Importer

Determine which fields to export

To do a bulk import, first export the data you want to change. This will typically include:

The field (or fields) you want to update
The LGL constituent ID
The ID for the data in the field/s you want to change, if one exists (for example, the “LGL Address ID” if you are updating the mailing address in multiple constituent records)

NOTE: If you were updating gifts, you’d export the LGL constituent ID and the LGL gift ID.

Here’s a list of IDs to include in your export if you’re updating any of the fields associated with them:

LGL Constituent ID
LGL Address ID
LGL Phone Number ID
LGL Email Address ID
LGL Gift ID
LGL Task ID
LGL Note ID
LGL Contact Report ID
LGL Vol. Time ID

Create your export

Export your fields and save the export to your computer. (Read about how to create an export here.)

Update your export data

Open your export spreadsheet. Your task here is to update or add the data you want to change so that each row in your update column/s contain/s the correct information. Make all of your changes, and then proofread them to make sure each is accurate. What is in your updated cells will end up in the field/s you are updating.

Import your updated spreadsheet into LGL

Re-import your updates into LGL. Be sure you follow the mapping instructions for the specific type/s of data you are importing, which are available from within this help article.