Frequently Asked Questions (English)

How can I check which profiles are available to me for doing "Gift Input"?

Troy Wolbrink — Thu, 04 Mar 2010 17:41:30 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 3/4/2010 12:41:30 PM

Some ministries provide the ability to choose a profile when doing "Gift Input from the Web". These profiles allow you to choose which accounts you're interested in downloading donation information for. If you'd like to know which profiles are available to you:

1. Click the "Gift Input" button.

2. If you haven't already, choose your organization and type in your login and password.

3. Drop down the box where it says, "Profile" and then click on "Download list of profiles..."

After a few seconds, the profile box should drop down again. The list of profiles available to you will be included in the list:

If you never received an error message in this process, than this is the list of profiles available to you.

How can I make my organization's online donation system compatible with TntMPD?

Troy Wolbrink — Tue, 23 Feb 2010 18:35:37 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/23/2010 1:35:37 PM

How can I make my organization's online donation system compatible with TntMPD?

Filed under: Developer Guides

This document describes how you can make your organization's online donation system compatible with TntMPD. The technical details are spelled out so that you can provide your own custom solution. It requires a knowledge of computer programming. Keep in mind that the preferred and recommended way to provide a TntMPD-compatible download for your staff is to use TntMPD.DataServer. TntMPD.DataServer already includes pre-built integration templates for DonorWise, Raiser's Edge and OPTIGEM. Tools and documentation are provided to allow you to integrate TntMPD.DataServer with your own donation system.

Once you are TntMPD-compatible, your staff will be able to use TntMPD to connect to your system using the Web to:

Download contribution details
Download names and addresses of donors
Be notified of their staff account balance

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

What it takes...

Query INI file
Account Balance Query
Donations Query
Addresses Query
Addresses By IDs Query
Profiles Query (Optional) <new for TntMPD 2.0>
SingleSignOn Query (Optional) <future: TntMPD 2.2>

Query INI File

You need to provide a Query INI File. This file will provide the web address and parameter template needed to download the results of the query. Below is an example. Notice it is based on a standard Windows INI file format.

[APPLICATION]
MinimumVersion=1.5.0
RecommendedVersion=1.5.0

[ORGANIZATION]
RedirectQueryIni=
Name=Your Organization Name
Abbreviation=MyOrg
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
MinimumWebGiftDate=1/1/1990
Code=MyOrg-USA
QueryAuthentication=0
MinPidLength=0
OrgHelpEmail=help@myorg.org
OrgHelpUrl=https://www.myorg.org/help.htm
OrgHelpUrlDescription=Click here to report this issue over the Web!
OrgHelpOther=You may also reach the CCC Call Center at 407-826-2948.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
StaffPortalUrl=http://myorg.org/staffportal.html
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

[ACCOUNT_BALANCE.2]
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS.2]
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.2]
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

Now let me explain the meaning of each value...

[APPLICATION]
// You can require a minimum version of TntMPD for Web Input features.
MinimumVersion=1.5.0
// You can recommend a minimum version of TntMPD for Web Input features if you wish.
RecommendedVersion=1.5.0

[ORGANIZATION]
// If you move your Query INI File, you can permanently redirect users to the new query.ini url.
RedirectQueryIni=
// Specify the name of your organization here.
Name=Your Organization Name
// Specify a short abbreviation of your organization here.
Abbreviation=MyOrg
// Really old versions of TntMPD may use this. This has been deprecated. Use "WebLogo-JPEG-470x120" on new work.
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
// URL of where your logo can be downloaded (JPEG only).
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
// URL of a mini portal into your website
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
// URL to help your staff get setup with an account.
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
// URL of your banner ad.
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
// Boundary of how back your online donation system provides data for. (M/D/YYYY)
MinimumWebGiftDate=1/1/1990
// Unique code to represent your ministry internally to TntMPD. (User never sees this.)
Code=MyOrg-USA
// Set this to "1" if you want the queries to use basic HTTP authentication
QueryAuthentication=0
// TntMPD internally removes leading zeros from numeric donor account ids. Specify the minimum number of digits a
// donor id should be, and TntMPD will add leading zeros when returning them back in the "Addresses By IDs Query" query.
MinPidLength=0
// <new for TntMPD 2.1.16> Specify an email address where users can report errors with your download process.
OrgHelpEmail=help@myorg.org
// <new for TntMPD 2.0> Specify a url where users can report errors with your download process.
OrgHelpUrl=https://www.myorg.org/help.htm
// <new for TntMPD 2.0> Specify the text users will see for OrgHelpUrl.
OrgHelpUrlDescription=Click here to report this issue over the Web!
// <new for TntMPD 2.0> Specify alternative text for how users can get help with downloading information.
OrgHelpOther=You may also reach the us at 123-456-7890.
// <new for TntMPD 2.0> Specify the url where users can request new download profiles.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
// <new for TntMPD 2.0.44> Specify the url where users can view a staff portal.
StaffPortalUrl=http://myorg.org/staffportal.html
// <future: TntMPD 2.2> Specify the base currency code (ISO 4217 3-char) for gifts returning from your Donations Query.
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/    // URL of your online donation system.
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$    // Your POST template. (described later)

[ACCOUNT_BALANCE.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]    // URL and POST have same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&PID=$PERSONIDS$

[ADDRESSES_BY_PERSONIDS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2] <new for TntMPD 2.0>
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.2] <future: TntMPD 2.2>
// Note: If this query were actually used, credentials would not be
//   passed in to the other queries. But $SSO_TICKET$ would be used instead.
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

The benefit of keeping the instructions in this file is that if you later change the URL or POST template of your query, you can just edit the Query INI File and make a seamless transition. The staff using the program will never know it changed.

TntMPD-version specific sections <new for TntMPD 2.0>

TntMPD 2.0 and newer will support version specific sections. For example a client running TntMPD 2.2 will search for the "DONATION" section by using the first out of this list that it finds first:

[DONATIONS.2.2]
[DONATIONS.2.1]
[DONATIONS.2.0]
[DONATIONS.2]
[DONATIONS]

The Queries

--Placeholders--
Each query has a URL and a POST. The URL specifies your online donation server object (CGI object, for example). The POST specifies the data to send with the HTTP POST transaction. The POST is in a template form. These placeholders are key words that will be substituted by the appropriate string based on the user's input in TntMPD:

$ACCOUNT$	The user name of the staff logging in to the donation system.
$PASSWORD$	The password of the staff logging in to the donation system.
$SSO_TICKET$	<future: TntMPD 2.2> The service ticket returned by the SingleSignOn Query. Generally you would use this in lieu of $ACCOUNT$ and $PASSWORD$. Note: The SingleSignOn query never receives the $SSO_TICKET$ placeholder, but only accepts $ACCOUNT$ and $PASSWORD$.
$PROFILE$	<new for TntMPD 2.0> The profile code of the staff logging in to the donation system. If the Profiles query is not supported, this will always be blank. Note: The $PROFILE$ placeholder is never provided in the Profiles Query itself.
$DATEFROM$	The specified beginning date. (M/D/YYYY) (I'll explain later where and how this is used.)
$DATETO$	The specified ending date. (M/D/YYYY) (I'll explain later where and how this is used.)
$PERSONIDS$	A comma separated list of donor IDs. (I'll explain later where and how this is used.)

So for example, if I defined my Post value by:

<divre></divre>Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

And if my user name was "JohnDoe", and my password was "abc123" then the following data would be send with the HTTP POST transaction:

<divre></divre>Action=TntBalance&Username=JohnDoe&Password=abc123

--Standard Response--
Each query should return its results as CSV text. I will describe the
field names expected for each query.

--Error Response--
Each query should handle invalid conditions (such as an invalid username) by
returning two lines of text. The first line of text should be "ERROR".
The second line of text is the error description. Here are a couple of
examples to give you the general idea.

ERROR
Invalid password.

ERROR
Invalid user name.

ERROR
Server is down for maintenance.

ERROR
Invalid date range.

Account Balance Query

The purpose of this query is to simply return the staff account balance of the staff member submitting the request. It only uses the $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders.

Example result:

EMPLID	ACCT_NAME	BALANCE
12345678	Doe, John & Jane	1225.30

Result in it's raw form just in case you are not familiar with the CSV format:

EMPLID,ACCT_NAME,BALANCE
12345678,"Doe, John & Jane",1225.30

Field Descriptions:

FieldName	Description
EMPLID	Comma separated list of designation ids (A18) associated with this user/profile.
ACCT_NAME	List of designation account names (A50) associated with this user. Each name is delimited by carriage returns and line feeds (vbCrLf or #13#10), and correlates to designation ids found in EMPLID.
BALANCE	(Text) Custom text that describes the user's account balance.

Donations Query

The purpose of this query is to return all donation detail data for the staff member within a certain date range. In addition to the usual $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders, it also uses $DATEFROM$ and $DATETO$. Keep in mind that these placeholders come in the (M/D/YYYY) format. The $DATEFROM$ and $DATETO$ placeholders describe the beginning and ending dates of the query. You should include donation data for all dates between and including these dates. The beginning date will be limited by the "MinimumWebGiftDate" value in the Query INI file.

Here's an example result:

"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, "DefaultCurrencyCode" should be defined once in the [Organization] section.

Addresses Query

The purpose of this query is to return detailed name, address and phone data for the staff member's donors. In addition to the usual $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders, it also uses $DATEFROM$. Keep in mind that this parameter comes in the (M/D/YYYY) format. The $DATEFROM$ placeholder limits the address list to only those that have changed since the given date. If the given date is blank, the user is requesting ALL addresses.

Note: You may simply ignore the $DATEFROM$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

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

Addresses By IDs Query

This Query only differs from the Addresses Query in that it uses the $PERSONIDS$ parameter instead of the $DATEFROM$ parameter. The $PERSONID$ parameter is substituted by a comma separated list of donor IDs. These donor IDs are obtained from donations in the Donations Query. TntMPD will never submit a request with more than 200 donor IDs.

Note: You may simply ignore the $PERSONIDS$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

Profiles Query (Optional) <new for TntMPD 2.0>

The purpose of this query is to return a list of different profiles associated with the user. This allows a user to have different "modes" for downloading information, without having to setup different username/passwords for each mode. This works especially well in a Single Sign On (SSO) environment.

Example result:

PROFILE_CODE	PROFILE_DESC
	Staff Account (Default)
MIN1	Operating Account #1
MIN2	Operating Account #2

Field Descriptions:

FieldName	Description
PROFILE_CODE	(A18) A code to identify this profile. A blank profile code would be the default profile associated with the account. Note: The Field Name "ROLE_CODE" was supported at one time, but is now deprecated for new work.
PROFILE_DESCRIPTION	(A50) A description of the profile. This is what the user sees. Note: The Field Name "ROLE_DESCRIPTION" was supported at one time, but is now deprecated for new work.

SingleSignOn Query (Optional) <future: TntMPD 2.2>

The purpose of this query is to return a one-time-use authentication ticket that can be used in one (and only one) query. It receives $ACCOUNT$ and $PASSWORD$. It should return one row.

Example result:

SSO_TICKET

ST-gjdhgvyudmfnbgbyf

Field Descriptions:

FieldName	Description
SSO_TICKET	(Text) An authentication "service" ticket than can be passed into another query for one-time use.

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.

Testing your compatibility with TntMPD

To test your online donation system's compatibility with TntMPD, pull up the "Gift Input from Web" screen. Where it has you choose your Organization, choose "Custom". (Note: You must hold down the Shift key when you drop down the list.) Then you can simply type in the URL of your Query INI File. That is all there is to it!

Making it easy for your staff to connect...

If you want to include your organization in the drop down list where you choose the Organization, just send me an email. (wolbrink@ccci.org) Be sure to include your organization's name, and the URL of your Query INI File. I can update the list on my website, and your organization will automatically appear in the list.

Then when your staff member tries to do "Gift Input from Web" for the first time, they can just select your organization's name in the list. It couldn't be much easier!

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.

How can I make my organization's online donation system compatible with TntMPD?

Troy Wolbrink — Sat, 30 May 2009 01:48:35 GMT

Revision 7 posted to Frequently Asked Questions (English) by Troy Wolbrink on 5/29/2009 9:48:35 PM

How can I make my organization's online donation system compatible with TntMPD?

Filed under: Developer Guides

Once you are TntMPD-compatible, your staff will be able to use TntMPD to connect to your system using the Web to:

Download contribution details
Download names and addresses of donors
Be notified of their staff account balance

This is an example of the logo you can provide:

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

What it takes...

Query INI file
Account Balance Query
Donations Query
Addresses Query
Addresses By IDs Query
Profiles Query (Optional) <new for TntMPD 2.0>
SingleSignOn Query (Optional) <future: TntMPD 2.12.2>

Query INI File

[APPLICATION]
MinimumVersion=1.5.0
RecommendedVersion=1.5.0

[ORGANIZATION]
RedirectQueryIni=
Name=Your Organization Name
Abbreviation=MyOrg
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
MinimumWebGiftDate=1/1/1990
Code=MyOrg-USA
QueryAuthentication=0
MinPidLength=0
OrgHelpUrl=https://www.myorg.org/help.htm
OrgHelpUrlDescription=Click here to report this issue over the Web!
OrgHelpOther=You may also reach the CCC Call Center at 407-826-2948.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
StaffPortalUrl=http://myorg.org/staffportal.html
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1]SingleSignOn.2.2]
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

Now let me explain the meaning of each value...

[ORGANIZATION]
// If you move your Query INI File, you can permanently redirect users to the new query.ini url.
RedirectQueryIni=
// Specify the name of your organization here.
Name=Your Organization Name
// Specify a short abbreviation of your organization here.
Abbreviation=MyOrg
// Really old versions of TntMPD may use this. This has been deprecated. Use "WebLogo-JPEG-470x120" on new work.
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
// URL of where your logo can be downloaded (JPEG only).
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
// URL of a mini portal into your website
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
// URL to help your staff get setup with an account.
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
// URL of your banner ad.
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
// Boundary of how back your online donation system provides data for. (M/D/YYYY)
MinimumWebGiftDate=1/1/1990
// Unique code to represent your ministry internally to TntMPD. (User never sees this.)
Code=MyOrg-USA
// Set this to "1" if you want the queries to use basic HTTP authentication
QueryAuthentication=0
// TntMPD internally removes leading zeros from numeric donor account ids. Specify the minimum number of digits a
// donor id should be, and TntMPD will add leading zeros when returning them back in the "Addresses By IDs Query" query.
MinPidLength=0
// <new for TntMPD 2.0> Specify a url where users can report errors with your download process.
OrgHelpUrl=https://www.myorg.org/help.htm
// <new for TntMPD 2.0> Specify the text users will see for OrgHelpUrl.
OrgHelpUrlDescription=Click here to report this issue over the Web!
// <new for TntMPD 2.0> Specify alternative text for how users can get help with downloading information.
OrgHelpOther=You may also reach the us at 123-456-7890.
// <new for TntMPD 2.0> Specify the url where users can request new download profiles.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
// <new for TntMPD 2.0.44> Specify the url where users can view a staff portal.
StaffPortalUrl=http://myorg.org/staffportal.html
// <future: TntMPD 2.12.2> Specify the base currency code (ISO 4217 3-char) for gifts returning from your Donations Query.
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/    // URL of your online donation system.
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$    // Your POST template. (described later)

[ACCOUNT_BALANCE.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]    // URL and POST have same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&PID=$PERSONIDS$

[ADDRESSES_BY_PERSONIDS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2] <new for TntMPD 2.0>
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1] SingleSignOn.2.2] <future: TntMPD 2.12.2>
// Note: If this query were actually used, credentials would not be
//   passed in to the other queries. But $SSO_TICKET$ would be used instead.
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

TntMPD-version specific sections <new for TntMPD 2.0>

TntMPD 2.0 and newer will support version specific sections. For example a client running TntMPD 2.2 will search for the "DONATION" section by using the first out of this list that it finds first:

[DONATIONS.2.2]
[DONATIONS.2.1]
[DONATIONS.2.0]
[DONATIONS.2]
[DONATIONS]

The Queries

$ACCOUNT$	The user name of the staff logging in to the donation system.
$PASSWORD$	The password of the staff logging in to the donation system.
$SSO_TICKET$	<future: TntMPD 2.12.2> The service ticket returned by the SingleSignOn Query. Generally you would use this in lieu of $ACCOUNT$ and $PASSWORD$. Note: The SingleSignOn query never receives the $SSO_TICKET$ placeholder, but only accepts $ACCOUNT$ and $PASSWORD$.
$PROFILE$	<new for TntMPD 2.0> The profile code of the staff logging in to the donation system. If the Profiles query is not supported, this will always be blank. Note: The $PROFILE$ placeholder is never provided in the Profiles Query itself.
$DATEFROM$	The specified beginning date. (M/D/YYYY) (I'll explain later where and how this is used.)
$DATETO$	The specified ending date. (M/D/YYYY) (I'll explain later where and how this is used.)
$PERSONIDS$	A comma separated list of donor IDs. (I'll explain later where and how this is used.)

So for example, if I defined my Post value by:

<divre></divre>Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

And if my user name was "JohnDoe", and my password was "abc123" then the following data would be send with the HTTP POST transaction:

<divre></divre>Action=TntBalance&Username=JohnDoe&Password=abc123

ERROR
Invalid password.

ERROR
Invalid user name.

ERROR
Server is down for maintenance.

ERROR
Invalid date range.

Account Balance Query

The purpose of this query is to simply return the staff account balance of the staff member submitting the request. It only uses the $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders.

Example result:

EMPLID	ACCT_NAME	BALANCE
12345678	Doe, John & Jane	1225.30

Result in it's raw form just in case you are not familiar with the CSV format:

EMPLID,ACCT_NAME,BALANCE
12345678,"Doe, John & Jane",1225.30

Field Descriptions:

FieldName	Description
EMPLID	Comma separated list of designation ids (A18) associated with this user/profile.
ACCT_NAME	List of designation account names (A50) associated with this user. Each name is delimited by carriage returns and line feeds (vbCrLf or #13#10), and correlates to designation ids found in EMPLID.
BALANCE	(Text) Custom text that describes the user's account balance.

Donations Query

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.

Addresses Query

Note: You may simply ignore the $DATEFROM$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

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

Addresses By IDs Query

Note: You may simply ignore the $PERSONIDS$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

Profiles Query (Optional) <new for TntMPD 2.0>

Example result:

PROFILE_CODE	PROFILE_DESC
	Staff Account (Default)
MIN1	Operating Account #1
MIN2	Operating Account #2

Field Descriptions:

FieldName	Description
PROFILE_CODE	(A18) A code to identify this profile. A blank profile code would be the default profile associated with the account. Note: The Field Name "ROLE_CODE" was supported at one time, but is now deprecated for new work.
PROFILE_DESCRIPTION	(A50) A description of the profile. This is what the user sees. Note: The Field Name "ROLE_DESCRIPTION" was supported at one time, but is now deprecated for new work.

SingleSignOn Query (Optional) <future: TntMPD 2.12.2>

The purpose of this query is to return a one-time-use authentication ticket that can be used in one (and only one) query. It receives $ACCOUNT$ and $PASSWORD$. It should return one row.

Example result:

SSO_TICKET

ST-gjdhgvyudmfnbgbyf

Field Descriptions:

FieldName	Description
SSO_TICKET	(Text) An authentication "service" ticket than can be passed into another query for one-time use.

Case Insensitivity

Testing your compatibility with TntMPD

Making it easy for your staff to connect...

Then when your staff member tries to do "Gift Input from Web" for the first time, they can just select your organization's name in the list. It couldn't be much easier!

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.

How can I make my organization's online donation system compatible with TntMPD?

Troy Wolbrink — Mon, 02 Mar 2009 16:08:18 GMT

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

How can I make my organization's online donation system compatible with TntMPD?

Filed under: Developer Guides

Once you are TntMPD-compatible, your staff will be able to use TntMPD to connect to your system using the Web to:

Download contribution details
Download names and addresses of donors
Be notified of their staff account balance

This is an example of the logo you can provide:

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

What it takes...

Query INI file
Account Balance Query
Donations Query
Addresses Query
Addresses By IDs Query
Profiles Query (Optional) <new for TntMPD 2.0>
SingleSignOn Query (Optional) <future: TntMPD 2.1>

Query INI File

[APPLICATION]
MinimumVersion=1.5.0
RecommendedVersion=1.5.0

[ORGANIZATION]
RedirectQueryIni=
Name=Your Organization Name
Abbreviation=MyOrg
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
MinimumWebGiftDate=1/1/1990
Code=MyOrg-USA
QueryAuthentication=0
MinPidLength=0
OrgHelpUrl=https://www.myorg.org/help.htm
OrgHelpUrlDescription=Click here to report this issue over the Web!
OrgHelpOther=You may also reach the CCC Call Center at 407-826-2948.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
StaffPortalUrl=http://myorg.org/staffportal.html
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1]
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

Now let me explain the meaning of each value...

[ORGANIZATION]
// If you move your Query INI File, you can permanently redirect users to the new query.ini url.
RedirectQueryIni=
// Specify the name of your organization here.
Name=Your Organization Name
// Specify a short abbreviation of your organization here.
Abbreviation=MyOrg
// Really old versions of TntMPD may use this. This has been deprecated. Use "WebLogo-JPEG-470x120" on new work.
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
// URL of where your logo can be downloaded (JPEG only).
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
// URL of a mini portal into your website
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
// URL to help your staff get setup with an account.
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
// URL of your banner ad.
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
// Boundary of how back your online donation system provides data for. (M/D/YYYY)
MinimumWebGiftDate=1/1/1990
// Unique code to represent your ministry internally to TntMPD. (User never sees this.)
Code=MyOrg-USA
// Set this to "1" if you want the queries to use basic HTTP authentication
QueryAuthentication=0
// TntMPD internally removes leading zeros from numeric donor account ids. Specify the minimum number of digits a
// donor id should be, and TntMPD will add leading zeros when returning them back in the "Addresses By IDs Query" query.
MinPidLength=0
// <new for TntMPD 2.0> Specify a url where users can report errors with your download process.
OrgHelpUrl=https://www.myorg.org/help.htm
// <new for TntMPD 2.0> Specify the text users will see for OrgHelpUrl.
OrgHelpUrlDescription=Click here to report this issue over the Web!
// <new for TntMPD 2.0> Specify alternative text for how users can get help with downloading information.
OrgHelpOther=You may also reach the us at 123-456-7890.
// <new for TntMPD 2.0> Specify the url where users can request new download profiles.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
// <new for TntMPD 2.0.44> Specify the url where users can view a staff portal.
StaffPortalUrl=http://myorg.org/staffportal.html
// <future: TntMPD 2.1> Specify the base currency code (ISO 4217 3-char) for gifts returning from your Donations Query.
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/    // URL of your online donation system.
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$    // Your POST template. (described later)

[ACCOUNT_BALANCE.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]    // URL and POST have same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&PID=$PERSONIDS$

[ADDRESSES_BY_PERSONIDS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2] <new for TntMPD 2.0>
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1] <future: TntMPD 2.1>
// Note: If this query were actually used, credentials would not be
//   passed in to the other queries. But $SSO_TICKET$ would be used instead.
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

TntMPD-version specific sections <new for TntMPD 2.0>

TntMPD 2.0 and newer will support version specific sections. For example a client running TntMPD 2.2 will search for the "DONATION" section by using the first out of this list that it finds first:

[DONATIONS.2.2]
[DONATIONS.2.1]
[DONATIONS.2.0]
[DONATIONS.2]
[DONATIONS]

The Queries

$ACCOUNT$	The user name of the staff logging in to the donation system.
$PASSWORD$	The password of the staff logging in to the donation system.
$SSO_TICKET$	<future: TntMPD 2.1> The service ticket returned by the SingleSignOn Query. Generally you would use this in lieu of $ACCOUNT$ and $PASSWORD$. Note: The SingleSignOn query never receives the $SSO_TICKET$ placeholder, but only accepts $ACCOUNT$ and $PASSWORD$.
$PROFILE$	<new for TntMPD 2.0> The profile code of the staff logging in to the donation system. If the Profiles query is not supported, this will always be blank. Note: The $PROFILE$ placeholder is never provided in the Profiles Query itself.
$DATEFROM$	The specified beginning date. (M/D/YYYY) (I'll explain later where and how this is used.)
$DATETO$	The specified ending date. (M/D/YYYY) (I'll explain later where and how this is used.)
$PERSONIDS$	A comma separated list of donor IDs. (I'll explain later where and how this is used.)

So for example, if I defined my Post value by:

Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

And if my user name was "JohnDoe", and my password was "abc123" then the following data would be send with the HTTP POST transaction:

Action=TntBalance&Username=JohnDoe&Password=abc123

ERROR
Invalid password.

ERROR
Invalid user name.

ERROR
Server is down for maintenance.

ERROR
Invalid date range.

Account Balance Query

The purpose of this query is to simply return the staff account balance of the staff member submitting the request. It only uses the $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders.

Example result:

EMPLID	ACCT_NAME	BALANCE
12345678	Doe, John & Jane	1225.30

Result in it's raw form just in case you are not familiar with the CSV format:

EMPLID,ACCT_NAME,BALANCE
12345678,"Doe, John & Jane",1225.30

Field Descriptions:

FieldName	Description
EMPLID	Comma separated list of designation ids (A18) associated with this user/profile.
ACCT_NAME	List of designation account names (A50) associated with this user. Each name is delimited by carriage returns and line feeds (vbCrLf or #13#10), and correlates to designation ids found in EMPLID.
BALANCE	(Text) Custom text that describes the user's account balance.

Donations Query

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.

Addresses Query

Note: You may simply ignore the $DATEFROM$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

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

Addresses By IDs Query

Note: You may simply ignore the $PERSONIDS$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

Profiles Query (Optional) <new for TntMPD 2.0>

Example result:

PROFILE_CODE	PROFILE_DESC
	Staff Account (Default)
MIN1	Operating Account #1
MIN2	Operating Account #2

Field Descriptions:

FieldName	Description
PROFILE_CODE	(A18) A code to identify this profile. A blank profile code would be the default profile associated with the account. Note: The Field Name "ROLE_CODE" was supported at one time, but is now deprecated for new work.
PROFILE_DESCRIPTION	(A50) A description of the profile. This is what the user sees. Note: The Field Name "ROLE_DESCRIPTION" was supported at one time, but is now deprecated for new work.

SingleSignOn Query (Optional) <future: TntMPD 2.1>

The purpose of this query is to return a one-time-use authentication ticket that can be used in one (and only one) query. It receives $ACCOUNT$ and $PASSWORD$. It should return one row.

Example result:

SSO_TICKET

ST-gjdhgvyudmfnbgbyf

Field Descriptions:

FieldName	Description
SSO_TICKET	(Text) An authentication "service" ticket than can be passed into another query for one-time use.

Case Insensitivity

Testing your compatibility with TntMPD

Making it easy for your staff to connect...

Then when your staff member tries to do "Gift Input from Web" for the first time, they can just select your organization's name in the list. It couldn't be much easier!

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.

How can I make my organization's online donation system compatible with TntMPD?

Troy Wolbrink — Mon, 29 Sep 2008 19:06:25 GMT

Revision 5 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 3:06:25 PM

How can I make my organization's online donation system compatible with TntMPD?

Filed under: Developer Guides

Once you are TntMPD-compatible, your staff will be able to use TntMPD to connect to your system using the Web to:

Download contribution details
Download names and addresses of donors
Be notified of their staff account balance

This is an example of the logo you can provide:

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

What it takes...

Query INI file
Account Balance Query
Donations Query
Addresses Query
Addresses By IDs Query
Profiles Query (Optional) <new for TntMPD 2.0>
SingleSignOn Query (Optional) <future: TntMPD 2.1>

Query INI File

[APPLICATION]
MinimumVersion=1.5.0
RecommendedVersion=1.5.0

[ORGANIZATION]
RedirectQueryIni=
Name=Your Organization Name
Abbreviation=MyOrg
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
MinimumWebGiftDate=1/1/1990
Code=MyOrg-USA
QueryAuthentication=0
MinPidLength=0
OrgHelpUrl=https://www.myorg.org/help.htm
OrgHelpUrlDescription=Click here to report this issue over the Web!
OrgHelpOther=You may also reach the CCC Call Center at 407-826-2948.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
StaffPortalUrl=http://myorg.org/staffportal.html
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1]
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

Now let me explain the meaning of each value...

[ORGANIZATION]
// If you move your Query INI File, you can permanently redirect users to the new query.ini url.
RedirectQueryIni=
// Specify the name of your organization here.
Name=Your Organization Name
// Specify a short abbreviation of your organization here.
Abbreviation=MyOrg
// Really old versions of TntMPD may use this. This has been deprecated. Use "WebLogo-JPEG-470x120" on new work.
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
// URL of where your logo can be downloaded (JPEG only).
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
// URL of a mini portal into your website
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
// URL to help your staff get setup with an account.
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
// URL of your banner ad.
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
// Boundary of how back your online donation system provides data for. (M/D/YYYY)
MinimumWebGiftDate=1/1/1990
// Unique code to represent your ministry internally to TntMPD. (User never sees this.)
Code=MyOrg-USA
// Set this to "1" if you want the queries to use basic HTTP authentication
QueryAuthentication=0
// TntMPD internally removes leading zeros from numeric donor account ids. Specify the minimum number of digits a
// donor id should be, and TntMPD will add leading zeros when returning them back in the "Addresses By IDs Query" query.
MinPidLength=0
// <new for TntMPD 2.0> Specify a url where users can report errors with your download process.
OrgHelpUrl=https://www.myorg.org/help.htm
// <new for TntMPD 2.0> Specify the text users will see for OrgHelpUrl.
OrgHelpUrlDescription=Click here to report this issue over the Web!
// <new for TntMPD 2.0> Specify alternative text for how users can get help with downloading information.
OrgHelpOther=You may also reach the us at 123-456-7890.
// <new for TntMPD 2.0> Specify the url where users can request new download profiles.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
// <new for TntMPD 2.0.44> Specify the url where users can view a staff portal.
StaffPortalUrl=http://myorg.org/staffportal.html
// <future: TntMPD 2.1> Specify the base currency code (ISO 4217 3-char) for gifts returning from your Donations Query.
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/    // URL of your online donation system.
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$    // Your POST template. (described later)

[ACCOUNT_BALANCE.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]    // URL and POST have same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&PID=$PERSONIDS$

[ADDRESSES_BY_PERSONIDS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2] <new for TntMPD 2.0>
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1] <future: TntMPD 2.1>
// Note: If this query were actually used, credentials would not be
//   passed in to the other queries. But $SSO_TICKET$ would be used instead.
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

TntMPD-version specific sections <new for TntMPD 2.0>

TntMPD 2.0 and newer will support version specific sections. For example a client running TntMPD 2.2 will search for the "DONATION" section by using the first out of this list that it finds first:

[DONATIONS.2.2]
[DONATIONS.2.1]
[DONATIONS.2.0]
[DONATIONS.2]
[DONATIONS]

The Queries

$ACCOUNT$	The user name of the staff logging in to the donation system.
$PASSWORD$	The password of the staff logging in to the donation system.
$SSO_TICKET$	<future: TntMPD 2.1> The service ticket returned by the SingleSignOn Query. Generally you would use this in lieu of $ACCOUNT$ and $PASSWORD$. Note: The SingleSignOn query never receives the $SSO_TICKET$ placeholder, but only accepts $ACCOUNT$ and $PASSWORD$.
$PROFILE$	<new for TntMPD 2.0> The profile code of the staff logging in to the donation system. If the Profiles query is not supported, this will always be blank. Note: The $PROFILE$ placeholder is never provided in the Profiles Query itself.
$DATEFROM$	The specified beginning date. (M/D/YYYY) (I'll explain later where and how this is used.)
$DATETO$	The specified ending date. (M/D/YYYY) (I'll explain later where and how this is used.)
$PERSONIDS$	A comma separated list of donor IDs. (I'll explain later where and how this is used.)

So for example, if I defined my Post value by:

Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

And if my user name was "JohnDoe", and my password was "abc123" then the following data would be send with the HTTP POST transaction:

Action=TntBalance&Username=JohnDoe&Password=abc123

ERROR
Invalid password.

ERROR
Invalid user name.

ERROR
Server is down for maintenance.

ERROR
Invalid date range.

Account Balance Query

The purpose of this query is to simply return the staff account balance of the staff member submitting the request. It only uses the $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders.

Example result:

EMPLID	ACCT_NAME	BALANCE
12345678	Doe, John & Jane	1225.30

Result in it's raw form just in case you are not familiar with the CSV format:

EMPLID,ACCT_NAME,BALANCE
12345678,"Doe, John & Jane",1225.30

Field Descriptions:

FieldName	Description
EMPLID	Comma separated list of designation ids (A18) associated with this user/profile.
ACCT_NAME	List of designation account names (A50) associated with this user. Each name is delimited by carriage returns and line feeds (vbCrLf or #13#10), and correlates to designation ids found in EMPLID.
BALANCE	(Text) Custom text that describes the user's account balance.

Donations Query

Here's an example result:

"PEOPLE_ID","ACCT_NAME","ADDR1","ADDR2","ADDR3","ADDR4","CITY","STATE","ZIP",...

"PEOPLE_ID","ACCT_NAME","DISPLAY_DATE","AMOUNT","DONATION_ID","DESIGNATION","MOTIVATION"
"921875429","Smith, Dave J & Julie J","630 Pine St",,,,"Hickleman","SD","18372-2637",...","08/23/2002","60","J5INQ","0455770","Z01000"
"332812300","Pine Hills Christian Church","1212 Elm Cir",,,,"Orlando","FL","32828-1868",...","08/22/2002","50","J5E2S","0455770","Z01000"
"220389751","Fryerson, Sue","900 S Sarmon Dr",,,,"Mitchell","SD","57302-9244", ...","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.

Addresses Query

The purpose of this query is to return detailed name, address and phone data for the staff member's donors. In addition to the usual $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders, it also uses $DATEFROM$. Keep in mind that this parameter comes in the (M/D/YYYY) format. The $DATEFROM$ placeholder limits the address list to only those that have changed since the given date. If the given date is blank, the user is requesting ALL addresses.

Note: You may simply ignore the $DATEFROM$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

Here's an example result:

"PEOPLE_ID","ACCT_NAME","DISPLAY_DATE","AMOUNT","DONATION_ID","DESIGNATION","MOTIVATION"

"PEOPLE_ID","ACCT_NAME","ADDR1","ADDR2","ADDR3","ADDR4","CITY","STATE","ZIP",...
"921875429","Smith, Dave J & Julie J","08/23/2002","60","J5INQ","0455770","Z01000"","630 Pine St",,,,"Hickleman","SD","18372-2637",...
"332812300","Pine Hills Christian Church","08/22/2002","50","J5E2S","0455770","Z01000"","1212 Elm Cir",,,,"Orlando","FL","32828-1868",...
"220389751","Fryerson, Sue","08/22/2002","40","J5EGE","0455770","Z01000"","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".

Addresses By IDs Query

This Query only differs from the Addresses Query in that it uses the $PERSONIDS$ parameter instead of the $DATEFROM$ parameter. The $PERSONID$ parameter is substituted by a comma separated list of donor IDs. These donor IDs are obtained from donations in the Donations Query. TntMPD will never submit a request with more than 200 donor IDs.

Note: You may simply ignore the $PERSONIDS$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

Profiles Query (Optional)   <new for TntMPD 2.0>

The purpose of this query is to return a list of different profiles associated with the user. This allows a user to have different "modes" for downloading information, without having to setup different username/passwords for each mode. This works especially well in a Single Sign On (SSO) environment.

Example result:

PROFILE_CODE PROFILE_DESC

Staff Account (Default)

MIN1 Operating Account #1

MIN2 Operating Account #2

Field Descriptions:

FieldName Description

PROFILE_CODE (A18) A code to identify this profile. A blank profile code would be the default profile associated with the account. Note: The Field Name "ROLE_CODE" was supported at one time, but is now deprecated for new work.

PROFILE_DESCRIPTION (A50) A description of the profile. This is what the user sees. Note: The Field Name "ROLE_DESCRIPTION" was supported at one time, but is now deprecated for new work.

SingleSignOn Query (Optional)   <future: TntMPD 2.1>

The purpose of this query is to return a one-time-use authentication ticket that can be used in one (and only one) query. It receives $ACCOUNT$ and $PASSWORD$. It should return one row.

Example result:

SSO_TICKET

ST-gjdhgvyudmfnbgbyf

Field Descriptions:

FieldName Description

SSO_TICKET (Text) An authentication "service" ticket than can be passed into another query for one-time use.

Testing your compatibility with TntMPD

To test your online donation system's compatibility with TntMPD, pull up the "Gift Input from Web" screen. Where it has you choose your Organization, choose "Custom". (Note: You must hold down the Shift key when you drop down the list.) Then you can simply type in the URL of your Query INI File. That is all there is to it!

Making it easy for your staff to connect...

If you want to include your organization in the drop down list where you choose the Organization, just send me an email. (wolbrink@ccci.org) Be sure to include your organization's name, and the URL of your Query INI File. I can update the list on my website, and your organization will automatically appear in the list.

Then when your staff member tries to do "Gift Input from Web" for the first time, they can just select your organization's name in the list. It couldn't be much easier!

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.

How can I make my organization's online donation system compatible with TntMPD?

Troy Wolbrink — Mon, 29 Sep 2008 18:53:24 GMT
Revision 4 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 2:53:24 PM

How can I make my organization's online donation system compatible with TntMPD?

This document describes how you can make your organization's online donation system compatible with TntMPD. The technical details are spelled out so that you can provide your own custom solution. It requires a knowledge of computer programming. Keep in mind that the preferred and recommended way to provide a TntMPD-compatible download for your staff is to use TntMPD.DataServer. TntMPD.DataServer already includes pre-built integration templates for DonorWise, Raiser's Edge and OPTIGEM. Tools and documentation are provided to allow you to integrate TntMPD.DataServer with your own donation system.

Once you are TntMPD-compatible, your staff will be able to use TntMPD to connect to your system using the Web to:

Download contribution details

Download names and addresses of donors

Be notified of their staff account balance

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

What it takes...

Query INI file

Account Balance Query

Donations Query

Addresses Query

Addresses By IDs Query

Profiles Query (Optional) <new for TntMPD 2.0>

SingleSignOn Query (Optional) <future: TntMPD 2.1>

Query INI File

You need to provide a Query INI File. This file will provide the web address and parameter template needed to download the results of the query. Below is an example. Notice it is based on a standard Windows INI file format.

[APPLICATION]
MinimumVersion=1.5.0
RecommendedVersion=1.5.0

[ORGANIZATION]
RedirectQueryIni=
Name=Your Organization Name
Abbreviation=MyOrg
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
MinimumWebGiftDate=1/1/1990
Code=MyOrg-USA
QueryAuthentication=0
MinPidLength=0
OrgHelpUrl=https://www.myorg.org/help.htm
OrgHelpUrlDescription=Click here to report this issue over the Web!
OrgHelpOther=You may also reach the CCC Call Center at 407-826-2948.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
StaffPortalUrl=http://myorg.org/staffportal.html
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

[ACCOUNT_BALANCE.2]
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS.2]
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1]
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

Now let me explain the meaning of each value...

[APPLICATION]
// You can require a minimum version of TntMPD for Web Input features.
MinimumVersion=1.5.0
// You can recommend a minimum version of TntMPD for Web Input features if you wish.
RecommendedVersion=1.5.0

[ORGANIZATION]
// If you move your Query INI File, you can permanently redirect users to the new query.ini url.
RedirectQueryIni=
// Specify the name of your organization here.
Name=Your Organization Name
// Specify a short abbreviation of your organization here.
Abbreviation=MyOrg
// Really old versions of TntMPD may use this. This has been deprecated. Use "WebLogo-JPEG-470x120" on new work.
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
// URL of where your logo can be downloaded (JPEG only).
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
// URL of a mini portal into your website
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
// URL to help your staff get setup with an account.
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
// URL of your banner ad.
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
// Boundary of how back your online donation system provides data for. (M/D/YYYY)
MinimumWebGiftDate=1/1/1990
// Unique code to represent your ministry internally to TntMPD. (User never sees this.)
Code=MyOrg-USA
// Set this to "1" if you want the queries to use basic HTTP authentication
QueryAuthentication=0
// TntMPD internally removes leading zeros from numeric donor account ids. Specify the minimum number of digits a
// donor id should be, and TntMPD will add leading zeros when returning them back in the "Addresses By IDs Query" query.
MinPidLength=0
// <new for TntMPD 2.0> Specify a url where users can report errors with your download process.
OrgHelpUrl=https://www.myorg.org/help.htm
// <new for TntMPD 2.0> Specify the text users will see for OrgHelpUrl.
OrgHelpUrlDescription=Click here to report this issue over the Web!
// <new for TntMPD 2.0> Specify alternative text for how users can get help with downloading information.
OrgHelpOther=You may also reach the us at 123-456-7890.
// <new for TntMPD 2.0> Specify the url where users can request new download profiles.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
// <new for TntMPD 2.0.44> Specify the url where users can view a staff portal.
StaffPortalUrl=http://myorg.org/staffportal.html
// <future: TntMPD 2.1> Specify the base currency code (ISO 4217 3-char) for gifts returning from your Donations Query.
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/    // URL of your online donation system.
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$    // Your POST template. (described later)

[ACCOUNT_BALANCE.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]    // URL and POST have same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&PID=$PERSONIDS$

[ADDRESSES_BY_PERSONIDS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2] <new for TntMPD 2.0>
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1] <future: TntMPD 2.1>
// Note: If this query were actually used, credentials would not be
//   passed in to the other queries. But $SSO_TICKET$ would be used instead.
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

The benefit of keeping the instructions in this file is that if you later change the URL or POST template of your query, you can just edit the Query INI File and make a seamless transition. The staff using the program will never know it changed.

TntMPD-version specific sections <new for TntMPD 2.0>

TntMPD 2.0 and newer will support version specific sections. For example a client running TntMPD 2.2 will search for the "DONATION" section by using the first out of this list that it finds first:

[DONATIONS.2.2]

[DONATIONS.2.1]

[DONATIONS.2.0]

[DONATIONS.2]

[DONATIONS]

The Queries

--Placeholders--
Each query has a URL and a POST. The URL specifies your online donation server object (CGI object, for example). The POST specifies the data to send with the HTTP POST transaction. The POST is in a template form. These placeholders are key words that will be substituted by the appropriate string based on the user's input in TntMPD:

$ACCOUNT$ The user name of the staff logging in to the donation system.

$PASSWORD$ The password of the staff logging in to the donation system.

$SSO_TICKET$ <future: TntMPD 2.1> The service ticket returned by the SingleSignOn Query.
Generally you would use this in lieu of $ACCOUNT$ and $PASSWORD$. Note: The
SingleSignOn query never receives the $SSO_TICKET$ placeholder, but only
accepts $ACCOUNT$ and $PASSWORD$.

$PROFILE$ <new for TntMPD 2.0> The profile code of the staff logging in to the donation system.
If the Profiles query is not supported, this will always be blank. Note: The $PROFILE$
placeholder is never provided in the Profiles Query itself.

$DATEFROM$ The specified beginning date. (M/D/YYYY) (I'll explain later where and how this is used.)

$DATETO$ The specified ending date. (M/D/YYYY) (I'll explain later where and how this is used.)

$PERSONIDS$ A comma separated list of donor IDs. (I'll explain later where and how this is used.)

So for example, if I defined my Post value by:

Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

And if my user name was "JohnDoe", and my password was "abc123" then the following data would be send with the HTTP POST transaction:

Action=TntBalance&Username=JohnDoe&Password=abc123

--Standard Response--
Each query should return its results as CSV text. I will describe the
field names expected for each query.

--Error Response--
Each query should handle invalid conditions (such as an invalid username) by
returning two lines of text. The first line of text should be "ERROR".
The second line of text is the error description. Here are a couple of
examples to give you the general idea.

ERROR
Invalid password.

ERROR
Invalid user name.

ERROR
Server is down for maintenance.

ERROR
Invalid date range.

Account Balance Query

The purpose of this query is to simply return the staff account balance of the staff member submitting the request. It only uses the $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders.

Example result:

EMPLID ACCT_NAME BALANCE

12345678 Doe, John & Jane 1225.30

Result in it's raw form just in case you are not familiar with the CSV format:

EMPLID,ACCT_NAME,BALANCE
12345678,"Doe, John & Jane",1225.30

Field Descriptions:

FieldName Description

EMPLID Comma separated list of designation ids (A18) associated with this user/profile.

ACCT_NAME List of designation account names (A50) associated with this user. Each name is delimited by carriage returns and line feeds (vbCrLf or #13#10), and correlates to designation ids found in EMPLID.

BALANCE (Text) Custom text that describes the user's account balance.

Donations Query

The purpose of this query is to return all donation detail data for the staff member within a certain date range. In addition to the usual $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders, it also uses $DATEFROM$ and $DATETO$. Keep in mind that these placeholders come in the (M/D/YYYY) format. The $DATEFROM$ and $DATETO$ placeholders describe the beginning and ending dates of the query. You should include donation data for all dates between and including these dates. The beginning date will be limited by the "MinimumWebGiftDate" value in the Query INI file.

Click here To see

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

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.

Addresses Query

The purpose of this query is to return detailed name, address and phone data for the staff member's donors. In addition to the usual $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders, it also uses $DATEFROM$. Keep in mind that this parameter comes in the (M/D/YYYY) format. The $DATEFROM$ placeholder limits the address list to only those that have changed since the given date. If the given date is blank, the user is requesting ALL addresses.

Note: You may simply ignore the $DATEFROM$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

Click here To see

Here's an example result.:

"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

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

Addresses By IDs Query

This Query only differs from the Addresses Query in that it uses the $PERSONIDS$ parameter instead of the $DATEFROM$ parameter. The $PERSONID$ parameter is substituted by a comma separated list of donor IDs. These donor IDs are obtained from donations in the Donations Query. TntMPD will never submit a request with more than 200 donor IDs.

Note: You may simply ignore the $PERSONIDS$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

Profiles Query (Optional)   <new for TntMPD 2.0>

The purpose of this query is to return a list of different profiles associated with the user. This allows a user to have different "modes" for downloading information, without having to setup different username/passwords for each mode. This works especially well in a Single Sign On (SSO) environment.

Example result:

PROFILE_CODE PROFILE_DESC

Staff Account (Default)

MIN1 Operating Account #1

MIN2 Operating Account #2

Field Descriptions:

FieldName Description

PROFILE_CODE (A18) A code to identify this profile. A blank profile code would be the default profile associated with the account. Note: The Field Name "ROLE_CODE" was supported at one time, but is now deprecated for new work.

PROFILE_DESCRIPTION (A50) A description of the profile. This is what the user sees. Note: The Field Name "ROLE_DESCRIPTION" was supported at one time, but is now deprecated for new work.

SingleSignOn Query (Optional)   <future: TntMPD 2.1>

The purpose of this query is to return a one-time-use authentication ticket that can be used in one (and only one) query. It receives $ACCOUNT$ and $PASSWORD$. It should return one row.

Example result:

SSO_TICKET

ST-gjdhgvyudmfnbgbyf

Field Descriptions:

FieldName Description

SSO_TICKET (Text) An authentication "service" ticket than can be passed into another query for one-time use.

Testing your compatibility with TntMPD

To test your online donation system's compatibility with TntMPD, pull up the "Gift Input from Web" screen. Where it has you choose your Organization, choose "Custom". (Note: You must hold down the Shift key when you drop down the list.) Then you can simply type in the URL of your Query INI File. That is all there is to it!

Making it easy for your staff to connect...

If you want to include your organization in the drop down list where you choose the Organization, just send me an email. (wolbrink@ccci.org) Be sure to include your organization's name, and the URL of your Query INI File. I can update the list on my website, and your organization will automatically appear in the list.

Then when your staff member tries to do "Gift Input from Web" for the first time, they can just select your organization's name in the list. It couldn't be much easier!

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.

How can I make my organization's online donation system compatible with TntMPD?

Troy Wolbrink — Mon, 29 Sep 2008 18:47:07 GMT
Revision 3 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 2:47:07 PM

How can I make my organization's online donation system compatible with TntMPD?

This document describes how you can make your organization's online donation system compatible with TntMPD. The technical details are spelled out so that you can provide your own custom solution. It requires a knowledge of computer programming. Keep in mind that the preferred and recommended way to provide a TntMPD-compatible download for your staff is to use TntMPD.DataServer. TntMPD.DataServer already includes pre-built integration templates for DonorWise, Raiser's Edge and OPTIGEM. Tools and documentation are provided to allow you to integrate TntMPD.DataServer with your own donation system.

Once you are TntMPD-compatible, your staff will be able to use TntMPD to connect to your system using the Web to:

Download contribution details

Download names and addresses of donors

Be notified of their staff account balance

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

What it takes...

Query INI file

Account Balance Query

Donations Query

Addresses Query

Addresses By IDs Query

Profiles Query (Optional) <new for TntMPD 2.0>

SingleSignOn Query (Optional) <future: TntMPD 2.1>

Query INI File

You need to provide a Query INI File. This file will provide the web address and parameter template needed to download the results of the query. Below is an example. Notice it is based on a standard Windows INI file format.

[APPLICATION]
MinimumVersion=1.5.0
RecommendedVersion=1.5.0

[ORGANIZATION]
RedirectQueryIni=
Name=Your Organization Name
Abbreviation=MyOrg
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
MinimumWebGiftDate=1/1/1990
Code=MyOrg-USA
QueryAuthentication=0
MinPidLength=0
OrgHelpUrl=https://www.myorg.org/help.htm
OrgHelpUrlDescription=Click here to report this issue over the Web!
OrgHelpOther=You may also reach the CCC Call Center at 407-826-2948.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
StaffPortalUrl=http://myorg.org/staffportal.html
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

[ACCOUNT_BALANCE.2]
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS.2]
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1]
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

Now let me explain the meaning of each value...

[APPLICATION]
// You can require a minimum version of TntMPD for Web Input features.
MinimumVersion=1.5.0
// You can recommend a minimum version of TntMPD for Web Input features if you wish.
RecommendedVersion=1.5.0

[ORGANIZATION]
// If you move your Query INI File, you can permanently redirect users to the new query.ini url.
RedirectQueryIni=
// Specify the name of your organization here.
Name=Your Organization Name
// Specify a short abbreviation of your organization here.
Abbreviation=MyOrg
// Really old versions of TntMPD may use this. This has been deprecated. Use "WebLogo-JPEG-470x120" on new work.
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
// URL of where your logo can be downloaded (JPEG only).
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
// URL of a mini portal into your website
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
// URL to help your staff get setup with an account.
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
// URL of your banner ad.
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
// Boundary of how back your online donation system provides data for. (M/D/YYYY)
MinimumWebGiftDate=1/1/1990
// Unique code to represent your ministry internally to TntMPD. (User never sees this.)
Code=MyOrg-USA
// Set this to "1" if you want the queries to use basic HTTP authentication
QueryAuthentication=0
// TntMPD internally removes leading zeros from numeric donor account ids. Specify the minimum number of digits a
// donor id should be, and TntMPD will add leading zeros when returning them back in the "Addresses By IDs Query" query.
MinPidLength=0
// <new for TntMPD 2.0> Specify a url where users can report errors with your download process.
OrgHelpUrl=https://www.myorg.org/help.htm
// <new for TntMPD 2.0> Specify the text users will see for OrgHelpUrl.
OrgHelpUrlDescription=Click here to report this issue over the Web!
// <new for TntMPD 2.0> Specify alternative text for how users can get help with downloading information.
OrgHelpOther=You may also reach the us at 123-456-7890.
// <new for TntMPD 2.0> Specify the url where users can request new download profiles.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
// <new for TntMPD 2.0.44> Specify the url where users can view a staff portal.
StaffPortalUrl=http://myorg.org/staffportal.html
// <future: TntMPD 2.1> Specify the base currency code (ISO 4217 3-char) for gifts returning from your Donations Query.
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/    // URL of your online donation system.
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$    // Your POST template. (described later)

[ACCOUNT_BALANCE.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]    // URL and POST have same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&PID=$PERSONIDS$

[ADDRESSES_BY_PERSONIDS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2] <new for TntMPD 2.0>
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1] <future: TntMPD 2.1>
// Note: If this query were actually used, credentials would not be
//   passed in to the other queries. But $SSO_TICKET$ would be used instead.
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

The benefit of keeping the instructions in this file is that if you later change the URL or POST template of your query, you can just edit the Query INI File and make a seamless transition. The staff using the program will never know it changed.

TntMPD-version specific sections <new for TntMPD 2.0>

TntMPD 2.0 and newer will support version specific sections. For example a client running TntMPD 2.2 will search for the "DONATION" section by using the first out of this list that it finds first:

[DONATIONS.2.2]

[DONATIONS.2.1]

[DONATIONS.2.0]

[DONATIONS.2]

[DONATIONS]

The Queries

--Placeholders--
Each query has a URL and a POST. The URL specifies your online donation server object (CGI object, for example). The POST specifies the data to send with the HTTP POST transaction. The POST is in a template form. These placeholders are key words that will be substituted by the appropriate string based on the user's input in TntMPD:

$ACCOUNT$ The user name of the staff logging in to the donation system.

$PASSWORD$ The password of the staff logging in to the donation system.

$SSO_TICKET$ <future: TntMPD 2.1> The service ticket returned by the SingleSignOn Query.
Generally you would use this in lieu of $ACCOUNT$ and $PASSWORD$. Note: The
SingleSignOn query never receives the $SSO_TICKET$ placeholder, but only
accepts $ACCOUNT$ and $PASSWORD$.

$PROFILE$ <new for TntMPD 2.0> The profile code of the staff logging in to the donation system.
If the Profiles query is not supported, this will always be blank. Note: The $PROFILE$
placeholder is never provided in the Profiles Query itself.

$DATEFROM$ The specified beginning date. (M/D/YYYY) (I'll explain later where and how this is used.)

$DATETO$ The specified ending date. (M/D/YYYY) (I'll explain later where and how this is used.)

$PERSONIDS$ A comma separated list of donor IDs. (I'll explain later where and how this is used.)

So for example, if I defined my Post value by:

Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

And if my user name was "JohnDoe", and my password was "abc123" then the following data would be send with the HTTP POST transaction:

Action=TntBalance&Username=JohnDoe&Password=abc123

--Standard Response--
Each query should return its results as CSV text. I will describe the
field names expected for each query.

--Error Response--
Each query should handle invalid conditions (such as an invalid username) by
returning two lines of text. The first line of text should be "ERROR".
The second line of text is the error description. Here are a couple of
examples to give you the general idea.

ERROR
Invalid password.

ERROR
Invalid user name.

ERROR
Server is down for maintenance.

ERROR
Invalid date range.

Account Balance Query

The purpose of this query is to simply return the staff account balance of the staff member submitting the request. It only uses the $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders.

Example result:

EMPLID ACCT_NAME BALANCE

12345678 Doe, John & Jane 1225.30

Result in it's raw form just in case you are not familiar with the CSV format:

EMPLID,ACCT_NAME,BALANCE
12345678,"Doe, John & Jane",1225.30

Field Descriptions:

FieldName Description

EMPLID Comma separated list of designation ids (A18) associated with this user/profile.

ACCT_NAME List of designation account names (A50) associated with this user. Each name is delimited by carriage returns and line feeds (vbCrLf or #13#10), and correlates to designation ids found in EMPLID.

BALANCE (Text) Custom text that describes the user's account balance.

Donations Query

The purpose of this query is to return all donation detail data for the staff member within a certain date range. In addition to the usual $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders, it also uses $DATEFROM$ and $DATETO$. Keep in mind that these placeholders come in the (M/D/YYYY) format. The $DATEFROM$ and $DATETO$ placeholders describe the beginning and ending dates of the query. You should include donation data for all dates between and including these dates. The beginning date will be limited by the "MinimumWebGiftDate" value in the Query INI file.

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.

Addresses Query

The purpose of this query is to return detailed name, address and phone data for the staff member's donors. In addition to the usual $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders, it also uses $DATEFROM$. Keep in mind that this parameter comes in the (M/D/YYYY) format. The $DATEFROM$ placeholder limits the address list to only those that have changed since the given date. If the given date is blank, the user is requesting ALL addresses.

Note: You may simply ignore the $DATEFROM$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

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

Addresses By IDs Query

This Query only differs from the Addresses Query in that it uses the $PERSONIDS$ parameter instead of the $DATEFROM$ parameter. The $PERSONID$ parameter is substituted by a comma separated list of donor IDs. These donor IDs are obtained from donations in the Donations Query. TntMPD will never submit a request with more than 200 donor IDs.

Note: You may simply ignore the $PERSONIDS$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

Profiles Query (Optional)   <new for TntMPD 2.0>

The purpose of this query is to return a list of different profiles associated with the user. This allows a user to have different "modes" for downloading information, without having to setup different username/passwords for each mode. This works especially well in a Single Sign On (SSO) environment.

Example result:

PROFILE_CODE PROFILE_DESC

Staff Account (Default)

MIN1 Operating Account #1

MIN2 Operating Account #2

Field Descriptions:

FieldName Description

PROFILE_CODE (A18) A code to identify this profile. A blank profile code would be the default profile associated with the account. Note: The Field Name "ROLE_CODE" was supported at one time, but is now deprecated for new work.

PROFILE_DESCRIPTION (A50) A description of the profile. This is what the user sees. Note: The Field Name "ROLE_DESCRIPTION" was supported at one time, but is now deprecated for new work.

SingleSignOn Query (Optional)   <future: TntMPD 2.1>

The purpose of this query is to return a one-time-use authentication ticket that can be used in one (and only one) query. It receives $ACCOUNT$ and $PASSWORD$. It should return one row.

Example result:

SSO_TICKET

ST-gjdhgvyudmfnbgbyf

Field Descriptions:

FieldName Description

SSO_TICKET (Text) An authentication "service" ticket than can be passed into another query for one-time use.

Testing your compatibility with TntMPD

To test your online donation system's compatibility with TntMPD, pull up the "Gift Input from Web" screen. Where it has you choose your Organization, choose "Custom". (Note: You must hold down the Shift key when you drop down the list.) Then you can simply type in the URL of your Query INI File. That is all there is to it!

Making it easy for your staff to connect...

If you want to include your organization in the drop down list where you choose the Organization, just send me an email. (wolbrink@ccci.org) Be sure to include your organization's name, and the URL of your Query INI File. I can update the list on my website, and your organization will automatically appear in the list.

Then when your staff member tries to do "Gift Input from Web" for the first time, they can just select your organization's name in the list. It couldn't be much easier!

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.

How can I make my organization's online donation system compatible with TntMPD?

Troy Wolbrink — Mon, 29 Sep 2008 18:38:59 GMT
Revision 2 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 2:38:59 PM

How can I make my organization's online donation system compatible with TntMPD?

This document describes how you can make your organization's online donation system compatible with TntMPD. The technical details are spelled out so that you can provide your own custom solution. It requires a knowledge of computer programming. Keep in mind that the preferred and recommended way to provide a TntMPD-compatible download for your staff is to use TntMPD.DataServer. TntMPD.DataServer already includes pre-built integration templates for DonorWise, Raiser's Edge and OPTIGEM. Tools and documentation are provided to allow you to integrate TntMPD.DataServer with your own donation system.

Once you are TntMPD-compatible, your staff will be able to use TntMPD to connect to your system using the Web to:

Download contribution details

Download names and addresses of donors

Be notified of their staff account balance

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

What it takes...

Query INI file

Account Balance Query

Donations Query

Addresses Query

Addresses By IDs Query

Profiles Query (Optional) <new for TntMPD 2.0>

SingleSignOn Query (Optional) <future: TntMPD 2.1>

Query INI File

You need to provide a Query INI File. This file will provide the web address and parameter template needed to download the results of the query. Below is an example. Notice it is based on a standard Windows INI file format.

[APPLICATION]
MinimumVersion=1.5.0
RecommendedVersion=1.5.0

[ORGANIZATION]
RedirectQueryIni=
Name=Your Organization Name
Abbreviation=MyOrg
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
MinimumWebGiftDate=1/1/1990
Code=MyOrg-USA
QueryAuthentication=0
MinPidLength=0
OrgHelpUrl=https://www.myorg.org/help.htm
OrgHelpUrlDescription=Click here to report this issue over the Web!
OrgHelpOther=You may also reach the CCC Call Center at 407-826-2948.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
StaffPortalUrl=http://myorg.org/staffportal.html
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

[ACCOUNT_BALANCE.2]
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS.2]
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1]
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

Now let me explain the meaning of each value...

[APPLICATION]
// You can require a minimum version of TntMPD for Web Input features.
MinimumVersion=1.5.0
// You can recommend a minimum version of TntMPD for Web Input features if you wish.
RecommendedVersion=1.5.0

[ORGANIZATION]
// If you move your Query INI File, you can permanently redirect users to the new query.ini url.
RedirectQueryIni=
// Specify the name of your organization here.
Name=Your Organization Name
// Specify a short abbreviation of your organization here.
Abbreviation=MyOrg
// Really old versions of TntMPD may use this. This has been deprecated. Use "WebLogo-JPEG-470x120" on new work.
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
// URL of where your logo can be downloaded (JPEG only).
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
// URL of a mini portal into your website
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
// URL to help your staff get setup with an account.
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
// URL of your banner ad.
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
// Boundary of how back your online donation system provides data for. (M/D/YYYY)
MinimumWebGiftDate=1/1/1990
// Unique code to represent your ministry internally to TntMPD. (User never sees this.)
Code=MyOrg-USA
// Set this to "1" if you want the queries to use basic HTTP authentication
QueryAuthentication=0
// TntMPD internally removes leading zeros from numeric donor account ids. Specify the minimum number of digits a
// donor id should be, and TntMPD will add leading zeros when returning them back in the "Addresses By IDs Query" query.
MinPidLength=0
// <new for TntMPD 2.0> Specify a url where users can report errors with your download process.
OrgHelpUrl=https://www.myorg.org/help.htm
// <new for TntMPD 2.0> Specify the text users will see for OrgHelpUrl.
OrgHelpUrlDescription=Click here to report this issue over the Web!
// <new for TntMPD 2.0> Specify alternative text for how users can get help with downloading information.
OrgHelpOther=You may also reach the us at 123-456-7890.
// <new for TntMPD 2.0> Specify the url where users can request new download profiles.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
// <new for TntMPD 2.0.44> Specify the url where users can view a staff portal.
StaffPortalUrl=http://myorg.org/staffportal.html
// <future: TntMPD 2.1> Specify the base currency code (ISO 4217 3-char) for gifts returning from your Donations Query.
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/    // URL of your online donation system.
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$    // Your POST template. (described later)

[ACCOUNT_BALANCE.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]    // URL and POST have same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&PID=$PERSONIDS$

[ADDRESSES_BY_PERSONIDS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2] <new for TntMPD 2.0>
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1] <future: TntMPD 2.1>
// Note: If this query were actually used, credentials would not be
//   passed in to the other queries. But $SSO_TICKET$ would be used instead.
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

The benefit of keeping the instructions in this file is that if you later change the URL or POST template of your query, you can just edit the Query INI File and make a seamless transition. The staff using the program will never know it changed.

TntMPD-version specific sections <new for TntMPD 2.0>

TntMPD 2.0 and newer will support version specific sections. For example a client running TntMPD 2.2 will search for the "DONATION" section by using the first out of this list that it finds first:

[DONATIONS.2.2]

[DONATIONS.2.1]

[DONATIONS.2.0]

[DONATIONS.2]

[DONATIONS]

The Queries

--Placeholders--
Each query has a URL and a POST. The URL specifies your online donation server object (CGI object, for example). The POST specifies the data to send with the HTTP POST transaction. The POST is in a template form. These placeholders are key words that will be substituted by the appropriate string based on the user's input in TntMPD:

$ACCOUNT$ The user name of the staff logging in to the donation system.

$PASSWORD$ The password of the staff logging in to the donation system.

$SSO_TICKET$ <future: TntMPD 2.1> The service ticket returned by the SingleSignOn Query.
Generally you would use this in lieu of $ACCOUNT$ and $PASSWORD$. Note: The
SingleSignOn query never receives the $SSO_TICKET$ placeholder, but only
accepts $ACCOUNT$ and $PASSWORD$.

$PROFILE$ <new for TntMPD 2.0> The profile code of the staff logging in to the donation system.
If the Profiles query is not supported, this will always be blank. Note: The $PROFILE$
placeholder is never provided in the Profiles Query itself.

$DATEFROM$ The specified beginning date. (M/D/YYYY) (I'll explain later where and how this is used.)

$DATETO$ The specified ending date. (M/D/YYYY) (I'll explain later where and how this is used.)

$PERSONIDS$ A comma separated list of donor IDs. (I'll explain later where and how this is used.)

So for example, if I defined my Post value by:

Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

And if my user name was "JohnDoe", and my password was "abc123" then the following data would be send with the HTTP POST transaction:

Action=TntBalance&Username=JohnDoe&Password=abc123

--Standard Response--
Each query should return its results as CSV text. I will describe the
field names expected for each query.

--Error Response--
Each query should handle invalid conditions (such as an invalid username) by
returning two lines of text. The first line of text should be "ERROR".
The second line of text is the error description. Here are a couple of
examples to give you the general idea.

ERROR
Invalid password.

ERROR
Invalid user name.

ERROR
Server is down for maintenance.

ERROR
Invalid date range.

Account Balance Query

The purpose of this query is to simply return the staff account balance of the staff member submitting the request. It only uses the $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders.

Example result:
<colgroup><colwidth="115"style="width:86pt;mso-width-source:userset;mso-width-alt:4205;"></col><colwidth="75"style="width:56pt;mso-width-source:userset;mso-width-alt:2742;"></col><colwidth="167"style="width:125pt;mso-width-source:userset;mso-width-alt:6107;"></col></colgroup>

EMPLID ACCT_NAME BALANCE

12345678 Doe, John & Jane 1225.30

Result in it's raw form just in case you are not familiar with the CSV format:

EMPLID,ACCT_NAME,BALANCE
12345678,"Doe, John & Jane",1225.30

Field Descriptions:
<colgroup><colwidth="115"style="width:86pt;mso-width-source:userset;mso-width-alt:4205;"></col><colwidth="95"style="width:71pt;mso-width-source:userset;mso-width-alt:3474;"></col></colgroup>

FieldName Description

EMPLID Comma separated list of designation ids (A18) associated with this user/profile.

ACCT_NAME List of designation account names (A50) associated with this user. Each name is delimited by carriage returns and line feeds (vbCrLf or #13#10), and correlates to designation ids found in EMPLID.

BALANCE (Text) Custom text that describes the user's account balance.

Donations Query

The purpose of this query is to return all donation detail data for the staff member within a certain date range. In addition to the usual $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders, it also uses $DATEFROM$ and $DATETO$. Keep in mind that these placeholders come in the (M/D/YYYY) format. The $DATEFROM$ and $DATETO$ placeholders describe the beginning and ending dates of the query. You should include donation data for all dates between and including these dates. The beginning date will be limited by the "MinimumWebGiftDate" value in the Query INI file.


Click here To see an example result.

Field Descriptions:
<colgroup><colwidth="129"style="width:97pt;mso-width-source:userset;mso-width-alt:4717;"></col><colwidth="187"style="width:140pt;mso-width-source:userset;mso-width-alt:6838;"></col></colgroup>

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.



Addresses Query

The purpose of this query is to return detailed name, address and phone data for the staff member's donors. In addition to the usual $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders, it also uses $DATEFROM$. Keep in mind that this parameter comes in the (M/D/YYYY) format. The $DATEFROM$ placeholder limits the address list to only those that have changed since the given date. If the given date is blank, the user is requesting ALL addresses.

Note: You may simply ignore the $DATEFROM$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.


Click here To see an example result.

Field Descriptions:
<colgroup><colwidth="130"style="width:98pt;mso-width-source:userset;mso-width-alt:4754;"></col><colwidth="219"style="width:164pt;mso-width-source:userset;mso-width-alt:8009;"></col></colgroup>

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



Addresses By IDs Query

This Query only differs from the Addresses Query in that it uses the $PERSONIDS$ parameter instead of the $DATEFROM$ parameter. The $PERSONID$ parameter is substituted by a comma separated list of donor IDs. These donor IDs are obtained from donations in the Donations Query. TntMPD will never submit a request with more than 200 donor IDs.

Note: You may simply ignore the $PERSONIDS$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

Profiles Query (Optional)   <new for TntMPD 2.0>

The purpose of this query is to return a list of different profiles associated with the user. This allows a user to have different "modes" for downloading information, without having to setup different username/passwords for each mode. This works especially well in a Single Sign On (SSO) environment.

Example result:
<colgroup><colwidth="115"style="width:86pt;mso-width-source:userset;mso-width-alt:4205;"></col><colwidth="95"style="width:71pt;mso-width-source:userset;mso-width-alt:3474;"></col></colgroup>

PROFILE_CODE PROFILE_DESC

Staff Account (Default)

MIN1 Operating Account #1

MIN2 Operating Account #2

Field Descriptions:
<colgroup><colwidth="115"style="width:86pt;mso-width-source:userset;mso-width-alt:4205;"></col><colwidth="95"style="width:71pt;mso-width-source:userset;mso-width-alt:3474;"></col></colgroup>

FieldName Description

PROFILE_CODE (A18) A code to identify this profile. A blank profile code would be the default profile associated with the account. Note: The Field Name "ROLE_CODE" was supported at one time, but is now deprecated for new work.

PROFILE_DESCRIPTION (A50) A description of the profile. This is what the user sees. Note: The Field Name "ROLE_DESCRIPTION" was supported at one time, but is now deprecated for new work.

SingleSignOn Query (Optional)   <future: TntMPD 2.1>

The purpose of this query is to return a one-time-use authentication ticket that can be used in one (and only one) query. It receives $ACCOUNT$ and $PASSWORD$. It should return one row.

Example result:
<colgroup><colwidth="115"style="width:86pt;mso-width-source:userset;mso-width-alt:4205;"></col></colgroup>

SSO_TICKET

ST-gjdhgvyudmfnbgbyf

Field Descriptions:
<colgroup><colwidth="115"style="width:86pt;mso-width-source:userset;mso-width-alt:4205;"></col><colwidth="95"style="width:71pt;mso-width-source:userset;mso-width-alt:3474;"></col></colgroup>

FieldName Description

SSO_TICKET (Text) An authentication "service" ticket than can be passed into another query for one-time use.

Testing your compatibility with TntMPD

To test your online donation system's compatibility with TntMPD, pull up the "Gift Input from Web" screen. Where it has you choose your Organization, choose "Custom". (Note: You must hold down the Shift key when you drop down the list.) Then you can simply type in the URL of your Query INI File. That is all there is to it!

Making it easy for your staff to connect...

If you want to include your organization in the drop down list where you choose the Organization, just send me an email. (wolbrink@ccci.org) Be sure to include your organization's name, and the URL of your Query INI File. I can update the list on my website, and your organization will automatically appear in the list.

Then when your staff member tries to do "Gift Input from Web" for the first time, they can just select your organization's name in the list. It couldn't be much easier!

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.

How can I make my organization's online donation system compatible with TntMPD?

Troy Wolbrink — Mon, 29 Sep 2008 18:02:31 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 2:02:31 PM

Once you are TntMPD-compatible, your staff will be able to use TntMPD to connect to your system using the Web to:

Download contribution details
Download names and addresses of donors
Be notified of their staff account balance

This is an example of the logo you can provide:

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

What it takes...

Query INI file
Account Balance Query
Donations Query
Addresses Query
Addresses By IDs Query
Profiles Query (Optional) <new for TntMPD 2.0>
SingleSignOn Query (Optional) <future: TntMPD 2.1>

Query INI File

[APPLICATION]
MinimumVersion=1.5.0
RecommendedVersion=1.5.0

[ORGANIZATION]
RedirectQueryIni=
Name=Your Organization Name
Abbreviation=MyOrg
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
MinimumWebGiftDate=1/1/1990
Code=MyOrg-USA
QueryAuthentication=0
MinPidLength=0
OrgHelpUrl=https://www.myorg.org/help.htm
OrgHelpUrlDescription=Click here to report this issue over the Web!
OrgHelpOther=You may also reach the CCC Call Center at 407-826-2948.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
StaffPortalUrl=http://myorg.org/staffportal.html
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1]
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

Now let me explain the meaning of each value...

[ORGANIZATION]
// If you move your Query INI File, you can permanently redirect users to the new query.ini url.
RedirectQueryIni=
// Specify the name of your organization here.
Name=Your Organization Name
// Specify a short abbreviation of your organization here.
Abbreviation=MyOrg
// Really old versions of TntMPD may use this. This has been deprecated. Use "WebLogo-JPEG-470x120" on new work.
WebLogo-JPEG-476x100=http://www.myorg.org/WebLogo.jpg
// URL of where your logo can be downloaded (JPEG only).
WebLogo-JPEG-470x120=http://www.myorg.org/WebLogo.jpg
// URL of a mini portal into your website
WebPortalUrl-470x120=http://www.myorg.org/miniportal?Username=$ACCOUNT$&Password=$PASSWORD$
// URL to help your staff get setup with an account.
AccountHelpUrl=http://www.myorg.org/staffaccounthelp.html
// URL of your banner ad.
BannerAdUrl-468x60=http://www.myorg.org/bannerad.html
// Boundary of how back your online donation system provides data for. (M/D/YYYY)
MinimumWebGiftDate=1/1/1990
// Unique code to represent your ministry internally to TntMPD. (User never sees this.)
Code=MyOrg-USA
// Set this to "1" if you want the queries to use basic HTTP authentication
QueryAuthentication=0
// TntMPD internally removes leading zeros from numeric donor account ids. Specify the minimum number of digits a
// donor id should be, and TntMPD will add leading zeros when returning them back in the "Addresses By IDs Query" query.
MinPidLength=0
// <new for TntMPD 2.0> Specify a url where users can report errors with your download process.
OrgHelpUrl=https://www.myorg.org/help.htm
// <new for TntMPD 2.0> Specify the text users will see for OrgHelpUrl.
OrgHelpUrlDescription=Click here to report this issue over the Web!
// <new for TntMPD 2.0> Specify alternative text for how users can get help with downloading information.
OrgHelpOther=You may also reach the us at 123-456-7890.
// <new for TntMPD 2.0> Specify the url where users can request new download profiles.
RequestProfileUrl=https://www.myorg.org/requestprofile.htm
// <new for TntMPD 2.0.44> Specify the url where users can view a staff portal.
StaffPortalUrl=http://myorg.org/staffportal.html
// <future: TntMPD 2.1> Specify the base currency code (ISO 4217 3-char) for gifts returning from your Donations Query.
DefaultCurrencyCode=USD

[ACCOUNT_BALANCE]
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/    // URL of your online donation system.
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$    // Your POST template. (described later)

[ACCOUNT_BALANCE.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$

[DONATIONS]    // URL and POST have same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[DONATIONS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntDonList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$&DateTo=$DATETO$

[ADDRESSES]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&DateFrom=$DATEFROM$

[ADDRESSES.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[ADDRESSES_BY_PERSONIDS]    // same comments as for ACCOUNT_BALANCE section
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&PID=$PERSONIDS$

[ADDRESSES_BY_PERSONIDS.2]   <new for TntMPD 2.0> // A version specific section with the new $PROFILE$ placeholder included
Post=Action=TntAddrList&Username=$ACCOUNT$&Password=$PASSWORD$&ProfileCode=$PROFILE$&DateFrom=$DATEFROM$

[PROFILES.2] <new for TntMPD 2.0>
Url=https://www.myorg.org/cgi-bin/StaffAccountApp/
Post=Action=Profiles&Username=$ACCOUNT$&Password=$PASSWORD$

[SingleSignOn.2.1] <future: TntMPD 2.1>
// Note: If this query were actually used, credentials would not be
//   passed in to the other queries. But $SSO_TICKET$ would be used instead.
Url=https://www.myorg.org/cg-bin/sso/
Post=Username=$ACCOUNT$&Password=$PASSWORD$

TntMPD-version specific sections <new for TntMPD 2.0>

TntMPD 2.0 and newer will support version specific sections. For example a client running TntMPD 2.2 will search for the "DONATION" section by using the first out of this list that it finds first:

[DONATIONS.2.2]
[DONATIONS.2.1]
[DONATIONS.2.0]
[DONATIONS.2]
[DONATIONS]

The Queries

$ACCOUNT$	The user name of the staff logging in to the donation system.
$PASSWORD$	The password of the staff logging in to the donation system.
$SSO_TICKET$	<future: TntMPD 2.1> The service ticket returned by the SingleSignOn Query. Generally you would use this in lieu of $ACCOUNT$ and $PASSWORD$. Note: The SingleSignOn query never receives the $SSO_TICKET$ placeholder, but only accepts $ACCOUNT$ and $PASSWORD$.
$PROFILE$	<new for TntMPD 2.0> The profile code of the staff logging in to the donation system. If the Profiles query is not supported, this will always be blank. Note: The $PROFILE$ placeholder is never provided in the Profiles Query itself.
$DATEFROM$	The specified beginning date. (M/D/YYYY) (I'll explain later where and how this is used.)
$DATETO$	The specified ending date. (M/D/YYYY) (I'll explain later where and how this is used.)
$PERSONIDS$	A comma separated list of donor IDs. (I'll explain later where and how this is used.)

So for example, if I defined my Post value by:

Post=Action=TntBalance&Username=$ACCOUNT$&Password=$PASSWORD$

And if my user name was "JohnDoe", and my password was "abc123" then the following data would be send with the HTTP POST transaction:

Action=TntBalance&Username=JohnDoe&Password=abc123

ERROR
Invalid password.

ERROR
Invalid user name.

ERROR
Server is down for maintenance.

ERROR
Invalid date range.

Account Balance Query

The purpose of this query is to simply return the staff account balance of the staff member submitting the request. It only uses the $ACCOUNT$, $PASSWORD$ and $PROFILE$ placeholders.

Example result:

EMPLID	ACCT_NAME	BALANCE
12345678	Doe, John & Jane	1225.30

Result in it's raw form just in case you are not familiar with the CSV format:

EMPLID,ACCT_NAME,BALANCE
12345678,"Doe, John & Jane",1225.30

Field Descriptions:

FieldName	Description
EMPLID	Comma separated list of designation ids (A18) associated with this user/profile.
ACCT_NAME	List of designation account names (A50) associated with this user. Each name is delimited by carriage returns and line feeds (vbCrLf or #13#10), and correlates to designation ids found in EMPLID.
BALANCE	(Text) Custom text that describes the user's account balance.

Donations Query

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.

Addresses Query

Note: You may simply ignore the $DATEFROM$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

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

Addresses By IDs Query

Note: You may simply ignore the $PERSONIDS$ parameter and return all addresses every time if you wish. But keep in mind that this will generally increase the download time for the user.

Profiles Query (Optional) <new for TntMPD 2.0>

Example result:

PROFILE_CODE	PROFILE_DESC
	Staff Account (Default)
MIN1	Operating Account #1
MIN2	Operating Account #2

Field Descriptions:

FieldName	Description
PROFILE_CODE	(A18) A code to identify this profile. A blank profile code would be the default profile associated with the account. Note: The Field Name "ROLE_CODE" was supported at one time, but is now deprecated for new work.
PROFILE_DESCRIPTION	(A50) A description of the profile. This is what the user sees. Note: The Field Name "ROLE_DESCRIPTION" was supported at one time, but is now deprecated for new work.

SingleSignOn Query (Optional) <future: TntMPD 2.1>

The purpose of this query is to return a one-time-use authentication ticket that can be used in one (and only one) query. It receives $ACCOUNT$ and $PASSWORD$. It should return one row.

Example result:

SSO_TICKET

ST-gjdhgvyudmfnbgbyf

Field Descriptions:

FieldName	Description
SSO_TICKET	(Text) An authentication "service" ticket than can be passed into another query for one-time use.

Testing your compatibility with TntMPD

Making it easy for your staff to connect...

Then when your staff member tries to do "Gift Input from Web" for the first time, they can just select your organization's name in the list. It couldn't be much easier!

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.

As a CCCI staff member, why can't I download gifts? The error says something about my GCX login.

Troy Wolbrink — Mon, 15 Feb 2010 21:23:19 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/15/2010 4:23:19 PM

[Note: This information is for connection to the CCCI US system.]

If you receive an error message about the need to use your GCX login when trying to download gift information, it's probably because you're using an older style "PeopleSoft" login from before 2006.

To correct this, you need to enter your GCX login into where it says "Login" and you need to enter the corresponding password as well.

Note: If you're on page 2 where you select the date range, you'll need to click the "<< Prev" button.

Back on page 1, just type in your GCX login and password (where you see your old login and password).

As of Feb 13, 2010, the older PeopleSoft style logins are no longer accepted. You must use a GCX login.

By the way, if you're not even sure what your GCX login is, try to login to the Staff Services website and check your donations via your web browser. If you can't get that to work, you may need to contact ITG at: itghelp@ccci.org

Can TntMPD be used on a Windows 7 platform?

Troy Wolbrink — Thu, 14 Jan 2010 14:46:56 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 1/14/2010 9:46:56 AM

Can TntMPD be used on a Windows 7 platform?

TntMPD runs fine on Windows 7. TntMPD works well on both 32-bit (x86) and 64-bit (x64) versions of Windows.

Can TntMPD be used on a Windows 7 platform?

Troy Wolbrink — Tue, 08 Dec 2009 15:50:38 GMT

Revision 2 posted to Frequently Asked Questions (English) by Troy Wolbrink on 12/8/2009 10:50:38 AM

Can TntMPD be used on a Windows 7 Compatibleplatform?

Can

TntMPD be used runs fine on a Windows 7platform? Want to upgrade, but do not want to lose functionality.Any ideas?

Windows 7 Compatible

Stephen Verner — Mon, 07 Dec 2009 14:34:15 GMT

Revision 1 posted to Frequently Asked Questions (English) by Stephen Verner on 12/7/2009 9:34:15 AM

Can TntMPD be used on a Windows 7 platform? Want to upgrade, but do not want to lose functionality. Any ideas?

How can I start translating a language that doesn't appear in the Online Translation Center?

Troy Wolbrink — Thu, 17 Dec 2009 19:41:59 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 12/17/2009 2:41:59 PM

RomanianHow can I start translating a language that doesn't appear in the Online Translation Center?

Can I

If you want to start translating TntMPD into a language that doesn't yet appear on this website, please contact Troy Wolbrink to translate request that your language be added.

If you don't want to wait, you can begin working right away using the TntTranslator that is installed with TntMPD.

To get started:

1. Under the "Start" menu, under "All Programs", click on "TntMPD", then "TntTranslator".

2. Under the "File" menu (in romanian?TntTranslator), click on "Open" and choose "TntMPD.exe".

3. Under the "File" menu, click on "New" and choose your language.

4. Begin translating. You can test your translation using options under the "Tools" menu.

5. When you're done, under the "File" menu, click on "Export Translation as a CSV file" and save a csv file of your work.

6. Once the language is added to this website, you can import the csv file (step 5) into the online translation center and not lose any of your hard work.

Romanian

Alex — Tue, 15 Dec 2009 21:29:00 GMT

Revision 1 posted to Frequently Asked Questions (English) by Alex on 12/15/2009 4:29:00 PM

Can I start to translate in romanian?

How can I become a translator?

Troy Wolbrink — Mon, 14 Dec 2009 17:44:32 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 12/14/2009 12:44:32 PM

How can I become a translator?

Filed under: Translation

Set your profile language preference

In order to translate a project into your language, your profile must be set to this language. This should have been detected automatically, but to be sure, click on the "Edit" link next to your name so that you can edit your profile.

Your language preference is under "Regional and Language Options". Set this to your language preference. If your language preference is not listed, please contact Troy Wolbrink to request that your language be added.

Go to the online translation center

Click the "Translate" navigation link near the top right.

Note: If your profile language is "English" then you can't go any further. You can see the progress of translations, but you can't translate anything.

Click on the project you want to translate

If you want to translate the online help, click on "TntMPD Online Help".

Translate

Replace all the English text with the translated text. If you see placeholders such as "%s", "%d", "1:s", "{0}" or anything else that looks a little abstract, please treat this as a placeholder. What this means is that you can consider this a word that is filled in later. Keep these placeholders as is. If you don't, the translation screen will inform you, and give you a chance to correct it.

Save your work

When you are done translating, don't just close your browser. Be sure to click "OK" at the bottom of the screen. There area also other ways in which your work gets saved. Everytime you click the "Next>" or "<Previous" link to go to the next or previous page of translatable items, when you click "Apply" or when you click the "TntTranslator" link at the top of the screen all cause your work to be saved.

Not saving your work

To cancel (not save) your work since the last time your work was saved, you can either:

Close your browser window, or
Click the "Cancel" button.

Advanced options

Check the "Advanced" check box near the top left to reveal some additional options.

These options allow you to:

Filter by some custom text that you enter
Sort by the English text
Import a *.Translation.CSV or *.PO translation file.
Download a *.Translation.CSV file.
Work Offline.

Working Offline

When you click "Work Offline" under the "Advanced" area, you can download a file onto your computer, and disconnect from the internet. You need TntMPD 2.0 r73 or newer installed on your computer for this to work. Just double-click on this file to open it in TntTranslator. You can save your changes as you work. When you're all ready to upload your changes to the web, under the "File" menu, click on "Save to Web", or click the "Save to Web" button on the toolbar.

Testing

Learn how you can test your TntMPD translation.

How can I become a translator?

Troy Wolbrink — Thu, 26 Feb 2009 19:21:21 GMT

Revision 5 posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/26/2009 2:21:21 PM

How can I become a translator?

Filed under: Translation

Set your profile language preference

Go to the online translation center

Click the "Translate" navigation link near the top right.

Note: If your profile language is "English" then you can't go any further. You can see the progress of translations, but you can't translate anything.

Click on the project you want to translate

If you want to translate the online help, click on "TntMPD Online Help".

Translate

Save your work

Not saving your work

To cancel (not save) your work since the last time your work was saved, you can either:

Close your browser window, or
Click the "Cancel" button.

Advanced options

Check the "Advanced" check box near the top left to reveal some additional options.

These options allow you tofilter :

Filter by some custom text that you enter, to sort
Sort by the English , or to import/export translations as csv textfiles
Import a *.Translation.CSV or *.PO translation file. There is also
Download a "[Work *.Translation.CSV file.
Work Offline].

Working Offline

When you click "Work Offline" link that allows under the "Advanced" area, you to work with TntTranslator that comes with can download a file onto your computer, and disconnect from the internet. You need TntMPD 2.0 r73 or newer . This allows you installed on your computer for this to workoffline, and from . Just double-click on this file to open it in TntTranslator, you . You can File | Save to Web save your changes as you work. When you're all ready to upload your workchanges to the web, under the "File" menu, click on "Save to Web", or click the "Save to Web" button on the toolbar.

How can I become a translator?

Troy Wolbrink — Thu, 26 Feb 2009 19:08:42 GMT

Revision 4 posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/26/2009 2:08:42 PM

How can I become a translator?

Filed under: Translation

Set your profile language preference

Go to the online translation center

Click the "Translate" navigation link near the top right.

Note: If your profile language is "English" then you can't go any further. You can see the progress of translations, but you can't translate anything.

Click on the project you want to translate

If you want to translate the online help, click on "TntMPD Online Help".

Translate

Save your work

When you are done translating, don't just close your browser. Be sure to click "OK" "OK" at the bottom of the screen. There area also other ways in which your work gets saved. Everytime you click the "Next>" or "<Previous" link to go to the next or previous page of translatable items, when you click "Apply" "Apply" or when you click the "TntTranslator" link at the top of the screen all cause your work to be saved. The 2 ways you can avoid

Not saving your workis to just close

To cancel (not save) your work since the last time your work was saved, you can either:

Close your browser window, or to click
Click the "Cancel" "Cancel" button.

Advanced options

Check the "Advanced" check box near the top left to reveal some additional options. These options allow you to filter by some custom text that you enter, to sort by English, or to import/export translations as csv text files. There is also a "[Work Offline]" link that allows you to work with TntTranslator that comes with TntMPD 2.0 r73 or newer. This allows you to work offline, and from TntTranslator, you can File | Save to Web to upload your work.

How can I become a translator?

Troy Wolbrink — Wed, 18 Feb 2009 22:00:20 GMT

Revision 3 posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/18/2009 5:00:20 PM

How can I become a translator?

Filed under: Translation

Set your profile language preference

In order to translate a project into your language, your profile must be set to this language...more info coming soon.. This should have been detected automatically, but to be sure, click on the "Edit" link next to your name so that you can edit your profile.

Go to the online translation center

Click the "Translate" navigation link near the top right.

Note: If your profile language is "English" then you can't go any further. You can see the progress of translations, but you can't translate anything.

Click on the project you want to translate

If you want to translate the online help, click on "TntMPD Online Help".

Translate

Save your work

When you are done translating, don't just close your browser. Be sure to click "OK" at the bottom of the screen. There area also other ways in which your work gets saved. Everytime you click the "Next>" or "<Previous" link to go to the next or previous page of translatable items, when you click "Apply" or when you click the "TntTranslator" link at the top of the screen all cause your work to be saved. The 2 ways you can avoid saving your work is to just close your browser window, or to click the "Cancel" button.

Advanced options

How can I become a translator?

Troy Wolbrink — Thu, 12 Feb 2009 18:50:29 GMT

Revision 2 posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/12/2009 1:50:29 PM

How can I translate this software and website into my languagebecome a translator?

Filed under: Translation

...more info coming soon...

How can I translate this software and website into my language?

Troy Wolbrink — Thu, 12 Feb 2009 18:48:01 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/12/2009 1:48:01 PM

...more info coming soon...

How can I test my translation of TntMPD?

Troy Wolbrink — Mon, 14 Dec 2009 17:43:02 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 12/14/2009 12:43:02 PM

If you've been translating TntMPD at the online translation center, and you'd like to test your translation to see how it really looks in TntMPD, here's how:

1. Download your translation to a file on your local hard drive (remember where you downloaded the file):

2. Under the "Start" menu, click on "All Programs", then "TntMPD", then "TntTranslator".

3. Under the "File" menu, click on "Open...", select "TntMPD.exe" and click "Open".

4. Under the "File" menu, click on "New...", select your language and click "OK". (if prompted, agree to overwrite any existing file)

5. Under the "File" menu, click on "Import Translation from CSV file...". Select the file you downloaded in step 1. Then click "Open".

6. Under the "File" menu, click on "Save".

7. Under the "Tools" menu, click on "Launch TntMPD using this translation.

How do I get past "Internal Error: Can not find CountryID -2"

Troy Wolbrink — Thu, 03 Dec 2009 18:36:35 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 12/3/2009 1:36:35 PM

If you open TntMPD and get the error, "Internal Error: Can not find CountryID -2" try this:

1. Under the "Tools" menu, click on "Options".

2. Under the "International" tab, select the Default and Mailing From countries.

3. Click "OK" and close TntMPD.

Next time you open TntMPD it should be back to normal.

How do I create an installation CD for TntMPD to share with others?

Troy Wolbrink — Thu, 03 Dec 2009 18:11:30 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 12/3/2009 1:11:30 PM

How do I create an installation CD for TntMPD to share with others?

Filed under: How TntMPD Works

If you want to make an offline installation folder or CD for TntMPD, you not only need "SetupTntMPD.exe", but you should also include include some additional files. You should include all the *.7zip "*.7zip" files from here:
http://download.tntware.com/tntmpd/redist/

You should also include all the "tntmpd.help.*.7zip" files from here:
http://download.tntware.com/tntmpd/archive/ in the subfolder specific to your version of SetupTntMPD.exe.

These files should be right next to each other (in the same folder). The main program "SetupTntMPD.exe" will use the others as it needs to. If the files are NOT right next to each other, and "SetupTntMPD.exe" needs one of them, it will try to download the needed file over the Internet.

Here's an example screenshot of a complete folder ready to install on any supported version of Windows without requiring any further downloads from the TntMPD website:

How do I create an installation CD for TntMPD to share with others?

Troy Wolbrink — Mon, 29 Sep 2008 17:41:26 GMT

Revision 5 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 1:41:26 PM

How do I create an installation CD for TntMPD to share with others?

Filed under: How TntMPD Works

http://download.tntware.com/tntmpd/redist/

How do I create an installation CD for TntMPD to share with others?

Troy Wolbrink — Mon, 29 Sep 2008 17:41:26 GMT

Revision 4 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 1:41:26 PM

How do I create an installation CD for TntMPD to share with others?

http://download.tntware.com/tntmpd/redist/

How do I create an installation CD for TntMPD to share with others?

Troy Wolbrink — Mon, 29 Sep 2008 17:41:26 GMT

Revision 3 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 1:41:26 PM

How do I create an installation CD for TntMPD to share with others?

http://download.tntware.com/tntmpd/redist/

How do I create an installation CD for TntMPD to share with others?

Troy Wolbrink — Mon, 29 Sep 2008 17:41:26 GMT

Revision 2 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 1:41:26 PM

How do I create an installation CD for TntMPD to share with others?

http://download.tntware.com/tntmpd/redist/

[View:/tntmpd/cfs-file.ashx/__key/CommunityServer.Wikis.Components.Files/en/Setup.ico]

How do I create an installation CD for TntMPD to share with others?

Troy Wolbrink — Mon, 29 Sep 2008 17:39:40 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 1:39:40 PM

http://download.tntware.com/tntmpd/redist/

(Please visit the site to view this media)

How do I recover from a corrupted database file?

Troy Wolbrink — Thu, 03 Dec 2009 17:46:50 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 12/3/2009 12:46:50 PM

How do I recover from a corrupted database file?

Filed under: Troubleshooting

Your database file might be corrupt if you begin to receive an error such as the following:

The Microsoft Jet database engine cannot find the input table or query...
Unrecognized database format...
The Microsoft Jet database engine stopped the process because you and another user ...

What can you do in this situation? You have a few options:

1. You can try to repair your database in TntMPD. Under the "File" menu, click on "Rebuild Database".

2. TntMPD takes auto-backups every time you close the program. Under the "File" menu, click on "Restore" to try to find a good working recent backup. Note: Be sure to check the box for "Include backups of other databases." if you recently moved your database.

3. Perhaps you have a backup of your database file on another computer or external drive.

4. You can try to open the database in Access 2007. Access 2007 has enhanced database repair functionality. If this works, you should click on "Rebuild Database" under the "File" menu in TntMPD to ensure the database structure is correct. If prompted for a database password, it's: tntMPD

5. As a last resort, you can try a paid file recovery service such as: http://www.datarevive.com/

Note: Be sure to check your disk for errors, as it's quite possible that your hard disk is failing: http://www.microsoft.com/windowsxp/using/helpandsupport/learnmore/tips/kbtip.mspx

Note to Parallels users: Sometimes these corruptions occur because Windows is not properly shut down. If you exit Parallels the wrong way, this can be similar to pulling the plug on the computer (which is a bad thing to do). So be sure to either suspend Parallels, or choose "Turn Off Computer" from the Windows Start menu when you're done with TntMPD. It's also important that you keep your database on the local C: drive within Parallels. This way if Parallels suspends, it's preserves the state of the virtual hard drive in a consistent way. If it's important that you keep backups of your database on your Mac partition, then configure your auto-backup location appropriately.

How do I recover from a corrupted database file?

Troy Wolbrink — Fri, 09 Oct 2009 18:04:20 GMT

Revision 7 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/9/2009 2:04:20 PM

How do I recover from a corrupted database file?

Filed under: Troubleshooting

Your database file might be corrupt if you begin to receive an error such as the following:

The Microsoft Jet database engine cannot find the input table or query...
Unrecognized database format...
The Microsoft Jet database engine stopped the process because you and another user ...

What can you do in this situation? You have a few options:

1. You can try to repair your database in TntMPD. Under the "File" menu, click on "Rebuild Database".

3. Perhaps you have a backup of your database file on another computer or external drive.

5. As a last resort, you can try a paid file recovery service such as: http://www.datarevive.com/

Note: Be sure to check your disk for errors, as it's quite possible that your hard disk is failing: http://www.microsoft.com/windowsxp/using/helpandsupport/learnmore/tips/kbtip.mspx

How do I recover from a corrupted database file?

Troy Wolbrink — Fri, 26 Jun 2009 19:42:15 GMT

Revision 6 posted to Frequently Asked Questions (English) by Troy Wolbrink on 6/26/2009 3:42:15 PM

How do I recover from a corrupted database file?

Filed under: Troubleshooting

Your database file might be corrupt if you begin to receive an error such as the following:

The Microsoft Jet database engine cannot find the input table or query...
Unrecognized database format...
The Microsoft Jet database engine stopped the process because you and another user ...

What can you do in this situation? You have a few options:

1. You can try to repair your database in TntMPD. Under the "File" menu, click on "Rebuild Database".

3. Perhaps you have a backup of your database file on another computer or external drive.

5. As a last resort, you can try a paid file recovery service such as: http://www.datarevive.com/

Note: Be sure to check your disk for errors, as it's quite possible that your hard disk is failing: http://www.microsoft.com/windowsxp/using/helpandsupport/learnmore/tips/kbtip.mspx

How do I recover from a corrupted database file?

Troy Wolbrink — Mon, 27 Apr 2009 13:32:52 GMT

Revision 5 posted to Frequently Asked Questions (English) by Troy Wolbrink on 4/27/2009 9:32:52 AM

How do I recover from a corrupted database file?

Filed under: Troubleshooting

Your database file might be corrupt if you begin to receive an error such as the following:

The Microsoft Jet database engine cannot find the input table or query...
Unrecognized database format...
The Microsoft Jet database engine stopped the process because you and another user ...

What can you do in this situation? You have a few options:

1. You can try to repair your database in TntMPD. Under the "File" menu, click on "Rebuild Database".

3. Perhaps you have a backup of your database file on another computer or external drive.

5. As a last resort, you can try a paid file recovery service such as: http://www.datarevive.com/

Note: Be sure to check your disk for errors, as it's quite possible that your hard disk is failing: http://www.microsoft.com/windowsxp/using/helpandsupport/learnmore/tips/kbtip.mspx

How do I recover from a corrupted database file?

Troy Wolbrink — Fri, 03 Apr 2009 19:55:56 GMT

Revision 4 posted to Frequently Asked Questions (English) by Troy Wolbrink on 4/3/2009 3:55:56 PM

How do I recover from a corrupted database file?

Filed under: Troubleshooting

Your database file might be corrupt if you begin to receive an error such as the following:

The Microsoft Jet database engine cannot find the input table or query...
Unrecognized database format...
The Microsoft Jet database engine stopped the process because you and another user ...

What can you do in this situation? You have a few options:

1. You can try to repair your database in TntMPD. Under the "File" menu, click on "Rebuild Database".

3. Perhaps you have a backup of your database file on another computer or external drive.

4. As a last resort, you can try a paid file recovery service such as: http://www.datarevive.com/

Note: Be sure to check your disk for errors, as it's quite possible that your hard disk is failing: http://www.microsoft.com/windowsxp/using/helpandsupport/learnmore/tips/kbtip.mspx

How do I recover from a corrupted database file?

Troy Wolbrink — Fri, 03 Apr 2009 19:55:56 GMT

Revision 3 posted to Frequently Asked Questions (English) by Troy Wolbrink on 4/3/2009 3:55:56 PM

How do I recover from a corrupted database file?

Your database file might be corrupt if you begin to receive an error such as the following:

The Microsoft Jet database engine cannot find the input table or query...
Unrecognized database format...
The Microsoft Jet database engine stopped the process because you and another user ...

What can you do in this situation? You have a few options:

1. You can try to repair your database in TntMPD. Under the "File" "File" menu, click on "Rebuild "Rebuild Database".

2. TntMPD takes auto-backups every time you close the program. Under the "File" "File" menu, click on "Restore" "Restore" to try to find a good working recent backup. Note: Be sure to check the box for "Include backups of other databases." if you recently moved your database.

3. Perhaps you have a backup of your database file on another computer or external drive.

4. As a last resort, you can try a paid file recovery service such as: http://www.datarevive.com/

Note: Be sure to check your disk for errors, as it's quite possible that your hard disk is failing: http://www.microsoft.com/windowsxp/using/helpandsupport/learnmore/tips/kbtip.mspx

How do I recover from a corrupted database file?

Troy Wolbrink — Thu, 30 Oct 2008 22:34:22 GMT

Revision 2 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/30/2008 6:34:22 PM

How do I recover from a corrupted database file?

Your database file might be corrupt if you begin to receive an error such as the following:

The Microsoft Jet database engine cannot find the input table or query...
Unrecognized database format...
The Microsoft Jet database engine stopped the process because you and another user ...

What can you do in this situation? You have a few options:

1. You can try to repair your database in TntMPD. Under the "File" menu, click on "Rebuild Database".

2. TntMPD takes auto-backups every time you close the program. Under the "File" menu, click on "Restore" to try to find a good working recent backup.

3. Perhaps you have a backup of your database file on another computer or external drive.

4. As a last resort, you can try a paid file recovery service such as: http://www.datarevive.com/

Note: Be sure to check your disk for errors, as it's quite possible that your hard disk is failing: http://www.microsoft.com/windowsxp/using/helpandsupport/learnmore/tips/kbtip.mspx

How do I recover from a corrupted database file?

Troy Wolbrink — Fri, 10 Oct 2008 21:00:45 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/10/2008 5:00:45 PM

Your database file might be corrupt if you begin to receive an error such as the following:

The Microsoft Jet database engine cannot find the input table or query...
Unrecognized database format...
The Microsoft Jet database engine stopped the process because you and another user ...

What can you do in this situation? You have a few options:

1. You can try to repair your database in TntMPD. Under the "File" menu, click on "Rebuild Database".

2. TntMPD takes auto-backups every time you close the program. Under the "File" menu, click on "Restore" to try to find a good working recent backup.

3. Perhaps you have a backup of your database file on another computer or external drive.

4. As a last resort, you can try a paid file recovery service such as: http://www.datarevive.com/

How can I lookup all contacts who gave a certain number of gifts within a specific date range?

Troy Wolbrink — Wed, 02 Dec 2009 16:06:06 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 12/2/2009 11:06:06 AM

How can I lookup all contacts who gave a certain number of gifts within a specific date range?

Filed under: Analysis, Lookups

Custom lookups can be used to lookup about almost anything. To lookup all the contacts who gave a certain number of gifts within a specific date range, you can use a custom lookups.

Here's a custom lookup like this (requires TntMPD 2.1 r10 that will return all contacts who have given 5 gifts or newer)more since 1/1/2009.

In TntMPD, under the "Lookup" menu, click on "Custom". Then copy/paste the following lookup:

SELECT Gift.ContactID
FROM Gift
WHERE (((Gift.[GiftDate])>=#1/1/2009#))
GROUP BY Gift.ContactID
HAVING COUNT(*) >= 5
ORDER BY COUNT(*) DESC

This lookup returns all the contacts who gave 5 gifts or more since 1/1/2009.

When you do this lookup, be sure to check the box "Custom Filter returns a list of Contact IDs". If this box is not available, be sure you're running TntMPD 2.1 r10 or newer.

Click "OK", and the lookup will be sorted with the more frequent givers on top.

By way of another example, here's a custom lookup that returns all contacts who gave between 6 and 12 donations between 1/1/2009 and 12/31/2009:

SELECT Gift.ContactID
FROM Gift
WHERE ((Gift.GiftDate BETWEEN #1/1/2009# AND #12/31/2009#))
GROUP BY Gift.ContactID
HAVING COUNT(*) BETWEEN 6 AND 12
ORDER BY COUNT(*) DESC

How can I lookup all contacts who gave a certain number of gifts within a specific date range?

Troy Wolbrink — Wed, 02 Dec 2009 16:02:02 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 12/2/2009 11:02:02 AM

Custom lookups can be used to lookup about almost anything. To lookup all the contacts who gave a certain number of gifts within a specific date range, you can use a custom lookup like this (requires TntMPD 2.1 r10 or newer):

SELECT Gift.ContactID
FROM Gift
WHERE (((Gift.[GiftDate])>=#1/1/2009#))
GROUP BY Gift.ContactID
HAVING COUNT(*) >= 5
ORDER BY COUNT(*) DESC

This lookup returns all the contacts who gave 5 gifts or more since 1/1/2009.

When you do this lookup, be sure to check the box "Custom Filter returns a list of Contact IDs". If this box is not available, be sure you're running TntMPD 2.1 r10 or newer.

By way of another example, here's a custom lookup that returns all contacts who gave between 6 and 12 donations between 1/1/2009 and 12/31/2009:

SELECT Gift.ContactID
FROM Gift
WHERE ((Gift.GiftDate BETWEEN #1/1/2009# AND #12/31/2009#))
GROUP BY Gift.ContactID
HAVING COUNT(*) BETWEEN 6 AND 12
ORDER BY COUNT(*) DESC

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

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

Current revision 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

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

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

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

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

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

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

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

How to contact me

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

Troy Wolbrink — Mon, 29 Sep 2008 18:40:46 GMT

Revision 2 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 2:40:46 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

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

How to contact me

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

Troy Wolbrink — Mon, 29 Sep 2008 18:10:00 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 2:10:00 PM

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]

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

How to contact me

How can I get past the error message, "The server name or address could not be resolved."?

Troy Wolbrink — Fri, 13 Nov 2009 14:51:57 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 11/13/2009 9:51:57 AM

This FAQ article should help you get past the error message, "The server name or address could not be resolved.":

https://www.tntware.com/tntmpd/faqs/en/troubleshooting-internet-connection-issues.aspx

How can I get past the error message, "A connection with the server could not be established."?

Troy Wolbrink — Mon, 09 Nov 2009 15:54:16 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 11/9/2009 10:54:16 AM

This FAQ article should help you get past the error message, "A connection with the server could not be established.":

https://www.tntware.com/tntmpd/faqs/en/troubleshooting-internet-connection-issues.aspx

How can I run TntMPD on my Mac?

Troy Wolbrink — Tue, 03 Nov 2009 20:00:35 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 11/3/2009 3:00:35 PM

How can I run TntMPD on my Mac?

Filed under: Getting Started, Macintosh

A better question might be "How can I run Windows on my Mac?". TntMPD is built for Windows, and it requires Windows 2000 or newer. The thought of developing a Mac-specific version of TntMPD has been considered, and there are some steps being taken internally to move TntMPD towards being more cross-platform friendly. But the current reality is that it will probably be many years until anything is available.

Fortunately there are many good options for running Windows on your Mac now. A few years ago Apple began using the Intel chip for Macs which is the same chip used by Windows computers. This shift by Apple has made it much easier and faster to run Windows on your Mac.

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

These products allow you to simultaneously run Windows side by side with your Mac OS. Because these products don't have to emulate the Intel CPU, they run Windows very fast at nearly full native speed. Parallels and VMware even provide options to make the programs running in Windows to appear as if they are Mac programs, hiding much of the Windows interface.

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.
Work has been done by our staff in Germany to make the Parallels experience even more integrated:
TnT-Word-Mac Plug-in for Parallels (version 0.3)

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

Boot Camp allows you to install Windows on its own partition on your hard drive. Unlike virtualization you can not run Windows side by side with your Mac OS. Instead, you need to restart your computer into Windows mode. Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

On older Macintosh computers, you might be able to install Virtual PC. Although Virtual PC will allow you to run TntMPD, many users have reported this to be a painfully slow experience. This slowness is because older Macintosh computers are not based on the Intel CPU, this it must be emulated.

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (Crossover, WINE)

CrossOver is a commercial variant of WINE. WINE is an open source project with the goal of cloning Windows functionality without requiring Windows. A few have reported being able to successfully install and run TntMPD using these technologies. But most of the feedback I have received has been that running TntMPD on these technologies is problematic. If you are feeling brave and would like to experiment with these products by all means do so. But be aware that TntWare does not officially support TntMPD running on CrossOver or WINE. Various sets of Instructions on how to begin trying this are available:

http://www.codeweavers.com/ [CrossOver]

http://download.tntware.com/ [CrossOver]
http://andrewroth.ca/ [WINE]
http://appdb.winehq.org/ [WINE]

Until CrossOver and WINE are officially supported by TntWare, please share your experiences or seek advice from others on this topic at TntMPD's "Beta Testers" group and not in the main forum.

How can I run TntMPD on my Mac?

Troy Wolbrink — Thu, 26 Feb 2009 21:36:40 GMT

Revision 11 posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/26/2009 4:36:40 PM

How can I run TntMPD on my Mac?

Filed under: Getting Started, Macintosh

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (Crossover, WINE)

http://www.codeweavers.com/ [CrossOver]

http://download.tntware.com/ [CrossOver]
http://andrewroth.ca/ [WINE]
http://appdb.winehq.org/ [WINE]

Until CrossOver and WINE are officially supported by TntWare, please share your experiences or seek advice from others on this topic at TntMPD's "Beta Testers" group and not in the main forum.

How can I run TntMPD on my Mac?

Troy Wolbrink — Thu, 26 Feb 2009 21:36:40 GMT

Revision 10 posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/26/2009 4:36:40 PM

How can I run TntMPD on my Mac?

Filed under: Getting Started

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (Crossover, WINE)

http://www.codeweavers.com/ [CrossOver]

http://download.tntware.com/ [CrossOver]
http://andrewroth.ca/ [WINE]
http://appdb.winehq.org/ [WINE]

Please

Until CrossOver and WINE are officially supported by TntWare, please share your experiences or seek advice from others on this topic at TntMPD's "Beta Testers" group and not in the main forum.

How can I run TntMPD on my Mac?

Troy Wolbrink — Thu, 26 Feb 2009 21:30:07 GMT

Revision 9 posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/26/2009 4:30:07 PM

How can I run TntMPD on my Mac?

Filed under: Getting Started

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (Crossover, WINE)

http://www.codeweavers.com/ [CrossOver]

http://download.tntware.com/ [CrossOver]
http://andrewroth.ca/ [WINE]
http://download.tntware.com

http://appdb.winehq.org/ [CrossOver]WINE]

Please share your experiences or seek advice from others on this topic at TntMPD's "Beta Testers" group.

How can I run TntMPD on my Mac?

Troy Wolbrink — Thu, 26 Feb 2009 18:41:47 GMT

Revision 8 posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/26/2009 1:41:47 PM

How can I run TntMPD on my Mac?

Filed under: Getting Started

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (Crossover, WINE)

http://www.codeweavers.com/ [CrossOver]
http://andrewroth.ca/ [WINE]
http://download.tntware.com/ [CrossOver]

Please share your experiences or seek advice from others on this topic at TntMPD's "Beta Testers" group.

How can I run TntMPD on my Mac?

Troy Wolbrink — Thu, 26 Feb 2009 18:40:45 GMT

Revision 7 posted to Frequently Asked Questions (English) by Troy Wolbrink on 2/26/2009 1:40:45 PM

How can I run TntMPD on my Mac?

Filed under: Getting Started

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (Crossover, WINE)

CrossOver is a commercial variant of WINE. WINE is an open source project with the goal of cloning Windows functionality without requiring Windows. A few have reported being able to successfully install and run TntMPD using these technologies. But most of the feedback I have received has been that running TntMPD on these technologies is problematic. If you are feeling brave and would like to experiment with these products by all means do so. Instructions on how to begin are available here. But be aware that TntWare does not officially support TntMPD running on CrossOver or WINE. Feel free Various sets of Instructions on how to begin trying this are available:

http://www.codeweavers.com/ [CrossOver]
http://andrewroth.ca/ [WINE]
http://download.tntware.com/ [CrossOver]

Please share your experiences or seek advice from others on this topic atthe "Beta TntMPD's "Beta Testers" group at: http://www.tntware.com/tntmpd/groups/beta_testers/default.aspx" group.

How can I run TntMPD on my Mac?

Caron Jensen — Tue, 21 Oct 2008 19:56:06 GMT

Revision 6 posted to Frequently Asked Questions (English) by Caron Jensen on 10/21/2008 3:56:06 PM

How can I run TntMPD on my Mac?

Filed under: Getting Started

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (Crossover, WINE)

CrossOver is a commercial variant of WINE. WINE is an open source project with the goal of cloning Windows functionality without requiring Windows. A few have reported being able to successfully install and run TntMPD using these technologies. But most of the feedback I have received has been that running TntMPD on these technologies is problematic. If you are feeling brave and would like to experiment with these products by all means do so. Instructions on how to begin are available here. But be aware that TntWare does not officially support TntMPD running on CrossOver or WINE. Feel free to share your experiences or seek advice from others on this topic at the "Beta Testers" group at: http://www.tntware.com/tntmpd/groups/beta_testers/default.aspx

How can I run TntMPD on my Mac?

Caron Jensen — Tue, 21 Oct 2008 19:50:00 GMT

Revision 5 posted to Frequently Asked Questions (English) by Caron Jensen on 10/21/2008 3:50:00 PM

How can I run TntMPD on my Mac?

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (CrossOver, Crossover, WINE)

CrossOver is a commercial variant of WINE. WINE is an open source project with the goal of cloning Windows functionality without requiring Windows. A few have reported being able to successfully install and run TntMPD using these technologies. But most of the feedback I have received has been that running TntMPD on these technologies is problematic. If you are feeling brave and would like to experiment with these products by all means do so. But be aware that TntWare does not officially support TntMPD running on CrossOver or WINE. Feel free to share your experiences or seek advice from others on this topic at the "Beta Testers" group at: http://www.tntware.com/tntmpd/groups/beta_testers/default.aspx

How can I run TntMPD on my Mac?

Troy Wolbrink — Tue, 14 Oct 2008 16:14:03 GMT

Revision 4 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/14/2008 12:14:03 PM

How can I run TntMPD on my Mac?

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (CrossOver, WINE)

CrossOver is a commercial variant of WINE. WINE is an open source project with the goal of cloning Windows functionality without requiring Windows. A few have reported being able to successfully install and run TntMPD using these technologies. But most of the feedback I have received has been that running TntMPD on these technologies is problematic. If you are feeling brave and would like to experiment with these products by all means do so. But be aware that TntWare does not officially support TntMPD running on CrossOver or WINE. Feel free to share your experiences or seek advice from others on this topic at the "Beta Testers" group at: http://www.tntware.com/tntmpd/groups/beta_testers/default.aspx

How can I run TntMPD on my Mac?

Troy Wolbrink — Tue, 14 Oct 2008 16:14:03 GMT

Revision 3 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/14/2008 12:14:03 PM

How can I run TntMPD on my Mac?

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (CrossOver, WINE)

CrossOver is a commercial variant of WINE. WINE is an open source project with the goal of cloning Windows functionality without requiring Windows. A few have reported being able to successfully install and run TntMPD using these technologies. But most of the feedback I have received has been that running TntMPD on these technologies is problematic. If you are feeling brave and would like to experiment with these products by all means do so. But be aware that TntWare does not officially support this platformTntMPD running on CrossOver or WINE. Feel free to share your experiences or seek advice from others on this topic at the "tntmpd.beta-testers.discussion" forum Beta Testers" group at: http://webboard.ccci.org:8080/~tnt/ http://www.tntware.com/tntmpd/groups/beta_testers/default.aspx

How can I run TntMPD on my Mac?

Troy Wolbrink — Mon, 29 Sep 2008 15:28:19 GMT

Revision 2 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 11:28:19 AM

How can I run TntMPD on my Mac?

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (CrossOver, WINE)

CrossOver is a commercial variant of WINE. WINE is an open source project with the goal of cloning Windows functionality without requiring Windows. A few have reported being able to successfully install and run TntMPD using these technologies. But most of the feedback I have received has been that running TntMPD on these technologies is problematic. If you are feeling brave and would like to experiment with these products by all means do so. But be aware that TntWare does not officially support this platform. Feel free to share your experiences or seek advice from others on this topic at the "tntmpd.beta-testers.discussion" forum at: http://webboard.ccci.org:8080/~tnt/

How can I run TntMPD on my Mac?

Troy Wolbrink — Mon, 29 Sep 2008 15:28:19 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 11:28:19 AM

The different options can be roughly broken down to 4 categories:

Virtualization (Parallels, VMware, VirtualBox).
Dual boot (Boot Camp).
Emulation (Virtual PC).
Other (CrossOver, WINE).

Virtualization (Parallels, VMware, VirtualBox)

Take note:

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.
Some work is being done (in the "labs") specific to the Parallels product that might help TntMPD better integrate with the Mac environment.

Parallels (Recommended by TntWare!)

VMware

VirtualBox

Dual Boot (Boot Camp)

This option requires a Mac with the Intel chip.
You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Boot Camp

Emulation (Virtual PC)

You still need to purchase and install a full license of Windows.
Windows XP Home or Windows Vista Home are more than sufficient for running TntMPD.

Virtual PC

Other (CrossOver, WINE)

CrossOver is a commercial variant of WINE. WINE is an open source project with the goal of cloning Windows functionality without requiring Windows. A few have reported being able to successfully install and run TntMPD using these technologies. But most of the feedback I have received has been that running TntMPD on these technologies is problematic. If you are feeling brave and would like to experiment with these products by all means do so. But be aware that TntWare does not officially support this platform. Feel free to share your experiences or seek advice from others on this topic at the "tntmpd.beta-testers.discussion" forum at: http://webboard.ccci.org:8080/~tnt/

How can I manage a list of "Email-Only Newsletter" recipients?

BevHoy — Wed, 28 Oct 2009 14:49:51 GMT

Current revision posted to Frequently Asked Questions (English) by BevHoy on 10/28/2009 10:49:51 AM

How can I manage a list of "Email-Only Newsletter" recipients?

Right now, all you get for tracking your newsletter recipients is a simple check box called "Send Newsletter". Currently, there's no built-in way to specify newsletter preferences. This is a commonly requested feature. Here's a way you can manage a list of "Email-Only Newsletter" recipients using TntMPD's current features:

1. Create a Saved Group called "Email-Only Newsletter".

2. For the contacts that prefer to receive your newsletter by email only, check the box under the "Groups" tab (back to the Contacts view) to include them in the that group.

3. Continue to use the "Send Newsletter" check box for those that wish to receive your newsletter (irregardless of HOW they like to receive it).

4. When you are sending out your newsletter by email, perform this lookup:

Lookup | Newsletter Recipients | With Valid Preferred Email
Lookup | By Group.
      > Select the "Email-Only Newsletter" group.
      > Click on "Lookup within the current group".
      > Click "OK".

5. When you are sending out your newsletter by paper, perform this lookup:

Lookup | Newsletter Recipients | With Deliverable Mailing Address
Lookup | By Group
     > Select the "Email-Only Newsletter" group.
     > Click on "Take away from the current group".
     > Click "OK".

----

After step 4 and after step 5 you may want to save the lookup as a favorite, so that you can easily recall it more quickly in the future.

> More info on Lookups in TntMPD.

How can I manage a list of "Email-Only Newsletter" recipients?

Troy Wolbrink — Fri, 10 Oct 2008 20:49:40 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/10/2008 4:49:40 PM

1. Create a Saved Group called "Email-Only Newsletter".

2. For the contacts that prefer to receive your newsletter by email only, check the box under the "Groups" tab (back to the Contacts view) to include them in the that group.

3. Continue to use the "Send Newsletter" check box for those that wish to receive your newsletter (irregardless of HOW they like to receive it).

4. When you are sending out your newsletter by email, perform this lookup:

Lookup | Newsletter Recipients | With Valid Preferred Email
Lookup | By Group.
      > Select the "Email-Only Newsletter" group.
      > Click on "Lookup within the current group".
      > Click "OK".

5. When you are sending out your newsletter by paper, perform this lookup:

Lookup | Newsletter Recipients | With Deliverable Mailing Address
Lookup | By Group
     > Select the "Email-Only Newsletter" group.
     > Click on "Take away from the current group".
     > Click "OK".

----

After step 4 and after step 5 you may want to save the lookup as a favorite, so that you can easily recall it more quickly in the future.

> More info on Lookups in TntMPD.

Can I use a databse file that is stored on the internet?

Alon — Mon, 12 Oct 2009 22:46:56 GMT

Current revision posted to Frequently Asked Questions (English) by Alon on 10/12/2009 6:46:56 PM

I would love to run TntMPD on my laptop and my work computer. I was wondering if I could store the database file on the internet and use it from both locations? I can share a database file stored on my home server but haven't figured out if it's possible over the internet.

How does the sync with Outlook work, and what are currently some of its shortcomings?

Troy Wolbrink — Fri, 09 Oct 2009 19:48:01 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/9/2009 3:48:01 PM

TntMPD can sync 2-way with Outlook. When it does this, it tries to match contacts between TntMPD and Outlook. By default, it will not export new contacts from TntMPD to Outlook. Nor will it, by default, try to import new contacts from Outlook. But it does give you the option to do so. For the contacts that are in common, it tries to find where the change occurred. If it happened on only one side (TntMPD or Outlook) since the last sync, it will automatically be able to determine which way to propogate the change. If a change occured to the same contact on both sides, it will mark this as a "Skip" and you'll have to manually decide what to do (and then right-click and choose an action). At this point, it will give you the option to "Update TntMPD Only" (if you consider Outlook your primary contact manager) or you can "Update Outlook Only" (if you consider TntMPD your primary contact manager).

There are currently some problems with the way TntMPD handles change detection. There are processes in TntMPD that make contacts appear to be changed, when in reality there are no fields that changed that would affect Outlook. The same is true on the Outlook side. I do have plans to address this in a future version, but for now you get alot of "Skips" if you rely solely on automatic change detection. But if you consider TntMPD your authoritative contact manager, then you can click "Update Outlook Only" and not worry about it. Or if you consider Outlook your authoritative contact manager, you can click "Update TntMPD Only" and not wory about it.

How can I reduce the size of a digital pictures using Office 2000?

Troy Wolbrink — Wed, 07 Oct 2009 15:10:01 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/7/2009 11:10:01 AM

How can I reduce the size of a digital pictures using Office 2000?

Filed under: Photos

How to reduce the size of digital pictures using Office 2000.

1. Check to see if "Microsoft Photo Editor" is installed. If it is installed you should find it under the "Microsoft Office Tools" program group.

2. If it is NOT installed, you need to insert the Office 2000 installation CD and add this component. The following pictures show you where it is located in the installation options tree.

3. Launch "Microsoft Photo Editor", and under the "File" menu select "Open...". Select the photo you want to reduce in size.

4. Notice the initial zoom size. The program has automatically visually scaled down the picture on the screen. Take not of this number (for step 5).

5. Under the "Image" menu, click on "Resize...". Type in the percentage you would like to reduce the original image by. You can use the same number as the initial zoom size (from step 4). Click "OK".

6. Notice how small the picture is. This is because the zoom is still set to 25%. Change the zoom to 100% to see what the picture actually looks like.

7. Now you're ready to save the file. It is important that you use a different name, since you don't want to overwrite your original high quality picture with the smaller, lower quality picture. Under the "File" menu, click on "Save As". I would suggest adding "_smaller" to end of the file name. Then click "Save".

8. Finally, notice that next to your original picture, you have the reduced size picture. Notice the size difference. The smaller picture will not only be scaled better for email, but it will be alot smaller in size also (which can be nice for those with slower connections.)

Just in case you're interested, here are links to the original file, and the reduced file used for this tutorial...

100_1050.JPG (933 KB)
100_1050_smaller.JPG (83 KB)

How can I reduce the size of a digital pictures using Office 2000?

Troy Wolbrink — Wed, 07 Oct 2009 15:07:38 GMT

Revision 2 posted to Frequently Asked Questions (English) by Troy Wolbrink on 10/7/2009 11:07:38 AM

How can I reduce the size of a digital pictures using Office 2000?

Filed under: Photos

How to reduce the size of digital pictures using Office 2000.

1. Check to see if "Microsoft Photo Editor" is installed. If it is installed you should find it under the "Microsoft Office Tools" program group.

2. If it is NOT installed, you need to insert the Office 2000 installation CD and add this component. The following pictures show you where it is located in the installation options tree.


You want the option to look like this.

3. Launch "Microsoft Photo Editor", and under the "File" menu select "Open...". Select the photo you want to reduce in size.

4. Notice the initial zoom size. The program has automatically visually scaled down the picture on the screen. Take not of this number (for step 5).

5. Under the "Image" menu, click on "Resize...". Type in the percentage you would like to reduce the original image by. You can use the same number as the initial zoom size (from step 4). Click "OK".

6. Notice how small the picture is. This is because the zoom is still set to 25%. Change the zoom to 100% to see what the picture actually looks like.

Just in case you're interested, here are links to the original file, and the reduced file used for this tutorial...

100_1050.JPG (933 KB)
100_1050_smaller.JPG (83 KB)

How can I reduce the size of a digital pictures using Office 2000?

Troy Wolbrink — Mon, 29 Sep 2008 17:55:31 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 1:55:31 PM

How to reduce the size of digital pictures using Office 2000.

1. Check to see if "Microsoft Photo Editor" is installed. If it is installed you should find it under the "Microsoft Office Tools" program group.

2. If it is NOT installed, you need to insert the Office 2000 installation CD and add this component. The following pictures show you where it is located in the installation options tree.

You want the option to look like this.

3. Launch "Microsoft Photo Editor", and under the "File" menu select "Open...". Select the photo you want to reduce in size.

4. Notice the initial zoom size. The program has automatically visually scaled down the picture on the screen. Take not of this number (for step 5).

5. Under the "Image" menu, click on "Resize...". Type in the percentage you would like to reduce the original image by. You can use the same number as the initial zoom size (from step 4). Click "OK".

6. Notice how small the picture is. This is because the zoom is still set to 25%. Change the zoom to 100% to see what the picture actually looks like.

Just in case you're interested, here are links to the original file, and the reduced file used for this tutorial...

100_1050.JPG (933 KB)
100_1050_smaller.JPG (83 KB)

Who develops TntMPD, and what is the background of this software?

Troy Wolbrink — Wed, 23 Sep 2009 15:44:34 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/23/2009 11:44:34 AM

I, Troy Wolbrink, joined the staff of Campus Crusade for Christ in 1996. Starting with the Jesus Film Master Studio, my assignment was to help develop the software they used to record, edit and mix new language versions of the Jesus Film. As a learning project I was encouraged by my team leader to consider developing an application that can help me stay organized as I work on MPD. I was also interested in doing this as a hobby, since I was unsatisfied with any of the existing software I had already tried. So this learning project became a hobby.

A few years later in 1999, Campus Crusade began making donation data available online. Up to this point, I was manually entering my donation information into TntMPD every month when the paper report came in the mail. It was worth it to do all this typing, because TntMPD would help me track my pledges and stay on top of thanking my partners. But once this donation data was available online, I quickly adapted TntMPD to be able to download this information directly into the program because I wanted to avoid all the typing each month. Once I realized I could get all the benefit of tracking my pledges without all the work, it became clear to me that this program could really help other staff.

For another year I worked on TntMPD so that it would be easy for any staff to install and begin using it. My fear was that if it wasn't user friendly, I'd be bogged down with technical support. My wife, Tammy, was my usability tester. She's not a technical person, so I'd work on different features of the software until she was able to perform certain tasks without my help, such as mail merge, scheduling tasks or checking for new gifts online. Once it passed Tammy's approval, it was ready and made available on our personal website. We told a friend about this software who was working as a MPD coach at Campus Crusade's New Staff Training Conference in January 2001. By the end of that month, about 100 new staff were already using the software!

I was surprised when the number of staff using the software continued to grow by about 100 each month. It's been encouraging to see the number of missionaries, as well as the number of organizations adopt TntMPD. TntMPD is in 8 languages now (as of 2009) and about 6,000 missionaries from 100 organizations use TntMPD! TntMPD gives each missionary about 6 more hours per month. That's about 36,000 additional hours each month for missionaries to be telling others about Jesus Christ!

Besides working on TntMPD, I also work on helping our international staff get up and running with TntMPD. One project I developed and now help maintain is DonorWise, which is a donation processing system for national ministries. Another project is called TntMPD.DataServer which brings a "Staff Services"-like website to national ministries, along with the ability for the national staff to be able to download their local donations into TntMPD. Another project is called TntTranslator which now allows a volunteer to translate TntMPD, the help manual, the technical support website and more ... and this can even be done online!

TntMPD is still maintained by me as its sole software developer, although there is a growing virtual team of others who have really helped to free up my time so that I can focus on what I do best. I serve as a full time staff member with the Global Technology Office of Campus Crusade for Christ. We provide leadership to the ministry in the effective use of technology so that we, as a ministry, have more capacity to build spiritual movements everywhere.

How can I develop add-ons for TntMPD?

Troy Wolbrink — Thu, 06 Aug 2009 04:34:27 GMT

Current revision posted to Frequently Asked Questions (English) by Troy Wolbrink on 8/6/2009 12:34:27 AM

How can I develop add-ons for TntMPD?

Filed under: Developer Guides

Access Database Add-On

Windows Application Add-On

More advanced developers will appreciate the fact that TntMPD provides programmatic ways to create and update linked Access databases via the command line. For help on this feature, run "TntMPD.exe /?" from the command line. The location of TntMPD.exe can be found in the registry at "HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath". Each add-on can create and maintain its own link to the database without requiring the user to manually establish the link.

TntMPD's Database Structure

As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called "Contact". The primary key is "ContactID". The gift table has a field called "ContactID" that links back to the person who gave the gift.

Changing Data in TntMPD?

If your add-on changes data in TntMPD using your linked database tables, be sure to perform the File|Maintenance task when you are done. Open TntMPD. Click on the "File" menu ... select "Maintenance". From the maintenance screen, recalculate mailing, money and history data. These steps are recommended for the program to operate correctly. Also, each table has a "LastEdit" field that needs to be updated for TntSync to work correctly.

Adding your Add-On to the "Tools" menu in TntMPD

Look in the Windows registry (using regedit.exe) at the key: "HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\ExternalTools\"
(or if you're on 64-bit Windows look at: "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntMPD\ExternalTools\")
TntCrypt and TntSync are provided as examples of how you can register your add-on under the "Tools" menu.

Each tool can specify certain values: Category (if you want a sub-menu), Target (what get's executed when you click the menu ... can be anything that runs under the Windows "Start" menu ... "Run"), IconTarget (where you want the menu extracted from for the tool's menu item), and Shortcut (if you want a keyboard hotkey such as "Ctrl+F1" for running your add-on).

In the Target, you can include "currentgroup.csv" somewhere, and it will be replaced with the name of an actual file which represents an export of the current filtered list of contacts in TntMPD's contacts view. This allows your add-on to do something with the current group.

Mail Merge Handler

TntMPD includes built-in support for merging with Microsoft Word 2000 and newer. You can replace this with your own Mail Merge functionality. For some documentation on how to integrate your add-on with TntMPD, look in TntMPD's installation folder under "\Developer Notes\External Handlers.zip".

App Exit Handler

If you want your add-on program to get called when TntMPD exits, look for the example in TntMPD's installation folder under "\Developer Notes\External Handlers.zip"

Examples

There are some add-ons currently available for TntMPD.

How can I develop add-ons for TntMPD?

Troy Wolbrink — Thu, 06 Aug 2009 04:30:47 GMT

Revision 4 posted to Frequently Asked Questions (English) by Troy Wolbrink on 8/6/2009 12:30:47 AM

How can I develop add-ons for TntMPD?

Filed under: Developer Guides

Access Database Add-On

Windows Application Add-On

TntMPD's Database Structure

Changing Data in TntMPD?

Adding your Add-On to the "Tools" menu in TntMPD

Mail Merge Handler

App Exit Handler

If you want your add-on program to get called when TntMPD exits, look for the example in TntMPD's installation folder under "\Developer Notes\External Handlers.zip"

Examples

There are some add-ons currently available for TntMPD.

How can I develop add-ons for TntMPD?

Troy Wolbrink — Thu, 06 Aug 2009 04:27:22 GMT

Revision 3 posted to Frequently Asked Questions (English) by Troy Wolbrink on 8/6/2009 12:27:22 AM

How can I develop add-ons for TntMPD?

Filed under: Developer Guides

TntMPD

Access Database Add-OnDeveloper Page

If TntMPD doesn't do exactly what you want, and you know how to use Access 2000, you can develop custom Access solutions to enhance TntMPD. TntMPD has a special feature called "Link to Access Database". This takes an existing database and adds links to tables within TntMPD. This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules. For a better explanation follow this link: http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx Keep in mind in this illustration that the "Back End" database is the TntMPD file (*.mpd) and the "Front End" database is the Access 2000 database (*.mdb) that you told TntMPD to link.

Windows Application Add-On

More advanced developers will appreciate the fact that TntMPD provides programmatic ways to create and update linked Access databases via the command line. For help on this feature, run "TntMPD.exe /?" from the command line. The location of TntMPD.exe can be found in the registry at "HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath". Thus, each Each add-onshould can create and maintain its own link to the database , and without requiring the user shouldn't have tobe involved. (Note: The MLC add-on was designed before this feature was available and thus requires manually establish the userlink.

TntMPD's involvement in setting up the link.) Database Structure

As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called "Contact". The primary key is "ContactID". The gift table has a field called "ContactID" that links back to the person who gave the gift.

Changing Data in TntMPD?

If your add-on changes data in TntMPD tables in Access 2000 using your linked database tables, be sure to performthis the File|Maintenance task when you are done. Open TntMPD. Click on the "File" menu ... select "Maintenance". From the maintenance screen, recalculate mailing, money and history data. These steps are recommended for the program to operate correctly. Also, each table has a "LastEdit" field that needs to be updated for TntSync to work correctly.

Adding your Add-On to the "Tools" menu in TntMPD

Look in the Windows registry (using regedit.exe) at the key: "HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\ExternalTools\"
(or if you're on 64-bit Windows look at: "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntMPD\ExternalTools\")
TntCrypt and TntSync are provided as examples of how you can register your add-on under the "Tools" menu.

Each tool can specify certain values: Category (if you want a sub-menu), Target (what get's executed when you click the menu ... can be anything that runs under the Windows "Start" menu ... "Run"), IconTarget (where you want the menu extracted from for the tool's menu item), and Shortcut (if you want a keyboard hotkey such as "Ctrl+F1" for running your add-on).

In the Target, you can include "currentgroup.csv" somewhere, and it will be replaced with the name of an actual file which represents an export of the current filtered list of contacts in TntMPD's contacts view. This allows your add-on to do something with the current group.

Mail Merge Handler

TntMPD includes built-in support for merging with Microsoft Word 2000 and newer. You can replace this with your own Mail Merge functionality. For some documentation on how to integrate your add-on with TntMPD, look in TntMPD's installation folder under "\Developer Notes\External Handlers.zip".

App Exit Handler

If you want your add-on program to get called when TntMPD exits, look for the example in TntMPD's installation folder under "\Developer Notes\External Handlers.zip"

Examples

There are some add-ons currently available for TntMPD.

How can I develop add-ons for TntMPD?

Troy Wolbrink — Mon, 29 Sep 2008 18:17:49 GMT
Revision 2 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 2:17:49 PM

How can I develop add-ons for TntMPD?

Filed under: Developer Guides

TntMPD Add-On Developer Page

If TntMPD doesn't do exactly what you want, and you know how to use Access 2000, you can develop custom solutions to enhance TntMPD. TntMPD has a special feature called "Link to Access Database". This takes an existing database and adds links to tables within TntMPD. This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.

For a better explanation follow this link:

http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx

Keep in mind in this illustration that the "Back End" database is the TntMPD file (*.mpd) and the "Front End" database is the Access 2000 database (*.mdb) that you told TntMPD to link.

More advanced developers will appreciate the fact that TntMPD provides programmatic ways to create and update linked Access databases via the command line. For help on this feature, run "TntMPD.exe /?" from the command line. The location of TntMPD.exe can be found in the registry at "HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath". Thus, each add-on should create and maintain its own link to the database, and the user shouldn't have to be involved. (Note: The MLC add-on was designed before this feature was available and thus requires the user's involvement in setting up the link.)

If your add-on changes data in TntMPD tables in Access 2000 using your linked database, be sure to perform this task when you are done. Open TntMPD. Click on the "File" menu ... select "Maintenance". From the maintenance screen, recalculate mailing, money and history data. These steps are recommended for the program to operate correctly. Also, each table has a "LastEdit" field that needs to be updated for TntSync to work correctly.

There are some add-ons currently available for TntMPD.

How can I develop add-ons for TntMPD?

Troy Wolbrink — Mon, 29 Sep 2008 18:17:14 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 2:17:14 PM

TntMPD Add-On Developer Page

For a better explanation follow this link:

http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx

Keep in mind in this illustration that the "Back End" database is the TntMPD file (*.mpd) and the "Front End" database is the Access 2000 database (*.mdb) that you told TntMPD to link.

More advanced developers will appreciate the fact that TntMPD provides programmatic ways to create and update linked Access databases via the command line. For help on this feature, run "TntMPD.exe /?" from the command line. The location of TntMPD.exe can be found in the registry at "HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath". Thus, each add-on should create and maintain its own link to the database, and the user shouldn't have to be involved. (Note: The MLC add-on was designed before this feature was available and thus requires the user's involvement in setting up the link.)

There are some add-ons currently available for TntMPD.

How do I keep two copies of my database in sync using TntSync?

LeoPochari — Fri, 19 Jun 2009 16:49:03 GMT

Current revision posted to Frequently Asked Questions (English) by LeoPochari on 6/19/2009 12:49:03 PM

How do I keep two copies of my database in sync using TntSync?

Filed under: Managing Database Files

A more sophisticated approach to keeping two databases in sync is to use TntSync. This approach works best with a large format drive that you can share between two computers. What I have in mind here are a Zip drive, Jazz drive, LS-120, network shared drive, USB flash drive, or an external hard drive.

Let's say you have a Zip drive that you can share between your two computers. You [[en:how-do-i-transfer-my-database-to-another-computer|transfer a copy of your database]] to your secondary computer such that it is at "C:\My Documents\My Partners.mpd" on both computers. The Zip drive is configured so that it appears on each computer as the "D:" Drive. So you keep your backup copy on your Zip drive as "D:\My Documents\My Partners.mpd". In this scenario, the database on the Zip drive becomes the master copy, and each computer keeps in sync with the Zip drive.

TntSync needs to be configured on each computer the same way, so repeat these instructions for each computer. To launch TntSync, under the "Tools" menu in TntMPD, click on "TntSync". An alternative is to click on the "Start" menu ... "Programs" ... "TntMPD" ... "TntSync". For convenience, I've made a copy of this TntSync shortcut and placed it on my desktop. (This shortcut points to "C:\Program Files\TntMPD\TntSync.exe".)

In TntSync, under the "File" menu, click on "Add", then click on "TntMPD Databases". For "Local TntMPD Database" enter "C:\My Documents\My Partners.mpd". For "Remote TntMPD Database" enter "D:\My Documents\My Partners.mpd". Then click "OK".

Now under the "Action" menu, click on "Synchronize All". (Or you can right-click on the row you just added to the list and click on "Synchronize".) It's a good idea to synchronize right away even though the databases should be identical at this point. This helps to initialize TntSync so that it can better detect future changes in the database. Now as changes are eventually made to the database you will be prompted with screen such as this...

This screen shows that "Fred Flintstone" was changed on the "C:" drive only so the change needs to be copied to the "D:" drive. Also, "Barney Rubble" was added to the "D:" drive so it will be copied to the "C:" drive. The "John Doe" record was changed on both the "C:" and "D:" drive so TntSync will skip this record since it doesn't know what to do with it. At the top left of the screen you can see a summary of all the actions. Notice that "1 Skips" (bad Englishi.e., the number of records to be skipped) is bold. This is to draw you your attention to it. For your database to synchronize you need to have no skips. You can click on "Only Show Conflicts" if you only want to see the "Skip" records.

You can double-click on any record to see the details of what changed. When I double-click on the "Fred Flintstone" record I can see that "Pebbles" was added to the "Children" field.

If this is what I want, I can just leave the default action of "Replace" (remote) as is. However, let's say I wanted to revert the record to the one without "Pebbles", then I could right-click on the "Fred Flintstone" record and choose "Replace" (local).

Since the "John Doe" record was changed in both locations I can double-click on it to see what exactly was change in either location. You can selectively choose which side of each field you want to keep by double-clicking on the "good" value that you want to keep. If I wanted to keep "Jan" from the remote side, but keep everything else from the local side, I could double-click on "Jan".

Before	After

Then I could change the action from "Skip" to "Replace" (remote).

Now I can click "Sync!" to perform the actions. By the way, clicking "Cancel" would have backed you out of the synchronize action completely, while clicking "Skip All" would have skipped the current list of actions. The current list of actions is related to the "Contacts" in TntMPD. Other lists of actions may refer to Tasks, Gifts, Histories, etc.

Because the "John Doe" record had a name/address change, it is recommended that you start TntMPD and under the "File" menu, click on "Maintenance". Click on "Recalculate Address Data". This is important because many additional fields will need "Jan" added to them such as "Full Name" or "Home Address Block".

Now you should run TntSync again, and if you're curious you can see exactly which fields needed to be updated.

The best advice I can give to avoid conflicts ("Skips") is to synchronize often. Try to synchronize before you start making changes, and try to synchronize after making changes. I rarely have skips, and both my wife and I use TntMPD alot. Another helpful thing I use TntSync for is to synchronize files and folders. (In TntSync, under the "File" menu, click on "Add", then "Files and Folders".)

My own story: In my own usage of TntSync, I sync all of my Word documents and Excel spreadsheets for MPD, as well as all my programming files used to actually build TntMPD. I use an external hard drive that I can carry between home and work (much lighter and smaller than a laptop). This allows me to work from home as well as the office, and this allows me to keep all my file changes sorted out. Also, this gives me a daily backup of all my files which has proven helpful on a number of occasions.

How do I keep two copies of my database in sync using TntSync?

Troy Wolbrink — Mon, 29 Sep 2008 16:57:23 GMT

Revision 2 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 12:57:23 PM

How do I keep two copies of my database in sync using TntSync?

Filed under: Managing Database Files

This screen shows that "Fred Flintstone" was changed on the "C:" drive only so the change needs to be copied to the "D:" drive. Also, "Barney Rubble" was added to the "D:" drive so it will be copied to the "C:" drive. The "John Doe" record was changed on both the "C:" and "D:" drive so TntSync will skip this record since it doesn't know what to do with it. At the top left of the screen you can see a summary of all the actions. Notice that "1 Skips" (bad English) is bold. This is to draw you attention to it. For your database to synchronize you need to have no skips. You can click on "Only Show Conflicts" if you only want to see the "Skip" records.

You can double-click on any record to see the details of what changed. When I double-click on the "Fred Flintstone" record I can see that "Pebbles" was added to the "Children" field.

If this is what I want, I can just leave the default action of "Replace" (remote) as is. However, let say I wanted to revert the record to the one without "Pebbles", then I could right-click on the "Fred Flintstone" record and choose "Replace" (local).

Before	After

Then I could change the action from "Skip" to "Replace" (remote).

Now I can click "Sync!" to perform the actions. By the way, clicking "Cancel" would have backed you out of the synchronize action completely, while clicking "Skip All" would have skipped the current list of actions. The current list of actions related to the "Contacts" in TntMPD. Other lists of actions may refer to Tasks, Gifts, Histories, etc.

Now you should run TntSync again, and if you're curious you can see exactly which fields needed to be updated.

How do I keep two copies of my database in sync using TntSync?

Troy Wolbrink — Mon, 29 Sep 2008 16:47:56 GMT

Revision 1 posted to Frequently Asked Questions (English) by Troy Wolbrink on 9/29/2008 12:47:56 PM

This screen shows that "Fred Flintstone" was changed on the "C:" drive only so the change needs to be copied to the "D:" drive. Also, "Barney Rubble" was added to the "D:" drive so it will be copied to the "C:" drive. The "John Doe" record was changed on both the "C:" and "D:" drive so TntSync will skip this record since it doesn't know what to do with it. At the top left of the screen you can see a summary of all the actions. Notice that "1 Skips" (bad English) is bold. This is to draw you attention to it. For your database to synchronize you need to have no skips. You can click on "Only Show Conflicts" if you only want to see the "Skip" records.

You can double-click on any record to see the details of what changed. When I double-click on the "Fred Flintstone" record I can see that "Pebbles" was added to the "Children" field.

Before	After

Then I could change the action from "Skip" to "Replace" (remote).

Now I can click "Sync!" to perform the actions. By the way, clicking "Cancel" would have backed you out of the synchronize action completely, while clicking "Skip All" would have skipped the current list of actions. The current list of actions related to the "Contacts" in TntMPD. Other lists of actions may refer to Tasks, Gifts, Histories, etc.

Now you should run TntSync again, and if you're curious you can see exactly which fields needed to be updated.

What phone number fields sync to a Palm Treo?

MarcVergo — Sat, 13 Jun 2009 01:30:39 GMT

Current revision posted to Frequently Asked Questions (English) by MarcVergo on 6/12/2009 9:30:39 PM

What phone number fields sync to a Palm Treo?

Filed under: Outlook Sync

TNTmpd maps it's contact fields exactly to Outlook. But once in Outlook, only certain phone number fields sync into the Palm Treo.

Palm only supports 7 phone numbers per contact. Here is their mapping to Outlook:

Palm Name<o:p></o:p>	Outlook/TNT Field<o:p></o:p>
work<o:p></o:p>	Business<o:p></o:p>
main<o:p></o:p>	business2<o:p></o:p>
fax<o:p></o:p>	business fax<o:p></o:p>
home<o:p></o:p>	Home<o:p></o:p>
other<o:p></o:p>	home2<o:p></o:p>
mobile<o:p></o:p>	Mobile<o:p></o:p>
pager<o:p></o:p>	Pager<o:p></o:p>

<o:p> </o:p><o:p> </o:p>

So, if you want the phone number in TNTmpd to show up on a Treo (via Outlook), here are the fields in TNT that make it all the way to the phone.

For example, I put the guy’s 's cell phone in “mobile” "mobile" and the woman’s 's in “pager” "pager" and update the labels respectively.

<o:p>

I hope this is helpful,</o:p>

<o:p>

Marc</o:p>