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