CSV Individual Import - Previous Person Ids

[guymaness2]

Description

What does the change add or fix?

Added support to pass comma separated list of previous person ids in a column named PreviousPersonIds. If a value is provided in this column, the Individual import portion of the CSV component will include those ids as it searches for previously imported records. If it locates a match based on one of the previous ids and not the primary PersonId field, it will add a PersonAlias entry to the Rock record with a foreign key of the primary PersonId provided. Added support for importing alternate email addresses as PersonSearchKeys by providing a comma separated list of emails in a column named AlternateEmails.

---

Release Notes

What does the change add or fix in a succinct statement that will be read by clients?

CSV Importing

• Added support to pass comma separated list of previous person ids in a column named PreviousPersonIds.
• Added support to pass comma separated list of alternate emails in a column named AlternateEmails.
• Fixed undocumented bug causing person records imported into families that already exist in the database to not be fully and properly built.

---

Requested By

Who reported, requested, or paid for the change?

Grace Family of Churches

---

Screenshots

Does this update or add options to the block UI?

none

---

Change Log

What files does it affect?

• Bulldozer.CSV/CSVComponent.cs
• Bulldozer.CSV/Maps/Individual.cs

---

Migrations/External Impacts

Is it a breaking change for other versions/clients?

Requires an additional column titled "PreviousPersonIds" be added to Individual csv file for individual import to work moving forward.

[nateh777]

@guymaness2 when we merge this request we should update the Rock DLL to 12.6 if you have been using these changes with 12.6.

[guymaness2]

@nateh777 Last commit should be ready for your review.