Start a new topic

Constituent Code

Hi all,

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.


Hi Ethan,

In order to properly assist you with this particular issue, I will need to examine the following files: the data file, the error.txt, and the IOM profile being used for this import. Please send these files to so that I can better assist you with your issue. When I have a resolution, I will post to this thread.

To send your IOM profile, please follow these steps:

* Go to IOM Configuration
* Highlight the name of the profile you are using
* Right click on it and choose to export
* Send the .xml file that is created
* It will be named in this fashion: IOM_Profile_Export_.xml

Omatic Support
Amanda will give you a real answer, but I ran into something similar when importing a constituent code with a space in it. You need to make sure that the field is surrounded by a double quote in the import file.
Wonderful, will do. Thanks so much.
Hi Ethan,

Thank you again for sending in your files. This error was caused by the Gift Appeal not being mapped in the virtual fields. Once we updated the mapping the import went through without error.

We also updated the mapping for the constituent code to use the Static Field function so that it will import the value in the Field Name to the constituent code.

Please let me know if you have any other questions.

Thank you,
Omatic Support
Login or Signup to post a comment