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?


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.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.