|
|
|
Create a new mapping, give it a name, and attach the associated CSV file.
|
|
|
|
|
|
|
|
Within each Entity, there may be some required CiviCRM fields that need to be mapped. These do not have corresponding fields in the CSV but are included in the tables below and indicated by italics.
|
|
|
|
|
|
|
|
### Contact Entity set-up:
|
|
|
|
|
|
|
|
- Entity: Contact
|
|
|
|
- For duplicate entity: No check
|
|
|
|
- Match on: \[leave blank\]
|
|
|
|
- Dedupe rule: Name and Email (reserved) (Individual)
|
|
|
|
|
|
|
|
NOTE: Contact entity mapping includes Primary Email Address and all CiviCRM custom fields.
|
|
|
|
|
|
|
|
<table>
|
|
|
|
<tr>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
**Col**
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
**Spreadsheet Column **
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
**CiviCRM Field**
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
**Value (where one needs to be set)**
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
**CiviCRM Field Group**
|
|
|
|
</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir=""> </span>
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir=""> </span>
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">_Contact Type\*_</span>
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">_Individual_</span>
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir=""> </span>
|
|
|
|
</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>A</td>
|
|
|
|
<td>nationbuilder_id</td>
|
|
|
|
<td>External Identifier</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>B</td>
|
|
|
|
<td>external_id</td>
|
|
|
|
<td>Old External ID</td>
|
|
|
|
<td> </td>
|
|
|
|
<td> </td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>C</td>
|
|
|
|
<td>prefix</td>
|
|
|
|
<td>Individual Prefix</td>
|
|
|
|
<td> </td>
|
|
|
|
<td> </td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>D</td>
|
|
|
|
<td>first_name</td>
|
|
|
|
<td>First Name</td>
|
|
|
|
<td> </td>
|
|
|
|
<td> </td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FR</td>
|
|
|
|
<td>Middle Name</td>
|
|
|
|
<td>Middle Name</td>
|
|
|
|
<td> </td>
|
|
|
|
<td> </td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>E</td>
|
|
|
|
<td>last_name</td>
|
|
|
|
<td>Last Name</td>
|
|
|
|
<td> </td>
|
|
|
|
<td> </td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>F</td>
|
|
|
|
<td>suffix</td>
|
|
|
|
<td>Individual Suffix</td>
|
|
|
|
<td> </td>
|
|
|
|
<td> </td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>G</td>
|
|
|
|
<td>email</td>
|
|
|
|
<td>Primary Email</td>
|
|
|
|
<td> </td>
|
|
|
|
<td> </td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CS</td>
|
|
|
|
<td>nickname</td>
|
|
|
|
<td>Nickname</td>
|
|
|
|
<td> </td>
|
|
|
|
<td> </td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>W</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">do_not_call</span>
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">Do Not Phone</span>
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
</td>
|
|
|
|
<td>Communication Preferences: Privacy</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>Y</td>
|
|
|
|
<td>federal_donotcall</td>
|
|
|
|
<td>Federal Do Not call</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>BW</td>
|
|
|
|
<td>employer</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir=""> </span>Employer
|
|
|
|
</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Additional Profile Details</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>BX</td>
|
|
|
|
<td>occupation</td>
|
|
|
|
<td>Position</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Additional Profile Details</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CA</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">born_at</span>
|
|
|
|
</td>
|
|
|
|
<td>Birth Date</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Demographics</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CB</td>
|
|
|
|
<td>is_deceased</td>
|
|
|
|
<td>Deceased</td>
|
|
|
|
<td>Yes (or leave blank)</td>
|
|
|
|
<td>Demographics</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CC</td>
|
|
|
|
<td>created_at</td>
|
|
|
|
<td>Created at</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CD</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">updated_at</span>
|
|
|
|
</td>
|
|
|
|
<td>Updated at</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CF</td>
|
|
|
|
<td>maiden_name</td>
|
|
|
|
<td>Maiden Name</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Additional Profile Details</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CG</td>
|
|
|
|
<td>graduation_year</td>
|
|
|
|
<td>Graduation Year</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>School Information</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CH</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">college</span>
|
|
|
|
</td>
|
|
|
|
<td>College or Post-Secondary Institution</td>
|
|
|
|
<td> </td>
|
|
|
|
<td> </td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CI</td>
|
|
|
|
<td>major</td>
|
|
|
|
<td>Major</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>School Information</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CJ</td>
|
|
|
|
<td>description</td>
|
|
|
|
<td>Bio</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Additional Profile Details</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CM</td>
|
|
|
|
<td>connection</td>
|
|
|
|
<td> Connection</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>School Information</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CN</td>
|
|
|
|
<td>load_id</td>
|
|
|
|
<td>Load ID</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CO</td>
|
|
|
|
<td>merged_load_id</td>
|
|
|
|
<td>Merged Load ID</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CP</td>
|
|
|
|
<td>origion</td>
|
|
|
|
<td>Origion</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CR</td>
|
|
|
|
<td>alt_id</td>
|
|
|
|
<td>Alt ID</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CT</td>
|
|
|
|
<td>grad</td>
|
|
|
|
<td>Graduate</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>School Information</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CU</td>
|
|
|
|
<td>high_school</td>
|
|
|
|
<td>High School</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>School Information</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CV</td>
|
|
|
|
<td>elementary_schools</td>
|
|
|
|
<td>Elementary School</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>School Information</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>CW</td>
|
|
|
|
<td>intermediate_junior_high_school</td>
|
|
|
|
<td>Intermediate Junior High School</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>School Information</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DC</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">narrative</span>
|
|
|
|
</td>
|
|
|
|
<td>Narrative</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DD</td>
|
|
|
|
<td>spouse_name</td>
|
|
|
|
<td>Spouse First Name</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Additional Profile Details</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DE</td>
|
|
|
|
<td>is_spouse_hse_grad</td>
|
|
|
|
<td>Did they go to same high school?</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Additional Profile Details</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DF</td>
|
|
|
|
<td>ambassador_registration</td>
|
|
|
|
<td>Ambassador</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DH</td>
|
|
|
|
<td>deceased_date</td>
|
|
|
|
<td>Deceased Date</td>
|
|
|
|
<td> </td>
|
|
|
|
<td> </td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DQ</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">land_plus_improvement_value</span>
|
|
|
|
</td>
|
|
|
|
<td>Land plus improvement value</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DR</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">improvement_value</span>
|
|
|
|
</td>
|
|
|
|
<td>Improvement value</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DS</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">assessed_value</span>
|
|
|
|
</td>
|
|
|
|
<td>Assessed value</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DT</td>
|
|
|
|
<td>length_of_residence</td>
|
|
|
|
<td>Length at residence</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DU</td>
|
|
|
|
<td>homeowner</td>
|
|
|
|
<td>Homeowner</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DW</td>
|
|
|
|
<td>acres</td>
|
|
|
|
<td>Acres</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DX</td>
|
|
|
|
<td>year_built</td>
|
|
|
|
<td>Year built</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DY</td>
|
|
|
|
<td>tax_amount</td>
|
|
|
|
<td>Tax amount</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>DZ</td>
|
|
|
|
<td>recording_date</td>
|
|
|
|
<td>Recording date</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>EA</td>
|
|
|
|
<td>sell_price</td>
|
|
|
|
<td>Sell price</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>EB</td>
|
|
|
|
<td>mortgage_amount</td>
|
|
|
|
<td>Mortgage amount</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>EC</td>
|
|
|
|
<td>mortgage_date</td>
|
|
|
|
<td>Mortgage date</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>EE</td>
|
|
|
|
<td>gender</td>
|
|
|
|
<td>Gender</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Demographics</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>EF</td>
|
|
|
|
<td>estimated_household_income</td>
|
|
|
|
<td>Estimated Household Income</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>EG</td>
|
|
|
|
<td>wealth_score</td>
|
|
|
|
<td>Wealth Score</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>EH</td>
|
|
|
|
<td>presence_of_children</td>
|
|
|
|
<td>Presence of children</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>EI</td>
|
|
|
|
<td>number_of_children</td>
|
|
|
|
<td>Number of children</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>EN</td>
|
|
|
|
<td>truemail</td>
|
|
|
|
<td> Truemail</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>ES</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">home_market_value</span>
|
|
|
|
</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">Estimated Home Market Value</span>
|
|
|
|
</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Wealth Indicator Data</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>ET</td>
|
|
|
|
<td>alumni_or_student_id</td>
|
|
|
|
<td> Alumni or Student ID</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Metadata</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FA</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">spouse_last_name</span>
|
|
|
|
</td>
|
|
|
|
<td>Spouse Last Name </td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Additional Profile Details</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FB</td>
|
|
|
|
<td>
|
|
|
|
|
|
|
|
<span dir="">clubs</span>
|
|
|
|
</td>
|
|
|
|
<td>Clubs</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FC</td>
|
|
|
|
<td>academic_teams</td>
|
|
|
|
<td>Academic Competitive Teams</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FD</td>
|
|
|
|
<td>art</td>
|
|
|
|
<td>Art</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FE</td>
|
|
|
|
<td>culture</td>
|
|
|
|
<td>Culture & Language</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FF</td>
|
|
|
|
<td>community</td>
|
|
|
|
<td>Community</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FG</td>
|
|
|
|
<td>leadership</td>
|
|
|
|
<td>Leadership</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FH</td>
|
|
|
|
<td>media</td>
|
|
|
|
<td>Media</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FI</td>
|
|
|
|
<td>military</td>
|
|
|
|
<td>Military</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FJ</td>
|
|
|
|
<td>music</td>
|
|
|
|
<td>Music</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FK</td>
|
|
|
|
<td>performance</td>
|
|
|
|
<td>Performance Arts</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FL</td>
|
|
|
|
<td>religious</td>
|
|
|
|
<td>Religious</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FM</td>
|
|
|
|
<td>roleplaying</td>
|
|
|
|
<td>Roleplaying/Fantasy</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FN</td>
|
|
|
|
<td>activism</td>
|
|
|
|
<td>Social Activism</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FO</td>
|
|
|
|
<td>special_interest</td>
|
|
|
|
<td>Special Interest</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FP</td>
|
|
|
|
<td>political</td>
|
|
|
|
<td>Speech and Political Interest</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
<tr>
|
|
|
|
<td>FQ</td>
|
|
|
|
<td>sports</td>
|
|
|
|
<td>Sports</td>
|
|
|
|
<td> </td>
|
|
|
|
<td>Activities & Clubs</td>
|
|
|
|
</tr>
|
|
|
|
</table>
|
|
|
|
|
|
|
|
<div>
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
<div>
|
|
|
|
|
|
|
|
<div>
|
|
|
|
|
|
|
|
|
|
|
|
</div>
|
|
|
|
</div>
|
|
|
|
</div> |
|
|
|
\ No newline at end of file |