TntMPD ®
Powerful software for ministry partner development...

How do I import contacts from my previous database?

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

Table of Contents

Page Details

First published by:
Troy Wolbrink
on 29 Sep 2008
Last revision by:
Troy Wolbrink
on 29 Sep 2008
This page has not yet been rated

How do I import contacts from my previous database?

Importing Contacts

If you already have an existing database of your ministry partners from another program such as a contact manager, you should strongly consider importing it into TntMPD.  If you have been keeping fairly good records of your ministry partners, you will want to keep the correct spelling of their name, address, phone number, etc.  There is little benefit in throwing all of this hard work away!

If you do not already have an existing database of your ministry partners, and your ministry organization offers an online donation system that is compatible with TntMPD, you can import your contacts from there.

You should hold off on connecting to your ministry's online donation system until after you have imported your previous database.  If you already have connected to your ministry's online donation system, but you haven't yet imported your contacts from your previous database, you may want to consider completely starting over.  To create a new database and completely start over, click on New from the File menu.

TntMPD can import contacts in two ways:

  • From a CSV (comma delimited) text file
  • From Microsoft Outlook 2000/XP

Importing contacts from a CSV text file

Most database programs and contact managers (such as Microsoft Access and Symantec ACT!) can export their data to a CSV (comma delimited) text file.  Even if they can't export to a CSV file, if they export their data at all they can probably export their data to a format that Microsoft Excel can open.  When you export from your previous database, if your program gives you the option to include field names when you export, choose to.  You want the first row of data to include field names just like Figure 1.

<caption valign="bottom">Figure 1.  Sample import database</caption>
 

Once you have your CSV file ready for import, start TntMPD.  On the File menu, point to Import, and then click Import Contacts from Text.  From there you are prompted to choose your file.  After you choose your CSV file, your are prompted to map the fields between your CSV file and TntMPD.  See Figure 2.

<caption valign="bottom">Figure 2.  Import from CSV</caption>

Notice that the contents of the CSV file are visible under where it says Data Being Imported.  Also notice that all of the fields in the CSV file are listed in the From column of the field mapping grid.  To map a field from your CSV file to a field in TntMPD, drag a field from the Target Fields list into the To column of the field mapping grid.

TntMPD offers many fields you can import into.  There are nine name fields (see Figure 3).  Address fields are available for Home, Business, and Other.  There are 19 phone fields.  There are three email fields.  You can also import unlimited notes into the "Notes" field.  There are 4 user fields, a "UserStatus" field and a "Categories" field.

<caption valign="bottom">Figure 3.  Name fields</caption>
Title SpouseTitle
FirstName Spouse
MiddleName SpouseMiddleName
LastName SpouseLastName (if different)
Suffix (i.e. Jr., Sr., II.)  

You can also import MPD related data such as financial pledge information.  Learn detailed information about all of the available import fields

<caption valign="bottom">Figure 4.  Import from CSV - Fields are mapped.</caption>

After you have mapped all the fields you wish to import into TntMPD, click the Import button (see Figure 4).


Importing contacts from Outlook 2000/XP

Importing from Microsoft Outlook is very straightforward.  On the File menu, point to Import, and then click Import Contacts from Outlook.  TntMPD will begin to immediately analyze the Outlook contacts folder.  See Figure 5.

<caption valign="bottom">Figure 5.  Import from Outlook - analyzing the contacts folder</caption>

This process will by default analyze the main contacts folder in Outlook.  If you with to import from another folder, or if you receive an error about "MAPI Enhancements", refer to Advanced Outlook Settings.  After the analysis phase is over, you will be presented with the contacts available for import.  See Figure 6.

<caption valign="bottom">Figure 6.  Import from Outlook.</caption>

All that is needed at this point is to select the contacts you wish to import from the list.  As an added convenience you can click on Choose All (see Figure 7).  If you wish to select the contacts based upon which category in Outlook they have are associated with, click on Categories.

<caption valign="bottom">Figure 7.  Import from Outlook - contacts are checked off and ready for import.</caption>

After you have checked off the contacts you wish to import, click the Next button.  You will be given confirmation on how many contact will be imported from Outlook.  To import, click the Import button.  See Figure 8.

<caption valign="bottom">Figure 8.  Import from Outlook - confirmation</caption>

Recent Comments

By: faith Posted on 18 Jun 2009 1:02 PM

How do you import contacts from TnTMPD  on one computer to another?  

By: Craig M Posted on 14 Sep 2010 2:39 PM

I have a new request: how to import all my donors information, including giving into Donor Manager data intoTNT?  I want to beginning using TNT instead.

By: Troy Wolbrink Posted on 1 Oct 2010 11:49 PM

You might want to check out the Downloads section.  Somebody posted a tool for converting from DM to TntMPD.

By: JRM Posted on 21 Oct 2010 12:10 AM

Is there a master list of database fields to input into available online?  I'd like to figure out what data I can import from my excel database ahead of time.

By: Troy Wolbrink Posted on 27 Oct 2010 8:04 PM
By: gob123 Posted on 20 Jan 2011 11:00 AM
100% of people found this useful

i diidn't know what a csv file was or how to convert my excel spreadsheet into csv. here's a link:

www.completecampaigns.com/.../How_to_convert_an_existing_Excel_file_into_a_csv_format.htm

By: Alan Goddard Posted on 28 Feb 2011 8:28 PM

How do I directly import my information from Access where I have kept my own database? Do I first have to export everything from Access as a csv then import the csv? I assumed the "link to Access" tool is what was used for this, but evidently not.

By: Troy Wolbrink Posted on 4 Mar 2011 11:25 AM

The "Link To Access" tool makes TntMPD tables available (as linked tables) in the Access database of your choice.  Then, it's up to you what you do with that in Access.  If you're good w/ databases, you could probably transfer data from your old database that way.  Otherwise, you'll have to export your contact information from your old Access database to a CSV file, and TntMPD can import contacts from that CSV file.

By: Drew Posted on 19 Apr 2011 2:51 PM

Hi Troy, I am new to Tnt and am having some trouble transferring my names and addresses into Tnt from MS Excel. Could you give some directions as to how to this? Thanks. - Drew

By: Troy Wolbrink Posted on 22 Apr 2011 9:43 AM

Drew, this FAQ article is the best source of information on the topic.  In Excel, be sure to "Save As" to save to a CSV file so that TntMPD can import from it.

By: AlanandJudy Posted on 6 Jul 2011 11:07 PM

How do I import email contacts from a separate email acct?  How do I send 'enewsletters' to groups or all contacts?

By: Troy Wolbrink Posted on 7 Jul 2011 12:36 AM

@AlanandJudy, these are good questions.  Might be a good idea to discuss this on the forums area of this website.

By: cjw2469 Posted on 13 Oct 2011 2:55 PM

can I import directly from Excel to TNT?

By: Troy Wolbrink Posted on 20 Oct 2011 10:37 PM

TntMPD can only import from CSV.   From Excel, you can [File \ Save As] to save your Excel spreadsheet as a CSV file.