I am trying to update an import module that we are using. I'm trying to have it import a field from the report CSV as a Constituent Code in RE. It's generating the following exception:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TABLEENTRIES_1". The conflict occurred in database "re7", table "dbo.CODETABLES", column "CODETABLESID".
In my import profile, I have the field name as "T CAP" (which is the constituent code I'd like to include for the constituent), the record type is "Constituent - Constituent Code", and there is no Value Type (there are apparently no options).
Any help would be appreciated. I'm fairly new at developing and maintaining IOM import modules.