Importing Multiple Attributes to Existing Constituents

Gayle Bendoris

Hello,

Does anyone know how to import multiple attributes to existing constituents? I am able to do this by putting the constituent id and each of the attributes on separate rows but it seems as if it should be possible to keep each constituents data on the same row. Thanks!

ConsID	CAttrCat	CAttrDesc	CAttrDate
1	Which Y?	Southern Y	7/1/2023
1	DonorSearch Propensity	DS 1-1	7/1/2023
1	DonorSearch Wealth	$1,000,000 - $4,999,999	7/1/2023
1	Southern Y Campaign Prospect		7/1/2023

Austen Brown

@Gayle Bendoris - Here's more info on how to do it: https://kb.blackbaud.com/knowledgebase/Article/39511

Personally, I'd run a Constituent Attribute import, which matches how you currently have this set up.

Stu Manewith

@Gayle Bendoris ImportOmatic+ (Omatic Software) does what you need with one row per constituent and each attribute in its own column on the row. Don't hesitate to contact support@omaticsoftware.com or your Omatic consultant for more info.

Christine Robertson

@Gayle Bendoris - Yes - you can do this with the constituent and all of the data in one row. Just be sure that you check the extensions at the far right in the mapping screen as they can make or break your import.