https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields.aspxen-USCommunityServer 2008.5 SP2 (Debug Build: 40407.4157)https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields.aspxSat, 04 Oct 2008 19:27:28 GMT1fa7c37c-d68d-46f5-9639-4669b01a21c5:7Troy Wolbrinkhttps://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/comments.aspxCurrent revision posted to Frequently Asked Questions by Troy Wolbrink on 10/4/2008 7:27:28 PM<br /> <h2>What are all the Contact import fields?</h2> <div style="font-size: 90%;">Filed under: <span style="background: SpringGreen;">Import</span> <span style="background: SpringGreen;">Contacts</span></div> <h1>Import Field Details</h1> <table border="1" style="cellborder:#000000 1px solid;border:#000000 1px solid;"> <tbody> <tr> <td align="center" style="border-width:1px;">Grouping</td> <td style="border-width:1px;">Field Name</td> <td style="border-width:1px;">Comments</td> </tr> <tr> <td align="center" style="border-width:1px;">Name</td> <td style="border-width:1px;">IsOrganization</td> <td style="border-width:1px;"> <div align="left"> <table border="1"> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">churches, companies, organizations</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">individuals</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="9" align="center" style="border-width:1px;">Name <p>(IsOrganization = &quot;False&quot;)</p> </td> <td style="border-width:1px;">Title</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">FirstName</td> <td style="border-width:1px;"></td> </tr> <tr> <td style="border-width:1px;">MiddleName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">LastName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Suffix</td> <td style="border-width:1px;">ex. Jr., Sr., II., III.</td> </tr> <tr> <td style="border-width:1px;">SpouseTitle</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Spouse</td> <td style="border-width:1px;">spouse first name</td> </tr> <tr> <td style="border-width:1px;">SpouseMiddleName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseLastName</td> <td style="border-width:1px;">only if different than LastName</td> </tr> <tr> <td align="center" style="border-width:1px;">Name <p>(IsOrganization = &quot;True&quot;)</p> </td> <td style="border-width:1px;">CompanyName</td> <td style="border-width:1px;">If IsOrganization = &quot;False&quot; then CompanyName refers to where the individual works.</td> </tr> <tr> <td align="center" style="border-width:1px;">Address</td> <td style="border-width:1px;">SelectedMailingAddress</td> <td style="border-width:1px;"> <div align="left"> <table border="1"> <tbody> <tr> <td style="border-width:1px;">1</td> <td style="border-width:1px;">Home</td> </tr> <tr> <td style="border-width:1px;">2</td> <td style="border-width:1px;">Business</td> </tr> <tr> <td style="border-width:1px;">3</td> <td style="border-width:1px;">Other</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">Home Address</td> <td style="border-width:1px;">HomeAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeCity</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeState</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeZip</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeCountry</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">Business Address</td> <td style="border-width:1px;">BusinessAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessCity</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessState</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessZip</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessCountry</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">Other Address</td> <td style="border-width:1px;">OtherAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherCity</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherState</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherZip</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherCountry</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="19" align="center" style="border-width:1px;">Phone</td> <td style="border-width:1px;">AssistantPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessPhone2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessFax</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">CallbackPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">CarPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">CompanyMainPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomePhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomePhone2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeFax</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ISDNPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">MobilePhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherFax</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">PagerNumber</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">PrimaryPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">RadioPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">TelexPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">TTYTDDPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="11" align="center" style="border-width:1px;">Internet</td> <td style="border-width:1px;">Email1</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Email2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Email3</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">UserCertificate</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">PersonalHomePage</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessHomePage</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">NetMeetingAlias</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">NetMeetingServer</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ComputerNetworkName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">FTPSite</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">InternetFreeBusyAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td align="center" style="border-width:1px;">Notes</td> <td style="border-width:1px;">Notes</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="3" align="center" style="border-width:1px;">Greetings</td> <td style="border-width:1px;">FullName</td> <td style="border-width:1px;">Formal greeting used to address envelopes</td> </tr> <tr> <td style="border-width:1px;">Greeting</td> <td style="border-width:1px;">Greeting used inside letters</td> </tr> <tr> <td style="border-width:1px;">ShortName</td> <td style="border-width:1px;">Formatted: FirstName and Spouse LastName</td> </tr> <tr> <td rowspan="17" align="center" style="border-width:1px;">MPD</td> <td style="border-width:1px;">CreatedDate</td> <td style="border-width:1px;">When the contact was first added to the database</td> </tr> <tr> <td style="border-width:1px;">OrgAccountIDs</td> <td style="border-width:1px;">Account ids associated with this contact by the organization.&nbsp; Multiple IDs can be separated by a comma. <p>Example:&nbsp;&nbsp; 12345678, 87654321, 18273645</p> </td> </tr> <tr> <td style="border-width:1px;">Deceased</td> <td style="border-width:1px;">True/False</td> </tr> <tr> <td style="border-width:1px;">DirectDeposit</td> <td style="border-width:1px;">True/False</td> </tr> <tr> <td style="border-width:1px;">MPDPhaseID</td> <td style="border-width:1px;"> <div align="left"> <table border="1"> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">n/a</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Contacted</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Ask in Future</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Appt</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Appt Scheduled</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Decision</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Financial</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Special</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Pray</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Not Interested</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Ask</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">NeverAsk</td> <td style="border-width:1px;"> <div align="left"> <table border="1"> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">Never ask this contact for support</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">Allow asking this contact for support</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">NextAsk</td> <td style="border-width:1px;">Date when you should ask this contact for support</td> </tr> <tr> <td style="border-width:1px;">PledgeAmount</td> <td style="border-width:1px;">If amount is greater than zero, PledgeFrequency must be greater than zero.</td> </tr> <tr> <td style="border-width:1px;">PledgeFrequency</td> <td style="border-width:1px;"> <div align="left"> <table border="1"> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;none&gt;</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">monthly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">bi-monthly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">quarterly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">4</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">quad-monthly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">6</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">semi-annual</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">12</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">annual</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">24</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">biannual</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">PledgeReceived</td> <td style="border-width:1px;"> <div align="left"> <table border="1"> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">First check has been received for this pledge</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">First check has not been received for this pledge</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">PledgeStartDate</td> <td style="border-width:1px;">Date when the pledge started</td> </tr> <tr> <td style="border-width:1px;">ReferredBy</td> <td style="border-width:1px;">Primary referrer</td> </tr> <tr> <td style="border-width:1px;">ReferredByList</td> <td style="border-width:1px;">All those who have referred you to this contact.&nbsp; Each referrer should be on their own line (separated by a carriage return).</td> </tr> <tr> <td style="border-width:1px;">Region</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SendNewsletter</td> <td style="border-width:1px;"> <div align="left"> <table border="1"> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">Send this contact a prayer letter</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">Don&#39;t send this contact a prayer letter</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">Magazine</td> <td style="border-width:1px;">True/False</td> </tr> <tr> <td style="border-width:1px;">LikelyToGive</td> <td style="border-width:1px;"> <div align="left"> <table border="1"> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Unassigned</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Least Likely</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Likely</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Most Likely</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="17" align="center" style="border-width:1px;">Personal / Professional</td> <td style="border-width:1px;">AssistantName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Categories</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Children</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ChurchName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Department</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">FamilyLevel</td> <td style="border-width:1px;"> <div align="left"> <table border="1"> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;None&gt;</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Very Extended</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Cousin</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Uncle/Aunt</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandparent</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Nephew/Niece</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Sibling</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Parent</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandchild</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Son/Daughter</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Immediate</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">FamilySide</td> <td style="border-width:1px;"> <div align="left"> <table border="1"> <tbody> <tr> <td style="border-width:1px;">0</td> <td style="border-width:1px;">&lt;none&gt;</td> </tr> <tr> <td style="border-width:1px;">1</td> <td style="border-width:1px;">His</td> </tr> <tr> <td style="border-width:1px;">2</td> <td style="border-width:1px;">Hers</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">Hobby</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">JobTitle</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ManagerName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">NickName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OfficeLocation</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Profession</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseCompanyName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseHobby</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseNickName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseProfession</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="9" align="center" style="border-width:1px;">Anniversary / Birthday</td> <td style="border-width:1px;">AnniversaryDay</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">AnniversaryMonth</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">AnniversaryYear</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BirthdayDay</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BirthdayMonth</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BirthdayYear</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseBirthdayDay</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseBirthdayMonth</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseBirthdayYear</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">User</td> <td style="border-width:1px;">User1</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">User2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">User3</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">User4</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">UserStatus</td> <td style="border-width:1px;">&nbsp;</td> </tr> </tbody> </table>https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/revision/9.aspxSat, 04 Oct 2008 19:27:28 GMT1fa7c37c-d68d-46f5-9639-4669b01a21c5:239Troy Wolbrinkhttps://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/comments.aspxRevision 9 posted to Frequently Asked Questions by Troy Wolbrink on 10/4/2008 7:27:28 PM<br /> <h2>What are all <span style="background: SpringGreen;">the</span> Contact import fields?</h2> <h1>Import Field Details</h1> <table style="cellborder:#000000 1px solid;border:#000000 1px solid;"> <tbody> <tr> <td align="center" style="border-width:1px;">Grouping</td> <td style="border-width:1px;">Field Name</td> <td style="border-width:1px;">Comments</td> </tr> <tr> <td align="center" style="border-width:1px;">Name</td> <td style="border-width:1px;">IsOrganization</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">churches, companies, organizations</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">individuals</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="9" align="center" style="border-width:1px;">Name <p>(IsOrganization = &quot;False&quot;)</p> </td> <td style="border-width:1px;">Title</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">FirstName</td> <td style="border-width:1px;"></td> </tr> <tr> <td style="border-width:1px;">MiddleName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">LastName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Suffix</td> <td style="border-width:1px;">ex. Jr., Sr., II., III.</td> </tr> <tr> <td style="border-width:1px;">SpouseTitle</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Spouse</td> <td style="border-width:1px;">spouse first name</td> </tr> <tr> <td style="border-width:1px;">SpouseMiddleName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseLastName</td> <td style="border-width:1px;">only if different than LastName</td> </tr> <tr> <td align="center" style="border-width:1px;">Name <p>(IsOrganization = &quot;True&quot;)</p> </td> <td style="border-width:1px;">CompanyName</td> <td style="border-width:1px;">If IsOrganization = &quot;False&quot; then CompanyName refers to where the individual works.</td> </tr> <tr> <td align="center" style="border-width:1px;">Address</td> <td style="border-width:1px;">SelectedMailingAddress</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">1</td> <td style="border-width:1px;">Home</td> </tr> <tr> <td style="border-width:1px;">2</td> <td style="border-width:1px;">Business</td> </tr> <tr> <td style="border-width:1px;">3</td> <td style="border-width:1px;">Other</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">Home Address</td> <td style="border-width:1px;">HomeAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeCity</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeState</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeZip</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeCountry</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">Business Address</td> <td style="border-width:1px;">BusinessAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessCity</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessState</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessZip</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessCountry</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">Other Address</td> <td style="border-width:1px;">OtherAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherCity</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherState</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherZip</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherCountry</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="19" align="center" style="border-width:1px;">Phone</td> <td style="border-width:1px;">AssistantPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessPhone2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessFax</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">CallbackPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">CarPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">CompanyMainPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomePhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomePhone2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeFax</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ISDNPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">MobilePhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherFax</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">PagerNumber</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">PrimaryPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">RadioPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">TelexPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">TTYTDDPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="11" align="center" style="border-width:1px;">Internet</td> <td style="border-width:1px;">Email1</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Email2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Email3</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">UserCertificate</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">PersonalHomePage</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessHomePage</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">NetMeetingAlias</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">NetMeetingServer</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ComputerNetworkName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">FTPSite</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">InternetFreeBusyAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td align="center" style="border-width:1px;">Notes</td> <td style="border-width:1px;">Notes</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="3" align="center" style="border-width:1px;">Greetings</td> <td style="border-width:1px;">FullName</td> <td style="border-width:1px;">Formal greeting used to address envelopes</td> </tr> <tr> <td style="border-width:1px;">Greeting</td> <td style="border-width:1px;">Greeting used inside letters</td> </tr> <tr> <td style="border-width:1px;">ShortName</td> <td style="border-width:1px;">Formatted: FirstName and Spouse LastName</td> </tr> <tr> <td rowspan="17" align="center" style="border-width:1px;">MPD</td> <td style="border-width:1px;">CreatedDate</td> <td style="border-width:1px;">When the contact was first added to the database</td> </tr> <tr> <td style="border-width:1px;">OrgAccountIDs</td> <td style="border-width:1px;">Account ids associated with this contact by the organization.&nbsp; Multiple IDs can be separated by a comma. <p>Example:&nbsp;&nbsp; 12345678, 87654321, 18273645</p> </td> </tr> <tr> <td style="border-width:1px;">Deceased</td> <td style="border-width:1px;">True/False</td> </tr> <tr> <td style="border-width:1px;">DirectDeposit</td> <td style="border-width:1px;">True/False</td> </tr> <tr> <td style="border-width:1px;">MPDPhaseID</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">n/a</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Contacted</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Ask in Future</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Appt</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Appt Scheduled</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Decision</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Financial</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Special</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Pray</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Not Interested</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Ask</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">NeverAsk</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">Never ask this contact for support</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">Allow asking this contact for support</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">NextAsk</td> <td style="border-width:1px;">Date when you should ask this contact for support</td> </tr> <tr> <td style="border-width:1px;">PledgeAmount</td> <td style="border-width:1px;">If amount is greater than zero, PledgeFrequency must be greater than zero.</td> </tr> <tr> <td style="border-width:1px;">PledgeFrequency</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;none&gt;</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">monthly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">bi-monthly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">quarterly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">4</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">quad-monthly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">6</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">semi-annual</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">12</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">annual</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">24</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">biannual</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">PledgeReceived</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">First check has been received for this pledge</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">First check has not been received for this pledge</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">PledgeStartDate</td> <td style="border-width:1px;">Date when the pledge started</td> </tr> <tr> <td style="border-width:1px;">ReferredBy</td> <td style="border-width:1px;">Primary referrer</td> </tr> <tr> <td style="border-width:1px;">ReferredByList</td> <td style="border-width:1px;">All those who have referred you to this contact.&nbsp; Each referrer should be on their own line (separated by a carriage return).</td> </tr> <tr> <td style="border-width:1px;">Region</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SendNewsletter</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">Send this contact a prayer letter</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">Don&#39;t send this contact a prayer letter</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">Magazine</td> <td style="border-width:1px;">True/False</td> </tr> <tr> <td style="border-width:1px;">LikelyToGive</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Unassigned</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Least Likely</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Likely</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Most Likely</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="17" align="center" style="border-width:1px;">Personal / Professional</td> <td style="border-width:1px;">AssistantName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Categories</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Children</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ChurchName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Department</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">FamilyLevel</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;None&gt;</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Very Extended</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Cousin</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Uncle/Aunt</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandparent</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Nephew/Niece</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Sibling</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Parent</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandchild</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Son/Daughter</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Immediate</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">FamilySide</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">0</td> <td style="border-width:1px;">&lt;none&gt;</td> </tr> <tr> <td style="border-width:1px;">1</td> <td style="border-width:1px;">His</td> </tr> <tr> <td style="border-width:1px;">2</td> <td style="border-width:1px;">Hers</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">Hobby</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">JobTitle</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ManagerName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">NickName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OfficeLocation</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Profession</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseCompanyName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseHobby</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseNickName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseProfession</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="9" align="center" style="border-width:1px;">Anniversary / Birthday</td> <td style="border-width:1px;">AnniversaryDay</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">AnniversaryMonth</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">AnniversaryYear</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BirthdayDay</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BirthdayMonth</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BirthdayYear</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseBirthdayDay</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseBirthdayMonth</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseBirthdayYear</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">User</td> <td style="border-width:1px;">User1</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">User2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">User3</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">User4</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">UserStatus</td> <td style="border-width:1px;">&nbsp;</td> </tr> </tbody> </table>https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/revision/8.aspxTue, 30 Sep 2008 17:59:56 GMT1fa7c37c-d68d-46f5-9639-4669b01a21c5:58Troy Wolbrinkhttps://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/comments.aspxRevision 8 posted to Frequently Asked Questions by Troy Wolbrink on 9/30/2008 5:59:56 PM<br /> <h2>What are all Contact import fields?</h2> <h1>Import Field Details</h1> <table style="cellborder:#000000 1px solid;border:#000000 1px solid;"> <tbody> <tr> <td align="center" style="border-width:1px;">Grouping</td> <td style="border-width:1px;">Field Name</td> <td style="border-width:1px;">Comments</td> </tr> <tr> <td align="center" style="border-width:1px;">Name</td> <td style="border-width:1px;">IsOrganization</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">churches, companies, organizations</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">individuals</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="9" align="center" style="border-width:1px;">Name <p>(IsOrganization = &quot;False&quot;)</p> </td> <td style="border-width:1px;">Title</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">FirstName</td> <td style="border-width:1px;"></td> </tr> <tr> <td style="border-width:1px;">MiddleName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">LastName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Suffix</td> <td style="border-width:1px;">ex. Jr., Sr., II., III.</td> </tr> <tr> <td style="border-width:1px;">SpouseTitle</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Spouse</td> <td style="border-width:1px;">spouse first name</td> </tr> <tr> <td style="border-width:1px;">SpouseMiddleName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseLastName</td> <td style="border-width:1px;">only if different than LastName</td> </tr> <tr> <td align="center" style="border-width:1px;">Name <p>(IsOrganization = &quot;True&quot;)</p> </td> <td style="border-width:1px;">CompanyName</td> <td style="border-width:1px;">If IsOrganization = &quot;False&quot; then CompanyName refers to where the individual works.</td> </tr> <tr> <td align="center" style="border-width:1px;">Address</td> <td style="border-width:1px;">SelectedMailingAddress</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">1</td> <td style="border-width:1px;">Home</td> </tr> <tr> <td style="border-width:1px;">2</td> <td style="border-width:1px;">Business</td> </tr> <tr> <td style="border-width:1px;">3</td> <td style="border-width:1px;">Other</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">Home Address</td> <td style="border-width:1px;">HomeAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeCity</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeState</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeZip</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeCountry</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">Business Address</td> <td style="border-width:1px;">BusinessAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessCity</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessState</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessZip</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessCountry</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">Other Address</td> <td style="border-width:1px;">OtherAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherCity</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherState</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherZip</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherCountry</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="19" align="center" style="border-width:1px;">Phone</td> <td style="border-width:1px;">AssistantPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessPhone2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessFax</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">CallbackPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">CarPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">CompanyMainPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomePhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomePhone2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">HomeFax</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ISDNPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">MobilePhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OtherFax</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">PagerNumber</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">PrimaryPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">RadioPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">TelexPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">TTYTDDPhone</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="11" align="center" style="border-width:1px;">Internet</td> <td style="border-width:1px;">Email1</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Email2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Email3</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">UserCertificate</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">PersonalHomePage</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BusinessHomePage</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">NetMeetingAlias</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">NetMeetingServer</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ComputerNetworkName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">FTPSite</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">InternetFreeBusyAddress</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td align="center" style="border-width:1px;">Notes</td> <td style="border-width:1px;">Notes</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="3" align="center" style="border-width:1px;">Greetings</td> <td style="border-width:1px;">FullName</td> <td style="border-width:1px;">Formal greeting used to address envelopes</td> </tr> <tr> <td style="border-width:1px;">Greeting</td> <td style="border-width:1px;">Greeting used inside letters</td> </tr> <tr> <td style="border-width:1px;">ShortName</td> <td style="border-width:1px;">Formatted: FirstName and Spouse LastName</td> </tr> <tr> <td rowspan="17" align="center" style="border-width:1px;">MPD</td> <td style="border-width:1px;">CreatedDate</td> <td style="border-width:1px;">When the contact was first added to the database</td> </tr> <tr> <td style="border-width:1px;">OrgAccountIDs</td> <td style="border-width:1px;">Account ids associated with this contact by the organization.&nbsp; Multiple IDs can be separated by a comma. <p>Example:&nbsp;&nbsp; 12345678, 87654321, 18273645</p> </td> </tr> <tr> <td style="border-width:1px;">Deceased</td> <td style="border-width:1px;">True/False</td> </tr> <tr> <td style="border-width:1px;">DirectDeposit</td> <td style="border-width:1px;">True/False</td> </tr> <tr> <td style="border-width:1px;">MPDPhaseID</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">n/a</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Contacted</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Ask in Future</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Appt</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Appt Scheduled</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Decision</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Financial</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Special</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Pray</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Not Interested</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Ask</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">NeverAsk</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">Never ask this contact for support</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">Allow asking this contact for support</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">NextAsk</td> <td style="border-width:1px;">Date when you should ask this contact for support</td> </tr> <tr> <td style="border-width:1px;">PledgeAmount</td> <td style="border-width:1px;">If amount is greater than zero, PledgeFrequency must be greater than zero.</td> </tr> <tr> <td style="border-width:1px;">PledgeFrequency</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;none&gt;</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">monthly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">bi-monthly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">quarterly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">4</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">quad-monthly</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">6</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">semi-annual</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">12</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">annual</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">24</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">biannual</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">PledgeReceived</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">First check has been received for this pledge</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">First check has not been received for this pledge</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">PledgeStartDate</td> <td style="border-width:1px;">Date when the pledge started</td> </tr> <tr> <td style="border-width:1px;">ReferredBy</td> <td style="border-width:1px;">Primary referrer</td> </tr> <tr> <td style="border-width:1px;">ReferredByList</td> <td style="border-width:1px;">All those who have referred you to this contact.&nbsp; Each referrer should be on their own line (separated by a carriage return).</td> </tr> <tr> <td style="border-width:1px;">Region</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SendNewsletter</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">True</td> <td style="border-width:1px;">Send this contact a prayer letter</td> </tr> <tr> <td style="border-width:1px;">False</td> <td style="border-width:1px;">Don&#39;t send this contact a prayer letter</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">Magazine</td> <td style="border-width:1px;">True/False</td> </tr> <tr> <td style="border-width:1px;">LikelyToGive</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Unassigned</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Least Likely</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Likely</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Most Likely</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="17" align="center" style="border-width:1px;">Personal / Professional</td> <td style="border-width:1px;">AssistantName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Categories</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Children</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ChurchName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Department</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">FamilyLevel</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;None&gt;</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Very Extended</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Cousin</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Uncle/Aunt</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandparent</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Nephew/Niece</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Sibling</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Parent</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandchild</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Son/Daughter</span></td> </tr> <tr> <td align="right" style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td style="border-width:1px;"><span style="font-size:x-small;color:#000000;font-family:Arial;">Immediate</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">FamilySide</td> <td style="border-width:1px;"> <div align="left"> <table> <tbody> <tr> <td style="border-width:1px;">0</td> <td style="border-width:1px;">&lt;none&gt;</td> </tr> <tr> <td style="border-width:1px;">1</td> <td style="border-width:1px;">His</td> </tr> <tr> <td style="border-width:1px;">2</td> <td style="border-width:1px;">Hers</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td style="border-width:1px;">Hobby</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">JobTitle</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">ManagerName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">NickName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">OfficeLocation</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">Profession</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseCompanyName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseHobby</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseNickName</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseProfession</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="9" align="center" style="border-width:1px;">Anniversary / Birthday</td> <td style="border-width:1px;">AnniversaryDay</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">AnniversaryMonth</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">AnniversaryYear</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BirthdayDay</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BirthdayMonth</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">BirthdayYear</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseBirthdayDay</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseBirthdayMonth</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">SpouseBirthdayYear</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td rowspan="5" align="center" style="border-width:1px;">User</td> <td style="border-width:1px;">User1</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">User2</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">User3</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">User4</td> <td style="border-width:1px;">&nbsp;</td> </tr> <tr> <td style="border-width:1px;">UserStatus</td> <td style="border-width:1px;">&nbsp;</td> </tr> </tbody> </table>https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/revision/7.aspxTue, 30 Sep 2008 17:52:21 GMT1fa7c37c-d68d-46f5-9639-4669b01a21c5:56Troy Wolbrinkhttps://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/comments.aspxRevision 7 posted to Frequently Asked Questions by Troy Wolbrink on 9/30/2008 5:52:21 PM<br /> <h2>What are all Contact import fields?</h2> <h1>Import Field Details</h1> <table style="cellborder:#000000 1px solid;border:#000000 1px solid;"> <tbody> <tr> <td align="center">Grouping</td> <td>Field Name</td> <td>Comments</td> </tr> <tr> <td align="center">Name</td> <td>IsOrganization</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>churches, companies, organizations</td> </tr> <tr> <td>False</td> <td>individuals</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="9" align="center">Name <p>(IsOrganization = &quot;False&quot;)</p> </td> <td>Title</td> <td>&nbsp;</td> </tr> <tr> <td style="height:25px;">FirstName</td> <td style="height:25px;"></td> </tr> <tr> <td>MiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>LastName</td> <td>&nbsp;</td> </tr> <tr> <td>Suffix</td> <td>ex. Jr., Sr., II., III.</td> </tr> <tr> <td>SpouseTitle</td> <td>&nbsp;</td> </tr> <tr> <td>Spouse</td> <td>spouse first name</td> </tr> <tr> <td>SpouseMiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseLastName</td> <td>only if different than LastName</td> </tr> <tr> <td align="center">Name <p>(IsOrganization = &quot;True&quot;)</p> </td> <td>CompanyName</td> <td>If IsOrganization = &quot;False&quot; then CompanyName refers to where the individual works.</td> </tr> <tr> <td align="center">Address</td> <td>SelectedMailingAddress</td> <td> <div align="left"> <table> <tbody> <tr> <td>1</td> <td>Home</td> </tr> <tr> <td>2</td> <td>Business</td> </tr> <tr> <td>3</td> <td>Other</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="5" align="center">Home Address</td> <td>HomeAddress</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCity</td> <td>&nbsp;</td> </tr> <tr> <td>HomeState</td> <td>&nbsp;</td> </tr> <tr> <td>HomeZip</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Business Address</td> <td>BusinessAddress</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCity</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessState</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessZip</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Other Address</td> <td>OtherAddress</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCity</td> <td>&nbsp;</td> </tr> <tr> <td>OtherState</td> <td>&nbsp;</td> </tr> <tr> <td>OtherZip</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="19" align="center">Phone</td> <td>AssistantPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone2</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessFax</td> <td>&nbsp;</td> </tr> <tr> <td>CallbackPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CarPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CompanyMainPhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone2</td> <td>&nbsp;</td> </tr> <tr> <td>HomeFax</td> <td>&nbsp;</td> </tr> <tr> <td>ISDNPhone</td> <td>&nbsp;</td> </tr> <tr> <td>MobilePhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherPhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherFax</td> <td>&nbsp;</td> </tr> <tr> <td>PagerNumber</td> <td>&nbsp;</td> </tr> <tr> <td>PrimaryPhone</td> <td>&nbsp;</td> </tr> <tr> <td>RadioPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TelexPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TTYTDDPhone</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="11" align="center">Internet</td> <td>Email1</td> <td>&nbsp;</td> </tr> <tr> <td>Email2</td> <td>&nbsp;</td> </tr> <tr> <td>Email3</td> <td>&nbsp;</td> </tr> <tr> <td>UserCertificate</td> <td>&nbsp;</td> </tr> <tr> <td>PersonalHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingAlias</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingServer</td> <td>&nbsp;</td> </tr> <tr> <td>ComputerNetworkName</td> <td>&nbsp;</td> </tr> <tr> <td>FTPSite</td> <td>&nbsp;</td> </tr> <tr> <td>InternetFreeBusyAddress</td> <td>&nbsp;</td> </tr> <tr> <td align="center">Notes</td> <td>Notes</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="3" align="center">Greetings</td> <td>FullName</td> <td>Formal greeting used to address envelopes</td> </tr> <tr> <td>Greeting</td> <td>Greeting used inside letters</td> </tr> <tr> <td>ShortName</td> <td>Formatted: FirstName and Spouse LastName</td> </tr> <tr> <td rowspan="17" align="center">MPD</td> <td>CreatedDate</td> <td>When the contact was first added to the database</td> </tr> <tr> <td>OrgAccountIDs</td> <td>Account ids associated with this contact by the organization.&nbsp; Multiple IDs can be separated by a comma. <p>Example:&nbsp;&nbsp; 12345678, 87654321, 18273645</p> </td> </tr> <tr> <td>Deceased</td> <td>True/False</td> </tr> <tr> <td>DirectDeposit</td> <td>True/False</td> </tr> <tr> <td>MPDPhaseID</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">n/a</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Contacted</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Ask in Future</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Appt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Appt Scheduled</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Decision</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Financial</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Special</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Pray</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Not Interested</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Ask</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NeverAsk</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Never ask this contact for support</td> </tr> <tr> <td>False</td> <td>Allow asking this contact for support</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NextAsk</td> <td>Date when you should ask this contact for support</td> </tr> <tr> <td>PledgeAmount</td> <td>If amount is greater than zero, PledgeFrequency must be greater than zero.</td> </tr> <tr> <td>PledgeFrequency</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;none&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">bi-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quarterly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">4</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quad-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">6</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">semi-annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">12</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">24</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">biannual</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeReceived</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>First check has been received for this pledge</td> </tr> <tr> <td>False</td> <td>First check has not been received for this pledge</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeStartDate</td> <td>Date when the pledge started</td> </tr> <tr> <td>ReferredBy</td> <td>Primary referrer</td> </tr> <tr> <td>ReferredByList</td> <td>All those who have referred you to this contact.&nbsp; Each referrer should be on their own line (separated by a carriage return).</td> </tr> <tr> <td>Region</td> <td>&nbsp;</td> </tr> <tr> <td>SendNewsletter</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Send this contact a prayer letter</td> </tr> <tr> <td>False</td> <td>Don&#39;t send this contact a prayer letter</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Magazine</td> <td>True/False</td> </tr> <tr> <td>LikelyToGive</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Unassigned</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Least Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Most Likely</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="17" align="center">Personal / Professional</td> <td>AssistantName</td> <td>&nbsp;</td> </tr> <tr> <td>Categories</td> <td>&nbsp;</td> </tr> <tr> <td>Children</td> <td>&nbsp;</td> </tr> <tr> <td>ChurchName</td> <td>&nbsp;</td> </tr> <tr> <td>Department</td> <td>&nbsp;</td> </tr> <tr> <td>FamilyLevel</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;None&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Very Extended</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Cousin</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Uncle/Aunt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandparent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Nephew/Niece</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Sibling</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Parent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandchild</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Son/Daughter</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Immediate</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>FamilySide</td> <td> <div align="left"> <table> <tbody> <tr> <td>0</td> <td>&lt;none&gt;</td> </tr> <tr> <td>1</td> <td>His</td> </tr> <tr> <td>2</td> <td>Hers</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Hobby</td> <td>&nbsp;</td> </tr> <tr> <td>JobTitle</td> <td>&nbsp;</td> </tr> <tr> <td>ManagerName</td> <td>&nbsp;</td> </tr> <tr> <td>NickName</td> <td>&nbsp;</td> </tr> <tr> <td>OfficeLocation</td> <td>&nbsp;</td> </tr> <tr> <td>Profession</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseCompanyName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseHobby</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseNickName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseProfession</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="9" align="center">Anniversary / Birthday</td> <td>AnniversaryDay</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryMonth</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryYear</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">User</td> <td>User1</td> <td>&nbsp;</td> </tr> <tr> <td>User2</td> <td>&nbsp;</td> </tr> <tr> <td>User3</td> <td>&nbsp;</td> </tr> <tr> <td>User4</td> <td>&nbsp;</td> </tr> <tr> <td>UserStatus</td> <td>&nbsp;</td> </tr> </tbody> </table>https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/revision/6.aspxTue, 30 Sep 2008 17:44:24 GMT1fa7c37c-d68d-46f5-9639-4669b01a21c5:55Troy Wolbrinkhttps://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/comments.aspxRevision 6 posted to Frequently Asked Questions by Troy Wolbrink on 9/30/2008 5:44:24 PM<br /> <h2>What are all Contact import fields?</h2> <h1>Import Field Details</h1> <table style="cellborder:#000000 1px solid;border:#000000 1px solid;"> <tbody> <tr> <td align="center">Grouping</td> <td>Field Name</td> <td>Comments</td> </tr> <tr> <td align="center">Name</td> <td>IsOrganization</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>churches, companies, organizations</td> </tr> <tr> <td>False</td> <td>individuals</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="9" align="center">Name <p>(IsOrganization = &quot;False&quot;)</p> </td> <td>Title</td> <td>&nbsp;</td> </tr> <tr> <td>FirstName</td> <td>&nbsp;</td> </tr> <tr> <td>MiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>LastName</td> <td>&nbsp;</td> </tr> <tr> <td>Suffix</td> <td>ex. Jr., Sr., II., III.</td> </tr> <tr> <td>SpouseTitle</td> <td>&nbsp;</td> </tr> <tr> <td>Spouse</td> <td>spouse first name</td> </tr> <tr> <td>SpouseMiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseLastName</td> <td>only if different than LastName</td> </tr> <tr> <td align="center">Name <p>(IsOrganization = &quot;True&quot;)</p> </td> <td>CompanyName</td> <td>If IsOrganization = &quot;False&quot; then CompanyName refers to where the individual works.</td> </tr> <tr> <td align="center">Address</td> <td>SelectedMailingAddress</td> <td> <div align="left"> <table> <tbody> <tr> <td>1</td> <td>Home</td> </tr> <tr> <td>2</td> <td>Business</td> </tr> <tr> <td>3</td> <td>Other</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="5" align="center">Home Address</td> <td>HomeAddress</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCity</td> <td>&nbsp;</td> </tr> <tr> <td>HomeState</td> <td>&nbsp;</td> </tr> <tr> <td>HomeZip</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Business Address</td> <td>BusinessAddress</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCity</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessState</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessZip</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Other Address</td> <td>OtherAddress</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCity</td> <td>&nbsp;</td> </tr> <tr> <td>OtherState</td> <td>&nbsp;</td> </tr> <tr> <td>OtherZip</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="19" align="center">Phone</td> <td>AssistantPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone2</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessFax</td> <td>&nbsp;</td> </tr> <tr> <td>CallbackPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CarPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CompanyMainPhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone2</td> <td>&nbsp;</td> </tr> <tr> <td>HomeFax</td> <td>&nbsp;</td> </tr> <tr> <td>ISDNPhone</td> <td>&nbsp;</td> </tr> <tr> <td>MobilePhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherPhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherFax</td> <td>&nbsp;</td> </tr> <tr> <td>PagerNumber</td> <td>&nbsp;</td> </tr> <tr> <td>PrimaryPhone</td> <td>&nbsp;</td> </tr> <tr> <td>RadioPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TelexPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TTYTDDPhone</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="11" align="center">Internet</td> <td>Email1</td> <td>&nbsp;</td> </tr> <tr> <td>Email2</td> <td>&nbsp;</td> </tr> <tr> <td>Email3</td> <td>&nbsp;</td> </tr> <tr> <td>UserCertificate</td> <td>&nbsp;</td> </tr> <tr> <td>PersonalHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingAlias</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingServer</td> <td>&nbsp;</td> </tr> <tr> <td>ComputerNetworkName</td> <td>&nbsp;</td> </tr> <tr> <td>FTPSite</td> <td>&nbsp;</td> </tr> <tr> <td>InternetFreeBusyAddress</td> <td>&nbsp;</td> </tr> <tr> <td align="center">Notes</td> <td>Notes</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="3" align="center">Greetings</td> <td>FullName</td> <td>Formal greeting used to address envelopes</td> </tr> <tr> <td>Greeting</td> <td>Greeting used inside letters</td> </tr> <tr> <td>ShortName</td> <td>Formatted: FirstName and Spouse LastName</td> </tr> <tr> <td rowspan="17" align="center">MPD</td> <td>CreatedDate</td> <td>When the contact was first added to the database</td> </tr> <tr> <td>OrgAccountIDs</td> <td>Account ids associated with this contact by the organization.&nbsp; Multiple IDs can be separated by a comma. <p>Example:&nbsp;&nbsp; 12345678, 87654321, 18273645</p> </td> </tr> <tr> <td>Deceased</td> <td>True/False</td> </tr> <tr> <td>DirectDeposit</td> <td>True/False</td> </tr> <tr> <td>MPDPhaseID</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">n/a</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Contacted</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Ask in Future</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Appt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Appt Scheduled</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Decision</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Financial</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Special</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Pray</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Not Interested</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Ask</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NeverAsk</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Never ask this contact for support</td> </tr> <tr> <td>False</td> <td>Allow asking this contact for support</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NextAsk</td> <td>Date when you should ask this contact for support</td> </tr> <tr> <td>PledgeAmount</td> <td>If amount is greater than zero, PledgeFrequency must be greater than zero.</td> </tr> <tr> <td>PledgeFrequency</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;none&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">bi-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quarterly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">4</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quad-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">6</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">semi-annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">12</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">24</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">biannual</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeReceived</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>First check has been received for this pledge</td> </tr> <tr> <td>False</td> <td>First check has not been received for this pledge</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeStartDate</td> <td>Date when the pledge started</td> </tr> <tr> <td>ReferredBy</td> <td>Primary referrer</td> </tr> <tr> <td>ReferredByList</td> <td>All those who have referred you to this contact.&nbsp; Each referrer should be on their own line (separated by a carriage return).</td> </tr> <tr> <td>Region</td> <td>&nbsp;</td> </tr> <tr> <td>SendNewsletter</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Send this contact a prayer letter</td> </tr> <tr> <td>False</td> <td>Don&#39;t send this contact a prayer letter</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Magazine</td> <td>True/False</td> </tr> <tr> <td>LikelyToGive</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Unassigned</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Least Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Most Likely</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="17" align="center">Personal / Professional</td> <td>AssistantName</td> <td>&nbsp;</td> </tr> <tr> <td>Categories</td> <td>&nbsp;</td> </tr> <tr> <td>Children</td> <td>&nbsp;</td> </tr> <tr> <td>ChurchName</td> <td>&nbsp;</td> </tr> <tr> <td>Department</td> <td>&nbsp;</td> </tr> <tr> <td>FamilyLevel</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;None&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Very Extended</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Cousin</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Uncle/Aunt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandparent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Nephew/Niece</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Sibling</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Parent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandchild</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Son/Daughter</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Immediate</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>FamilySide</td> <td> <div align="left"> <table> <tbody> <tr> <td>0</td> <td>&lt;none&gt;</td> </tr> <tr> <td>1</td> <td>His</td> </tr> <tr> <td>2</td> <td>Hers</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Hobby</td> <td>&nbsp;</td> </tr> <tr> <td>JobTitle</td> <td>&nbsp;</td> </tr> <tr> <td>ManagerName</td> <td>&nbsp;</td> </tr> <tr> <td>NickName</td> <td>&nbsp;</td> </tr> <tr> <td>OfficeLocation</td> <td>&nbsp;</td> </tr> <tr> <td>Profession</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseCompanyName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseHobby</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseNickName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseProfession</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="9" align="center">Anniversary / Birthday</td> <td>AnniversaryDay</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryMonth</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryYear</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">User</td> <td>User1</td> <td>&nbsp;</td> </tr> <tr> <td>User2</td> <td>&nbsp;</td> </tr> <tr> <td>User3</td> <td>&nbsp;</td> </tr> <tr> <td>User4</td> <td>&nbsp;</td> </tr> <tr> <td>UserStatus</td> <td>&nbsp;</td> </tr> </tbody> </table>https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/revision/5.aspxTue, 30 Sep 2008 17:43:09 GMT1fa7c37c-d68d-46f5-9639-4669b01a21c5:54Troy Wolbrinkhttps://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/comments.aspxRevision 5 posted to Frequently Asked Questions by Troy Wolbrink on 9/30/2008 5:43:09 PM<br /> <h2>What are all Contact import fields?</h2> <h1>Import Field Details</h1> <table style="border:#000000 1px solid;"> <tbody> <tr> <td align="center">Grouping</td> <td>Field Name</td> <td>Comments</td> </tr> <tr> <td align="center">Name</td> <td>IsOrganization</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>churches, companies, organizations</td> </tr> <tr> <td>False</td> <td>individuals</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="9" align="center">Name <p>(IsOrganization = &quot;False&quot;)</p> </td> <td>Title</td> <td>&nbsp;</td> </tr> <tr> <td>FirstName</td> <td>&nbsp;</td> </tr> <tr> <td>MiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>LastName</td> <td>&nbsp;</td> </tr> <tr> <td>Suffix</td> <td>ex. Jr., Sr., II., III.</td> </tr> <tr> <td>SpouseTitle</td> <td>&nbsp;</td> </tr> <tr> <td>Spouse</td> <td>spouse first name</td> </tr> <tr> <td>SpouseMiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseLastName</td> <td>only if different than LastName</td> </tr> <tr> <td align="center">Name <p>(IsOrganization = &quot;True&quot;)</p> </td> <td>CompanyName</td> <td>If IsOrganization = &quot;False&quot; then CompanyName refers to where the individual works.</td> </tr> <tr> <td align="center">Address</td> <td>SelectedMailingAddress</td> <td> <div align="left"> <table> <tbody> <tr> <td>1</td> <td>Home</td> </tr> <tr> <td>2</td> <td>Business</td> </tr> <tr> <td>3</td> <td>Other</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="5" align="center">Home Address</td> <td>HomeAddress</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCity</td> <td>&nbsp;</td> </tr> <tr> <td>HomeState</td> <td>&nbsp;</td> </tr> <tr> <td>HomeZip</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Business Address</td> <td>BusinessAddress</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCity</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessState</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessZip</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Other Address</td> <td>OtherAddress</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCity</td> <td>&nbsp;</td> </tr> <tr> <td>OtherState</td> <td>&nbsp;</td> </tr> <tr> <td>OtherZip</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="19" align="center">Phone</td> <td>AssistantPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone2</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessFax</td> <td>&nbsp;</td> </tr> <tr> <td>CallbackPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CarPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CompanyMainPhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone2</td> <td>&nbsp;</td> </tr> <tr> <td>HomeFax</td> <td>&nbsp;</td> </tr> <tr> <td>ISDNPhone</td> <td>&nbsp;</td> </tr> <tr> <td>MobilePhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherPhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherFax</td> <td>&nbsp;</td> </tr> <tr> <td>PagerNumber</td> <td>&nbsp;</td> </tr> <tr> <td>PrimaryPhone</td> <td>&nbsp;</td> </tr> <tr> <td>RadioPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TelexPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TTYTDDPhone</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="11" align="center">Internet</td> <td>Email1</td> <td>&nbsp;</td> </tr> <tr> <td>Email2</td> <td>&nbsp;</td> </tr> <tr> <td>Email3</td> <td>&nbsp;</td> </tr> <tr> <td>UserCertificate</td> <td>&nbsp;</td> </tr> <tr> <td>PersonalHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingAlias</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingServer</td> <td>&nbsp;</td> </tr> <tr> <td>ComputerNetworkName</td> <td>&nbsp;</td> </tr> <tr> <td>FTPSite</td> <td>&nbsp;</td> </tr> <tr> <td>InternetFreeBusyAddress</td> <td>&nbsp;</td> </tr> <tr> <td align="center">Notes</td> <td>Notes</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="3" align="center">Greetings</td> <td>FullName</td> <td>Formal greeting used to address envelopes</td> </tr> <tr> <td>Greeting</td> <td>Greeting used inside letters</td> </tr> <tr> <td>ShortName</td> <td>Formatted: FirstName and Spouse LastName</td> </tr> <tr> <td rowspan="17" align="center">MPD</td> <td>CreatedDate</td> <td>When the contact was first added to the database</td> </tr> <tr> <td>OrgAccountIDs</td> <td>Account ids associated with this contact by the organization.&nbsp; Multiple IDs can be separated by a comma. <p>Example:&nbsp;&nbsp; 12345678, 87654321, 18273645</p> </td> </tr> <tr> <td>Deceased</td> <td>True/False</td> </tr> <tr> <td>DirectDeposit</td> <td>True/False</td> </tr> <tr> <td>MPDPhaseID</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">n/a</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Contacted</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Ask in Future</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Appt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Appt Scheduled</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Decision</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Financial</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Special</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Pray</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Not Interested</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Ask</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NeverAsk</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Never ask this contact for support</td> </tr> <tr> <td>False</td> <td>Allow asking this contact for support</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NextAsk</td> <td>Date when you should ask this contact for support</td> </tr> <tr> <td>PledgeAmount</td> <td>If amount is greater than zero, PledgeFrequency must be greater than zero.</td> </tr> <tr> <td>PledgeFrequency</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;none&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">bi-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quarterly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">4</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quad-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">6</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">semi-annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">12</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">24</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">biannual</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeReceived</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>First check has been received for this pledge</td> </tr> <tr> <td>False</td> <td>First check has not been received for this pledge</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeStartDate</td> <td>Date when the pledge started</td> </tr> <tr> <td>ReferredBy</td> <td>Primary referrer</td> </tr> <tr> <td>ReferredByList</td> <td>All those who have referred you to this contact.&nbsp; Each referrer should be on their own line (separated by a carriage return).</td> </tr> <tr> <td>Region</td> <td>&nbsp;</td> </tr> <tr> <td>SendNewsletter</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Send this contact a prayer letter</td> </tr> <tr> <td>False</td> <td>Don&#39;t send this contact a prayer letter</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Magazine</td> <td>True/False</td> </tr> <tr> <td>LikelyToGive</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Unassigned</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Least Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Most Likely</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="17" align="center">Personal / Professional</td> <td>AssistantName</td> <td>&nbsp;</td> </tr> <tr> <td>Categories</td> <td>&nbsp;</td> </tr> <tr> <td>Children</td> <td>&nbsp;</td> </tr> <tr> <td>ChurchName</td> <td>&nbsp;</td> </tr> <tr> <td>Department</td> <td>&nbsp;</td> </tr> <tr> <td>FamilyLevel</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;None&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Very Extended</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Cousin</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Uncle/Aunt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandparent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Nephew/Niece</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Sibling</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Parent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandchild</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Son/Daughter</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Immediate</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>FamilySide</td> <td> <div align="left"> <table> <tbody> <tr> <td>0</td> <td>&lt;none&gt;</td> </tr> <tr> <td>1</td> <td>His</td> </tr> <tr> <td>2</td> <td>Hers</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Hobby</td> <td>&nbsp;</td> </tr> <tr> <td>JobTitle</td> <td>&nbsp;</td> </tr> <tr> <td>ManagerName</td> <td>&nbsp;</td> </tr> <tr> <td>NickName</td> <td>&nbsp;</td> </tr> <tr> <td>OfficeLocation</td> <td>&nbsp;</td> </tr> <tr> <td>Profession</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseCompanyName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseHobby</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseNickName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseProfession</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="9" align="center">Anniversary / Birthday</td> <td>AnniversaryDay</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryMonth</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryYear</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">User</td> <td>User1</td> <td>&nbsp;</td> </tr> <tr> <td>User2</td> <td>&nbsp;</td> </tr> <tr> <td>User3</td> <td>&nbsp;</td> </tr> <tr> <td>User4</td> <td>&nbsp;</td> </tr> <tr> <td>UserStatus</td> <td>&nbsp;</td> </tr> </tbody> </table>https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/revision/4.aspxMon, 29 Sep 2008 16:39:45 GMT1fa7c37c-d68d-46f5-9639-4669b01a21c5:53Troy Wolbrinkhttps://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/comments.aspxRevision 4 posted to Frequently Asked Questions by Troy Wolbrink on 9/29/2008 4:39:45 PM<br /> <h2>What are all Contact import fields?</h2> <h1>Import Field Details</h1> <table> <tbody> <tr> <td align="center">Grouping</td> <td>Field Name</td> <td>Comments</td> </tr> <tr> <td align="center">Name</td> <td>IsOrganization</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>churches, companies, organizations</td> </tr> <tr> <td>False</td> <td>individuals</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="9" align="center">Name <p>(IsOrganization = &quot;False&quot;)</p> </td> <td>Title</td> <td>&nbsp;</td> </tr> <tr> <td>FirstName</td> <td>&nbsp;</td> </tr> <tr> <td>MiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>LastName</td> <td>&nbsp;</td> </tr> <tr> <td>Suffix</td> <td>ex. Jr., Sr., II., III.</td> </tr> <tr> <td>SpouseTitle</td> <td>&nbsp;</td> </tr> <tr> <td>Spouse</td> <td>spouse first name</td> </tr> <tr> <td>SpouseMiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseLastName</td> <td>only if different than LastName</td> </tr> <tr> <td align="center">Name <p>(IsOrganization = &quot;True&quot;)</p> </td> <td>CompanyName</td> <td>If IsOrganization = &quot;False&quot; then CompanyName refers to where the individual works.</td> </tr> <tr> <td align="center">Address</td> <td>SelectedMailingAddress</td> <td> <div align="left"> <table> <tbody> <tr> <td>1</td> <td>Home</td> </tr> <tr> <td>2</td> <td>Business</td> </tr> <tr> <td>3</td> <td>Other</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="5" align="center">Home Address</td> <td>HomeAddress</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCity</td> <td>&nbsp;</td> </tr> <tr> <td>HomeState</td> <td>&nbsp;</td> </tr> <tr> <td>HomeZip</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Business Address</td> <td>BusinessAddress</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCity</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessState</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessZip</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Other Address</td> <td>OtherAddress</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCity</td> <td>&nbsp;</td> </tr> <tr> <td>OtherState</td> <td>&nbsp;</td> </tr> <tr> <td>OtherZip</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="19" align="center">Phone</td> <td>AssistantPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone2</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessFax</td> <td>&nbsp;</td> </tr> <tr> <td>CallbackPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CarPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CompanyMainPhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone2</td> <td>&nbsp;</td> </tr> <tr> <td>HomeFax</td> <td>&nbsp;</td> </tr> <tr> <td>ISDNPhone</td> <td>&nbsp;</td> </tr> <tr> <td>MobilePhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherPhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherFax</td> <td>&nbsp;</td> </tr> <tr> <td>PagerNumber</td> <td>&nbsp;</td> </tr> <tr> <td>PrimaryPhone</td> <td>&nbsp;</td> </tr> <tr> <td>RadioPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TelexPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TTYTDDPhone</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="11" align="center">Internet</td> <td>Email1</td> <td>&nbsp;</td> </tr> <tr> <td>Email2</td> <td>&nbsp;</td> </tr> <tr> <td>Email3</td> <td>&nbsp;</td> </tr> <tr> <td>UserCertificate</td> <td>&nbsp;</td> </tr> <tr> <td>PersonalHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingAlias</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingServer</td> <td>&nbsp;</td> </tr> <tr> <td>ComputerNetworkName</td> <td>&nbsp;</td> </tr> <tr> <td>FTPSite</td> <td>&nbsp;</td> </tr> <tr> <td>InternetFreeBusyAddress</td> <td>&nbsp;</td> </tr> <tr> <td align="center">Notes</td> <td>Notes</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="3" align="center">Greetings</td> <td>FullName</td> <td>Formal greeting used to address envelopes</td> </tr> <tr> <td>Greeting</td> <td>Greeting used inside letters</td> </tr> <tr> <td>ShortName</td> <td>Formatted: FirstName and Spouse LastName</td> </tr> <tr> <td rowspan="17" align="center">MPD</td> <td>CreatedDate</td> <td>When the contact was first added to the database</td> </tr> <tr> <td>OrgAccountIDs</td> <td>Account ids associated with this contact by the organization.&nbsp; Multiple IDs can be separated by a comma. <p>Example:&nbsp;&nbsp; 12345678, 87654321, 18273645</p> </td> </tr> <tr> <td>Deceased</td> <td>True/False</td> </tr> <tr> <td>DirectDeposit</td> <td>True/False</td> </tr> <tr> <td>MPDPhaseID</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">n/a</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Contacted</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Ask in Future</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Appt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Appt Scheduled</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Decision</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Financial</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Special</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Pray</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Not Interested</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Ask</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NeverAsk</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Never ask this contact for support</td> </tr> <tr> <td>False</td> <td>Allow asking this contact for support</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NextAsk</td> <td>Date when you should ask this contact for support</td> </tr> <tr> <td>PledgeAmount</td> <td>If amount is greater than zero, PledgeFrequency must be greater than zero.</td> </tr> <tr> <td>PledgeFrequency</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;none&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">bi-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quarterly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">4</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quad-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">6</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">semi-annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">12</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">24</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">biannual</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeReceived</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>First check has been received for this pledge</td> </tr> <tr> <td>False</td> <td>First check has not been received for this pledge</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeStartDate</td> <td>Date when the pledge started</td> </tr> <tr> <td>ReferredBy</td> <td>Primary referrer</td> </tr> <tr> <td>ReferredByList</td> <td>All those who have referred you to this contact.&nbsp; Each referrer should be on their own line (separated by a carriage return).</td> </tr> <tr> <td>Region</td> <td>&nbsp;</td> </tr> <tr> <td>SendNewsletter</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Send this contact a prayer letter</td> </tr> <tr> <td>False</td> <td>Don&#39;t send this contact a prayer letter</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Magazine</td> <td>True/False</td> </tr> <tr> <td>LikelyToGive</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Unassigned</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Least Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Most Likely</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="17" align="center">Personal / Professional</td> <td>AssistantName</td> <td>&nbsp;</td> </tr> <tr> <td>Categories</td> <td>&nbsp;</td> </tr> <tr> <td>Children</td> <td>&nbsp;</td> </tr> <tr> <td>ChurchName</td> <td>&nbsp;</td> </tr> <tr> <td>Department</td> <td>&nbsp;</td> </tr> <tr> <td>FamilyLevel</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;None&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Very Extended</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Cousin</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Uncle/Aunt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandparent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Nephew/Niece</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Sibling</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Parent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandchild</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Son/Daughter</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Immediate</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>FamilySide</td> <td> <div align="left"> <table> <tbody> <tr> <td>0</td> <td>&lt;none&gt;</td> </tr> <tr> <td>1</td> <td>His</td> </tr> <tr> <td>2</td> <td>Hers</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Hobby</td> <td>&nbsp;</td> </tr> <tr> <td>JobTitle</td> <td>&nbsp;</td> </tr> <tr> <td>ManagerName</td> <td>&nbsp;</td> </tr> <tr> <td>NickName</td> <td>&nbsp;</td> </tr> <tr> <td>OfficeLocation</td> <td>&nbsp;</td> </tr> <tr> <td>Profession</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseCompanyName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseHobby</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseNickName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseProfession</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="9" align="center">Anniversary / Birthday</td> <td>AnniversaryDay</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryMonth</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryYear</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">User</td> <td>User1</td> <td>&nbsp;</td> </tr> <tr> <td>User2</td> <td>&nbsp;</td> </tr> <tr> <td>User3</td> <td>&nbsp;</td> </tr> <tr> <td>User4</td> <td>&nbsp;</td> </tr> <tr> <td>UserStatus</td> <td>&nbsp;</td> </tr> </tbody> </table>https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/revision/3.aspxMon, 29 Sep 2008 16:39:45 GMT1fa7c37c-d68d-46f5-9639-4669b01a21c5:52Troy Wolbrinkhttps://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/comments.aspxRevision 3 posted to Frequently Asked Questions by Troy Wolbrink on 9/29/2008 4:39:45 PM<br /> <h2>What are all Contact import fields?</h2> <h1>Import Field Details</h1> <table> <tbody> <tr> <td align="center">Grouping</td> <td>Field Name</td> <td>Comments</td> </tr> <tr> <td align="center">Name</td> <td>IsOrganization</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>churches, companies, organizations</td> </tr> <tr> <td>False</td> <td>individuals</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="9" align="center">Name <p>(IsOrganization = &quot;False&quot;)</p> </td> <td>Title</td> <td>&nbsp;</td> </tr> <tr> <td>FirstName</td> <td>&nbsp;</td> </tr> <tr> <td>MiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>LastName</td> <td>&nbsp;</td> </tr> <tr> <td>Suffix</td> <td>ex. Jr., Sr., II., III.</td> </tr> <tr> <td>SpouseTitle</td> <td>&nbsp;</td> </tr> <tr> <td>Spouse</td> <td>spouse first name</td> </tr> <tr> <td>SpouseMiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseLastName</td> <td>only if different than LastName</td> </tr> <tr> <td align="center">Name <p>(IsOrganization = &quot;True&quot;)</p> </td> <td>CompanyName</td> <td>If IsOrganization = &quot;False&quot; then CompanyName refers to where the individual works.</td> </tr> <tr> <td align="center">Address</td> <td>SelectedMailingAddress</td> <td> <div align="left"> <table> <tbody> <tr> <td>1</td> <td>Home</td> </tr> <tr> <td>2</td> <td>Business</td> </tr> <tr> <td>3</td> <td>Other</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="5" align="center">Home Address</td> <td>HomeAddress</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCity</td> <td>&nbsp;</td> </tr> <tr> <td>HomeState</td> <td>&nbsp;</td> </tr> <tr> <td>HomeZip</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Business Address</td> <td>BusinessAddress</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCity</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessState</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessZip</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Other Address</td> <td>OtherAddress</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCity</td> <td>&nbsp;</td> </tr> <tr> <td>OtherState</td> <td>&nbsp;</td> </tr> <tr> <td>OtherZip</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="19" align="center">Phone</td> <td>AssistantPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone2</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessFax</td> <td>&nbsp;</td> </tr> <tr> <td>CallbackPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CarPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CompanyMainPhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone2</td> <td>&nbsp;</td> </tr> <tr> <td>HomeFax</td> <td>&nbsp;</td> </tr> <tr> <td>ISDNPhone</td> <td>&nbsp;</td> </tr> <tr> <td>MobilePhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherPhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherFax</td> <td>&nbsp;</td> </tr> <tr> <td>PagerNumber</td> <td>&nbsp;</td> </tr> <tr> <td>PrimaryPhone</td> <td>&nbsp;</td> </tr> <tr> <td>RadioPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TelexPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TTYTDDPhone</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="11" align="center">Internet</td> <td>Email1</td> <td>&nbsp;</td> </tr> <tr> <td>Email2</td> <td>&nbsp;</td> </tr> <tr> <td>Email3</td> <td>&nbsp;</td> </tr> <tr> <td>UserCertificate</td> <td>&nbsp;</td> </tr> <tr> <td>PersonalHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingAlias</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingServer</td> <td>&nbsp;</td> </tr> <tr> <td>ComputerNetworkName</td> <td>&nbsp;</td> </tr> <tr> <td>FTPSite</td> <td>&nbsp;</td> </tr> <tr> <td>InternetFreeBusyAddress</td> <td>&nbsp;</td> </tr> <tr> <td align="center">Notes</td> <td>Notes</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="3" align="center">Greetings</td> <td>FullName</td> <td>Formal greeting used to address envelopes</td> </tr> <tr> <td>Greeting</td> <td>Greeting used inside letters</td> </tr> <tr> <td>ShortName</td> <td>Formatted: FirstName and Spouse LastName</td> </tr> <tr> <td rowspan="17" align="center">MPD</td> <td>CreatedDate</td> <td>When the contact was first added to the database</td> </tr> <tr> <td>OrgAccountIDs</td> <td>Account ids associated with this contact by the organization.&nbsp; Multiple IDs can be separated by a comma. <p>Example:&nbsp;&nbsp; 12345678, 87654321, 18273645</p> </td> </tr> <tr> <td>Deceased</td> <td>True/False</td> </tr> <tr> <td>DirectDeposit</td> <td>True/False</td> </tr> <tr> <td>MPDPhaseID</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">n/a</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Contacted</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Ask in Future</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Appt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Appt Scheduled</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Decision</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Financial</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Special</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Pray</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Not Interested</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Ask</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NeverAsk</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Never ask this contact for support</td> </tr> <tr> <td>False</td> <td>Allow asking this contact for support</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NextAsk</td> <td>Date when you should ask this contact for support</td> </tr> <tr> <td>PledgeAmount</td> <td>If amount is greater than zero, PledgeFrequency must be greater than zero.</td> </tr> <tr> <td>PledgeFrequency</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;none&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">bi-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quarterly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">4</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quad-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">6</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">semi-annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">12</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">24</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">biannual</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeReceived</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>First check has been received for this pledge</td> </tr> <tr> <td>False</td> <td>First check has not been received for this pledge</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeStartDate</td> <td>Date when the pledge started</td> </tr> <tr> <td>ReferredBy</td> <td>Primary referrer</td> </tr> <tr> <td>ReferredByList</td> <td>All those who have referred you to this contact.&nbsp; Each referrer should be on their own line (separated by a carriage return).</td> </tr> <tr> <td>Region</td> <td>&nbsp;</td> </tr> <tr> <td>SendNewsletter</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Send this contact a prayer letter</td> </tr> <tr> <td>False</td> <td>Don&#39;t send this contact a prayer letter</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Magazine</td> <td>True/False</td> </tr> <tr> <td>LikelyToGive</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Unassigned</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Least Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Most Likely</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="17" align="center">Personal / Professional</td> <td>AssistantName</td> <td>&nbsp;</td> </tr> <tr> <td>Categories</td> <td>&nbsp;</td> </tr> <tr> <td>Children</td> <td>&nbsp;</td> </tr> <tr> <td>ChurchName</td> <td>&nbsp;</td> </tr> <tr> <td>Department</td> <td>&nbsp;</td> </tr> <tr> <td>FamilyLevel</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;None&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Very Extended</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Cousin</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Uncle/Aunt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandparent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Nephew/Niece</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Sibling</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Parent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandchild</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Son/Daughter</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Immediate</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>FamilySide</td> <td> <div align="left"> <table> <tbody> <tr> <td>0</td> <td>&lt;none&gt;</td> </tr> <tr> <td>1</td> <td>His</td> </tr> <tr> <td>2</td> <td>Hers</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Hobby</td> <td>&nbsp;</td> </tr> <tr> <td>JobTitle</td> <td>&nbsp;</td> </tr> <tr> <td>ManagerName</td> <td>&nbsp;</td> </tr> <tr> <td>NickName</td> <td>&nbsp;</td> </tr> <tr> <td>OfficeLocation</td> <td>&nbsp;</td> </tr> <tr> <td>Profession</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseCompanyName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseHobby</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseNickName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseProfession</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="9" align="center">Anniversary / Birthday</td> <td>AnniversaryDay</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryMonth</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryYear</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">User</td> <td>User1</td> <td>&nbsp;</td> </tr> <tr> <td>User2</td> <td>&nbsp;</td> </tr> <tr> <td>User3</td> <td>&nbsp;</td> </tr> <tr> <td>User4</td> <td>&nbsp;</td> </tr> <tr> <td>UserStatus</td> <td>&nbsp;</td> </tr> </tbody> </table>https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/revision/2.aspxMon, 29 Sep 2008 16:39:45 GMT1fa7c37c-d68d-46f5-9639-4669b01a21c5:49Troy Wolbrinkhttps://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/comments.aspxRevision 2 posted to Frequently Asked Questions by Troy Wolbrink on 9/29/2008 4:39:45 PM<br /> <h2>What are all Contact import fields?</h2> <h1>Import Field Details</h1> <table> <tbody> <tr> <td align="center">Grouping</td> <td>Field Name</td> <td>Comments</td> </tr> <tr> <td align="center">Name</td> <td>IsOrganization</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>churches, companies, organizations</td> </tr> <tr> <td>False</td> <td>individuals</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="9" align="center">Name <p>(IsOrganization = &quot;False&quot;)</p> </td> <td>Title</td> <td>&nbsp;</td> </tr> <tr> <td>FirstName</td> <td>&nbsp;</td> </tr> <tr> <td>MiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>LastName</td> <td>&nbsp;</td> </tr> <tr> <td>Suffix</td> <td>ex. Jr., Sr., II., III.</td> </tr> <tr> <td>SpouseTitle</td> <td>&nbsp;</td> </tr> <tr> <td>Spouse</td> <td>spouse first name</td> </tr> <tr> <td>SpouseMiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseLastName</td> <td>only if different than LastName</td> </tr> <tr> <td align="center">Name <p>(IsOrganization = &quot;True&quot;)</p> </td> <td>CompanyName</td> <td>If IsOrganization = &quot;False&quot; then CompanyName refers to where the individual works.</td> </tr> <tr> <td align="center">Address</td> <td>SelectedMailingAddress</td> <td> <div align="left"> <table> <tbody> <tr> <td>1</td> <td>Home</td> </tr> <tr> <td>2</td> <td>Business</td> </tr> <tr> <td>3</td> <td>Other</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="5" align="center">Home Address</td> <td>HomeAddress</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCity</td> <td>&nbsp;</td> </tr> <tr> <td>HomeState</td> <td>&nbsp;</td> </tr> <tr> <td>HomeZip</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Business Address</td> <td>BusinessAddress</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCity</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessState</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessZip</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Other Address</td> <td>OtherAddress</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCity</td> <td>&nbsp;</td> </tr> <tr> <td>OtherState</td> <td>&nbsp;</td> </tr> <tr> <td>OtherZip</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="19" align="center">Phone</td> <td>AssistantPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone2</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessFax</td> <td>&nbsp;</td> </tr> <tr> <td>CallbackPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CarPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CompanyMainPhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone2</td> <td>&nbsp;</td> </tr> <tr> <td>HomeFax</td> <td>&nbsp;</td> </tr> <tr> <td>ISDNPhone</td> <td>&nbsp;</td> </tr> <tr> <td>MobilePhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherPhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherFax</td> <td>&nbsp;</td> </tr> <tr> <td>PagerNumber</td> <td>&nbsp;</td> </tr> <tr> <td>PrimaryPhone</td> <td>&nbsp;</td> </tr> <tr> <td>RadioPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TelexPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TTYTDDPhone</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="11" align="center">Internet</td> <td>Email1</td> <td>&nbsp;</td> </tr> <tr> <td>Email2</td> <td>&nbsp;</td> </tr> <tr> <td>Email3</td> <td>&nbsp;</td> </tr> <tr> <td>UserCertificate</td> <td>&nbsp;</td> </tr> <tr> <td>PersonalHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingAlias</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingServer</td> <td>&nbsp;</td> </tr> <tr> <td>ComputerNetworkName</td> <td>&nbsp;</td> </tr> <tr> <td>FTPSite</td> <td>&nbsp;</td> </tr> <tr> <td>InternetFreeBusyAddress</td> <td>&nbsp;</td> </tr> <tr> <td align="center">Notes</td> <td>Notes</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="3" align="center">Greetings</td> <td>FullName</td> <td>Formal greeting used to address envelopes</td> </tr> <tr> <td>Greeting</td> <td>Greeting used inside letters</td> </tr> <tr> <td>ShortName</td> <td>Formatted: FirstName and Spouse LastName</td> </tr> <tr> <td rowspan="17" align="center">MPD</td> <td>CreatedDate</td> <td>When the contact was first added to the database</td> </tr> <tr> <td>OrgAccountIDs</td> <td>Account ids associated with this contact by the organization.&nbsp; Multiple IDs can be separated by a comma. <p>Example:&nbsp;&nbsp; 12345678, 87654321, 18273645</p> </td> </tr> <tr> <td>Deceased</td> <td>True/False</td> </tr> <tr> <td>DirectDeposit</td> <td>True/False</td> </tr> <tr> <td>MPDPhaseID</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">n/a</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Contacted</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Ask in Future</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Appt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Appt Scheduled</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Decision</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Financial</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Special</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Pray</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Not Interested</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Ask</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NeverAsk</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Never ask this contact for support</td> </tr> <tr> <td>False</td> <td>Allow asking this contact for support</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NextAsk</td> <td>Date when you should ask this contact for support</td> </tr> <tr> <td>PledgeAmount</td> <td>If amount is greater than zero, PledgeFrequency must be greater than zero.</td> </tr> <tr> <td>PledgeFrequency</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;none&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">bi-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quarterly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">4</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quad-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">6</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">semi-annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">12</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">24</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">biannual</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeReceived</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>First check has been received for this pledge</td> </tr> <tr> <td>False</td> <td>First check has not been received for this pledge</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeStartDate</td> <td>Date when the pledge started</td> </tr> <tr> <td>ReferredBy</td> <td>Primary referrer</td> </tr> <tr> <td>ReferredByList</td> <td>All those who have referred you to this contact.&nbsp; Each referrer should be on their own line (separated by a carriage return).</td> </tr> <tr> <td>Region</td> <td>&nbsp;</td> </tr> <tr> <td>SendNewsletter</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Send this contact a prayer letter</td> </tr> <tr> <td>False</td> <td>Don&#39;t send this contact a prayer letter</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Magazine</td> <td>True/False</td> </tr> <tr> <td>LikelyToGive</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Unassigned</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Least Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Most Likely</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="17" align="center">Personal / Professional</td> <td>AssistantName</td> <td>&nbsp;</td> </tr> <tr> <td>Categories</td> <td>&nbsp;</td> </tr> <tr> <td>Children</td> <td>&nbsp;</td> </tr> <tr> <td>ChurchName</td> <td>&nbsp;</td> </tr> <tr> <td>Department</td> <td>&nbsp;</td> </tr> <tr> <td>FamilyLevel</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;None&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Very Extended</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Cousin</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Uncle/Aunt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandparent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Nephew/Niece</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Sibling</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Parent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandchild</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Son/Daughter</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Immediate</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>FamilySide</td> <td> <div align="left"> <table> <tbody> <tr> <td>0</td> <td>&lt;none&gt;</td> </tr> <tr> <td>1</td> <td>His</td> </tr> <tr> <td>2</td> <td>Hers</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Hobby</td> <td>&nbsp;</td> </tr> <tr> <td>JobTitle</td> <td>&nbsp;</td> </tr> <tr> <td>ManagerName</td> <td>&nbsp;</td> </tr> <tr> <td>NickName</td> <td>&nbsp;</td> </tr> <tr> <td>OfficeLocation</td> <td>&nbsp;</td> </tr> <tr> <td>Profession</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseCompanyName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseHobby</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseNickName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseProfession</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="9" align="center">Anniversary / Birthday</td> <td>AnniversaryDay</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryMonth</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryYear</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">User</td> <td>User1</td> <td>&nbsp;</td> </tr> <tr> <td>User2</td> <td>&nbsp;</td> </tr> <tr> <td>User3</td> <td>&nbsp;</td> </tr> <tr> <td>User4</td> <td>&nbsp;</td> </tr> <tr> <td>UserStatus</td> <td>&nbsp;</td> </tr> </tbody> </table>https://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/revision/1.aspxMon, 29 Sep 2008 16:39:45 GMT1fa7c37c-d68d-46f5-9639-4669b01a21c5:14Troy Wolbrinkhttps://www.tntware.com/tntconnect/faqs/en/what-are-all-the-contact-import-fields/comments.aspxRevision 1 posted to Frequently Asked Questions by Troy Wolbrink on 9/29/2008 4:39:45 PM<br /> <h1>Import Field Details</h1> <table> <tbody> <tr> <td align="center">Grouping</td> <td>Field Name</td> <td>Comments</td> </tr> <tr> <td align="center">Name</td> <td>IsOrganization</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>churches, companies, organizations</td> </tr> <tr> <td>False</td> <td>individuals</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="9" align="center">Name <p>(IsOrganization = &quot;False&quot;)</p> </td> <td>Title</td> <td>&nbsp;</td> </tr> <tr> <td>FirstName</td> <td>&nbsp;</td> </tr> <tr> <td>MiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>LastName</td> <td>&nbsp;</td> </tr> <tr> <td>Suffix</td> <td>ex. Jr., Sr., II., III.</td> </tr> <tr> <td>SpouseTitle</td> <td>&nbsp;</td> </tr> <tr> <td>Spouse</td> <td>spouse first name</td> </tr> <tr> <td>SpouseMiddleName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseLastName</td> <td>only if different than LastName</td> </tr> <tr> <td align="center">Name <p>(IsOrganization = &quot;True&quot;)</p> </td> <td>CompanyName</td> <td>If IsOrganization = &quot;False&quot; then CompanyName refers to where the individual works.</td> </tr> <tr> <td align="center">Address</td> <td>SelectedMailingAddress</td> <td> <div align="left"> <table> <tbody> <tr> <td>1</td> <td>Home</td> </tr> <tr> <td>2</td> <td>Business</td> </tr> <tr> <td>3</td> <td>Other</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="5" align="center">Home Address</td> <td>HomeAddress</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCity</td> <td>&nbsp;</td> </tr> <tr> <td>HomeState</td> <td>&nbsp;</td> </tr> <tr> <td>HomeZip</td> <td>&nbsp;</td> </tr> <tr> <td>HomeCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Business Address</td> <td>BusinessAddress</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCity</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessState</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessZip</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">Other Address</td> <td>OtherAddress</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCity</td> <td>&nbsp;</td> </tr> <tr> <td>OtherState</td> <td>&nbsp;</td> </tr> <tr> <td>OtherZip</td> <td>&nbsp;</td> </tr> <tr> <td>OtherCountry</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="19" align="center">Phone</td> <td>AssistantPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessPhone2</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessFax</td> <td>&nbsp;</td> </tr> <tr> <td>CallbackPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CarPhone</td> <td>&nbsp;</td> </tr> <tr> <td>CompanyMainPhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone</td> <td>&nbsp;</td> </tr> <tr> <td>HomePhone2</td> <td>&nbsp;</td> </tr> <tr> <td>HomeFax</td> <td>&nbsp;</td> </tr> <tr> <td>ISDNPhone</td> <td>&nbsp;</td> </tr> <tr> <td>MobilePhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherPhone</td> <td>&nbsp;</td> </tr> <tr> <td>OtherFax</td> <td>&nbsp;</td> </tr> <tr> <td>PagerNumber</td> <td>&nbsp;</td> </tr> <tr> <td>PrimaryPhone</td> <td>&nbsp;</td> </tr> <tr> <td>RadioPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TelexPhone</td> <td>&nbsp;</td> </tr> <tr> <td>TTYTDDPhone</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="11" align="center">Internet</td> <td>Email1</td> <td>&nbsp;</td> </tr> <tr> <td>Email2</td> <td>&nbsp;</td> </tr> <tr> <td>Email3</td> <td>&nbsp;</td> </tr> <tr> <td>UserCertificate</td> <td>&nbsp;</td> </tr> <tr> <td>PersonalHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>BusinessHomePage</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingAlias</td> <td>&nbsp;</td> </tr> <tr> <td>NetMeetingServer</td> <td>&nbsp;</td> </tr> <tr> <td>ComputerNetworkName</td> <td>&nbsp;</td> </tr> <tr> <td>FTPSite</td> <td>&nbsp;</td> </tr> <tr> <td>InternetFreeBusyAddress</td> <td>&nbsp;</td> </tr> <tr> <td align="center">Notes</td> <td>Notes</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="3" align="center">Greetings</td> <td>FullName</td> <td>Formal greeting used to address envelopes</td> </tr> <tr> <td>Greeting</td> <td>Greeting used inside letters</td> </tr> <tr> <td>ShortName</td> <td>Formatted: FirstName and Spouse LastName</td> </tr> <tr> <td rowspan="17" align="center">MPD</td> <td>CreatedDate</td> <td>When the contact was first added to the database</td> </tr> <tr> <td>OrgAccountIDs</td> <td>Account ids associated with this contact by the organization.&nbsp; Multiple IDs can be separated by a comma. <p>Example:&nbsp;&nbsp; 12345678, 87654321, 18273645</p> </td> </tr> <tr> <td>Deceased</td> <td>True/False</td> </tr> <tr> <td>DirectDeposit</td> <td>True/False</td> </tr> <tr> <td>MPDPhaseID</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">n/a</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Contacted</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Ask in Future</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Appt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Appt Scheduled</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Call for Decision</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Financial</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Special</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">PARTNER-Pray</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Not Interested</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Never Ask</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NeverAsk</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Never ask this contact for support</td> </tr> <tr> <td>False</td> <td>Allow asking this contact for support</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>NextAsk</td> <td>Date when you should ask this contact for support</td> </tr> <tr> <td>PledgeAmount</td> <td>If amount is greater than zero, PledgeFrequency must be greater than zero.</td> </tr> <tr> <td>PledgeFrequency</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;none&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">bi-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quarterly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">4</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">quad-monthly</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">6</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">semi-annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">12</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">annual</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">24</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">biannual</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeReceived</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>First check has been received for this pledge</td> </tr> <tr> <td>False</td> <td>First check has not been received for this pledge</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>PledgeStartDate</td> <td>Date when the pledge started</td> </tr> <tr> <td>ReferredBy</td> <td>Primary referrer</td> </tr> <tr> <td>ReferredByList</td> <td>All those who have referred you to this contact.&nbsp; Each referrer should be on their own line (separated by a carriage return).</td> </tr> <tr> <td>Region</td> <td>&nbsp;</td> </tr> <tr> <td>SendNewsletter</td> <td> <div align="left"> <table> <tbody> <tr> <td>True</td> <td>Send this contact a prayer letter</td> </tr> <tr> <td>False</td> <td>Don&#39;t send this contact a prayer letter</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Magazine</td> <td>True/False</td> </tr> <tr> <td>LikelyToGive</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Unassigned</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">1</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Least Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">2</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Likely</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">3</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Most Likely</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td rowspan="17" align="center">Personal / Professional</td> <td>AssistantName</td> <td>&nbsp;</td> </tr> <tr> <td>Categories</td> <td>&nbsp;</td> </tr> <tr> <td>Children</td> <td>&nbsp;</td> </tr> <tr> <td>ChurchName</td> <td>&nbsp;</td> </tr> <tr> <td>Department</td> <td>&nbsp;</td> </tr> <tr> <td>FamilyLevel</td> <td> <div align="left"> <table> <tbody> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">0</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">&lt;None&gt;</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">10</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Very Extended</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">20</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Cousin</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">30</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Uncle/Aunt</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">40</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandparent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">50</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Nephew/Niece</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">60</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Sibling</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">70</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Parent</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">80</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Grandchild</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">90</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Son/Daughter</span></td> </tr> <tr> <td align="right"><span style="font-size:x-small;color:#000000;font-family:Arial;">100</span></td> <td><span style="font-size:x-small;color:#000000;font-family:Arial;">Immediate</span></td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>FamilySide</td> <td> <div align="left"> <table> <tbody> <tr> <td>0</td> <td>&lt;none&gt;</td> </tr> <tr> <td>1</td> <td>His</td> </tr> <tr> <td>2</td> <td>Hers</td> </tr> </tbody> </table> </div> </td> </tr> <tr> <td>Hobby</td> <td>&nbsp;</td> </tr> <tr> <td>JobTitle</td> <td>&nbsp;</td> </tr> <tr> <td>ManagerName</td> <td>&nbsp;</td> </tr> <tr> <td>NickName</td> <td>&nbsp;</td> </tr> <tr> <td>OfficeLocation</td> <td>&nbsp;</td> </tr> <tr> <td>Profession</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseCompanyName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseHobby</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseNickName</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseProfession</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="9" align="center">Anniversary / Birthday</td> <td>AnniversaryDay</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryMonth</td> <td>&nbsp;</td> </tr> <tr> <td>AnniversaryYear</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>BirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayDay</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayMonth</td> <td>&nbsp;</td> </tr> <tr> <td>SpouseBirthdayYear</td> <td>&nbsp;</td> </tr> <tr> <td rowspan="5" align="center">User</td> <td>User1</td> <td>&nbsp;</td> </tr> <tr> <td>User2</td> <td>&nbsp;</td> </tr> <tr> <td>User3</td> <td>&nbsp;</td> </tr> <tr> <td>User4</td> <td>&nbsp;</td> </tr> <tr> <td>UserStatus</td> <td>&nbsp;</td> </tr> </tbody> </table>