CiviCRM Community Forums (archive)

Hi,

I need to seek the name of a contact based on his phone number. I'm probably going to have to create a new api and query it from the rest interface.

On my db, the phone numbers are +44 20 39 48 39 3 (ie. with space), and the PBX is sending the phone number 0044203948393

What would you suggest to query it ?

My feeling is that it needs to be properly formatted in the db (without any space), so we can do a quick lookup, and add a layer of templating to format the phone numbers so it looks nice, and add validation/reformating as well on the data input side.

What do you think ? That's a side project, I'd rather avoid having to touch too much of Civi, the simpliest the best

X+

Hi,

The reformating can't be via template, wasn't clear about how I need to use it.

Someone calls you, instead of displaying 0114412345678 on your phone as the caller id, asterisk does a lookup on civicrm (via the rest interface),  eg rest.php?q=contact/byphone?phone=+0114412345678 that returns a
<contacts>
  <contact>
    <sort_name>Von Dach, gunter</sort_name>
    ...


asterisk then uses the sort_name as the caller id and displays it on your phone.

I could reformat the phone number to transform it to 011 44 12 34 56 78 before doing the query, but it would assume that the users are really strict on the formatting of the phone numbers...

If we don't enforce a formatting in the dataentry/import of these phone numbers, I somehow doubt it will work very very well.

Any idea ?
X+