populating new group with exported Raiser's Edge CSV file

Options
Matt Larson
Matt Larson
Ancient Membership First Comment Facilitator Level 2 Inquirer Level 2
in Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions

I'm trying to populate a newly created group to be suppressed from our spring online campaign. I have a CSV file with the constituents primary email address, the Group ID # and the Group Name (see attached), as specified in "Creating Custom Constituent Imports" (CCCE). After defining the import and mapping the ields I tried to run the import and it failed due to: required variable attribute was not found current.CONS_ID. I'm not trying to use CONS_ID, though - I want Primary Email (which I can export from RE) to be the identifier. According to CCCE only one identifier is needed. Maybe I'm mapping it wrong?

Any help would be appreciated.

Thanks!

Matt

Tagged:

Comments

  • Bryce Katzman
    Bryce Katzman
    Ancient Membership 10 Comments Facilitator Level 2

    Try using

    EXT_GROUP_ID instead of Group ID as the column header and see if that helps. It could be the mapping though...BTW - I wouldn't recommend allowing people to see a data file with real email addresses.
  • Noah Cooper
    Noah Cooper
    Ancient Membership 1000 Comments 100 Likes Photogenic

    First, you only need one of either Group ID or Group Name, not both. The error message you're receiving may be slightly misleading -- I believe the issue you're running into is that when using the Custom Constituent Import to create records, you must have one field in addition to primary_email, such as last_name. If you don't actually have last names for these constituents, that's OK. Try adding a column header for last_name and leave each row blank (making sure to select one of the options other than "Overwrite all fields with values from the import file" on the Select Update Action step).

  • Matt Larson
    Matt Larson
    Ancient Membership First Comment Facilitator Level 2 Inquirer Level 2
    Noah Cooper:

    First, you only need one of either Group ID or Group Name, not both. The error message you're receiving may be slightly misleading -- I believe the issue you're running into is that when using the Custom Constituent Import to create records, you must have one field in addition to primary_email, such as last_name. If you don't actually have last names for these constituents, that's OK. Try adding a column header for last_name and leave each row blank (making sure to select one of the options other than "Overwrite all fields with values from the import file" on the Select Update Action step).

    Thanks. That worked. I changed group ID header as Bryce suggested and then added blank last name field.

    Matt

Categories