Ticket #3968 (closed Module Submissions: fixed)

Opened 2 years ago

Last modified 2 years ago

Dynamic routing module

Reported by: john@erba.tv Assigned to: p_lindheimer
Priority: minor Milestone: 2.7
Component: Core - Trunks/Routing Version: 2.6-branch
Keywords: dynamic inbound mysql routing Cc:
Confirmation: Unreviewed SVN Revision (if applicable):
Backend Engine: Asterisk 1.6 Backend Engine Version: 1.6.2.0

Description

I'm submitting this module as a new ticket to make sure its visible as a module submission, though I had originally attached it to my feature request.#3862

This module allows you to send incoming calls to different destinations based on the result of a mysql query.

This can be used to:

  • play different annoucement to some callers
  • send some callers into different IVRs or queues
  • set queue priority for some callers
  • ring different extensions based on recognised callerid
  • have recognised customers received announcements in their own language

The following is just an example of how it could be setup to read the class of a caller from a database:

Example table mapping customers callerids to a priority

+-----------------+-------------+---------------+
| calleridname    | calleridnum | cust_priority |
+-----------------+-------------+---------------+
| Customer Name 1 | 12345678    | top           |
| Customer Name 2 | 12345679    | important     |
| Customer Name 3 | 12345670    | normal        |
+-----------------+-------------+---------------+

Then in the freepbx query under dynamic route module set up a route which uses this query:

select cust_priority from calleridlookup where calleridnum like '%[NUMBER]' and length('[NUMBER]') > 4

and then set up some routing destinations in the options part of the screen where every value returned by cust_priority is mapped to a specific destination. Example

  • top -> rings an extension
  • important -> sent to a queue
  • normal -> sent to an ivr

the destinations can be anything that is allowable as a destination in freepbx. An option called default should be set to indicate where to route calls if database does not return any of the forseen values.The built in default destination is to hang up.

Implementation notes: this module takes code from calleridlookup and ivr.

Attachments

dynroute-2.6.0.2.tar.gz (7.4 kB) - added by john@erba.tv on 12/04/09 01:30:11.

Change History

12/04/09 01:30:11 changed by john@erba.tv

  • attachment dynroute-2.6.0.2.tar.gz added.

01/02/10 15:57:19 changed by mbrevda

see also: #3862

01/30/10 21:45:47 changed by p_lindheimer

  • milestone changed from 2.7 to 2.8.

02/27/10 18:56:03 changed by p_lindheimer

  • milestone changed from 2.8 to 2.7.

adding to contributed_modules directory and adding SVN access to the author

02/27/10 18:56:58 changed by p_lindheimer

  • status changed from new to closed.
  • resolution set to fixed.

(In [8969]) closes #3968 added to contributed_modules directory and added SVN access for john@erba.tv