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

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

TNT.tips from Bob!

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

About TntWare

You are currently reviewing an older revision of this page. Go to current version

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

Filed under:

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

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.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:

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

[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.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:

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

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"

 


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.