CDM+

How to export data from CDM+

People

  • Navigate to Membership and select Export.
  • Within the export window select Individual Export.
  • Under Advanced Search, select Configure Advanced Search.
  • Set the criteria as "Last name not equal to [blank]," to select all people that have a last name (which should be everyone).
  • Click Add, and name the report "Breeze." Afterwhich, select the Breeze report.
  • Click Modify, and select all desired fields. Include Giving Unit Code if importing giving data.
  • Click Refresh Data (circular arrow icon).
  • Set Export Format to Delimited (Text).
  • Check the Include Header Row option.
  • Set delimiter to Comma.
  • Click Export.

Contributions

  • Navigate to Contributions and select Reports.
  • Next, choose Export and set your desired date range.
  • Set export format to: Delimited.
    1. Delimiter: Select Custom and use the pipe symbol (|).
  • Create a new set of fields to export with Add called "Breeze" and select these fields:
    1. Giving Unit Salutation under Giving Unit (no individual first names for Contributions).
    2. Giving Unit Last Name under Giving Unit.
    3. Contribution Date under Contributions.
    4. Total Contribution Amount under Contribution.
    5. Description under Giving Fund.
    6. Payment Type under Contribution.
    7. Check Number under Contribution.
    8. Contribution Breakdown and Contribution Breakdown Amount under Contribution.
  • Export the giving information.