CID Superfecta and Fop2 Address Book

NemesiIT · March 6, 2024, 9:05am

Hi everyone,
we recently are experiencing an issue with fop2 address book in CID superfecta lookup. It seems that in the last version is not working anymore due to fop2 changes in database.
Anybody experienced the same issue and found a solution?

Thank you in advance for your help

lgaetz · March 6, 2024, 1:26pm

Not a FOP2 user, but the code that Superfecta uses to find a name in FOP2 address book is all in

/var/www/html/admin/modules/superfecta/sources/source-FOP2_Phonebook.module

It uses a mysql query to find the name, so I expect it’s not that difficult to update the query, or better yet add a second query so that it will continue to work for the old version.

github.com

FreePBX/superfecta/blob/release/16.0/sources/source-FOP2_Phonebook.module

<?php

/*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
* Developer Notes:
* There may be some users who would want this module to do post processing to insert name/number into FOP2 address book
* Versions prior to 2013-12-20 would abandon the search if there were fewer digits than specified, disabled by

* Version History:
* 20xx-xx-xx	Initial migration to 2.11 platform
* 2013-12-19	bug fix, CNAM_Type missing from Source Param user input - lgaetz
* 2013-12-20	bug fix, don't modify $run_param variables inside get_caller_id function, fix filter length - lgaetz
* 2014-01-02	add user setting to use native FreeBPX connection to the asterisk database.
* 2014-08-19	removed reliance on deprecated mysql functions
* 2014-09-07	Fixed minor bug with PDO
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***/

class FOP2_Phonebook extends superfecta_base {
	public $description,$source_param;
	public $version_requirement = "2.11";

This file has been truncated. show original

NemesiIT · March 7, 2024, 7:13am

Thank you very much for your feedback. Unfortunately I’m not really skilled in mysql queries. I found another similar post CID Superfecta in FOP2 Version 2.31.36 (Latest) but the solution file is missing.
If anybody would be able to help, I’ll be greatful. Thanks. RZ

ErikVandergeld · March 7, 2024, 10:15am

Here is my modified file friend, adapted to work with old and new versions of FOP2

ErikVandergeld · March 7, 2024, 10:21am

@lgaetz Can I open a ticket to suggest including this updated version of the fop2 module in the freepbx distro?

lgaetz · March 7, 2024, 10:45am

Code is always welcome. Follow the procedure from this thread

NemesiIT · March 7, 2024, 10:46am

Thank you Erik,
that worked perfectly. I’m very grateful. You are awesome!
Thanks again. RZ

system · March 14, 2024, 10:46am

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.