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:
PrimAddEdit
PrimAddText
PrimAddID

Primary Salutation:
PrimSalEdit
PrimSalText
PrimSalID


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).