The following error may occur for the Primary Salutation Text or Primary Addressee Text when importing new constituent records your database requires Primary Addressee and Primary Salutation fields to save new records, and you choose to import Addressee and Salutation as editable fields.

Raiser's Edge Import reads your data file right to left. This error can occur when text field precedes the editable field. We recommend you include the following columns for editable addressee/salutations in this order:

Primary Addressee:

PrimAddEditPrimAddTextPrimAddID

Primary Salutation:

PrimSalEditPrimSalTextPrimSalID

Additional Notes:

The PrimAddID and the PrimSalID field must be populated with a numeric value of the Addressee/Salutation format desired. This ID value can be found running the Addressee/Salutations Report at Config > Addressee/Salutation.

If you do not want to add editable primary addressees and/or editable primary salutations in the import, remove the PrimAddEdit, PrimAddText, PrimSalEdit, and PrimSalText fields from the data file or remove their mapping on the Fields tab of the Import setup.

If Primary Addressee is set as required at Config > Fields > Constituent, the PrimAddEdit and PrimAddText columns are blank (no data), and the Primary Addressee fields are mapped for import, then the error may occur because Import is enforcing this requirement. To resolve the error, unmap the PrimAddEdit and PrimAddText fields on the Fields tab (if the data is blank) or temporarily uncheck Required for Primary Addressee at Config > Fields > Constituent.(if some fields have data and some don't).

If Primary Salutation is set as required at Config > Fields > Constituent, the PrimSalEdit and PrimSalText columns are blank (no data), and the Primary Salutation fields are mapped for import, then the error may occur because Import is enforcing this requirement. To resolve the error, unmap the PrimSalEdit and PrimSaText fields on the Fields tab (if the data is blank) or temporarily uncheck Required for Primary Salutation at Config > Fields > Constituent.(if some fields have data and some don't).

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!

We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.

We’re sorry to hear that. Please tell us why.

I don't like how this works.

The answer is confusing.

The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.