+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: [ solved ] Pabx Integration (/showthread.php?tid=587)
[ solved ] Pabx Integration - rslemer - 03-04-2017
When I have a PABX integration there are two situations
1) call coreBOS - in this case even the phone number contains comma, hyphen or spaces, works fine for me
2) Call received in coreBOS - in this case the pop-up, only show correct account / lead / contacts if the number in coreBOS, do not contains any special character
Is it possible to change the code, for special characters received, also deleted?
Another thing,
what fields coreBOS look when search a telefone number ?
Thanks a lot!
RE: Pabx Integration - joebordes - 03-05-2017
I had a look and this is harder than it seems. Outgoing calls are easy because we can eliminate all non numeric characters before sending it to asterisk. Incoming calls require us to eliminate all non numeric characters from the phone fields in the database before doing the search. There seems to be no easy way of doing that. At least I couldn't find one.
Truth is that MariaDB does have a way of doing this (regexp replace)
The search is done in ALL phone type fields, even custom fields.
RE: Pabx Integration - rslemer - 03-05-2017
Is possible I create a new phone type field and create a workflow to update this new custom field, only with numbers?
RE: Pabx Integration - joebordes - 03-06-2017
Yes, of course. That is a very good idea
RE: Pabx Integration - rslemer - 03-07-2017
=)
You think in create a mask from fields at coreBOS ?
if system has any mask to phone fields like a (99) 9999-9999, phone fields can be stored only with numbers ...
RE: Pabx Integration - rslemer - 09-24-2019
I solved that include in AsteriskClient.php a mask directly at callerID Number
changed table vtiger_asteriskincommingevents field to varchar(50)
ALTER TABLE `vtiger_asteriskincomingevents`
CHANGE COLUMN `from_number` `from_number` VARCHAR(50) NULL DEFAULT NULL ;
I can get problems with any other code parts, because thats changes?
Any "tip" I need pay attention with this kind of changes?
RE: Pabx Integration - joebordes - 09-25-2019
no, you should be ok