Updating Channels & Purposes with the File Uploader

You can use the file uploader to update channel and purpose permissions for existing constituents these are the steps you need to follow.

Note that this type of upload cannot be undone 

Download the data preparation template and find the Channel and Purposes worksheet - right click on the tab and from the pop-up menu choose Move or Copy, then choose to make a copy in a new book - make sure the new worksheet has the name 'Channels & Purposes'

 

In the worksheet in the new Excel workbook you then need to make the following entries, note you can remove any columns you do not need

  • Make entries into one of the Constituent Number, Email Address, Phone Number or External Key columns to allow Donorfy to identify the constituent to update  - see this article for more information about how Donorfy will identify the constituent
  • The Block_Email, Block_Mail, Block_Phone, Block_SMS columns allow you either block or allow contact by each channel - enter
    • Yes to block the communication channel,
    • No to allow the communication channel,
    • If the cell is left empty any existing setting of the channel will be left unchanged
  • The AllowPurpose_ columns should be used as follows, enter
    • Yes to allow a purpose,
    • No to disallow a purpose. 
    • If the cell is left empty or the column is removed from the worksheet then the purpose will be left unchanged
  • Preferred Channel - this allows you to update a constituent's preferred communication channel. The constituent must have contact details that work with the preferred channel - e.g. if the preferred channel is Email then the constituent must have an active email address. The preferred channel column can contain one of the following
    • Mail - preferred channel will be set to mailing address
    • Email - preferred channel will be set to email
    • Phone -  preferred channel will be set to phone
    • Do not contact - preferred channel will be set to 'Do not contact'
    • If the cell is left empty or the column is removed from the worksheet then the preferred channel will be left unchanged
  • These columns contain optional data will be used for history items generated in the preference centre
    • Consent Date - date associated with the update 
    • Consent Statement - a valid consent statement from your settings
    • Reason - a valid reason from your settings
    • Campaign - a valid campaign

 Please note

This is using a work sheet supplied in the Donorfy Upload Template - this will update existing constituents with Channel & Purpose settings - it will not upload tags - to upload tags follow the instructions within this article  This does not use a template but a simple excel workbook file 

 

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk