How would I send our staff a monthly TntConnect DataSync file?

TntWare — Tue, 04 Feb 2020 22:42:08 GMT

Current revision posted to Frequently Asked Questions by TntWare on 2/4/2020 10:42:08 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

This document describes how you can take data from your organization's donation system and package it in a way that is compatible with TntConnect. The file you create is called a TntConnect DataSync file. It might require technical skills to create this file. This a file you could securely deliver to your staff. But we recommended that you NOT send sensitive donor data over email!

Security Warning: Sending donor and giving information over email is not secure. You risk exposing your donor's private information and subjecting them to identity theft and loss of privacy.

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. TntWare does all the difficult technical part of making this work! If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect only recognizes this file extension.

Note that as of TntConnect 3.4,

TntConnect only recognizes the .tntdatasync extension. TntConnect 3.4 and newer 4.0 no longer recognizes .tnt or .tntmpdsupports importing DataSync files. Also TntConnect 3.4 4.0 requires the [ORGANIZATION] section.

The DataSync file is synchronized with the currently opened database. Because the data is synchronized, you can input the file several times into the same database without duplicating data in the database.

The DataSync file has up to four sections. The sections are:

[ORGANIZATION]
[FILE]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section. Use of the [GIFTS] section will require the use of the [FILE] section.

Here's a sample DonorHub for ongoing electronic inflow of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[DONORS]
"PEOPLE_ID","ACCT_NAME","ADDR1","ADDR2","ADDR3","ADDR4","CITY","STATE","ZIP",...
"921875429","Smith, Dave J & Julie J","630 Pine St",,,,"Hickleman","SD","18372-2637",...
"332812300","Pine Hills Christian Church","1212 Elm Cir",,,,"Orlando","FL","32828-1868",...
"220389751","Fryerson, Sue","900 S Sarmon Dr",,,,"Mitchell","SD","57302-9244", ...

[GIFTS]
"PEOPLE_ID","ACCT_NAME","DISPLAY_DATE","AMOUNT","DONATION_ID","DESIGNATION","MOTIVATION"
"921875429","Smith, Dave J & Julie J","08/23/2002","60","J5INQ","0455770","Z01000"
"332812300","Pine Hills Christian Church","08/22/2002","50","J5E2S","0455770","Z01000"
"220389751","Fryerson, Sue","08/22/2002","40","J5EGE","0455770","Z01000"

[ORGANIZATION]

The organization section is required and it has donation informationabout your organization. Here you can specify your organization's name, abbreviation and logo (JPEG only). In addition you can specify an announcement banner that the user sees while they import the file. The last item This is code. Try to think of a unique code to represent your ministry (25 chars max).

If you are using the sample file for inspiration, you must change the Code from "Sample-Organization-USA" to something else! This should be a unique code that identifies your organization . 25 characters max.

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[FILE]

The file section has information specific to this file.

<new in TntConnect 3.5.15> GiftsDateFrom and GiftsDateTo represent the date range TntConnect uses when synchronizing gifts in the [GIFTS] section. The [GIFTS] section is expected to include all gifts for this user within the date range. If TntConnect has gifts within this data range, but they are not included in the file, TntConnect might prompt the user to delete them, so as to stay in sync with the organization.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

"PEOPLE_ID","ACCT_NAME","ADDR1","ADDR2","ADDR3","ADDR4","CITY","STATE","ZIP",...
"921875429","Smith, Dave J & Julie J","630 Pine St",,,,"Hickleman","SD","18372-2637",...
"332812300","Pine Hills Christian Church","1212 Elm Cir",,,,"Orlando","FL","32828-1868",...
"220389751","Fryerson, Sue","900 S Sarmon Dr",,,,"Mitchell","SD","57302-9244", ...

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

[GIFTS]
"PEOPLE_ID","ACCT_NAME","DISPLAY_DATE","AMOUNT","DONATION_ID","DESIGNATION","MOTIVATION"
"921875429","Smith, Dave J & Julie J","08/23/2002","60","J5INQ","0455770","Z01000"
"332812300","Pine Hills Christian Church","08/22/2002","50","J5E2S","0455770","Z01000"
"220389751","Fryerson, Sue","08/22/2002","40","J5EGE","0455770","Z01000"

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

TntConnect will store designation ids, donor ids and donation ids exactly as it is received. (Leading zeros will be removed from numeric donor ids.) But internally when TntConnect is syncing incoming data, it will match up these ids in a case insensitive way. So a donation id of "ABC" and "abc" are the same from TntConnect's perspective. Sending your staff two donations with an id of "ABC" and "abc" respectively will either result in a "duplicate id error" in TntConnect or it will overwrite the one donation with the other.

Staying Informed of Changes

Announcements are made to the Beta Testers group when new versions of TntConnect are released to the beta testing phase. If there are any changes to the DataSync protocol you must know of to remain compatible, these changes will be announced here. If you'd like to receive an email when an announcement is made, you would need to "Subscribe to this group" by clicking the link on the left sidesign up for. Here's a screenshot:

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Fri, 22 Feb 2019 00:26:34 GMT

Revision 64 posted to Frequently Asked Questions by Troy Wolbrink on 2/22/2019 12:26:34 AM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect only recognizes this file extension.

Note that as of TntConnect 3.4, TntConnect only recognizes the .tntdatasync extension. TntConnect 3.4 and newer no longer recognizes .tnt or .tntmpd. Also TntConnect 3.4 requires the [ORGANIZATION] section.

The DataSync file has up to three four sections. The sections are:

[ORGANIZATION]
[FILE]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section. Use of the [GIFTS] section will require the use of the [FILE] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

The organization section is required and it has information about your organization. Here you can specify your organization's name, abbreviation and logo (JPEG only). In addition you can specify an announcement banner that the user sees while they import the file. The last item is code. Try to think of a unique code to represent your ministry (25 chars max).

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[FILE]

The file section has information specific to this file.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

Staying Informed of Changes

Announcements are made to the Beta Testers group when new versions of TntConnect are released to the beta testing phase. If there are any changes to the DataSync protocol you must know of to remain compatible, these changes will be announced here. If you'd like to receive an email when an announcement is made, you need to "Subscribe to this group" by clicking the link on the left side. Here's a screenshot:

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Fri, 22 Feb 2019 00:25:36 GMT

Revision 63 posted to Frequently Asked Questions by Troy Wolbrink on 2/22/2019 12:25:36 AM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect only recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[FILE]

The file section has information specific to this file.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

Staying Informed of Changes

Announcements are made to the Beta Testers group when new versions of TntConnect are released to the beta testing phase. If there are any changes to the DataSync protocol you must know of to remain compatible, these changes will be announced here. If you'd like to receive an email when an announcement is made, you need to "Subscribe to this group" by clicking the link on the left side. Here's a screenshot:

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Wed, 04 Oct 2017 01:51:35 GMT

Revision 62 posted to Frequently Asked Questions by Troy Wolbrink on 10/4/2017 1:51:35 AM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect only recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]
Name=Sample Organization
Abbreviation=SampleOrg
WebLogo-JPEG-470x120=http://download.tntware.com/ccc/SampleWebLogo.jpg
BannerAdUrl-468x60=http://download.tntware.com/ccc/SampleAdBanner.htm
Code=Sample-Organization-USA
DefaultCurrencyCode=USD

[DONORS]
"PEOPLE_ID","ACCT_NAME","ADDR1","ADDR2","ADDR3","ADDR4","CITY","STATE","ZIP",...
"921875429","Smith, Dave J & Julie J","630 Pine St",,,,"Hickleman","SD","18372-2637",...
"332812300","Pine Hills Christian Church","1212 Elm Cir",,,,"Orlando","FL","32828-1868",...
"220389751","Fryerson, Sue","900 S Sarmon Dr",,,,"Mitchell","SD","57302-9244", ...

[GIFTS]
"PEOPLE_ID","ACCT_NAME","DISPLAY_DATE","AMOUNT","DONATION_ID","DESIGNATION","MOTIVATION"
"921875429","Smith, Dave J & Julie J","08/23/2002","60","J5INQ","0455770","Z01000"
"332812300","Pine Hills Christian Church","08/22/2002","50","J5E2S","0455770","Z01000"
"220389751","Fryerson, Sue","08/22/2002","40","J5EGE","0455770","Z01000"

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

Staying Informed of Changes

Announcements are made to the Beta Testers group when new versions of TntConnect are released to the beta testing phase. If there are any changes to the DataSync protocol you must know of to remain compatible, these changes will be announced here. If you'd like to receive an email when an announcement is made, you need to "Subscribe to this group" by clicking the link on the left side. Here's a screenshot:

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Wed, 20 Sep 2017 21:15:53 GMT

Revision 61 posted to Frequently Asked Questions by Troy Wolbrink on 9/20/2017 9:15:53 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect only recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

Staying Informed of Changes

Announcements are made to the Beta Testers group when new versions of TntConnect are released to the beta testing phase. If there are any changes to the DataSync protocol you must know of to remain compatible, these changes will be announced here. If you'd like to receive an email when an announcement is made, you need to "Subscribe to this group" by clicking the link on the left side. Here's a screenshot:

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Mon, 18 Sep 2017 13:42:00 GMT

Revision 60 posted to Frequently Asked Questions by Troy Wolbrink on 9/18/2017 1:42:00 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect only recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

Staying Informed of Changes

Announcements are made to the Beta Testers group when new versions of TntConnect are released to the beta testing phase. If there are any changes to the DataSync protocol you must know of to remain compatible, these changes will be announced here. If you'd like to receive an email when an announcement is made, you need to "Subscribe to this group" by clicking the link on the left side. Here's a screenshot:

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Sat, 16 Sep 2017 20:49:56 GMT

Revision 59 posted to Frequently Asked Questions by Troy Wolbrink on 9/16/2017 8:49:56 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online.

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect only recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.
BASE_CURRENCY	A3	3.1	(Optional) Base currency code (ISO 4217 3-char) of donation as represented by AMOUNT. The only case where it is valid to provide a value for this field is when importing a DataSync file without an [Organization] section. Apart from this exception, this field is not to be used. Instead, "DefaultCurrencyCode" should be defined once in the [Organization] section.

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Sat, 16 Sep 2017 16:48:34 GMT

Revision 58 posted to Frequently Asked Questions by Troy Wolbrink on 9/16/2017 4:48:34 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online.

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect recognizes this file extension. Note that as of TntConnect 3.4, TntConnect only recognized recognizes the .tntdatasync extension. TntConnect 3.4 and newer no longer recognizes .tnt or .tntmpd.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.
BASE_CURRENCY	A3	3.1	(Optional) Base currency code (ISO 4217 3-char) of donation as represented by AMOUNT. The only case where it is valid to provide a value for this field is when importing a DataSync file without an [Organization] section. Apart from this exception, this field is not to be used. Instead, "DefaultCurrencyCode" should be defined once in the [Organization] section.

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Fri, 15 Sep 2017 17:28:03 GMT

Revision 57 posted to Frequently Asked Questions by Troy Wolbrink on 9/15/2017 5:28:03 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online.

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect recognizes this file extension. Note that as of TntConnect 3.4, TntConnect only recognized the .tntdatasync extension. TntConnect 3.4 and newer no longer recognizes .tnt or .tntmpd.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.
BASE_CURRENCY	A3	3.1	(Optional) Base currency code (ISO 4217 3-char) of donation as represented by AMOUNT. The only case where it is valid to provide a value for this field is when importing a DataSync file without an [Organization] section. Apart from this exception, this field is not to be used. Instead, "DefaultCurrencyCode" should be defined once in the [Organization] section.

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Fri, 15 Sep 2017 01:07:21 GMT

Revision 56 posted to Frequently Asked Questions by Troy Wolbrink on 9/15/2017 1:07:21 AM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online.

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.
BASE_CURRENCY	A3	3.1	(Optional) Base currency code (ISO 4217 3-char) of donation as represented by AMOUNT. The only case where it is valid to provide a value for this field is when importing a DataSync file without an [Organization] section. Apart from this exception, this field is not to be used. Instead, "DefaultCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	BOOL	future	(Optional) Blank implies "FALSE". Indicates if the gift is intended to be a personal gift for the staff member (which usually means it's not tax deductible).

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Thu, 14 Sep 2017 19:43:01 GMT

Revision 55 posted to Frequently Asked Questions by Troy Wolbrink on 9/14/2017 7:43:01 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online.

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2017.tntdatasync". TntConnect recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.
BASE_CURRENCY	A3	3.1	(Optional) Base currency code (ISO 4217 3-char) of donation as represented by AMOUNT. The only case where it is valid to provide a value for this field is when importing a DataSync file without an [Organization] section. Apart from this exception, this field is not to be used. Instead, "DefaultCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	BOOL	future	(Optional) Blank implies "FALSE". Indicates if the gift is intended to be a personal gift for the staff member (which usually means it's not tax deductible).

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Thu, 14 Sep 2017 19:29:24 GMT

Revision 54 posted to Frequently Asked Questions by Troy Wolbrink on 9/14/2017 7:29:24 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online.

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2002.tntdatasync". "January2017.tntdatasync". TntConnect recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.
BASE_CURRENCY	A3	3.1	(Optional) Base currency code (ISO 4217 3-char) of donation as represented by AMOUNT. The only case where it is valid to provide a value for this field is when importing a DataSync file without an [Organization] section. Apart from this exception, this field is not to be used. Instead, "DefaultCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	BOOL	future	(Optional) Blank implies "FALSE". Indicates if the gift is intended to be a personal gift for the staff member (which usually means it's not tax deductible).

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Thu, 14 Sep 2017 19:29:09 GMT

Revision 53 posted to Frequently Asked Questions by Troy Wolbrink on 9/14/2017 7:29:09 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online.

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2002.tntdatasync". TntConnect recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		(Optional)	If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.
BASE_CURRENCY	A3	3.1	(Optional) Base currency code (ISO 4217 3-char) of donation as represented by AMOUNT. The only case where it is valid to provide a value for this field is when importing a DataSync file without an [Organization] section. Apart from this exception, this field is not to be used. Instead, "DefaultCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	BOOL	future	(Optional) Blank implies "FALSE". Indicates if the gift is intended to be a personal gift for the staff member (which usually means it's not tax deductible).

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Thu, 14 Sep 2017 19:25:50 GMT

Revision 52 posted to Frequently Asked Questions by Troy Wolbrink on 9/14/2017 7:25:50 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online.

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2002.tntdatasync". TntConnect recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section , and/or the [DONORS] or you may include bothsection.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		(Optional) If you track this in your donation system you may include this code here.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.
BASE_CURRENCY	A3	3.1	(Optional) Base currency code (ISO 4217 3-char) of donation as represented by AMOUNT. The only case where it is valid to provide a value for this field is when importing a DataSync file without an [Organization] section. Apart from this exception, this field is not to be used. Instead, "DefaultCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	BOOL	future	(Optional) Blank implies "FALSE". Indicates if the gift is intended to be a personal gift for the staff member (which usually means it's not tax deductible).

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Thu, 14 Sep 2017 19:20:55 GMT

Revision 51 posted to Frequently Asked Questions by Troy Wolbrink on 9/14/2017 7:20:55 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

Usability Warning: Sending your staff DataSync files is much less than ideal. A much better approach is to use DonorHub Online. DonorHub is a secure, cloud-based service that allows your staff to simply push a button to seamlessly download their latest giving information. It also saves time for your finance team. If you'd like to learn more about how DonorHub Online can help you:
Ask us about DonorHub Online.

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2002.tntdatasync". TntConnect recognizes this file extension.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

The [ORGANIZATION] section is required. You must also provide the [GIFTS] section, the [DONORS] or you may include both.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		(Optional) If you track this in your donation system you may include this code here.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.
BASE_CURRENCY	A3	3.1	(Optional) Base currency code (ISO 4217 3-char) of donation as represented by AMOUNT. The only case where it is valid to provide a value for this field is when importing a DataSync file without an [Organization] section. Apart from this exception, this field is not to be used. Instead, "DefaultCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	BOOL	future	(Optional) Blank implies "FALSE". Indicates if the gift is intended to be a personal gift for the staff member (which usually means it's not tax deductible).

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity

How would I send our staff a monthly TntConnect DataSync file?

Troy Wolbrink — Thu, 14 Sep 2017 19:19:18 GMT

Revision 50 posted to Frequently Asked Questions by Troy Wolbrink on 9/14/2017 7:19:18 PM

How would I send our staff a monthly TntConnect DataSync file?

Filed under: Developer Guides

The downside to the DataSync file approach is But we recommended that it takes extra work on the part of the staff to import them, and it might introduce security issues by sending you NOT send sensitive donor data over email!

Usability Warning: Sending your staff DataSync files is much less than ideal. A much better approach for delivering donation data is to use DonorHub Online. This DonorHub is a secure, cloud-based service fully managed by TntWare that makes this process seamless for the allows your staff to simply push a button to seamlessly download their latest giving information. It 's alsomuch easier saves time for the accounting your finance teamback in the office. Plus, DonorHub Online can deliver donation data to many other support raising tools as well, such as MPDX, Karani or DonorElf. If you'd like to learn more about how DonorHub Online can help you become compatible more quickly: Ask us about DonorHub Online.

Once you are TntConnect-compatible, your staff will be able to use TntConnect to connect to your system to:

Download contribution details

Download names and addresses of donors

Be notified of their staff account balance

Not only will your staff be able to use these features, but their application will be branded with your organization's logo. Also, while they are using the "Web Input" features of TntConnect, you can display your own advertisement/announcement banner.

This is an example of the logo you can provide:

This is an example of the advertising banner you can provide:

Example of a DataSync file:

Here's a sample of a DataSync file (with the required ".tntdatasync" file name extension):
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync. So for example you may send your staff a file called "January2002.tntdatasync". TntConnect recognizes this fileformat which makes it incredibly easy for your staff to get started. All they need to do is double-click the file and open it. Since *.tntdatasyncis a registered filename extension, Windows will tell TntConnect to open it.

The DataSync file has up to three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

<future> Supported sections might also include (to be described later):

[APPLICATION]
[FILE]
[DESIGNATIONS]

The [GIFTS_BY_DONORS].

An example ORGANIZATION] section is listed belowrequired. (The complete version is available here You must also provide the [GIFTS] section, the [DONORS] or you may include both.)

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[ORGANIZATION]

<new in TntConnect 3.1> DefaultCurrencyCode specifies the base currency code (ISO 4217 3-char) for donations represented in the [GIFTS] section.

[DONORS]

The donors section has name, address and phone information about donors. All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
INFO_URL	MEMO	3.0	URL to view/edit donor information.
RELATED_IDS	MEMO	3.0	A comma seperated list of related donor codes/ids.
DECEASED	BOOL	3.0	Blank implies "FALSE". Is the donor deceased?
PERSON_TYPE	A1		"O" or "P" (Organization or Person)
LAST_NAME_ORG	A50		Last Name or Organization Name
ORG_CONTACT_PERSON	A50	3.0	[PERSON_TYPE="O"] Contact person for this organization.
TITLE	A25		[PERSON_TYPE="P"] Title (Mr., Mrs.)
FIRST_NAME	A25		[PERSON_TYPE="P"] First Name
MIDDLE_NAME	A25		[PERSON_TYPE="P"] Middle Name
SUFFIX	A25		[PERSON_TYPE="P"] Suffix (Jr., Sr.)
SP_TITLE	A25		[PERSON_TYPE="P"] for spouse
SP_FIRST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_MIDDLE_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_LAST_NAME	A25		[PERSON_TYPE="P"] for spouse
SP_SUFFIX	A25		[PERSON_TYPE="P"] for spouse Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1	MEMO		Street Address (Line 1)
ADDR2	MEMO		Street Address (Line 2)
ADDR3	MEMO		Street Address (Line 3)
ADDR4	MEMO		Street Address (Line 4)
CITY	A50		City
STATE	A50		State
ZIP	A25		Postal Code
COUNTRY	A3		(A3) ISO 3166 Alpha 3 country code <new in TntConnect 2.0> ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR	A50		Name of country.
ADDR_CHANGED	DATE		When the address was last changed.
PHONE	A50		Phone number.
PHONE_CHANGED	DATE		When the phone was last changed.
MOBILE_PHONE	A50	3.0	Mobile phone number.
MOBILE_PHONE_CHANGED	DATE	3.0	When the mobile phone was last changed.
SP_MOBILE_PHONE	A50	3.0	Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED	DATE	3.0	When the spouse mobile phone was last changed.
EMAIL	MEMO	3.0	Email address.
EMAIL_CHANGED	DATE	3.0	When the email address was last changed.
SP_EMAIL	MEMO	3.0	Spouse email address.
SP_EMAIL_CHANGED	DATE	3.0	When the spouse email address was last changed.
MEMO	MEMO	3.0	A note regarding the donor.

[GIFTS]

The gifts section has detailed contribution information over a particular date range.

Here's an example result:

Field Descriptions:

FieldName	Type	TntConnect Version	Description
PEOPLE_ID	A18		Donor Code/ID
ACCT_NAME	A50		Donor full name
DISPLAY_DATE	DATE		Date of contribution
AMOUNT	FLOAT		Amount of contribution
DONATION_ID	A18		Donation Code/ID
DESIGNATION	A18		What account this donation is designated for (normally same as employee id)
MOTIVATION	A18		(Optional) If you track this in your donation system you may include this code here.
PAYMENT_METHOD	A18	3.0	(Optional) Payment method of this donation.
MEMO	MEMO	3.0	(Optional) Any comments associated with this gift.
TENDERED_AMOUNT	FLOAT	3.1	(Optional) Amount of donation as tendered by donor. You may leave this blank if it is tendered in the same as currency code defined in the query.ini file.
TENDERED_CURRENCY	A3	3.1	(Optional) Currency code (ISO 4217 3-char) of donation as tendered by donor. You may leave this blank if it is the same as the default currency code from the query.ini file.
BASE_CURRENCY	A3	3.1	(Optional) Base currency code (ISO 4217 3-char) of donation as represented by AMOUNT. The only case where it is valid to provide a value for this field is when importing a DataSync file without an [Organization] section. Apart from this exception, this field is not to be used. Instead, "DefaultCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	BOOL	future	(Optional) Blank implies "FALSE". Indicates if the gift is intended to be a personal gift for the staff member (which usually means it's not tax deductible).

Data Types Explained

A25, a text column with a maximum of 25 characters
MEMO, a text column with no predefined length limits
DATE, a date formatted as M/D/YYYY (or <new in TntConnect 3.1> the YYYY-MM-DD format).
BOOL, a boolean as "TRUE" or "FALSE"
FLOAT, a floating point number. Currency symbols or thousands separators are not allowed. The decimal separator must be a period.

(Note: for all types, leading and trailing spaces are removed from the value. So " ABC " is always trimmed down to just "ABC".)

Case Insensitivity