CiviCRM Community Forums (archive)

Hi everyone this is a long explanation to hopefully an easy question, but too much info never hurt anyone. I have searched the forums and bug reports to the best of my ability and haven't found any similar issues:

I'm attempting to import activities to civicrm. I have gone through this process in the past with a mock install I was working on(2.1 I believe) and it worked flawlessly(although I used external id's to distinguish unique contacts, this is no longer an option). This time around I continue to get import errors complaining about "missing required fileds". I'm using the latests stable release i could download easily, 2.2.2

The problem is I can't figure out what these "required fields" are. If I knew I would add them to the import, but I can't seem to figure out what I'm missing. In past imports it would notify you of a missing required field(such as subject, which is "no longer necessary" according to this jira page: http://issues.civicrm.org/jira/browse/CRM-3983, although removing it from the process causes civicrm to complain)

One of the differences between now and then is I have set my strict individual merge rules to check for First/Last name, street address and city, each with a weight of 5, and a weight threshold of 15(not very strict I know, but I was assuming this was the problem, so I set it to win most of the time). I have modified these to different fields and values, none of which have changed the error given.

All of the contacts were previously imported and are in civicrm(I double checked). I have included First/last name, street and city in my import field mapping, and it even says match to contact for them. On my first tries I included a bunch of custom data, but I have since widdled down my imports to not include any of it to try and debug this situation. In the import I also set the activity ID(all the same),  a date, and subject(not always unique, does it need to be? seems to me it shouldn't) are also defined, what am I missing that is required?

Please find attached a cleansed portion of a test import that still reports back that required fields are missing. I tested this on the drupal demo site you host and produced the same results. Here are my steps:
I first changed the individual contact merge settings as described above. I then imported the contacts(there are 2 duplicates, (which is fine, it's a case we need to test around here) and then I attempted to import the activities and received the same "missing required fields" error. I have saved my import mappings on the demo site, hopefully they are still there, but the fields in the csv include labels if you get confused.

Any help is greatly appreciated, thanks in advance for your time. I will try to monitor this as much as physically possible and hope to quickly respond.

hi,

This is bug, thanks for catching and giving details

Issue has been filed and fixed. fix will be part of next CiviCRM v2.2 stable release.

For tracking purpose : http://issues.civicrm.org/jira/browse/CRM-4375

thanks
kiran

Moving the activity identification field to anywhere but the first position does indeed fix the problem. I'm now happily importing away. Thanks again