Calling a shell script for inbound routes not working

General Help
1

We are trying to intercept all incoming external calls and call up a shell script to lookup our CRM as to who is calling and then pass the call back to the dialplan for normal processing - ringing of the proper extension etc.
We already got the hard part to work, interfacing with the CRM, but surprisingly we cannot find anywhere a simple example of calling up the shell script, and we have looked - or we just don’t get it.

We can run the script successfully with # echo “agi_callerid:xxxx”|get_cid_name_timeout.sh

We placed the following context in extensions_custom.conf:
[custom-openerp-cid-lookup]
exten => s,1,AGI(/usr/local/bin/get_cid_name_timeout.sh)
exten => s,n,Goto(ext-did-0002,s,1)

also, tried Goto(ext-did,s,1)

We created a Custom Destination:
custom-openerp-cid-lookup,s,1 in the Custom Destination Module

We pointed the Inbound Route to the Custom Destination.

Nothing is working. We even tried the Dialplan injection module, which we got installed but comes up as “broken” in the module admin and so cannot use it.

We really don’t know where to go next. We just want to see an example of what really ought to be a simple process.

Can anyone help??
Thanks

3

Possibly you’ve already tried this, but there is a “Caller ID Lookup” module. Description says it “Allows CallerID Lookup of incoming calls against different sources (OpenCNAM, MySQL, HTTP, ENUM, Phonebook Module)”

4

Many thanks. We are not feeling too bright right now. We actually saw a reference to from-pstn-custom early on in our search but didn’t realise the obvious.

We are using 1.818.210.58-1 where FreePBX is 2.10.1.9 - we will be looking to upgrade when we have time but requires a full reinstall and restore.

For Dialplan Injection Module we used initially the 0.1.1 version which would not install due to SQL Table issues. These seem to be corrected in 0.1.1m as the module installed but it was marked as broken and would not uninstall. We removed the directory with rm -rf instead.

Many thanks for your help.

5

… but we didn’t pursue it as we were so close with the above.
Ultimately the .sh script looks up a Postgresql database which not only displays whose calling on the phone but offers to create a new contact or if already existing pulls up the crm, accounts, records, call logs or documentation of the caller in our ERP system. Works pretty well now.

Thanks for your input.

6

Why don’t you put the code in the user contributed section? What kind of phones does it work on?

What contact manager? Is it something like Sugar or ACT that would have a wide audience?

7

Agreed. It could probably be integrated into Caller ID Superfecta which already has a module to query a postgre dbase.

8

Based on his comments above, it looks like he’s using openERP.

I would also be interested in seeing this code, if you’re willing to share!

9

The original author of the OpenERP interface modules to asterisk is here: http://www.akretion.com/open-source-contributions/openerp-asterisk-voip-connector

Here it gives pretty good instructions how to set it all up but was missing the FreePBX last detail.

For the moment we just have all our contacts in OpenERP and are basically using asterisk to populate the database as calls arise. This is essentially our contact manager.
We are using Grandstream phones, next time though we will buy something else like Snom.

Happy to share the code, not sure how to get it into this forum …