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

How do I get past, "A first, last or organization name must be entered for this contact., , No records were imported"?


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 28 Jan 2009
Last revision by:
Troy Wolbrink
on 27 Sep 2013
2 people found this article useful.

25% of people found this useful
How do I get past, "A first, last or organization name must be entered for this contact., , No records were imported"?

When you import contacts, you can either import a contact

  • with just an Organization Name (no Title, First Name, Middle Name, Last Name or Suffix).
  • with a First Name and/or Last Name (no Organization Name).

Each contact must have either an Organization Name or it must have a First/Last Name.

If you are importing into the "Is Organization" field, then this must correspond appropriately.

If you want to specify where the contact works, use the "Company Name" for this purpose.

Here's a typical import, using First Name and Last Name:

Recent Comments

By: Bob Mac Leod Posted on 25 Aug 2010 7:29 PM

If your import file has an "Organization Name" field, then it must also have an "Is Organization" field with a TRUE/FALSE value for every entry. If it's TRUE, then there must also be a name in the Organization Name cell in that row. If it is FALSE, then there cannot be anything in the Organization Name cell in that row.

By: Troy Wolbrink Posted on 8 Sep 2010 2:27 PM

Actually, you don't need to import into "Is Organization".  TntMPD will determine that if the "Organization Name" is entered and the individual name fields are blank (or vice versa).

By: anu Posted on 29 Dec 2010 11:24 PM

Ok, I have tried all of that. I have filled in my husband/first name field with the single ladies, I have put Ms. in their spouse field just in case. I have tried adding the Is Organization and putting FALSE as the data in that column and still can't get it to work! Help!

Still getting the same error

"A first, last or organization name must be entered...", when importing contacts from a csv file?

By: anu Posted on 31 Dec 2010 8:57 PM

I figured it out!  I started a new database (mine only had a few test people in it) and it worked!!! YEAH!!!

By: jestnut Posted on 26 Mar 2011 11:07 PM

I am still getting this error message when I try to import a csv a file? First Name and Last Name are both inputed? What do I need to import my contacts?

By: Troy Wolbrink Posted on 12 Apr 2011 6:31 PM

Make sure the Organization Name field is left blank.  Unless you set "Is Organization" to TRUE.  In that case, set Organization Name, but leave first/last as blank.

By: m_penny00 Posted on 17 May 2011 2:36 AM

Getting the same "A first, last or organization name must be entered..." error.  I believe that I have the right fields, i.e. First/Given Name and Last/Family name and I do not have an "Organization Name" field, so I am stumped as to what I am doing wrong.  Please help.

By: Troy Wolbrink Posted on 7 Jul 2011 5:38 AM

@m_penny00, perhaps you're import a "True" value into the "IsOrganization" field.  Or perhaps you're importing a row with nothing in first and last name.

By: srouth Posted on 18 Apr 2012 5:55 PM

how do you get the place where you can even import a "true" value into the "IsOrganization" field?  I don't even see the "IsOrganization" field... Seriously confused... help!

By: Troy Wolbrink Posted on 20 Apr 2012 6:30 PM

It has a space.  "Is Organization" is one of the fields you can import into.

By: VaryaPlashko Posted on 29 May 2013 2:17 PM

Is it possible to import a list with Full Name column only, when both names are in the same cell and I match it with "Full Name" option in TNT. I get the same error message that everybody else here mentioned

By: Troy Wolbrink Posted on 29 May 2013 4:47 PM

You can't import into just the Full Name column.  But you could import a contact's full name into the "Last Name" column instead.

By: Jerry Oetersen Posted on 9 Jun 2013 5:32 PM

"It has a space.  "Is Organization" is one of the fields you can import into."

What has a space like that? The csv file? Mine has a column named "Organization." It's filled in where it is an organization and it's blank when it's not an organization. Do I need to change this? If so, what do I change to?

By: Troy Wolbrink Posted on 14 Jun 2013 5:38 PM

Jerry, map "Organization" -> "Organization Name" and you should be all set.  TntMPD will automatically determine which contacts are organizations when you don't have an organization name for individuals, and when you don't have individual fields (first/last/spouse) filled in for organizations.

By: Josh A Posted on 2 Jun 2016 8:48 PM

Please amend the instructions to reflect that the user must drag First/Given Name  and such into the desired field.

© 2018 TntWare | Privacy | Terms of Use