CiviCRM Community Forums (archive)

I'm wondering if anyone has done anything with CiviCRM where a search could be conducted by URL, with the search parameters passed as GET variables.

So for example www.example.com/civicrm/search?phone=5551112222

Would return a list of all users with that phone number?

I think I could create it, but I thought I would check to see if it was already done. I'm doing some VOIP integration, and have a pop up browser window that will open to a url with the calling phone number embedded in the url (as above). So when someone calls the office, CiviCRM will pop open and list all the contacts with the phone number so that the answerer can quickly make any necessary changes to their record.

Brian

Sounds like a cool project. Could you blog about it?

asterisk/voip integration is a question that comes from time to time.

Sounds even nicer

You seem to be on a more broad scope than when Dave suggested you the profile tip.

Another option that needs a bit more dev but brings potentially better UI is to use the api over ajax. You can get (as  json) pretty much any data that you can search on the advanced search, eg search based on the phone number or log a call on a new interface, more focused on your workflow.

I might have a project than involves custom features like normalisation of the phone number (ie be sure it contains the prefix and that the format is correct. Is this something that you have already implemented or plan to?

X+

That Phone Number normalisation would be something I might be interested in as well. For the click to dial implementation, it is going to be necessary to 'format' all phone numbers in the database with an <a href></a> tag. Could all be tied into that potentially.

That Phone Number normalisation would be something I might be interested in as well. For the click to dial implementation, it is going to be necessary to 'format' all phone numbers in the database with an <a href></a> tag. Could all be tied into that potentially.

For the click to dial on a client, what we did was to do it at the js level on a .extra: find all the dom with a phone class and wrap it with a number. We did a bit of formating too (if the number was without the prefix, add a default country prefix.

Probably not super useful as was specific, but can share the code as example

That's the Summary.extra.tpl
You will need to adjust it. As you can see, they have special cases, like internal phone numbers on 3 digit being skipped.

<script>
{literal}
cj(function($){
  function normalizePhone(phone) {
    var t= phone.replace(/[^\d.]/g, "");
    if (t.length == 3) {
      return t;
    }
    if (t[0] != "0")
      t = "00" + t;
    return "0"+t;
  }

  $(".crmf-1-phone-1,.crm-contact_phone span").click(function(){
   $("body").append("<iframe id='calling' src='http://asterisk.box/civiCRM/click2dial.php?to="+normalizePhone($(this).text())+"'></iframe>");
  }).attr("title","Click to dial").css( 'cursor', 'pointer' );
});
{/literal}
</script>