Difference between revisions of "Orgs & People Extract"
From Charitylog Manual
Line 12: | Line 12: | ||
* whether to filter these people (for example, only display people who live in a certain district) | * whether to filter these people (for example, only display people who live in a certain district) | ||
* whether to output the data directly to a spreadsheet, or to a [[Blue Folder Lookup]] | * whether to output the data directly to a spreadsheet, or to a [[Blue Folder Lookup]] | ||
+ | |||
+ | |||
+ | __TOC__ | ||
+ | |||
+ | |||
+ | |||
+ | ==Creating a Data Extraction which produces a spreadsheet== | ||
+ | |||
+ | Click on the menu item to see a list of the Data Extractions currently set up on your system, if there are any. Click "Create New Export" to create a new one. | ||
+ | |||
+ | [[File:DE_2.png|border]] | ||
+ | |||
+ | |||
+ | ===Choose who to extract=== | ||
+ | |||
+ | Click on the "Who To Extract?" tab. | ||
+ | |||
+ | [[File:DE_3.png|border]] | ||
+ | |||
+ | |||
+ | You can now choose the different Types of organisations/people to show details for. For each Type, there are three choices: | ||
+ | |||
+ | # Include | ||
+ | ** | ||
+ | # Exclude | ||
+ | # Not Relevant |
Revision as of 15:40, 22 May 2015
Location in standard build: Reports > Data Extraction/Mail Merge
Data Extractions provide a way to export data about organisations/people stored on the system. You can choose:
- which types of organisation/person you want information about
- whether to filter these people (for example, only display people who live in a certain district)
- whether to output the data directly to a spreadsheet, or to a Blue Folder Lookup
Creating a Data Extraction which produces a spreadsheet
Click on the menu item to see a list of the Data Extractions currently set up on your system, if there are any. Click "Create New Export" to create a new one.
Choose who to extract
Click on the "Who To Extract?" tab.
You can now choose the different Types of organisations/people to show details for. For each Type, there are three choices:
- Include
- Exclude
- Not Relevant