is it possible to call a contact page by phonenumber ? ( crm integration )

[jlcurty1]

Hi, I have to integrate asterisk with sugarcrm for incoming calls, I have been thinking of using flash operator panel or snap but when I display a contact detail or ticket detail it's always something like

_http://site/sugar/index.php?module=Cases&action=DetailView&record=1f ca56d0-6ac9-d1d6-aa58-44c7cd8cb802_


I have the caller id, let's 12345678

is possible to have something like
_http://site/sugar/index.php?module=module=Cases&action=DetailView&ph one=12345678_

any idea ? tip ?

thanks!
jl

[kbrill]

It can't be done relyably with sugar right now. I am working on a fix for the phone number search function that will allow this to work. Right now, if you search by phone number and you type in 3149689800 you will get nothing (because the real phone number is entered as 314-968-9800). I will be releasing an upgrade soon that fixes this "bug" and makes SuagrCRM more asterisk compatible.

[jlcurty1]

Thanks for quick reply,

is there a way to be kept informed about this fix ?

better luck with the case numbers ? I mean can I call up a page using a case number ?

thanks
jl

[kbrill]

No currently you can't call up a page with anything else but it's ID

[oddjob2000]

Any progress on this one?? It's possibe to search for a phone number from the form, so I imagine we should be able to do similar from snapanumber's URL capability? Or am I being naive? Thanks.

[kbrill]

Look here. There is a video lesson on how to do it and a loadable module.

[eggsurplus]

Hey oddjob,

We did this back in 3.5.1 by having our call software call this url:

(all on one line)
http://oursugarserver/sugarcrm/index.php
?action=Authenticate&module=Users&return_module=Us ers
&return_action=Login&user_name=myuser&user_hash=58 ac7394875e7de4189239dfe1c6e089323be
&login_theme=Sugar&login_language=en_us&forward_mo dule=%sSugarModule&forward_action=DetailView
&record=%sRecordID[/url]

It would insert the module we wanted for %sSugarModule and the record id for %sRecordID. It would call the server to get that record id. We had to change the authentication to accept the user hash instead of password which is a bit less secure if your server is available to the public.

[eggsurplus]

Sorry for the delay. For a url to auto-login to 4.5.1 and go to a module/record if you have the password use:

http://localhost/sugarcrm/index.php
?action=Authenticate&module=Users&user_name=myuser &user_password=mypassword
&login_theme=Sugar&login_language=en_us&login_modu le=Accounts&login_action=DetailView&login_record=0 63adf3a1c-09b1-102a-a884-001143e81ba9

FOLLOWING AT YOUR OWN RISK!
If you need to query the database for the password you'd have to use the user_hash and make a few changes to get that to work:
modules/Users/Authenticate.php:

 $authController->login($_REQUEST['user_name'],(isset( $_REQUEST['user_hash'])? $_REQUEST['user_hash']:$_REQUEST['user_password'])); 
  

modules/Users/authentication/SugarAuthenticate/SugarAuthenticateUser.php in function loadUserOnLogin()

 $user_hash = SugarAuthenticate::encodePassword($password);
$user_id = $this->authenticateUser($name, $user_hash);
/** eggsurplus: add this below...if password above doesn't work check to see if a hash would authenticate  below */
if(empty($user_id)) {
    $user_id = $this->authenticateUser($name, $password);
} 
  

Then:

http://localhost/sugarcrm/index.php
?action=Authenticate&module=Users&user_name=myuser &user_hash=032945u7-23iasv-asdf9ijmasdff
&login_theme=Sugar&login_language=en_us&login_modu le=Accounts&login_action=DetailView&login_record=0 63adf3a1c-09b1-102a-a884-001143e81ba9