Error: A field was specified that does not exist in the form definition: 'SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST'. - when importing into ResearchPoint using the Constituent Update Batch

Follow these steps to resolve the error:

In ResearchPoint, go to Administration > Batch > Batch Entry > Batch Templates
Edit the Constituent Update Batch
On the Select fields and defaults tab add the Spouse Relationship Type and Spouse Reciprocal Type fields to the selected fields
Save the Batch template
Go to Administration > Import > Add
Create a new import process using the Constituent Update Batch
Proceed with importing the records

Steps to Duplicate

1) Use an import file that includes the fields: Spouse First Name, Spouse Last Name, Spouse Relationship Type, Spouse Reciprocal Type
2) Log into ResearchPoint database
3) Go to Administration > Batch entry > Batch Templates
4) Edit the Constituent Update Batch
5) Make sure the template includes all fields from your import file EXCEPT Spouse Relationship Type and Spouse Reciprocal Type
6) Save the batch
7) Go to Administration > Import > Add
8) Create a new import process using the Constituent Update Batch
9) Map the fields -- note that the Spouse Relationship Type and Spouse Reciprocal Type fields are available for mapping even though they are not included in the batch template
10) Save the import and start the process

Environment

Affected Product ResearchPoint

Error: A field was specified that does not exist in the form definition: 'SPOUSE_RELATIONSHIPTYPECODEIDSIMPLELIST'. - when importing into ResearchPoint using the Constituent Update Batch

Steps to Duplicate

Environment

Was this article helpful?

Blackbaud Community

Chat with Support

Connect