|
|
This documents how to map National Builder data from Alumni Nations. It does not address data transformations that need to happen with the raw data prior to export (I'm working on a separate document with that information for the client).
|
|
|
|
|
|
Create a new mapping, give it a name, and attach the associated CSV file.
|
|
|
|
|
|
**NOTE:** Within each Entity, there may be some required CiviCRM fields that need to be mapped, sometimes with values. These do not have corresponding fields in the CSV but are included in the tables below and indicated with italics.
|
... | ... | @@ -720,7 +722,7 @@ Client has multiple address fields in Nation Builder. Each can be mapped with a |
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
**Spreadsheet Column**
|
|
|
**Spreadsheet Column**
|
|
|
</td>
|
|
|
<td>
|
|
|
|
... | ... | @@ -879,4 +881,164 @@ Client has multiple address fields in Nation Builder. Each can be mapped with a |
|
|
|
|
|
### Additional Address Entities set-up:
|
|
|
|
|
|
Add Entity: Address | No check |
|
|
\ No newline at end of file |
|
|
Add Entity: Address | No check
|
|
|
|
|
|
<table>
|
|
|
<tr>
|
|
|
<td>
|
|
|
|
|
|
**Col**
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
**Spreadsheet Column **
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
**CiviCRM Field**
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
**Value (where one needs to be set)**
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
**Notes**
|
|
|
</td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>
|
|
|
|
|
|
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">_Contact_</span> [<span dir="">_1.id_</span>](http://1.id)<span dir="">_(Contact)_</span>
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">_Contact ID_</span>
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
|
|
|
</td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>
|
|
|
|
|
|
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">_Address Location Type_</span>
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">_Billing, Home, Work,_ or _Other_</span>
|
|
|
</td>
|
|
|
<td>
|
|
|
|
|
|
|
|
|
</td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>AN, AY, BI</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">work_address1, mailing_address1 , user_submitted _address1</span>
|
|
|
</td>
|
|
|
<td>Street Address</td>
|
|
|
<td> </td>
|
|
|
<td> </td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>AO, AZ, BJ</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">work_address2, mailing_address2, user</span>_<span dir="">submitted _address2</span>
|
|
|
</td>
|
|
|
<td>Supplemental Address 1</td>
|
|
|
<td> </td>
|
|
|
<td> </td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>AP, BA, BK</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">work_address3, mailing</span>_<span dir="">address3, usersubmitted _address3</span>
|
|
|
</td>
|
|
|
<td>Supplemental Address 2</td>
|
|
|
<td> </td>
|
|
|
<td> </td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>AQ, BB, BL</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">work_city, mailing_city, </span>user_submitted _city
|
|
|
</td>
|
|
|
<td>City</td>
|
|
|
<td> </td>
|
|
|
<td> </td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>AR, BC, BM</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">work_county, mailing_county, user_submitted _county</span>
|
|
|
</td>
|
|
|
<td>County ID</td>
|
|
|
<td> </td>
|
|
|
<td> </td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>AS, BD, BN</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">work_state, mailing state, user_submitted _state</span>
|
|
|
</td>
|
|
|
<td>State/Province ID</td>
|
|
|
<td> </td>
|
|
|
<td> </td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>AT, BE, BO</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">work_zip, mailing_zip, user_submitted _zip</span>
|
|
|
</td>
|
|
|
<td>Postal Code</td>
|
|
|
<td> </td>
|
|
|
<td> </td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>AV, BG, BQ</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">work_country, mailing country, user_submitted _country</span>
|
|
|
</td>
|
|
|
<td>Country ID</td>
|
|
|
<td> </td>
|
|
|
<td> </td>
|
|
|
</tr>
|
|
|
<tr>
|
|
|
<td>AX, BH, BS</td>
|
|
|
<td>
|
|
|
|
|
|
<span dir="">work_submitted address, mailing_submitted_address, user_submitted_submitted_address</span>
|
|
|
</td>
|
|
|
<td>Updated by Contact</td>
|
|
|
<td> </td>
|
|
|
<td> </td>
|
|
|
</tr>
|
|
|
</table>
|
|
|
|