Addresses split into two record on import

Steve Kroser

Weirdest thing! I'm trying to import new constituents, each with a single address and multiple phone/emails. Everything works fine except that the addresses are being split into two address records; the address lines into one record and the city, state and zip into another. I'm using a quote qualified csv. Sample text of the address related fields below:

..."AddrImpID","PrefAddr","AddrType","AddrLines","AddrCity","AddrState","AddrZip"...

..."A18664","Yes","Home","3619 Main Street/n#23","Anytown","PA","15214"...

..."A18665","Yes","Home","5615 East First Avenue","Mycity","PA","15266"...


The resulting constituents each end up with two addresses. 

 

Alan French

Check the extensions on the Fields tab of the import settings. All the address fields should have an extension of 00. If the city, state and zip have a different extension to the other address fields, RE will treat them as a separate address.

Steve Kroser

Thanks Alan, that was the exact nudge I needed.!