I am doing a large import of constituents, some of whom may already be in RE.

I am importing from a .csv, the problem that I am getting is that I have the same constituents listed on mutiple rows but with different information. We have a ConsID (which i what I am using for the import), but we have a second ID from an older database. We need to keep record of it.

For example:

ConsID         OldID        FirstName        LastName          ZipCode

00001           798          John                 Doe                   97225

00001           798          John                 Doe                   10013

I have over 3000 rows of data,  there are up to 6 multiples of the same constituent over the rows. But different information, such as secondary addresses. The Constituent codes are constant over the rows.

When validating, it imports the first row for the constituent. When importing the second row for the same constituent, the second ID conflicts.
I get the error message "You cannot add this attribute more than once."

How can I work around this?

I think you might have to do the import in two passes; the first time mapping the first address & the second time mapping the second address. You may need to match all your duplicate data in Access into one row. And then your headings would be Addressfield1, addressfield2. It's a pain, but I don't think there's another way around it?

Ditto what Tracie said.  I also think each address would need a separate heading or be in a separate import.  You may be able to convert csv file to excel and do some of your filtering of duplicates if you need to separate data for additional imports.

Just a caution, if some of your constituents have a second address and others do not, be careful not to give blank fields an import ID or you could end  up with blank address created on your constituent records.

 You may wish to check with support for options. :-)

Good luck.

Based on the error message, have you checked the criteria for the Attribute in question in RE's Configuration section?  Maybe it's as simple as that ... I stumble across the "Allow only one per Record" setting once in awhile.

 Thanks All, I unchecked the Allow only one per Recod, which helped. But, put multiples of the same information.

I will find a work around for that later.