How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Wed, 01 Feb 2012 19:06:04 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/1/2012 2:06:04 PM

How would I send our staff a monthly (or weekly) TntMPD 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 TntMPD. The file you create is called a TntMPD DataSync file. Once you make this file available to your individual staff member (such as via an email attachment) your staff will be able to bring their donation data into TntMPD. The type of data you can put into a DataSync file includes:

Download contribution details
Download names and addresses of donors

Not only will your staff be able to use these features, but their application will be branded with your organization's logo and name. Also, while they are using the "Gift and Address Input from File" features of TntMPD, 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:

Technical Details

A TntMPD DataSync file has the file name extension *.tntmpd. So for example you may send your staff a file called "January2002.tntmpd". TntMPD recognizes this file format 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 *.tntmpd is a registered filename extension, Windows will tell TntMPD to open it.

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 three sections. The sections are:

[ORGANIZATION]
[DONORS]
[GIFTS].

<future: TntMPD 2.2> Supported sections will also include (to be described later):

[APPLICATION]
[FILE]
[DESIGNATIONS]
[GIFTS_BY_DONORS].

An example is listed below. (The complete version is available here: http://download.tntware.com/sample_data_sync_file/sample.tntmpd)

[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
BaseCurrencyCode=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]

The organization section 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).

<future: TntMPD 2.2> BaseCurrencyCode 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.

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	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor deceased
LAST_NAME_ORG	Last Name or Organization Name
ORG_CONTACT_PERSON	<future: TntMPD 2.2> When it's an organization (PERSON_TYPE="O"), who is the contact person for this organization?
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MOBILE_PHONE	<future: TntMPD 2.2> Mobile phone number.
MOBILE_PHONE_CHANGED	<future: TntMPD 2.2> (M/D/YYYY) When the mobile phone was last changed.
MOBILE_PHONE_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
SPOUSE_MOBILE_PHONE	<future: TntMPD 2.2> Spouse mobile phone number.
SPOUSE_MOBILE_PHONE_CHANGED	<future: TntMPD 2.2> (M/D/YYYY) When the spouse mobile phone was last changed.
SPOUSE_MOBILE_PHONE_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
SPOUSE_EMAIL	<future: TntMPD 2.2> Email address.
SPOUSE_EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
SPOUSE_EMAIL_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO	<future: TntMPD 2.2> A note regarding the donor.
MAGAZINE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Does the donor subscribe to the organization's news magazine?
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor decease?
REMINDER	<future: TntMPD 2.2> (A18) How often is the donor reminded by the organization to make a donation?
RELATED_IDS	<future: TntMPD 2.2> A comma seperated list of related donor ids (used by TntMPD to help with matching contacts to donor ids).

[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	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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, "BaseCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

"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"

Case Insensitivity

TntMPD 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 TntMPD 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 TntMPD's perspective. Sending your staff two donations with an id of "ABC" and "abc" respectively will either result in a "duplicate id error" in TntMPD or it will overwrite the one donation with the other.

How to contact me

If you have any questions regarding this document, please don't hesitate to contact me at my email address: wolbrink@ccci.org I would be glad to help you. If your organization finds this feature useful, I would love to know about that as well.

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Tue, 24 Jan 2012 20:09:40 GMT

Revision 17 posted to Frequently Asked Questions (English) by Troy Wolbrink on 1/24/2012 3:09:40 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

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

[ORGANIZATION]
[DONORS]
[GIFTS].

<future: TntMPD 2.2> Supported sections will also include (to be described later):

[APPLICATION]
[FILE]
[DESIGNATIONS]
[GIFTS_BY_DONORS].

An example is listed below. (The complete version is available here: http://download.tntware.com/sample_data_sync_file/sample.tntmpd)

[ORGANIZATION]

<future: TntMPD 2.2> BaseCurrencyCode 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE
ADDR_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL
PHONE_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MOBILE_PHONE	<future: TntMPD 2.2> Mobile phone number.
MOBILE_PHONE_CHANGED	<future: TntMPD 2.2> (M/D/YYYY) When the mobile phone was last changed.
MOBILE_PHONE_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
SPOUSE_MOBILE_PHONE	<future: TntMPD 2.2> Spouse mobile phone number.
SPOUSE_MOBILE_PHONE_CHANGED	<future: TntMPD 2.2> (M/D/YYYY) When the spouse mobile phone was last changed.
SPOUSE_MOBILE_PHONE_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL
EMAIL_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO
SPOUSE_EMAIL	<future: TntMPD 2.2> Email address.
SPOUSE_EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
SPOUSE_EMAIL_VALID	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO	<future: TntMPD 2.2> A note regarding the donor.
MAGAZINE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Does the donor subscribe to the organization's news magazine?
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor decease?
REMINDER	<future: TntMPD 2.2> (A18) How often is the donor reminded by the organization to make a donation?
RELATED_IDS	<future: TntMPD 2.2> A comma seperated list of related donor ids (used by TntMPD to help with matching contacts to donor ids).

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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, "BaseCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Wed, 05 Oct 2011 19:13:57 GMT

Revision 16 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/5/2011 3:13:57 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

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

[ORGANIZATION]
[DONORS]
[GIFTS].

<future: TntMPD 2.2> Supported section sections will also include (to be described later):

[APPLICATION]
[FILE]
[DESIGNATIONS]
[GIFTS_BY_DONORS].

An example is listed below. (The complete version is available here: http://download.tntware.com/sample_data_sync_file/sample.tntmpd)

[ORGANIZATION]

<future: TntMPD 2.2> BaseCurrencyCode 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO	<future: TntMPD 2.2> A note regarding the donor.
MAGAZINE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Does the donor subscribe to the organization's news magazine?
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor decease?
REMINDER	<future: TntMPD 2.2> (A18) How often is the donor reminded by the organization to make a donation?
RELATED_IDS	<future: TntMPD 2.2> A comma seperated list of related donor ids (used by TntMPD to help with matching contacts to donor ids).

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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, "BaseCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Wed, 05 Oct 2011 19:04:47 GMT

Revision 15 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/5/2011 3:04:47 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

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

[ORGANIZATION]
[DONORS]
[GIFTS].

<future: TntMPD 2.2> Supported versions section will also include (to be described later):

[APPLICATION]
[FILE]
[ACCOUNT_BALANCE]
[DESIGNATIONS]
[GIFTS_BY_DONORS].

An example is listed below. (The complete version is available here: http://download.tntware.com/sample_data_sync_file/sample.tntmpd)

[ORGANIZATION]

<future: TntMPD 2.2> BaseCurrencyCode 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO	<future: TntMPD 2.2> A note regarding the donor.
MAGAZINE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Does the donor subscribe to the organization's news magazine?
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor decease?
REMINDER	<future: TntMPD 2.2> (A18) How often is the donor reminded by the organization to make a donation?
RELATED_IDS	<future: TntMPD 2.2> A comma seperated list of related donor ids (used by TntMPD to help with matching contacts to donor ids).

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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, "BaseCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Mon, 03 Oct 2011 21:46:35 GMT

Revision 14 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/3/2011 5:46:35 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

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

[ORGANIZATION], ORGANIZATION]
[DONORS]and
[GIFTS]. An example is listed below. (The complete version is available here: http://download.tntware.com/sample_data_sync_file/sample.tntmpd)

<future: TntMPD 2.2> Supported versions will also include (to be described later):

[APPLICATION], APPLICATION]
[FILE], FILE]
[ACCOUNT_BALANCE], ACCOUNT_BALANCE]
[DESIGNATIONS]AND
[GIFTS_BY_DONORS].

An example is listed below. (more info to come!The complete version is available here: http://download.tntware.com/sample_data_sync_file/sample.tntmpd)

[ORGANIZATION]

<future: TntMPD 2.2> BaseCurrencyCode 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO	<future: TntMPD 2.2> A note regarding the donor.
MAGAZINE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Does the donor subscribe to the organization's news magazine?
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor decease?
REMINDER	<future: TntMPD 2.2> (A18) How often is the donor reminded by the organization to make a donation?
RELATED_IDS	<future: TntMPD 2.2> A comma seperated list of related donor ids (used by TntMPD to help with matching contacts to donor ids).

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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, "BaseCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Mon, 03 Oct 2011 21:43:42 GMT

Revision 13 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/3/2011 5:43:42 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

The DataSync file has up to three sections. The sections are [ORGANIZATION], [DONORS] and [GIFTS]. An example is listed below. (The complete version is available here: http://download.tntware.com/sample_data_sync_file/sample.tntmpd)

<future: TntMPD 2.2> Supported versions will also include: [APPLICATION], [FILE], [ACCOUNT_BALANCE]ACCOUNT_BALANCE], [DESIGNATIONS] AND [DESIGNATIONS].GIFTS_BY_DONORS]. (more info to come!)

[ORGANIZATION]

<future: TntMPD 2.2> BaseCurrencyCode 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO	<future: TntMPD 2.2> A note regarding the donor.
MAGAZINE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Does the donor subscribe to the organization's news magazine?
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor decease?
REMINDER	<future: TntMPD 2.2> (A18) How often is the donor reminded by the organization to make a donation?
RELATED_IDS	<future: TntMPD 2.2> A comma seperated list of related donor ids (used by TntMPD to help with matching contacts to donor ids).

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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, "BaseCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Mon, 03 Oct 2011 21:31:32 GMT

Revision 12 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/3/2011 5:31:32 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

<future: TntMPD 2.2> Supported versions will also include: [APPLICATION], [FILE], [ACCOUNT_BALANCE] AND [DESIGNATIONS]. (more info to come!)

[ORGANIZATION]

<future: TntMPD 2.2> BaseCurrencyCode 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO	<future: TntMPD 2.2> A note regarding the donor.
MAGAZINE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Does the donor subscribe to the organization's news magazine?
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor decease?
REMINDER	<future: TntMPD 2.2> (A18) How often is the donor reminded by the organization to make a donation?
RELATED_IDS	<future: TntMPD 2.2> A comma seperated list of related donor ids (used by TntMPD to help with matching contacts to donor ids).

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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, "BaseCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Mon, 03 Oct 2011 21:29:04 GMT

Revision 11 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/3/2011 5:29:04 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

<future: TntMPD 2.2> Supported versions will also include: [APPLICATION], [FILE], [ACCOUNT_BALANCE] AND [DESIGNATIONS]. (more info to come!)

[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
BaseCurrencyCode=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]

<future: TntMPD 2.2> BaseCurrencyCode 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO	<future: TntMPD 2.2> A note regarding the donor.
MAGAZINE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Does the donor subscribe to the organization's news magazine?
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor decease?
REMINDER	<future: TntMPD 2.2> (A18) How often is the donor reminded by the organization to make a donation?
RELATED_IDS	<future: TntMPD 2.2> A comma seperated list of related donor ids (used by TntMPD to help with matching contacts to donor ids).

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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, "BaseCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Mon, 03 Oct 2011 21:22:20 GMT

Revision 10 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/3/2011 5:22:20 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

<future: TntMPD 2.2> Supported versions will also include: [APPLICATION], [FILE], [ACCOUNT_BALANCE] AND [DESIGNATIONS]. (more info to come!)

[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]

<future: TntMPD 2.2> BaseCurrencyCode 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO	<future: TntMPD 2.2> A note regarding the donor.
MAGAZINE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Does the donor subscribe to the organization's news magazine?
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor decease?
REMINDER	<future: TntMPD 2.2> (A18) How often is the donor reminded by the organization to make a donation?
RELATED_IDS	<future: TntMPD 2.2> A comma seperated list of related donor ids (used by TntMPD to help with matching contacts to donor ids).

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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, "BaseCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Mon, 03 Oct 2011 21:19:49 GMT

Revision 9 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/3/2011 5:19:49 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

<future: TntMPD 2.2> Supported versions will also include: [APPLICATION], [FILE], [ACCOUNT_BALANCE] AND [DESIGNATIONS]. (more info to come!)

[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]

<future: TntMPD 2.2> DefaultCurrencyCode BaseCurrencyCode 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
MEMO	<future: TntMPD 2.2> A note regarding the donor.
MAGAZINE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Does the donor subscribe to the organization's news magazine?
DECEASED	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "FALSE". Is the donor decease?
REMINDER	<future: TntMPD 2.2> (A18) How often is the donor reminded by the organization to make a donation?
RELATED_IDS	<future: TntMPD 2.2> A comma seperated list of related donor ids (used by TntMPD to help with matching contacts to donor ids).

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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" "BaseCurrencyCode" should be defined once in the [Organization] section.
PERSONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

TntMPD will store designation ids, donor ids and donation ids exactly as it is received. But internally when TntMPD 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 TntMPD's perspective. Sending your staff two donations with an id of "ABC" and "abc" respectively will either result in a "duplicate id error" in TntMPD or it will overwrite the one donation with the other.

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Mon, 14 Mar 2011 14:52:29 GMT

Revision 8 posted to Frequently Asked Questions (English) by Troy Wolbrink on 3/14/2011 10:52:29 AM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

The DataSync file has three sections. The sections are [ORGANIZATION], [DONORS] and [GIFTS]. An example is listed below. (The complete version is available here: http://download.tntware.com/sample_data_sync_file/sample.tntmpd)

[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]

<future: TntMPD 2.2> 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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	<future: TntMPD 2.2> "TRUE" or "FALSE". 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).

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

tcarnahan — Fri, 27 Nov 2009 04:45:02 GMT

Revision 7 posted to Frequently Asked Questions (English) by tcarnahan on 11/26/2009 11:45:02 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

[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]

<future: TntMPD 2.2> 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.2> "TRUE" or "FALSE". Blank implies "TRUE".

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.2> (Float) (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	<future: TntMPD 2.2> (A3) (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.
MEMO	<future: TntMPD 2.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.2> (A3) 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.

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Fri, 29 May 2009 22:56:52 GMT

Revision 6 posted to Frequently Asked Questions (English) by Troy Wolbrink on 5/29/2009 6:56:52 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

[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]

<future: TntMPD 2.12.2> 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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.12.2> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.12.2> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.12.2> Email address.
EMAIL_CHANGED	<future: TntMPD 2.12.2>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.12.2> "TRUE" or "FALSE". Blank implies "TRUE".

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.12.2> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.12.2> (Float) (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	<future: TntMPD 2.12.2> (A3) (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.
MEMO	<future: TntMPD 2.12.2> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.12.2> (A3) 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.

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Mon, 02 Mar 2009 16:11:17 GMT

Revision 5 posted to Frequently Asked Questions (English) by Troy Wolbrink on 3/2/2009 11:11:17 AM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

[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]

<future: TntMPD 2.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.

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.1> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.1> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.1> Email address.
EMAIL_CHANGED	<future: TntMPD 2.1>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.1> "TRUE" or "FALSE". Blank implies "TRUE".

[GIFTS]

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

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.1> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.1> (Float) (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	<future: TntMPD 2.1> (A3) (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.
MEMO	<future: TntMPD 2.1> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.1> (A3) 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.

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

Case Insensitivity

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Mon, 29 Sep 2008 18:49:51 GMT

Revision 4 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 2:49:51 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Filed under: Developer Guides

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

[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]

<future: TntMPD 2.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.

Click here To see

Here's an example result:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.1> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.1> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.1> Email address.
EMAIL_CHANGED	<future: TntMPD 2.1>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.1> "TRUE" or "FALSE". Blank implies "TRUE".

[GIFTS]

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

Click here To see

Here's an example result.:

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.1> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.1> (Float) (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	<future: TntMPD 2.1> (A3) (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.
MEMO	<future: TntMPD 2.1> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.1> (A3) 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.

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section:

How to contact me

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Troy Wolbrink — Mon, 29 Sep 2008 18:44:15 GMT

Revision 3 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 2:44:15 PM

How would I send our staff a monthly (or weekly) TntMPD DataSync file?

Download contribution details
Download names and addresses of donors

This is an example of the logo you can provide:

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

Technical Details

[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]

<future: TntMPD 2.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.

Click here To see an example result.

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
PERSON_TYPE	"O" or "P" (Organization or Person)
LAST_NAME_ORG	Last Name or Organization Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
TITLE	Title (Mr., Mrs.)
SUFFIX	Suffix (Jr., Sr.)
SP_LAST_NAME	for spouse
SP_FIRST_NAME	for spouse
SP_MIDDLE_NAME	for spouse
SP_TITLE	for spouse
SP_SUFFIX	for spouse Note: If this is not blank, it is just concatenated with a space to SP_LAST_NAME.
ADDR1	Street Address (Line 1)
ADDR2	Street Address (Line 2)
ADDR3	Street Address (Line 3)
ADDR4	Street Address (Line 4)
CITY	City
STATE	State
ZIP	Postal Code
COUNTRY	(A3) ISO 3166 Alpha 3 country code <new in TntMPD 2.0> ISO 3166 Alpha 2 country codes are supported in TntMPD 2.0.
CNTRY_DESCR	Name of country.
ADDR_CHANGED	(M/D/YYYY) When the addres was last changed.
ADDR_DELIVERABLE	<future: TntMPD 2.1> "TRUE" or "FALSE". Blank implies "TRUE".
PHONE	Phone number.
PHONE_CHANGED	(M/D/YYYY) When the phone was last changed.
PHONE_OPERATIONAL	<future: TntMPD 2.1> "TRUE" or "FALSE". Blank implies "TRUE".
EMAIL	<future: TntMPD 2.1> Email address.
EMAIL_CHANGED	<future: TntMPD 2.1>(M/D/YYYY) When the email was last changed.
EMAIL_OPERATIONAL	<future: TntMPD 2.1> "TRUE" or "FALSE". Blank implies "TRUE".

[GIFTS]

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

Click here To see an example result.

Field Descriptions:

FieldName	Description
PEOPLE_ID	(A18) Donor ID
ACCT_NAME	Donor full name
DISPLAY_DATE	(M/D/YYYY) Date of contribution
AMOUNT	(Float) Amount of contribution
DONATION_ID	(A18) Donation 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	<future: TntMPD 2.1> (A18) (Optional) Payment method of this donation.
TENDERED_AMOUNT	<future: TntMPD 2.1> (Float) (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	<future: TntMPD 2.1> (A3) (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.
MEMO	<future: TntMPD 2.1> (A) Any comments (no length limit) associated with this gift.
BASE_CURRENCY	<future: TntMPD 2.1> (A3) 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.

Really Simple Option

One way to make this work is to provide just the [DONORS] or [GIFTS] section in a file (minus the section header). TntMPD will recognize that a single section is being provided.

For example, TntMPD would recognize this as being a [DONORS] section:

And for another example, TntMPD would recognize this as being a [GIFTS] section: