Orgs & People Extract

Introduction

Data Extraction/Mail Merge Definitions use person/org records without consideration of projects, allowing you to export all person/org records on the system. The data extraction tool allows the following three facilities:

1. Export Records direct to spread sheet.
2. Send to the Blue Folder Lookup tool.
3. Generate a mail merge with Letters or Email

File:Cl DE 2.png

Editing/Creating a definition

To edit an existing definition click on the name on the left or to create a new one click the 'Create New Definition' button. On the following screen you will be able to configure:

General Details Tab

• Definition Name - The name of the definition.
• Description - Used to explain what the definition is set up to do, this displays on the first page. Example 'Exports only Clients in North Postal District'.
• Include this extract in mail-merge audit? - When set to yes this will be in the Audit and will show in the letters and communications section of the person/org record, if its either a mail merge or an export to spreadsheet.
• Export function of this data extraction:
  • Export to Spreadsheet - Exports the results directly to a spreadsheet with the fields specified by the Filed Set.
  • Send to Blue Folder Lookup - Send the person/org record id's to the Blue Folder Lookup. It is important that a field set was not previously specified as this will produce an error. To check/change this then set to Export to Spreadsheet and set the 'Field Set' drop down to 'Select a Field Set', then change the Export Function back to 'Send to Blue Folder Lookup'
• Field Set - This option is ONLY required/used for Exporting to a Spreadsheet. Select the Field Set that contains the fields that you require.
• Export name to use in "save as" - If exporting to a spreadsheet you can specify a 'Save as' name for the spreadsheet. If the results a very larger and the export is converted to a CSV spreadsheet this name will not be used.
• Suppress people/organisations based on contact consent rules for letters - This will exclude people/orgs that have 'Suppress from mail-merge extract by default' set to 'No' in the Contact Rules of the persons/org record.
• Suppress people/organisations based on contact consent rules for emails - This will exclude people/orgs that have 'Suppress or Block Emails' set to 'Yes' in the Contact Rules of the persons/org record.
• Suppress anonymous and anonymised people/organisation records - This will exclude people that have been recorded using the record an anonymous record (whom have not been changed to a named person) and records that have been anonymised using the Cleanse/Anonymise Tool.
• Send only one letter/email to both "related and partnered" people, when both are in mail merge (and marked as such) - Using the Relationships Screen you can specify that two people only receive one letter in mail merges (you must also specify the joint salutation). If both of these records are part of the data set then they will be merged using the joint salutation on exports to spreadsheet and mail merges.
• Export active people/organisation records - This allows you to only use people/org records that are set to active.

Types of Orgs & People Tab

On this tab you will find the list of People and Organisation types you are using on your system. The names display are the ones specified in Customise Orgs & People. For each record type you can choose one of the following options:

• Not relevant - This will not include this record type when running the definition.
• Include - This will include this record type when running the definition.
• Exclude - This is to exclude a record type when running the definition. If a person/organisation is set to more than one record type the exclude will not use this record for the include.

Example
You wish to send a mail out to staff and a second mail out to volunteers.  You do not want to send anyone two mail outs.  The staff mail out is only set to include staff, the second mail out would be set to include volunteers and exclude staff.  Anyone that is both a staff member and volunteer would only be included in the staff mail out.

Running an existing definition

---