3

If I import a spread sheet with contacts and phone numbers and:

  • I choose to update duplicate contacts
  • I choose the same phone location and phone type of an existing, matching contact

Then, the existing phone number will be replaced with the one I'm importing.

That is reasonable for many workflows - but what if I want to add the number to the record and not overwrite anything? I know I can create more and more phone types but maybe there is a better way?

1
  • I'm really not sure whether the answer is: that's a feature request - to add a "Add as new" checkbox to the import screen or whether there is a way to do this that I'm not thinking of.
    – Jamie
    Oct 23, 2020 at 22:01

2 Answers 2

2

Use the API CSV Importer and import to the Phone entity which will always add new entries.

1
  • Thank you! Perfect.
    – Jamie
    Oct 26, 2020 at 14:44
1

Andy's answer is correct, but perhaps the more correct answer is "you don't want to". When you have multiple phones of the same location/phone type, saving one overwrites the others.

There's been a lot of debate about this, but ultimately, having multiple of the same phone/location type means that some can't ever be exported/found in reports.

3
  • I think you are right in most work flows. In this case, the group is working with a population that cycles through cell phones without much clarity on which ones are no longer in use and which ones are. The other half of this request is finding a report that simply concatenates all available phone numbers into a column.
    – Jamie
    Oct 26, 2020 at 14:48
  • if on drupal the latter could be done via a View - may be of no help to you though
    – petednz - fuzion
    Oct 26, 2020 at 22:12
  • Jamie - if your organization has a unique need that isn't easily met out of the box, it may be worth building a custom report or similar. Oct 27, 2020 at 14:06

Your Answer

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

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