Open 79XX XML Directory
I came across this XML code yesterday on the voip-info wiki and since it seems to work well with 7940 and 7960 phones (and is easy to install) I thought I would post my results. The project goes back to 2005/6 and there is not much activity on the forum however 79x0 users might like to give it a try. You end up with the ability to create contacts and memos in a browser and read them on the phone screen and dial the associated numbers. The RSS feeds also work.
The home page is: http://web.csma.biz/apps/xml_xmldir.php
The sourceforge is: http://sourceforge.net/projects/open79xxdir/
Note in the following replace 'openxml' and 'open79xx' with your own choices.
----
Installation: (This is the way I got it to work)
1. D/L the code - I took the zip file onto a PC.
2. Copy to a directory, that you have created (eg openxml), on the tb server accessible to the webserver and unpack.
eg /var/www/html/openxml/
3. chown -R asterisk.asterisk /var/www/html/openxml
4. chmod -R 775 /var/www/html/openxml
----
5. Create a new database (eg open79xx) with Mysql. I used phpMyAdmin which I had already installed on tb. This needs to be done because open79xx will populate the database but not create it.
From now on if you get an error in your browser window - something is amiss!
6. Point your browser at http://tb-server-ip/openxml/
you get a message
Your database has yet to be configured. First create a MySQL database and grant appropriate rights to an account for this application. Click here to configure your database and populate data.
7. You have already created the database in Mysql so click the link
8. Setup the XML database info, you enter:
Database Name: here enter the name of the db you created eg open79xx
Server: localhost
Login: root
Password: passw0rd
Click "submit"
Note the last 3 lines are determined by the way Mysql is configured - these are the defaults.
if you get the error "The file lib/mysql.php is not writable." check that you did stages 3 and 4 above.
9. Accept the updating of the database. This populates the Mysql database that you have created above.
(If you enter the name of any of the other databases in MySql you will screw up your trixbox config. So choose the name carefully to avoid any confusion.)
10. With luck you will get a message
Installation has determined that the default URL base is not working. ...
http://192.168.1.130/PhoneUI/
To correct this problem, please modify the following URL (this refers to the PhoneUI/ folder) so that it will work (include any sub-folders):
The installation assumes that you will put the code in the webserver document root. Put openxml/ in front of PhoneUI and update. This writes the correct path for the application to /var/www/html/openxmldir/PhoneUI/lib/urlbase.php You can also edit the file directly.
11. You can then point your browser at http://tb-server-ip/openxml/ and update the database with contacts, memos and RSS feeds that are accessible to the 79x0. The default web login is "admin" & the passwd "core"
12. Configure the 79x0.
All I have done is in SIPDefault.cnf to edit
# URL for external Directory location
directory_url: "http://192.168.1.130/openxml/PhoneUI"
and reboot the phone.
13. On the phone, select the Directory button and press 5 on the keypad.
The phone will show up a "security" error. Just go the Open XML screen on your PC browser and select "phone registration" the MAC address of your 79x0 should show up as not registered - enable the MAC of your phone and your away....
However, I can't get this to work on 79x1 and 7971... All I get is the raw xml code showing. I have trawled through Cisco docs and cannot see how xml on the 79x0 and 79x1 differ. Any ideas?
Can I please back up a call to develop a solution for this problem for the 79x1 phones...
I'm not a coder, and have managed to claw my way through configuring, tweaking, and getting a Trixbox CE system up and running with a Cisco 7941G, which has been a headache for a few weeks of a steeeeep learning curve... I had to do everything from scratch, having barely used linux before (all my web host settings are done through CPanel) and this issue of Phone Directories with the Cisco is doing my nut in...
I don't know which way to turn. What I want is the ability to set up my phone with some kind of telephone directory access so that when I sign a new client, I can add them to the database and if they ring me, the phone will tell me not merely the CID number, but the name of the contact so that I can answer the phone fully prepared to deal with that specific client.
I realise that I can do this having integrated HUD Lite with Outlook only by looking at my screen on the computer, but that kind of defeats the object of having a standalone phone system when I could have just had a softphone instead.
Someone recommended SugarCRM, which I've successfully installed but have no idea, after many attempts of getting nothing but XML syntax errors and the like in the Cisco (and indeed the same errors when opening the phonedirectory.php file in a web browser), how on earth to integrate it with TB and indeed with the Cisco XML services...
Then, just when I thought Open79XX was the saving grace, I find out that it too produces XML which is dubious, it seems, to the 79X1 series...
Its absolutely driving me crazy. It strikes me that this kind of functionality should really be a basic 'no brainer' in a server application like Trixbox, and it also strikes me that it cannot be that difficult a task for coders, because the interchange and interaction between a MySQL database and the output of working XML files to fulfil a relatively basic informational function cannot be that much of a challenge to those who are expert in these code lanugages and markup syntax. I wish like mad that I had those skills, because I see a massive gap here for an easy-to-install, easy-to-configure intuitive solution to this problem.
I can see the validity of a product like SugarCRM, even if it IS massive overkill for the very basic functions that I would need as 'standard'...
Someone somewhere must either have a product, or the capability of making a product which will integrate with Trixbox and provide this functionality, or must have a working setup which does what I'm talking about using a tool like SugarCRM or some other solution, who is prepared to share how its done with Trixbox CE 2.6.1 and a Cisco 7941G
Please...
These directories are enterprise directories designed to push large directories to an equally large number of phones.
Why don't you just load the Phonebook module and add it as a caller ID source? This will do exactly what you want.
You also may want to take a look at http://www.astassistant.com
It allows you to import Outlook contacts and has a nice user interface that you can click missed calls and drag and drop calls between extensions. It is also simple to install.



Member Since:
2006-06-07