Error: Required field missing: Category - when importing new or updating existing Ratings

When importing new Ratings or updating existing Ratings to Constituents records that have an existing Rating with a blank Category, the error "Required field missing: Category" may be received. This error may also be received when trying to delete any Ratings on these Constituent records using Admin > Globally Change Records, and may also be received when syncing these Constituent records in ResearchPoint.

When the rating record is opened, the Ratings field will be blank, but a rating may show up as normal in query results.
If you are experiencing this issue and you are using this version or a later version, click Chat with Support, reference this article, and provide the following information so we can assist you:

Steps to Duplicate

1. Go to Admin > Import, and in the Constituent list, open a new or existing Ratings import.
2. On the General tab, for "What do you want to do?", select Import new records or Update existing records.
3. Set up the spreadsheet to import new Ratings or update existing Ratings onto any Constituent record that has an existing Rating with a blank Category, and select the spreadsheet on the General tab of the Import.
4. Go to the Fields tab and ensure that The Raiser's Edge fields column matches the Fields to import column.
5. On the General tab, mark Validate data only, or leave that box unmarked.
6. Then, click the button at the bottom right that says either Validate Now or Import Now.
7.   The error is received (Required field missing: Category), and the import does not occur.

Environment

 Raiser's Edge

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.