TntConnect TM
Helping you build powerful connections for a lifetime of ministry...

What are all the Contact import fields?

TNT.tips from Bob!

Table of Contents

It is our pleasure to provide this software free of charge to help you in your ministry.  We're so thankful for our partners who make this possible!

About TntWare

Page Details

First published by:
Troy Wolbrink
on 29 Sep 2008
Last revision by:
Troy Wolbrink
on 4 Oct 2008
16 people found this article useful.

88% of people found this useful
What are all the Contact import fields?

Import Field Details

Grouping Field Name Comments
Name IsOrganization
True churches, companies, organizations
False individuals
Name

(IsOrganization = "False")

Title  
FirstName
MiddleName  
LastName  
Suffix ex. Jr., Sr., II., III.
SpouseTitle  
Spouse spouse first name
SpouseMiddleName  
SpouseLastName only if different than LastName
Name

(IsOrganization = "True")

CompanyName If IsOrganization = "False" then CompanyName refers to where the individual works.
Address SelectedMailingAddress
1 Home
2 Business
3 Other
Home Address HomeAddress  
HomeCity  
HomeState  
HomeZip  
HomeCountry  
Business Address BusinessAddress  
BusinessCity  
BusinessState  
BusinessZip  
BusinessCountry  
Other Address OtherAddress  
OtherCity  
OtherState  
OtherZip  
OtherCountry  
Phone AssistantPhone  
BusinessPhone  
BusinessPhone2  
BusinessFax  
CallbackPhone  
CarPhone  
CompanyMainPhone  
HomePhone  
HomePhone2  
HomeFax  
ISDNPhone  
MobilePhone  
OtherPhone  
OtherFax  
PagerNumber  
PrimaryPhone  
RadioPhone  
TelexPhone  
TTYTDDPhone  
Internet Email1  
Email2  
Email3  
UserCertificate  
PersonalHomePage  
BusinessHomePage  
NetMeetingAlias  
NetMeetingServer  
ComputerNetworkName  
FTPSite  
InternetFreeBusyAddress  
Notes Notes  
Greetings FullName Formal greeting used to address envelopes
Greeting Greeting used inside letters
ShortName Formatted: FirstName and Spouse LastName
MPD CreatedDate When the contact was first added to the database
OrgAccountIDs Account ids associated with this contact by the organization.  Multiple IDs can be separated by a comma.

Example:   12345678, 87654321, 18273645

Deceased True/False
DirectDeposit True/False
MPDPhaseID
0 n/a
10 Never Contacted
20 Ask in Future
30 Call for Appt
40 Appt Scheduled
50 Call for Decision
60 PARTNER-Financial
70 PARTNER-Special
80 PARTNER-Pray
90 Not Interested
100 Never Ask
NeverAsk
True Never ask this contact for support
False Allow asking this contact for support
NextAsk Date when you should ask this contact for support
PledgeAmount If amount is greater than zero, PledgeFrequency must be greater than zero.
PledgeFrequency
0 <none>
1 monthly
2 bi-monthly
3 quarterly
4 quad-monthly
6 semi-annual
12 annual
24 biannual
PledgeReceived
True First check has been received for this pledge
False First check has not been received for this pledge
PledgeStartDate Date when the pledge started
ReferredBy Primary referrer
ReferredByList All those who have referred you to this contact.  Each referrer should be on their own line (separated by a carriage return).
Region  
SendNewsletter
True Send this contact a prayer letter
False Don't send this contact a prayer letter
Magazine True/False
LikelyToGive
0 Unassigned
1 Least Likely
2 Likely
3 Most Likely
Personal / Professional AssistantName  
Categories  
Children  
ChurchName  
Department  
FamilyLevel
0 <None>
10 Very Extended
20 Cousin
30 Uncle/Aunt
40 Grandparent
50 Nephew/Niece
60 Sibling
70 Parent
80 Grandchild
90 Son/Daughter
100 Immediate
FamilySide
0 <none>
1 His
2 Hers
Hobby  
JobTitle  
ManagerName  
NickName  
OfficeLocation  
Profession  
SpouseCompanyName  
SpouseHobby  
SpouseNickName  
SpouseProfession  
Anniversary / Birthday AnniversaryDay  
AnniversaryMonth  
AnniversaryYear  
BirthdayDay  
BirthdayMonth  
BirthdayYear  
SpouseBirthdayDay  
SpouseBirthdayMonth  
SpouseBirthdayYear  
User User1  
User2  
User3  
User4  
UserStatus  

Recent Comments

By: Troy Wolbrink Posted on 5 Jan 2010 3:09 PM

Some of these field names changed in TntMPD 2.0:

www.tntware.com/.../2.0-Field-Changes.xls

By: anu Posted on 31 Dec 2010 8:46 PM

Can you post the list? I am unable to view it without a log in.

By: Troy Wolbrink Posted on 10 Jan 2011 6:43 PM

When you click "Enable Editing" and get the login screen, just click "Cancel".

By: lwarner58 Posted on 5 Oct 2014 2:17 AM

It seems the field names have changed again in TntMPD 3.0+. Can they be reposted? Thanks!

By: Lars Huttar Posted on 17 Mar 2015 10:39 AM

+1 to lwarner58's comment. Can the current field names be posted please? I'm especially interested to see what the valid values are for "Newsletter Media Preference" and what they mean.

By: Lars Huttar Posted on 17 Mar 2015 10:41 AM

P.S. It would be helpful if this article were clearly marked as reflecting TntMPD 1.0, if that's the version it relates to. Otherwise, a person looking for information doesn't know this article is out of date until they get all the way down to the comments.

By: Lars Huttar Posted on 17 Mar 2015 8:17 PM

For others who are looking for the same kind of information that I was: I did an experimental export and found out that the Newsletter Media Preference field takes the following values:

+P-E = paper w/ email backup

+E-P = email w/ paper backup

+E = email only

+P = paper only

+P+E = both

By: Troy Wolbrink Posted on 30 Mar 2015 3:46 PM

Great feedback, everyone.  Yes, I need to update this FAQ article for TntMPD 3.0.  On my to-do list!!!

By: Bryan Williamson Posted on 5 Jan 2016 4:03 PM

Here's a list I created of all the Target Fields in the Import process (TntMPD 3.0.40):

1 Anniversary Day

2 Anniversary Month

3 Anniversary Year

4 Birthday Day

5 Birthday Month

6 Birthday Year

7 Business Address Is Deliverable

8 Business City

9 Business Country/Region

10 Business Fax

11 Business Name

12 Business Phone

13 Business Phone 2

14 Business State/Province

15 Business Street Address

16 Business ZIP/Postal Code

17 Categories

18 Children

19 Church Name

20 Company Main Phone

21 ContactID

22 Created Date

23 Deceased

24 Direct Deposit

25 Email 1

26 Email 2

27 Email 3

28 Email Custom Greeting

29 Email Custom Salutation

30 Facebook

31 Family Level

32 Family Side

33 First/Given Name

34 Full Name

35 Greeting

36 Home Address Is Deliverable

37 Home City

38 Home Country/Region

39 Home Fax

40 Home Phone

41 Home Phone 2

42 Home State/Province

43 Home Street Address

44 Home ZIP/Postal Code

45 IM Address

46 Interests

47 Is Organization

48 Last Activity

49 Last Letter

50 Last Precall

51 Last/Family Name

52 Likely To Give

53 LinkedIn

54 Magazine

55 Mailing Address Type

56 Map Address Type

57 Map Latitude

58 Map Longitude

59 Map Status

60 Middle Name

61 Mobile Phone

62 Mobile Phone 2

63 MPD Phase

64 Never Ask

65 Newsletter Media Preference

66 Next Ask

67 Nickname

68 Notes

69 Notes (Formatted)

70 Organization Account IDs

71 Organization Contact Person

72 Organization Name

73 Other Address Is Deliverable

74 Other City

75 Other Country/Region

76 Other Fax

77 Other Phone

78 Other Social

79 Other State/Province

80 Other Street Address

81 Other ZIP/Postal Code

82 Pager Number

83 Pledge Amount

84 Pledge Frequency

85 Pledge Received

86 Pledge Start Date

87 Profession

88 Referred By

89 Referred By List

90 Region

91 Salutation

92 Send Newsletter

93 Short Name

94 Spouse Birthday Day

95 Spouse Birthday Month

96 Spouse Birthday Year

97 Spouse Business Address Is Deliverable

98 Spouse Business City

99 Spouse Business Country/Region

100 Spouse Business Fax

101 Spouse Business Name

102 Spouse Business Phone

103 Spouse Business Phone 2

104 Spouse Business State/Province

105 Spouse Business Street Address

106 Spouse Business ZIP/Postal Code

107 Spouse Company Main Phone

108 Spouse Email 1

109 Spouse Email 2

110 Spouse Email 3

111 Spouse Email Custom Greeting

112 Spouse Email Custom Salutation

113 Spouse Facebook

114 Spouse First/Given Name

115 Spouse IM Address

116 Spouse Interests

117 Spouse Last/Family Name

118 Spouse LinkedIn

119 Spouse Middle Name

120 Spouse Mobile Phone

121 Spouse Mobile Phone 2

122 Spouse Nickname

123 Spouse Other Social

124 Spouse Pager Number

125 Spouse Profession

126 Spouse Title

127 Spouse Twitter

128 Spouse Voice/Skype

129 Spouse Web Page

130 Spouse Web Page 2

131 Suffix

132 Title

133 Twitter

134 User 1

135 User 2

136 User 3

137 User 4

138 User Status

139 Voice/Skype

140 Web Page

141 Web Page 2

© 2024 TntWare, Inc. | Privacy | Terms of Use