2

Have a strange situation where 2000 contacts have been imported with address details. The addresses look fine but when you create a mailing label neither the contacts nor the addresses chosen appear. But when you go and edit/save the contact that contact does then appear on the mailing label, V strange.

I've tried clearing caches and I also though the scheduled job 'Update Greetings and Addresses' may be connected but this made no difference. Something happens when you save the contact but I can't see what it is.

Olly

4
  • Please check are all the address have is_primary set??? and what is your civicrm Version ??? Commented Oct 29, 2015 at 15:34
  • And do the contacts have the is_deleted set to 0? Just guesswork here... Commented Oct 29, 2015 at 15:36
  • SOLVED: this was due to an import bug. During the import some contacts were set as deceased (value 1). The remaining contacts were then set to null by the import tool. But all the elements like Do Not Email if Deceased require a value of 0 for the deceased field. So they wouldn't show on the mailing labels as the system thought they were deceased. A simple export of all individuals (contact ID and deceased value), remove those who are deceased and re-import with a value of 0 on the deceased field solved the issue. Commented Nov 2, 2015 at 8:27
  • Olly - you can post this as an answer and accept it :)
    – Coleman
    Commented Feb 25, 2016 at 19:05

1 Answer 1

1

This was due to an import bug. During the import some contacts were set as deceased (value 1). The remaining contacts were then set to null by the import tool. But all the elements like Do Not Email if Deceased require a value of 0 for the deceased field. So they wouldn't show on the mailing labels as the system thought they were deceased. A simple export of all individuals (contact ID and deceased value), remove those who are deceased and re-import with a value of 0 on the deceased field solved the issue. –

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.