FreePBX Contact Manager to Yealink Address Book

enaran

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 row

Any advice would be awesome
Cheers
Screen Shot 2021-03-30 at 3.12.07 pm.png
Screen Shot 2021-03-30 at 3.02.35 pm.png

JaredBusch

@enaran execute the SQL from command line and post the results

enaran

@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

alanbaker

Jared,

This has been working so well!

I bet you were waiting for this question which is, can a second instance be run so we have two directories listed, one for the internal phonebook and a second for example external suppliers (Using the external phonebook in contact manager?

Thanks so much

Alan

JaredBusch

@alanbaker said in FreePBX Contact Manager to Yealink Address Book:

Jared,

This has been working so well!

I bet you were waiting for this question which is, can a second instance be run so we have two directories listed, one for the internal phonebook and a second for example external suppliers (Using the external phonebook in contact manager?

Thanks so much

Alan

If you update to the current version, it accepts a parameter for the group name. So you can different directories on different buttons or say, per site.

krek

@jaredbusch said in FreePBX Contact Manager to Yealink Address Book:

If you update to the current version, it accepts a parameter for the group name. So you can different directories on different buttons or say, per site.

Good afternoon, is it possible to output two groups in one xml?

JaredBusch

@krek said in FreePBX Contact Manager to Yealink Address Book:

@jaredbusch said in FreePBX Contact Manager to Yealink Address Book:

If you update to the current version, it accepts a parameter for the group name. So you can different directories on different buttons or say, per site.

Good afternoon, is it possible to output two groups in one xml?

Not as currently designed, but yes.

krek

@jaredbusch
The development is super. I would also like to add the union of two different groups from internal and Extension into one xml and you can assign only one button, there will be fire.

alanbaker

Jared,

Hi, I have just received found the yealink handset is no longer receiving the phonebook, I navigated to the link http://my pbx domain.com/cm_to_yl_ab.php and the page showed 403 Forbidden, You don't have permission to access /cm_to_yl_ab.php on this server.

I have in the past seen the XML information on this page.

Any Ideas?

Thanks
Alan

vgvelukashvili

Good day,

Is it possible to add the option in to the script to grab the Contact Images as well? Would be great

JaredBusch

@vgvelukashvili said in FreePBX Contact Manager to Yealink Address Book:

Good day,

Is it possible to add the option in to the script to grab the Contact Images as well? Would be great

How does that get put into a yealink contact xml?

1337

@JaredBusch said in FreePBX Contact Manager to Yealink Address Book:

@vgvelukashvili said in FreePBX Contact Manager to Yealink Address Book:

Good day,

Is it possible to add the option in to the script to grab the Contact Images as well? Would be great

How does that get put into a yealink contact xml?

Maybe this could help: http://forum.yealink.com/forum/archive/index.php?thread-4123.html

eaglex

Hello,

First of all, let me thank you for your wonderful work. This made our lives much easier...

If you don't mind, I would like some help: I'm running this script on 2 FreePBX machines, both are practically the same. On one machine, I have no problems viewing contacts with more than one number (In both the XML file and on the phone itself).
However, on the other machine, I can only see on phone number for each contact, even if they have more than one phone number, again, it happens both when I visit the XML file directly from a browser and on the phones.
I can't think of any difference between both the pbx's.

I'd appreciate your help and I'll be happy to provide additional details, logs, info, etc..

Thanks a lot!

eaglex

@eaglex said in FreePBX Contact Manager to Yealink Address Book:

Hello,

First of all, let me thank you for your wonderful work. This made our lives much easier...

If you don't mind, I would like some help: I'm running this script on 2 FreePBX machines, both are practically the same. On one machine, I have no problems viewing contacts with more than one number (In both the XML file and on the phone itself).
However, on the other machine, I can only see on phone number for each contact, even if they have more than one phone number, again, it happens both when I visit the XML file directly from a browser and on the phones.
I can't think of any difference between both the pbx's.

I'd appreciate your help and I'll be happy to provide additional details, logs, info, etc..

Thanks a lot!

My fingers are still crossed for a solution

Thanks!