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

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


Table of Contents

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

About TntWare

Page Details

First published by:
Troy Wolbrink
on 29 Sep 2008
Last revision by:
Troy Wolbrink
on 4 Oct 2017
8 people found this article useful.

80% of people found this useful
How would I send our staff a monthly TntConnect DataSync file?

This document describes how you can take data from your organization's donation system and package it in a way that is compatible with TntConnect.  The file you create is called a TntConnect DataSync file.  It might require technical skills to create this file.  This a file you could securely deliver to your staff.  But we recommended that you NOT send sensitive donor data over email!

Security Warning:  Sending donor and giving information over email is not secure.  You risk exposing your donor's private information and subjecting them to identity theft and loss of privacy.

Usability Warning:  Sending your staff DataSync files is less than ideal.  A much better approach is to use DonorHub Online.  DonorHub is a secure, cloud-based service that allows your staff to simply push a button to download their latest giving information.  TntWare does all the difficult technical part of making this work!  If you'd like to learn more about how DonorHub Online can help you: 
 
Ask us about DonorHub Online


Technical Details

A TntConnect DataSync file has the file name extension *.tntdatasync.  So for example you may send your staff a file called "January2017.tntdatasync".  TntConnect only recognizes this file extension. 

Note that as of TntConnect 3.4, TntConnect only recognizes the .tntdatasync extension.  TntConnect 3.4 and newer no longer recognizes .tnt or .tntmpd.  Also TntConnect 3.4 requires the [ORGANIZATION] section.

The DataSync file is synchronized with the currently opened database.  Because the data is synchronized, you can input the file several times into the same database without duplicating data in the database.

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

  • [ORGANIZATION]
  • [DONORS]
  • [GIFTS]. 

The [ORGANIZATION] section is required.  You must also provide the [GIFTS] section and/or the [DONORS] section.

Here's a sample of a DataSync file:
https://download.tntware.com/tntconnect/sample_data_sync_file/sample.tntdatasync

[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 is required and it 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).

If you are using the sample file for inspiration, you must change the Code from "Sample-Organization-USA" to something else!  This should be a unique code that identifies your organization.  25 characters max.

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

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 Type TntConnect Version Description
PEOPLE_ID A18   Donor Code/ID
ACCT_NAME A50   Donor full name
INFO_URL MEMO 3.0 URL to view/edit donor information.
RELATED_IDS MEMO 3.0 A comma seperated list of related donor codes/ids.
DECEASED BOOL 3.0 Blank implies "FALSE".  Is the donor deceased?
PERSON_TYPE A1   "O" or "P" (Organization or Person)
LAST_NAME_ORG A50   Last Name or Organization Name
ORG_CONTACT_PERSON A50 3.0 [PERSON_TYPE="O"]
Contact person for this organization.
TITLE A25   [PERSON_TYPE="P"]  Title (Mr., Mrs.)
FIRST_NAME A25 [PERSON_TYPE="P"]  First Name
MIDDLE_NAME A25 [PERSON_TYPE="P"]  Middle Name
SUFFIX A25   [PERSON_TYPE="P"]  Suffix (Jr., Sr.)
SP_TITLE A25   [PERSON_TYPE="P"]  for spouse
SP_FIRST_NAME A25   [PERSON_TYPE="P"]  for spouse
SP_MIDDLE_NAME A25   [PERSON_TYPE="P"]  for spouse
SP_LAST_NAME A25   [PERSON_TYPE="P"]  for spouse
SP_SUFFIX A25   [PERSON_TYPE="P"]  for spouse
    Note: If provided, it is concatenated with a space to SP_LAST_NAME.
ADDR1 MEMO   Street Address (Line 1)
ADDR2 MEMO   Street Address (Line 2)
ADDR3 MEMO   Street Address (Line 3)
ADDR4 MEMO   Street Address (Line 4)
CITY A50   City
STATE A50   State
ZIP A25   Postal Code
COUNTRY A3   (A3) ISO 3166 Alpha 3 country code 
<new in TntConnect 2.0>
ISO 3166 Alpha 2 country codes are supported in TntConnect 2.0.
CNTRY_DESCR A50   Name of country.
ADDR_CHANGED DATE   When the address was last changed.
PHONE A50   Phone number.
PHONE_CHANGED DATE   When the phone was last changed.
MOBILE_PHONE A50 3.0 Mobile phone number.
MOBILE_PHONE_CHANGED DATE 3.0 When the mobile phone was last changed.
SP_MOBILE_PHONE A50 3.0 Spouse mobile phone number.
SP_MOBILE_PHONE_CHANGED DATE 3.0 When the spouse mobile phone was last changed.
EMAIL MEMO 3.0 Email address.
EMAIL_CHANGED DATE 3.0 When the email address was last changed.
SP_EMAIL MEMO 3.0 Spouse email address.
SP_EMAIL_CHANGED DATE 3.0 When the spouse email address was last changed.
MEMO MEMO 3.0 A note regarding the donor.


[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 Type TntConnect Version Description
PEOPLE_ID A18   Donor Code/ID
ACCT_NAME A50   Donor full name
DISPLAY_DATE DATE   Date of contribution
AMOUNT FLOAT   Amount of contribution
DONATION_ID A18   Donation Code/ID
DESIGNATION A18   What account this donation is designated for (normally same as employee id)
MOTIVATION A18   If you track this in your donation system you may include this code here. The column header is required, but the values can be blank.
PAYMENT_METHOD A18 3.0 (Optional)  Payment method of this donation.
MEMO MEMO 3.0 (Optional)  Any comments associated with this gift.
TENDERED_AMOUNT FLOAT 3.1 (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 A3 3.1 (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.


Data Types Explained
  • A25, a text column with a maximum of 25 characters

  • MEMO, a text column with no predefined length limits

  • DATE, a date formatted as M/D/YYYY (or  <new in TntConnect 3.1> the YYYY-MM-DD format).

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

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

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


Case Insensitivity

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


Staying Informed of Changes 

Announcements are made to the Beta Testers group when new versions of TntConnect are released to the beta testing phase.  If there are any changes to the DataSync protocol you must know of to remain compatible, these changes will be announced here.  If you'd like to receive an email when an announcement is made, you need to "Subscribe to this group" by clicking the link on the left side.  Here's a screenshot:

Recent Comments

By: Brian Posted on 17 Jan 2018 4:44 PM

Note,

1. The order of the fields in the file is not required to be in the same order of the exampled listed,,,,

[GIFTS]

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

You can use a file with the fields in a different order.  My order is below:

[GIFTS]

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

2. The Donation_ID can be any random number that is not repeated ever in your system.  You can make up this number if you don't have it.  I have an excel formula that makes a unique number based on the month the gift was given.  For example: if the donation was giving in 7/2016, my Donation_ID is 2016070001 and the next donation will be 2016070002.  I'm thinking I won't get more than 10,000 donations in one month.  

© 2018 TntWare | Privacy | Terms of Use