SmartMETRICS Exports - include the System Record ID field and don't rename the column

SmartMETRICS works with Raiser's Edge queries and exports now. When working with exports there are a couple of requirements:

Ensure you select the Constituent System Record ID as one of your export outputs
DO NOT rename the System Record ID column.

You can right click on any export field and select 'Column heading' to rename it to something that clearer indicates the value. In fact we suggest you do this on most of your export fields i.e. 'No. of gifts over £10k' would be a good column heading. HOWEVER, please do not rename the 'System Record ID' field as the default name for this column is required by SmartMETRICS in order to find the record to be updated. If you have previously renamed the column please just remove the column heading completely and it will revert to the default heading value.

Related Articles
SmartCHECKOUT: GiveWP Export donations with custom fields i.e. BBMS Transaction ID
You may wish to do financial reconciliation between your GiveWP donations and Raiser's Edge NXT's gifts. BBMS Is Blackbaud Merchant Services and is the payment provider of choice for Blackbaud clients. Unfortunately GiveWP do not by default export ...
SmartPASTE list with over 500 produces error message "New edit field criteria box did not appear"
See: https://desk.zoho.com/portal/smartthingltd/kb/articles/smartpaste-and-findomatic-don-t-work-well-together
SmartMETRICS - Quickstart guide
Why do you need SmartMETRICs? SmartMETRICS is a great way to get intelligent with your supporter information. You can apply complex scoring to your database, giving you an advantage in our more competitive marketplace. SmartMETRICS lets you segment ...
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 ...
Raiser's Edge: Install a T-SQL based solution to run automatically
We sometimes provide solutions for Raiser's Edge based upon REOpen/T-SQL technology. These are installed to run automatically on a timed basis on your Raiser's Edge database server. To do this you will need your RE Database Administrators to follow ...

Related Articles