Hi Jochen!
jhomme schrieb:
I’m not that much a developer but I’m wondering if it would be interesting
for the egroupware project to integrate an interaction with an Asterix pbx.
I use egroupware a couple of weeks now and I’m trying to compare it with the
german closed source project “infrastruktur” by the Netzkultur GmbH which is
btw a very interesting solution. Infrastruktur can actively use an asterisk
pbx to show the groupware users, which phonecalls they’ve missed and what
voicemail messages they’ve receiverd. All within the webinterface. There’s
some kind of dashboard you see at first when you log in.
That should be easy to do from within egroupware. The most complicated
question there is where the link between the local asterisk extension and
the user name should come from. You could maybe use your reverse.php to
check which user is assigned to that extension. The call data storage
will be maintained by asterisk (e.g. in a separate mysql database) and
accessed from plain PHP.
I think, I have seen some asterisk-egroupware integration somewhere
around, but I don’t remember. Maybe google gives a hint?
http://sourceforge.net/projects/agis/ goes beyond what you are looking for.
I imagine some kind of that functionality for the egroupware solution. It’d
be a great plus IMHO.
Additionally I’m currently writing an php script that reverse lookups the
callerid in the egw database so that the name is shown on the display of the
callee’s phone as well as the number. So everybody who’s stored in the
companies addressbook (egw) is shown on the phone’s display.
For me personally, that is on my long wish list as well, so if you could
share it, that might be a great feature. Yet, I cannot decide if it could
be maintained within the eGroupware SVN code repository. It should use
the common addressbook query functions in order to be compatible to all
SQL servers and LDAP (which may imply the need of memory usage / resource
optimizations within reverse.php).
Also, I think that it should be a web PHP file (not CLI), which would
then require some handling of credentials. This will allow the Asterisk
AGI script to be located on a local server, while eGroupware could still
be located in the public. The AGI script could then even use several
egroupware servers if required.
The main challenge there is that the script cannot perform a simple query
because the request needs to cope with:
- different incoming number formats and (worse)
- different number formats in the egroupware address book:
+49 123/45 678-90
0123-45 67890
So in the query, the request number first has to be joined and converted to:
- replace the city identifier for the with the international identifier
- dismiss all non-numeric characters
- perform at least two requests, one with the international identifier
and one without.
Another interesting feature which I have got used to is that the
extension of the remote party is added to the display name, e.g.:
- incoming call from +49-123-4567890
- addressbook entry for +49-123-456780 ==> “Your Company”
- Display name: "Your Company (-90)"
I have no approach of how to implement that “best match” in eGroupware, yet.
So please contact me if there’s any interest in the community to have an
extension like that i.e. running a asterisk server and using egw at the same
time. I think I could soon deliver a php function that will return the full
name as a query of the phonenumber.
Please let me know your approach, such that we can do a join approach to
get the best out of eGroupware. 
Please contact me by private mail if
you want to receive my current AGI script, which uses web interfaces but
still lacks the egroupware interface. It can handle the nice external
extension display. 
Best regards and a happy new year,
Hans-Jürgen
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon’s best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
