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

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

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 3.0> 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.  All fields are optional (column header must exist, but data can be blank) except PEOPLE_ID and ACCT_NAME.

Here's an example result:

Field Descriptions:

[GIFTS]

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

Here's an example result:

Field Descriptions:

Data Types Explained

• A25, a text column with a maximum of 25 characters

• MEMO, a text column with no predefined length limits

• DATE, a date formatted as M/D/YYYY.  TntMPD 3.0 also accepts the YYYY-MM-DD format.

• BOOL, a boolean as "TRUE" or "FALSE"

• FLOAT, a floating point number.  Currency symbols or thousands separators are not allowed.  The decimal separator must be a period.

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

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