Control duplicates on import
In this article:
- Why it's important to use matching preferences in your import
- Selecting matching preferences
- Import Summary shows matches to records in your LGL account
- What happens when there are duplicates within an import file?
- Report showing how each row of import data was processed
Why it's important to use matching preferences in your import
Optimizing your constituent matching preferences is an important step in importing new data into Little Green Light. It helps prevent the creation of constituent records that are duplicates of existing constituent records already in your database.
Selecting matching preferences
LGL will always match on IDs if they are provided in your import spreadsheet (e.g., the LGL-created LGL Constituent ID or an external constituent ID that you provide). Beyond constituent IDs, you can also match on name and/or email address.
NOTE: When your import has a mapping for "External Constituent ID", LGL strongly recommends turning off all optional matching options because all you should need is this ID for a match to be correctly made. If you intend to import a file in which some rows contain external IDs but others do not, it is best to separate the file into two separate files so as to match on external ID only for the file with IDs present and use other appropriate matching options for the file with no IDs present.
Read the following sections of this article for a description of when to use which constituent matching preferences.
The checkbox options shown above allow you to control which types of matches to allow. If you check all the boxes, you'll be allowing all of the possible matches. By checking just one or two of the boxes, you'll be allowing just one or two types.
Match on LGL Constituent ID or External Constituent ID
If your import spreadsheet contains a column for either LGL Constituent ID or you have an external constituent ID, you can map to either of these fields in LGL to bring your data into the correct constituent record.
Match on email address and name
This option is safe for most imports but is limited to matching constituents that have email addresses. It will ensure that constituents match only when both the email address and first name match. This process looks at all email addresses.
(Click the image to view a larger size)
Match on email address only
This option is safe for most imports as well, but it is limited to matching constituents that have email addresses. It also looks at all email addresses and will match to the first constituent it finds with the same email address.
(Click the image to view a larger size)
Match on name only
Matching is performed on first and last names for individuals, or organization name for organizations. This option can be effective but should be used with caution in cases where it's relatively common to have more than one constituent in your database with the same name.
(Click the image to view a larger size)
Import Summary shows matches to records in your LGL account
The Import Summary indicates how many records are expected to be added as new or updated, based on successful matches to records that already exist in your LGL account.
What happens when there are duplicates within an import file?
If there are duplicates within your import spreadsheet, the Flex Importer will process those in the order they appear. But note that the Import Summary will not reflect those matches at the step where you review and commit the import. This is because the Flex Importer looks only at records that already exist in your LGL account.
As the Flex Importer processes each row in your spreadsheet, those rows are added to your LGL account and become part of your data. This means later rows in your spreadsheet (which the Flex Importer processes "later") might match to rows higher up in the spreadsheet (which the Flex Importer processed "earlier" in the import).
Example
This import spreadsheet contains 5 rows, and there are matches within the spreadsheet.
When this import has a "Ready for Review" status, it's possible the number of new constituent records shown will be higher than after the import completes processing. This is because there may be duplicates within the spreadsheet, and matching can happen only after the constituent records are created (after you accept the import).
During processing, the Flex Importer will successfully de-dupe these records because it can match against the rows that it has already processed. After you accept the import, the final Import Summary will show the true number of constituent records created versus the number that were updated:
Report showing how each row of import data was processed
Once your file is fully imported, you can generate a report showing exactly which records from your import spreadsheet matched and which did not match existing records (i.e., created new records) in your database. To create this report, click the Generate Export button in the "Review and commit" step of your import, as shown here:
The spreadsheet that results from this export contains all records and their status in terms of whether a match was found in LGL or not. If you want to see just those that were rejected, you can sort/filter by status in Excel to see all of the applicable records.