FreePBX Contact Manager to Yealink Address Book
-
@mgbolts said in FreePBX Contact Manager to Yealink Address Book:
Another update to the script.
https://github.com/mgbolts/fpbx-yealink-xmlcontacts/blob/master/cm_to_yl_ab_L2.php
Updates are as follows:
a) I have added the ability to customise your own number labels. eg. I did not like cell or internal being the default label from fpbx. I wanted Mobile and Extension.
b) I wanted the ability to choose the display order for the set of numbers for each name. The issue was that it was random and I also wanted my chosen number to be the default number displayed against the name. This was particularly where I pulled in to the internal contact list. In this case, I wanted the extension to be the default and not some random number like cell etc.
c) It now has the ability to use the number as input (the default) or use the auto generated E164 format from FPBX. This may not be useful for most users, but is helpful where you have users in more than jurisdiction and each country has its own int dialing prefix, eg. AU is 0011 and other countries use different prefixes. It does require you to select the correct country when creating the contact number in fpbx. Further instructions in the code.
I have also updated my original script to handle most of this.
The sub sort by label order is not yet impelmented.
-
Just came across your script. It's working great here - thank you! I made a small change to remove all non-numeric characters from phone numbers (like +, (), - , etc.), otherwise my Yealink phone doesn't dial the number properly from the directory. It only required 1 line of code in the main loop:
$contact['number'] = preg_replace("/[^0-9]/", "", $contact['number']);One question: what is the purpose of the "label=" in the <Telephone> XML tag? This is not documented in Yealink's XML documentation, and although the script generates it properly for Home, Work, Mobile, and Other, my SIP-T29G phone seems to ignore it and instead indicates multiple numbers as Number1, Number2, etc. which is not great. I wish it used the tags. Do other Yealink phones support this?
Thanks again!
-
@cinergi said in FreePBX Contact Manager to Yealink Address Book:
One question: what is the purpose of the "label=" in the <Telephone> XML tag? This is not documented in Yealink's XML documentation, and although the script generates it properly for Home, Work, Mobile, and Other, my SIP-T29G phone seems to ignore it and instead indicates multiple numbers as Number1, Number2, etc. which is not great. I wish it used the tags. Do other Yealink phones support this?
Those labels started in some version of the phones, yes. I know it works in the T4 series and the T5 series.
-
@cinergi said in FreePBX Contact Manager to Yealink Address Book:
I made a small change to remove all non-numeric characters from phone numbers (like +, (), - , etc.), otherwise my Yealink phone doesn't dial the number properly from the directory.
How are you getting bad data in the directory to being with? At least I would consider that bad data in the source.
Are you using Contact Manager? If so, someone had to put those extra characters in there.
-
Hi, I'm testing in a lab environment for now, I have followed the instructions and created a internal contact manager group calling Internal, I have added one contact into it with an extension. When I browse to the cm_to_yl_ab.php file it gives the following error: -
This page contains the following errors:
error on line 3 at column 22: Opening and ending tag mismatch: CompanyIPPhoneDirectory line 0 and DirectoryEntry
Below is a rendering of the page up to the first error.In a red box with nothing else shown, I have rebooted the pbx but same thing, can you advise.
Thanks in advance.
Alan
-
@alanbaker said in FreePBX Contact Manager to Yealink Address Book:
Hi, I'm testing in a lab environment for now, I have followed the instructions and created a internal contact manager group calling Internal, I have added one contact into it with an extension. When I browse to the cm_to_yl_ab.php file it gives the following error: -
This page contains the following errors:
error on line 3 at column 22: Opening and ending tag mismatch: CompanyIPPhoneDirectory line 0 and DirectoryEntry
Below is a rendering of the page up to the first error.In a red box with nothing else shown, I have rebooted the pbx but same thing, can you advise.
Thanks in advance.
Alan
Make sure you have one entry in Contact Manager. I never designed it to handle zero contacts.
There is an issue posted on that already, but I have not had the free time to work on it.
https://github.com/sorvani/freepbx-helper-scripts/issues/12 -
Thanks for the quick reply, it makes sense I’ll populate with a number and try again.
@JaredBusch -
I am having some problems implementing the script.
I have followed the direction to install it in /var/www/html
Ran chown
Edited the script to set the $contact_manager_group to Clients - which I have made in FreePBX v15.0.17.24 - Asterisk V16.15.0
I have loaded one contact into this group
When I execute the script by navigating to http://10.0.0.120/cm_to_yl_ab.php I recieve the error:
PDOException (21000)
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 rowAny advice would be awesome
Cheers
-
@enaran execute the SQL from command line and post the results
-
@jaredbusch thank you.
I posted the SQL at the command line and it returned the same error.I figured it out though as I seemed to have a Clients group in both the External and Private Contact Manager Areas - hence the return of two records in the subquery.
I deleted the Clients Group from the Private area leaving just the one in the External area, and it started working.
Cheers
