« Back to Cisco JTAPI Questions

PopUP Program problems JTAPI use

Combination View Flat View Tree View
Threads [ Previous | Next ]
Hi ,
We are trying to make application that stay on the pc and when I have incoming call to show me pop-up
with caller information but to take it from Microsoft Exchange . Our application is almost ready but we have a problem :
In our public folder the phones are defined with country,City and local number and when display it  shows something like this : +359 (2) 5555555 but when I have incoming call it is 0035925555555
I can change + with 00 but how to know for other part of number how to separate it ? If I use content searching i have many problems ...
Sorry about bad english and stupid explanation.
Please help !  

This isn't really a Cisco problem.. it's an exchange search problem.
 
Since it's a text field, your users can enter whatever they please in Exchange and basically screwing you. There are two ways to make it work:
 
1) You institute a policy that say E.164 numbers only for every number... then at least for national numbers you can be reasonably sure you'll find what you're looking for.
2) You load all the contacts, reformat the number (replace +, strip spaces, strip dashes, remove brackets, etc.) then compare that with the number you get from JTAPI.
 
My caller identification application contains both mechanisms and I can activate whichever I need depending on what the customer is willing to do (the first approach means quicker lookup but potentially more work for the user, the second approach means no work for the user but a longer lookup time - the way I've implemented it I load the contacts upon the first lookup, then cache it for a day, and only perform additional lookups for numbers I don't find in the contacts I have in memory - of course that ends up using quite a bit of memory if you're dealing with a lot of users but that's the tradeoff).
 
If only Exchange allowed for SQL functions, right? Doing DB lookups you can sidestep the issue by having an SP that reformats numbers during lookup so you can really search for