SmartZIP RE Bulk Cleaning: Guide

SmartZIP RE Bulk Cleaning: Guide

Our SmartZIP RE Bulk tool allows you to export all (or a selection) of your address information. These can be verified and updated, then the results imported back into Raiser's Edge. To accomplish this there are two one-off tasks to complete, making the export and import's in Raiser's Edge. We also suggest creating an address attribute to store the status of your addresses.

These tasks use standard features of Raiser's Edge which most users will have access to although we do suggest you usually involve or pass this task to your Raiser's Edge administrator just due to their familiarity with the product.

Create an Address Attribute

To record the status of the address we recommend creating a new Address Attribute or type 'Text', 'Active', 1 per record called 'Address Validation Status'. 

Creating the Query (Export)

Your first task is to export the bank relationship information from Raiser's Edge to Excel using a QUERY:
  • Go to Query > New Query
  • Select the query type 'Constituent' and click 'OK'
  • Select the records to be cleaned. As an example you may choose the criteria as below:

  • Set the output fields in all cases to the below (ORDER is important, please ensure the fields are exactly as per the picture):

  • IMPORTANT Note: If you work with NZ addresses please also export the NZ City and NZ Suburb fields after the State field and before Country
  • Save the query as 'SmartZIP Bulk Export'

Running the Export

When the user uses the above query to export data from Raiser's Edge they will:
  • Go to Query and open the 'SmartZIP Bulk Export'
  • Go to File > Export
  • Select 'Excel 97-2000 (XLS)' as the format and 'Export Now' (note the file location as they then need to open the file in Excel)

Creating the Import 

Following a bulk SmartZIP process you will have a .imp file ready to be imported back into Raiser's Edge. To do this import please create a import as below:
  • Go to Admin > Import
  • Select 'Constituent Address' and click 'New'
  • On the General tab:
    • Select 'Update existing records'
    • Select your .imp file which will be in the same folder as the exported XLS file from the above export process
    • Select 'Create new table entries' to cope with counties and states that are missing from your Raiser's Edge database
    • The rest should be left at default values but for reference it should look as below:

  • Click 'Next' and leave the options at their defaults:

  • Fields should be mapped as below:

  • IMPORTANT: If working with NZ City and NZ Surburb in your Excel file they will need to be mapped after the State field in the above.
  • On the final tab we suggest you select to create an Exception file but the options are really down to yourselves.
  • Then save the Export as 'SmartZIP Bulk Import'
  • Finally click 'Update Now' to import the updated information back into Raiser's Edge

Notes

  • You may wish to review the file prior to import to correct any issues that might need manual intervention but you can also do this after the data is back in Raiser's Edge through use of the 'Address Validation attribute' field which has the overall status.

    • Related Articles

    • SmartZIP RE Guide

      Our Raiser's Edge edition of SmartZIP is a very quick and simple to use tool to provide address and now bank validation for Raiser's Edge. Installation is a case of following your trial email to download the program or it's windows ...

    • SmartZIP RE/Database View: Set up instructions

      Installation of SmartZIP RE is a quick three step process. 1. Set up your Loqate key You are hopefully aware that SmartZIP is powered by the leading provider of postcode lookups - Loqate (previously known as PCA Predict). You will need to set up your ...

    • SmartZIP RE: UK ONLY Guide - Bank and account verification when adding bank relationships

      SmartZIP from v1.87 supports adding bank details on the fly to a record. The process begins at the New Bank/Financial Institution dialog on the constituent record: You press F9 to launch the search dialog and enter your sort code and account number: ...

    • SmartZIP: Creating a Loqate Account

      Some of our products, powered by Loqate, require the user to have a Loqate account in order to use them (SmartZIP and SmartBANKVALIDATION). If you do not have a Loqate account, please click the link below to register for one: Set up Loqate account by ...

    • SmartZIP RENXT/BBCRM/eTapestry: Set up instructions

      This guide takes you through the installation of SmartZIP (Chrome edition) for Raiser's Edge NXT, eTapestry and Blackbaud CRM. Note: If you have just installed the Chrome extension skip to step 2. Step 1 - Install SmartZIP Using Google Chrome please ...