Error: The field 'Business' expects a valid ID. You may wish to review your settings on the Options tab of your import process.

When importing new individuals with businesses that are already in the database, and not using the business lookup ID, you may receive the error: The field 'Business' expects a valid ID. You may wish to review your settings on the Options tab of your import process.

 

  1. Go to Constituents > Batch Entry.
  2. Click on Batch Templates.  Click on the batch template being used in the import process, and click Edit.
  3. Go to the Select fields and defaults tab.
  4. On the left, select Business name and move this field to the right.
  5. Save the batch template.
  6. Go to Administration > Import.
  7. Edit your import process you are using.
  8. Go to the map fields tab.
  9. For the Business field, remove the import file column Business.
  10. For the Business name field, map this to the import file column Business.
  11. Go to Set Options > Other tab.  Make sure the Search List settings are set to quick find.
  12. Save and run the import.

Environment

 3.12

Was this article helpful?