Nick,
Thanks for the clarification and I COMPLETELY understand your situation. This isn't your fault at all. Sorry to hear this happened... I'm sure there is an interesting back story you can't share.
For the rest of us Sugar users:
For those interested in getting call popup functionality back, Matthew Orr from Voiptools.com gave me a great idea... just use the built-in "Behavior" settings in 3CX Desktop Client to do this.
For my setup: 3CX V15.5, SugarCE 6.5, Windows 10 w/ 3CX Desktop Client...
1. In 3CX, format your inbound caller ID number to match the phone number format you have in CRM. I realize this is going to be different for everyone, and if you all have any ideas to make this more of a broad search that is less format specific, let me know. But we're pretty good about formatting our phone numbers in Sugar with XXX-XXX-XXXX so I can simply tell 3CX to pass an inbound phone number in that format. Just go to SIP Trunks --> (selected trunk(s) you want) --> CallerID. Then add an Inbound Source Pattern to match what you have in CRM. So, for example, in my case, I want a phone number to display 123-456-7890 because if I search in Sugar with that format, it will look to match a record. So I create a source pattern of (...)(...)(....) and a replace pattern of \1-\2-\3 which translates 1234567890 to 123-456-7890. Besides, this makes calls easier to read on your desk phone.
2. Go to your 3CX Desktop Client Settings --> Advanced Settings --> Behavior --> and click the "Launch Application in incoming call" box. Then in the "Parameters to send" box add the URL corresponding to your CRM's search result BEFORE the parameter you want it to search for. I found this URL simply by running a query on a phone number (i.e. 1234567890) and recognizing that the phone number is simply appended to the end of the search URL as a string. For Sugar users, that would be:
https://YOURDOMAIN/index.php?action...=false&advanced=false&query_string=1234567890 so your text in the parameters to send would simply be
https://YOURDOMAIN/index.php?action...se&advanced=false&query_string=%CallerNumber%
3. Adjust which modules and fields in Sugar you want to respond to a Global Search query like this and you should be all set.
I am by no means a programmer or 3CX expert. Just a dude with a company trying to provide great service and support to my customers, so having their information handy when they call in is huge. If anyone here has some better ideas or improvements on what I've done here... PLEASE SHARE!!!
Don