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) »
  • Import failing due to "Missing Req Fields' though Contact Matching rule set
Pages: [1]

Author Topic: Import failing due to "Missing Req Fields' though Contact Matching rule set  (Read 2144 times)

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Import failing due to "Missing Req Fields' though Contact Matching rule set
March 11, 2008, 11:31:29 am
Hi - could someone point out my error?

I am trying to import data. The Data field I have to match on is the OldMemberID from our old database.
I have set the Contact Matching Rule to match only on this Field.
My test file has two cols, one for OldMemberID and one for the new data
Step 3 of Import has the OldMemberID showing in Import Row 2 and 3 and OldMemberID is set as Matching CiviCRM Field
The other field is a multichoice 'select' field where Email is one of the options, and so i have Email in my other column.

The result I am getting is "Missing required field"

Is there an obvious mistake I am making?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Import failing due to "Missing Req Fields' though Contact Matching rule set
March 11, 2008, 11:56:59 am

you could potentially argue that this is a feature / bug / missing feature :)

I just checked the code:

if we are not updating with internal contact id as one of the fields, then we require either first name and last name and/or email as part of the fields. In your case you are using OldMemberID as a replacement for the contact id (which is valid), but however triggers a bug in the code. I suspect the fix for this is not trivial :(

lobo

A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Import failing due to "Missing Req Fields' though Contact Matching rule set
March 11, 2008, 12:20:15 pm
Well I'll vote for it being a 'missing feature'  ;) rather than a 'feature' - that and/or misleading documentation since http://wiki.civicrm.org/confluence/display/CRMDOC/Import+Match+Rule says
Quote
The rule for matching contacts on import is by default first_name AND last_name AND email. You can change it in Administer CiviCRM >> Contact Matching. See Contact Matching for more information.
I am sure I can just drop this task on to Chris' pile but perhaps if the feature-fix isn't minor then the documentation needs adjusting.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Import failing due to "Missing Req Fields' though Contact Matching rule set
March 11, 2008, 01:00:26 pm

there are two different aspects of the issue:

1. what fields do we check to see if there is a match? A match may or may not exist with any rule

2. what are the minimum fields required to create a contact. The set of rules out here is fixed. for individual we need  first and last name OR email, orgs needs org name, household needs a household name.

So import enforces the second rule in all cases (except when you supply the internal contact id since that guarantees a contact already exists). This is the error that is triggered in your case.

hence i dont think it is a very clear case of a missing feature. Please do adjust the documentation to make it more clear for now

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Import failing due to "Missing Req Fields' though Contact Matching rule set
March 11, 2008, 01:10:59 pm
Done.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Import failing due to "Missing Req Fields' though Contact Matching rule set
March 12, 2008, 01:08:51 pm
Quote
we require either first name and last name and/or email as part of the fields
Maybe I am misreading the syntax. Does the above me I can do it just on email, or only email + first.

http://forum.civicrm.org/index.php/topic,952.0.html seems quite definite
Quote
For Contact Import, the required fields are EITHER:
* First Name AND Last Name

OR

* Email Address

So why if I am just importing a list of emails, that I then want to add to an existing Group am I getting this error report and no joy?

Line Number   Reason   Email - Home
2   Required fields not found for Individual : first_name   a.bain@minorplanet.co.nz
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Import failing due to "Missing Req Fields' though Contact Matching rule set
March 12, 2008, 01:20:42 pm

argh

can u please reproduce on drupal.demo and file an issue. Depending on severity and amount of code involved, we'll fix this in 2.0.x or 2.1

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Import failing due to "Missing Req Fields' though Contact Matching rule set
March 12, 2008, 01:35:47 pm
Same problem on demo (and I note that the instruction to "Join new contacts to existing group(s)" at step 3 is a bit misleading if one is importing existing contacts in order to add them to a group, as is the case for me. Now, do I know how to file an issue?
Does this do it? http://issues.civicrm.org/jira/browse/CRM-2839
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Import failing due to "Missing Req Fields' though Contact Matching rule set

This forum was archived on 2017-11-26.