SmartSYNC: Adding IDs as aliases to Raiser's Edge

SmartSYNC: Adding IDs as aliases to Raiser's Edge

Several of your SmartSYNC flows rely on having an external systems IDs stored in Raiser's Edge as an alias. This allows us to create that one to one record link between an external systems record and its corresponding RENXT constituent record.

To initially create this link you will have to create a one-off mapping between the systems, usually involving exporting information from the external system and RENXT and then matching in Microsoft Excel or Access. Once you have your list ready you then import it through RE Database View > Administration > Import > Constituent Alias.

Matching using Excel

We suggest you use =VLOOKUP(...) to perform matching in Excel as explained here. You can use it to match data in one column of your external system to your RENXT data.

As an example you could match email address in the external system with another worksheet containing your RENXT data and return the Constituent ID from the matched RENXT row. An example formula here might be in Cell B2:
  1. =VLOOKUP(A2, Sheet 2!A:B, 2, false)
    In this example:
    1. Cell A2 contains the Email address in the external system
    2. Sheet 2 contains the RENXT data with column A having the Email address and Column B containing the Constituent ID.
You would copy this formula to all the cells in column B of Sheet 1 (the External system worksheet). The resultant column will contain the matched Constituent IDs or '#N/A' if no match was found.

Steps to import IDs

  1. Add/Edit the columns in your Excel file:
    1. Alias Type: This will be the alias type in Raiser's Edge i.e. 'DotMailer ID' .
      Note: If an appropriate Alias Type does not currently exist in Raisers Edge you will need to add it within Config > Code Tables > Alias Types.
    2. Alias Name: Rename the column containing the external systems ID to 'Alias Name'
    3. Constituent ID: The Constituent ID of the RENXT record
  2. Save your Excel document as a CSV file
  3. Go to Administration > Import in RE Database View and double click 'Constituent Alias' in the middle column.
  4. Under General:
    1. Select your CSV file
      Note 1: Make sure you have closed Excel as you might get error messages otherwise.
      Note 2: You have to change the file filter (bottom right) when selecting your CSV to 'All files (*.*)' to see the CSV file.
    2. Select 'Use the Constituent ID'
  5. Under 'File Layout' click next
  6. Under 'Fields' map Alias Name, Alias Type and Constituent ID to fields of the same name i.e.
  7. Click 'Import Now'

    • Related Articles

    • SmartSYNC: Access NFP Donations to Raiser's Edge

      Access NFP provide their Appeal ID with each donation, we need to map this to the equivalent Campaign, Fund and Appeal in Raiser's Edge (RE). This page takes you through finding the Appeal ID and how to create a SmartSHEET to provide a mapping ...

    • SmartMAILCHIMP: Set up and configuration in Mailchimp and Raiser's Edge NXT

      How are Mailchimp and Raiser's Edge kept in sync? SmartMAILCHIMP works by transactional sync, changes are passed between Mailchimp and Raiser's Edge via our SmartSYNC platform as they happen. SmartMAILCHIMP connects a dynamic Constituent List in ...

    • SmartSYNC: Raiser's Edge 7 connector requirements

      If you have Raiser's Edge 7 (RE) self hosted and Blackbaud's REAPI addon then we can connect SmartSYNC for you. You will have a lot but not all the functionality of the product as we have reengineered a subset of the Blackbaud SKY API for RE7. The ...

    • SmartEMAIL: Connecting Gmail / Outlook to Raiser's Edge NXT

      Pick up the emails you wish to record First you need to create the category (in Outlook) or label (in Gmail) which you will apply to emails you wish SmartEMAIL to process. Any emails with this marker will be processed within 5 minutes by SmartSYNC ...

    • How to send emails from Raiser’s Edge via Outlook, Outlook 365 or OWA

      Raiser's Edge (RE) Database view (through Citrix) When you start RE via Citrix (by going to Blackbaud's website and logging in to launch the Database View of RE) there are no direct email integration options for sending emails. Clicking on an email ...