Asterisk to read the caller ID from FOP's phonebook

stuntshellstuntshell
in Support
Hi,
Is it possible to make asterisk read the information from the phonebook within FOP2?
I found another thread that states it's already done [1], but it does not work for me.
I would like to the caller ID to show on my IP phones.
I'm using FreePBX to manage my system (which comes with it's own phonebook and works), I'm running 1.4.36 with the latest FOP2 2.22.
I just don't want to have two different places to manage my phonebook entries.

Thanks,
[1] View Post 364&p=1323&hilit=caller+id#p1323

Comments

  • nicolasnicolas
    Hi,

    There is an article in the blog explainging how to do that:

    http://www.fop2.com/blog/lookup_source

    Best regards
  • stuntshellstuntshell
    Very well, this works perfectly!

    Thanks a lot.
  • hennyhenny
    How can i tweak the sql query to return the company name as well as the name because we have entries that only have company and no name in them.

    thanks

    Ian
  • nicolasnicolas 
    SELECT CONCAT(company, ' - ',firstname,' ',lastname) AS name FROM visual_phonebook WHERE phone1 LIKE CONCAT('%',SUBSTRING('[NUMBER]',-8)) OR phone2 LIKE CONCAT('%',SUBSTRING('[NUMBER]',-8)) ORDER BY LENGTH(CONCAT(phone1,phone2)) LIMIT 1
Sign In or Register to comment.

© Asternic Corp 2024