Importing a Segmented House File fails with no exception report or errors

Importing a Segmented House File in a Direct Marketing Effort may fail with no indication of the issue other than the number of exceptions.
This issue may be caused by incorrect finder number check digits in the House File. Open the House File in a .csv editor and locate a finder number. Calculate the check digit using these instructions: https://www.blackbaud.com/files/support/howto/coveo/crm/MKTFinderNumCheckDigCalc.html Alternatively you may use a Luhn's Algorithm calculator to calculate the Check Digit.

If the Check Digit at the end of the finder number is incorrect you may need to contact the vendor of the house file to correct the finder numbers.

Environment

 Blackbaud CRM

Was this article helpful?