Start a new topic

Adding table entries to constituents

I need to add our prospect interest table entries (56 of them) to several records.  Is there a way to do this without mapping every entry in IOM configuration?  I'm hoping for some kind of virtual field or a cut and paste shortcut.  If not, I'll have to do it the old fashioned way and manually enter them all on each record.

Thank you, in advance, for any ideas.


Hi Barbara,

Are the entries already in your data file?

You will need to map each entry, whether it's in the Field Map area or Virtual Fields area. Unfortunately there isn't a shortcut, so they need to be mapped one by one.

Omatic Software

Thanks Amanda for the confirmation. 

Hi Barbara,

I'm not 100% sure I understand where you are coming from but I am assuming that the data has one row per donor and then 50+ columns of interests.

The way that I do this is to "flatten" the data so that each row represents just one ConsID/Interest pair.

For example, if I start with

ID  Interest1   Interest2
 1  Things  OtherThings
 2  MoreThings  Things


 ID  Interest
 1  Things
 1  OtherThings
 2  MoreThings
 2  Things


Once the data is like this then a simple IOM profile can import all of the different interests.

Login or Signup to post a comment