Blackbaud NetCommunity Email Stats export with no data from Raisers Edge Constituent Export

The integration between Blackbaud NetCommunity and The Raiser's Edge adds information to constituent records on the NetCommunity tab. In a constituent query, some of these fields can be queried on and are viewable in the query output. However, when selecting the NetCommunity from the Raiser's Edge Export module, the NetCommunity fields are blank in a constituent export.
These fields are not available through the Export module in RE.

The query module allows these fields to be exported. Add the desired NetCommunity fields in a constituent query to the Output tab and export the query results.

Steps to Duplicate

  1. In The Raiser's Edge, start a new Constituent Export in an Excel or CSV format.
  2. On the General tab, attach a constituent query to identify records with NetCommunity tab data.
  3. On the Output tab, select the following fields from the Blackbaud NetCommunity Email Stats
    • Clicked Through Flag?
    • Date Sent
    • Email Name
    • Opened Flag?
    • Subject
    • System Record ID
    • VBA User Field
  4. Run the Export.

Note: The NetCommunity fields export blank with no data.

Environment

 Raiser's Edge
 7.94
 7.91, 7.92, 7.93

Was this article helpful?