Posts: 1,665
Threads: 644
Joined: Aug 2016
Reputation:
164
03-04-2017, 09:59 PM
(This post was last modified: 09-27-2019, 04:55 PM by rslemer.)
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!
Posts: 3,564
Threads: 36
Joined: Apr 2014
Reputation:
49
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.
Joe
TSolucio
Posts: 1,665
Threads: 644
Joined: Aug 2016
Reputation:
164
Is possible I create a new phone type field and create a workflow to update this new custom field, only with numbers?
Posts: 3,564
Threads: 36
Joined: Apr 2014
Reputation:
49
Yes, of course. That is a very good idea
Joe
TSolucio
Posts: 1,665
Threads: 644
Joined: Aug 2016
Reputation:
164
=)
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 ...
Posts: 1,665
Threads: 644
Joined: Aug 2016
Reputation:
164
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?
Ranieri
eCRM Web