External call to addressbook searh, possible?

[CLorenzo-2]

Hi to all.

I want to know if it is possible to make a external call to the addressbook application requesting a search, In the 1.2 version this was possible, to open a url with a parameter (string to search), then the egroupware opened the addessbook with the string to search in the search field.

I want this to make a Integration with our telephony system, so the telephony system calls this url with the Caller ID of the incoming call and the user gets on the screen the information from the addressbook.

Thanks

[JDlugi]

Hi to all.

I want to know if it is possible to make a external call to the address book application requesting a search, In the 1.2 version this was possible, to open a url with a parameter (string to search), then the egroupware opened the addessbook with the string to search in the search field.

I want this to make a Integration with our telephony system, so the telephony system calls this url with the Caller ID of the incoming call and the user gets on the screen the information from the addressbook.

Hi clorenzo,

there might be 2 possibilities:
a xml-rpc call, and you get the result for processing it in your own interface (->external application, soft phone etc.)

or you are going to manipulate the “app-session-data-cache” of the address book in relationship to the current user

You can do this by using
$addresssbookstate = $GLOBALS[‘egw’]->session->appsession(‘index’,‘addressbook’);

a print_r($addresssbookstate); shows up something like this:

Array
(
[get_rows] => addressbook.addressbook_ui.get_rows
[bottom_too] =>
[never_hide] => 1
[start] => 0
[cat_id] =>
[options-cat_id] => Array
(
[0] => Keine
)

[search] => www.alpha-zet.de
[order] => contact_modified

etc…

before executing this little piece of code I made a search for “www.alpha-zet.de”, as u can see - it’s there… so, if you want to have a pre-filled search text, you could write it directly in this array item… and next time the user clicks on the address book, or maybe - one step more - you are going to make redirection to the address book, the magic is done, the search text-field is filled. (->egw-intern)

This is what comes to my mind.

… btw, with the second way, we have integrated our proprietary telephone installation (elmeg) at alpha-zet.

regards
Jürgen

[CLorenzo-2]

Hi Jürgen.

Hi to all.

I want to know if it is possible to make a external call to the address book application requesting a search, In the 1.2 version this was possible, to open a url with a parameter (string to search), then the egroupware opened the addessbook with the string to search in the search field.

I want this to make a Integration with our telephony system, so the telephony system calls this url with the Caller ID of the incoming call and the user gets on the screen the information from the addressbook.

Hi clorenzo,

there might be 2 possibilities:
a xml-rpc call, and you get the result for processing it in your own interface (->external application, soft phone etc.)

or you are going to manipulate the “app-session-data-cache” of the address book in relationship to the current user

You can do this by using
$addresssbookstate = $GLOBALS[‘egw’]->session->appsession(‘index’,‘addressbook’);

a print_r($addresssbookstate); shows up something like this:

Array
(
[get_rows] => addressbook.addressbook_ui.get_rows
[bottom_too] =>
[never_hide] => 1
[start] => 0
[cat_id] =>
[options-cat_id] => Array
(
[0] => Keine
)

[search] => www.alpha-zet.de
[order] => contact_modified

etc…

before executing this little piece of code I made a search for “www.alpha-zet.de”, as u can see - it’s there… so, if you want to have a pre-filled search text, you could write it directly in this array item… and next time the user clicks on the address book, or maybe - one step more - you are going to make redirection to the address book, the magic is done, the search text-field is filled. (->egw-intern)

This is what comes to my mind.

… btw, with the second way, we have integrated our proprietary telephone installation (elmeg) at alpha-zet.

regards
Jürgen

Thanks, This sound a bit complicated for me as my php level is almost zero, I am testing an asterisk client that has the ability to fire a script or an external application passing the caller id. so I want this to integrate with eGroupware, I will try to look at this anyway

[JDlugi]

Hi Jürgen.

Hi to all.

I want to know if it is possible to make a external call to the address book application requesting a search, In the 1.2 version this was possible, to open a url with a parameter (string to search), then the egroupware opened the addessbook with the string to search in the search field.

I want this to make a Integration with our telephony system, so the telephony system calls this url with the Caller ID of the incoming call and the user gets on the screen the information from the addressbook.

Hi clorenzo,

there might be 2 possibilities:
a xml-rpc call, and you get the result for processing it in your own interface (->external application, soft phone etc.)

or you are going to manipulate the “app-session-data-cache” of the address book in relationship to the current user

You can do this by using
$addresssbookstate = $GLOBALS[‘egw’]->session->appsession(‘index’,‘addressbook’);

a print_r($addresssbookstate); shows up something like this:

Array
(
[get_rows] => addressbook.addressbook_ui.get_rows
[bottom_too] =>
[never_hide] => 1
[start] => 0
[cat_id] =>
[options-cat_id] => Array
(
[0] => Keine
)

[search] => www.alpha-zet.de
[order] => contact_modified

etc…

before executing this little piece of code I made a search for “www.alpha-zet.de”, as u can see - it’s there… so, if you want to have a pre-filled search text, you could write it directly in this array item… and next time the user clicks on the address book, or maybe - one step more - you are going to make redirection to the address book, the magic is done, the search text-field is filled. (->egw-intern)

This is what comes to my mind.

… btw, with the second way, we have integrated our proprietary telephone installation (elmeg) at alpha-zet.

regards
Jürgen

Thanks, This sound a bit complicated for me as my php level is almost zero, I am testing an asterisk client that has the ability to fire a script or an external application passing the caller id. so I want this to integrate with eGroupware, I will try to look at this anyway

yeah, maybe a bit… so, if you use asterisk and you won’t go into the code and modify it (btw. doing this by a self-made appl./modul using the egw-api, would be the best way, I solved it this way)
…have u ever seen: eGW pbx http://sourceforge.net/projects/egw-pbx/files/ maybe this fits your needs.

In the last time (about a year) devoloping seems not to be in progress, but in the setup.php file u can find

/* Dependencies for this app to work */

$setup_info[‘pbx’][‘depends’][] = array(
‘appname’ => ‘phpgwapi’,
‘versions’ => Array(‘1.5’,‘1.6’,‘1.7’)
);
$setup_info[‘pbx’][‘depends’][] = array(
‘appname’ => ‘etemplate’,
‘versions’ => Array(‘1.5’,‘1.6’,‘1.7’)
);

$setup_info['pbx']['depends'][] = array(
	 'appname' => 'calendar',
	 'versions' => Array('1.4', '1.5', '1.6')
);

$setup_info['pbx']['depends'][] = array(
	 'appname' => 'infolog',
	 'versions' => Array('1.4', '1.5', '1.6')
);

$setup_info['pbx']['depends'][] = array(
	 'appname' => 'addressbook',
	 'versions' => Array('1.4', '1.5', '1.6')
);
$setup_info['pbx']['depends'][] = array(
	 'appname' => 'felamimail',
	 'versions' => Array('1.4', '1.5', '1.6')
);</i>

so… maybe it will work with the 1.6 and maybe also with the actual trunk version, but in this case there could be api-breakings, because the stylite guys have done a lot of work at auto-class-loading etc.

regards jürgen

[CLorenzo-2]

Hi again Jürgen.

yeah, maybe a bit… so, if you use asterisk and you won’t go into the code and modify it (btw. doing this by a self-made appl./modul using the egw-api, would be the best way, I solved it this way)
…have u ever seen: eGW pbx http://sourceforge.net/projects/egw-pbx/files/ maybe this fits your needs.

In the last time (about a year) devoloping seems not to be in progress, but in the setup.php file u can find

/* Dependencies for this app to work */

$setup_info[‘pbx’][‘depends’][] = array(
‘appname’ => ‘phpgwapi’,
‘versions’ => Array(‘1.5’,‘1.6’,‘1.7’)
);
$setup_info[‘pbx’][‘depends’][] = array(
‘appname’ => ‘etemplate’,
‘versions’ => Array(‘1.5’,‘1.6’,‘1.7’)
);

$setup_info['pbx']['depends'][] = array(
	 'appname' => 'calendar',
	 'versions' => Array('1.4', '1.5', '1.6')
);

$setup_info['pbx']['depends'][] = array(
	 'appname' => 'infolog',
	 'versions' => Array('1.4', '1.5', '1.6')
);

$setup_info['pbx']['depends'][] = array(
	 'appname' => 'addressbook',
	 'versions' => Array('1.4', '1.5', '1.6')
);
$setup_info['pbx']['depends'][] = array(
	 'appname' => 'felamimail',
	 'versions' => Array('1.4', '1.5', '1.6')
);</i>

so… maybe it will work with the 1.6 and maybe also with the actual trunk version, but in this case there could be api-breakings, because the stylite guys have done a lot of work at auto-class-loading etc.

regards jürgen

Thanks again, I will take a look at this also

Best Regards

[mesfet]

Hi All.
I think it will be a great feature to permit to open a URL with the result of addressbook search when issuing an URL like
http://localhost/egroupware/?addressbook_search=KEYWORD
because it will permit to interface egroupware addressbook with telephony or other applications.
Egroupware already permit to integrate telephony with click2dial , and there is a very good call.php external script that do this job with Asterisk PBX.
The thing that is missing is the possibility to popup a window with the contact associated with an incoming call.
For this purpose, there is a great firefox extension, Click2Dial by Acipia, that connects with Asterisk PBX and listen to its management interface: when an incoming call arrives, it’s able to open a browser window with a URL containing the caller phone number, i.e.
http://localhost/egroupware/?addressbook_search=01234567

It will be very very nice that egroupware, receiving a similar request, does:

• if one contact has that phone number, open the addressbook window in edit mode displaying the company name, first and last name, city, country and notes: in this way it’s simple to look at the information for that contact before answering
• if more than one contats share that phone number, open the addressbook window with the list of contacts with that phone number (like a search)
• if no contacts has that phone number, I don’t know! Maybe showing the contact list so it’s possible for the user to look if there is an information about that contact (maybe with another phone number), or to add a new contact easely.

I’m not a good programmer, I know only a little bit of PHP. Could anybody help me?
Thank you!!
Paolo

[Hans-Jurgen_Tappe]

Hi Paolo!

One problem with the search is the number format in the eGroupware
database; the users can enter the numbers in any format, e.g.:
+1234567890
+12-23456-7890
0234 56 78 9/0
etc. etc.

So only a loop over all contacts, which normalizes the number format in
all contacts before comparing them to the incoming number would do the job.

Another option would be to have eGroupware (or a separate application
within eGroupware via a hook) maintain the normalized phone numbers in a
separate database table. This requires another eGroupware application to
be written - not impossible but time consuming (and still a valid feature
request, which I would also like to see, but do not currently find time
to integrate).

Best regards,
Hans-Jürgen

Hi All.
I think it will be a great feature to permit to open a URL with the result
of addressbook search when issuing an URL like
http://localhost/egroupware/?addressbook_search=KEYWORD
because it will permit to interface egroupware addressbook with telephony or
other applications.
Egroupware already permit to integrate telephony with click2dial , and there
is a very good call.php external script that do this job with Asterisk PBX.
The thing that is missing is the possibility to popup a window with the
contact associated with an incoming call.
For this purpose, there is a great firefox extension, Click2Dial by Acipia,
that connects with Asterisk PBX and listen to its management interface: when
an incoming call arrives, it’s able to open a browser window with a URL
containing the caller phone number, i.e.
http://localhost/egroupware/?addressbook_search=01234567

It will be very very nice that egroupware, receiving a similar request,
does:

• if one contact has that phone number, open the addressbook window in edit
  mode displaying the company name, first and last name, city, country and
  notes: in this way it’s simple to look at the information for that contact
  before answering
• if more than one contats share that phone number, open the addressbook
  window with the list of contacts with that phone number (like a search)
• if no contacts has that phone number, I don’t know! Maybe showing the
  contact list so it’s possible for the user to look if there is an
  information about that contact (maybe with another phone number), or to add
  a new contact easely.

I’m not a good programmer, I know only a little bit of PHP. Could anybody
help me?
Thank you!!
Paolo

---

http://shop.creasol.it Paolo Subiaco
info@creasol.it

---

This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[ngegw]

Hi All.
I think it will be a great feature to permit to open a URL with the result
of addressbook search when issuing an URL like
http://localhost/egroupware/?addressbook_search=KEYWORD

Try this for a start:
egroupware/index.php?menuaction=addressbook.addressbook_ui.index&search=KEYWORD

Opens the addressbook index, with the specified filter.
Available in trunk.

Nathan

---

This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Anthony_Messina]

I think it will be a great feature to permit to open a URL with the result
of addressbook search when issuing an URL like
http://localhost/egroupware/?addressbook_search=KEYWORD
because it will permit to interface egroupware addressbook with telephony
or other applications.

If it’s possible for you to store contacts in LDAP, this becomes trivial and
requires no eGW code, but can be used by anything that can search LDAP.

I use eGW (with accounts and contacts in LDAP) because it’s by far the best
contact management front end interface that I’ve found, but I have all my
other applications like KMail, apache, etc. look up those same contacts
directly via LDAP.

If you happen to be using 389 Directory Server (rather than OpenLDAP), I have
some information that may be helpful here:

http://messinet.com/trac/egw/browser/README.389DS

-A

–
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E

[mesfet]

Nathan Gray [via EGroupware] ha scritto:

Hi All.
I think it will be a great feature to permit to open a URL with the
result
of addressbook search when issuing an URL like
http://localhost/egroupware/?addressbook_search=KEYWORD

Try this for a start:
egroupware/index.php?menuaction=addressbook.addressbook_ui.index&search=KEYWORD

Opens the addressbook index, with the specified filter.
Available in trunk.

Hi Nathan.
Your suggestion is very good. calling
http://hostname/index.php?menuaction=addressbook.addressbook_ui.index&search=KEYWORD

or
http://hostname/index.php?menuaction=addressbook.addressbook_ui.index&search=PHONE_NUMBER
works very well with the trunk version. It does not work with stable release
1.6.003, but maybe it will be ported in the stable version soon!

Now I have a full integration between eGroupWare and my Asterisk PBX!
Both click2dial (originating call from addressbook, using call.php script) and
addressbook popup on incoming call (using click2dial asterisk extension which
calls the URL above on every incoming call) works well.

Many thanks for the great support and for the very nice groupware application!
Paolo

[mesfet]

Hans-Juergen Tappe [via EGroupware] ha scritto:

Hi Paolo!

One problem with the search is the number format in the eGroupware
database; the users can enter the numbers in any format, e.g.:
+1234567890
+12-23456-7890
0234 56 78 9/0
etc. etc.

So only a loop over all contacts, which normalizes the number format in
all contacts before comparing them to the incoming number would do the job.

Hi Hans-Jurgen,
Yes, you’are right… very often phone numbers are cut&pasted into the
addressbook in different formats.
The simple solution is to add them in the same format of the PBX, or to have
another indexed field, in the addressbook table, where it’s stored the phone
number with only digits, + converted into 00 and international prefix removed
for numbers of the same country.
Definings a regexp rule should help to do this, but I think it’s not so
important: just insert phone numbers in the right way to avoid this problem.

Another option would be to have eGroupware (or a separate application
within eGroupware via a hook) maintain the normalized phone numbers in a
separate database table. This requires another eGroupware application to
be written - not impossible but time consuming (and still a valid feature
request, which I would also like to see, but do not currently find time
to integrate).
Yes, infact!

I believe that suggestion made by Nathan is quite good: trunk version of
egroupware permit to specify an URL to search across the addressbook: this is fine!
Best regards. Paolo