CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Required / optional fields when importing data
Pages: [1]

Author Topic: Required / optional fields when importing data  (Read 1788 times)

tomchance

  • Guest
Required / optional fields when importing data
August 21, 2007, 08:17:17 am
Hello,

When importing data, lots of rows are skipped because they're missing some data. For example (doctored data):

Metro,Stephen Bull,,"Surrey Quays Road, London, SE16 7ND",020 7651 5000,020 7651 5000,email@metroaddress.co.uk,
Metro,Mike Bull,,"Surrey Quays Road, London, SE16 7ND",020 7651 5000,020 7651 5000,,

The second line is skipped because we don't have Mike's email address. How can I make that field optional so all the data still comes in?

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Required / optional fields when importing data
August 21, 2007, 10:03:14 am
For Contact Import, the required fields are EITHER:
* First Name AND Last Name

OR

* Email Address

You second record has a "Name" (Mike Bull) - but apparently doesn't separate First and Last names - which may be why it's being rejected. If you are indeed mapping columns for Email Address, First Name and Last Name - then records which meet either of the requirements above SHOULD work. If not, please recreate on the demo site (http://demo.civicrm.org/drupal/) and file a bug report in the issue tracker.
Protect your investment in CiviCRM by  becoming a Member!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Required / optional fields when importing data

This forum was archived on 2017-11-26.