Try each of the following steps in order until the issue is resolved:




    • In the import data file, add a column for the Key Indicator field and populate it with O for organizations and I for individuals.

    • Ensure the Last Name field is populated for individuals and is mapped on the Fields tab of the import:

      1. In the import data file, verify each record for an individual has a value in the Last Name field.

      • On the Fields tab of the import parameters, verify the Last Name field is mapped to Raiser's Edge Last Name field.



      • Remove the hard breaks(carriage returns) from the Key Indicator field of the import file.

      • Remove spaces in the Key Indicator field of the import file. The field should only contain an I or an O.

      • Delete "blank" rows at the end of the data file:

        1. On the File Layout tab of the import parameters, verify the Sample Import Format is readable.

        • If not, open the import data file in Excel.

        • Select File, Save As and save the file in CSV format.

        • Open the data file in notepad.

        • Press the down arrow on your keyboard until you reach the end of the file.

        • Delete any blank lines.

        • Save and close the file.



        • If the IRImpID field is included without any other relationship fields, either delete the IRImpID from the import file or include the relationship fields.

        • If you are importing an organization relationship with the constituent, ensure there are no individual relationship fields included. For example, the IRIsEmp field is an individual relationship field not an individual constituent field.