[asterisk-users] How to tie orders taken to specific CDR records

Bharat Lalcheta bharatlalcheta at gmail.com
Fri Oct 26 08:34:36 CDT 2012


Every CDR has uniqueid/callid generated and unique between all records.
This callid generated when call arrives on system. And logged in CDR record
as well. You can use it in your dialplan to bind with your order like

exten => s,1,Set(ORDERID=${UNIQUEID})


On Fri, Oct 26, 2012 at 6:49 PM, Ruddy Gbaguidi <plugworld at micnes.com>wrote:

> You can have your dialplan log and write a data in a specific table as soon
> as you get the call.
> Then send that call ID to the agent web interface. And when the agent
> complete the order, you just update the table with needed information.
>
>
> ____________________________________
> Ruddy Gbaguidi
> Micnes - Professional Services
> 3767 Thimens, Suite 202
> Montreal (Quebec), Canada, H4R 1W4
> C: +1.514.814.0690
> plugworld at micnes.com
>
>
>
> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com
> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Mitch
> Claborn
> Sent: 2012-10-25 12:19
> To: asterisk-users at lists.digium.com
> Subject: [asterisk-users] How to tie orders taken to specific CDR records
>
> Our phone operators work off of an Asterisk queue.  They take calls from
> customers and take orders with our back end systems.  What I need to be
> able
> to do is tie the orders taken to the specific CDR record that reflects the
> call from which the order originated.
>
> The typical/sample CDR table doesn't have a primary key.  I can add an
> auto-generated PK, but the CDR is not written until the call ends, when the
> orders have already been placed.  (Even if the CDR was written earlier,
> could I retrieve the generated PK from it in the dialplan somehow?)
>
> Is there some combination of fields in the CDR that might uniquely identify
> a specific call?
>
> Open to any and all ideas.
>
>
> --
>
> Mitch
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New
> to
> Asterisk? Join us for a live introductory webinar every Thurs:
>                http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>



-- 
Bharat Lalcheta
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20121026/b04b5dc6/attachment.htm>


More information about the asterisk-users mailing list