<div><br>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</div>
<div> </div><div>exten => s,1,Set(ORDERID=${UNIQUEID})</div><div><br> </div><div class="gmail_quote">On Fri, Oct 26, 2012 at 6:49 PM, Ruddy Gbaguidi <span dir="ltr"><<a href="mailto:plugworld@micnes.com" target="_blank">plugworld@micnes.com</a>></span> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">You can have your dialplan log and write a data in a specific table as soon<br>
as you get the call.<br>
Then send that call ID to the agent web interface. And when the agent<br>
complete the order, you just update the table with needed information.<br>
<br>
<br>
____________________________________<br>
Ruddy Gbaguidi<br>
Micnes - Professional Services<br>
3767 Thimens, Suite 202<br>
Montreal (Quebec), Canada, H4R 1W4<br>
C: <a href="tel:%2B1.514.814.0690" value="+15148140690">+1.514.814.0690</a><br>
<a href="mailto:plugworld@micnes.com">plugworld@micnes.com</a><br>
<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a><br>
[mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a>] On Behalf Of Mitch Claborn<br>
Sent: 2012-10-25 12:19<br>
To: <a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</a><br>
Subject: [asterisk-users] How to tie orders taken to specific CDR records<br>
<br>
Our phone operators work off of an Asterisk queue. They take calls from<br>
customers and take orders with our back end systems. What I need to be able<br>
to do is tie the orders taken to the specific CDR record that reflects the<br>
call from which the order originated.<br>
<br>
The typical/sample CDR table doesn't have a primary key. I can add an<br>
auto-generated PK, but the CDR is not written until the call ends, when the<br>
orders have already been placed. (Even if the CDR was written earlier,<br>
could I retrieve the generated PK from it in the dialplan somehow?)<br>
<br>
Is there some combination of fields in the CDR that might uniquely identify<br>
a specific call?<br>
<br>
Open to any and all ideas.<br>
<br>
<br>
--<br>
<br>
Mitch<br>
<br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> -- New to<br>
Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
<br>
<br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Bharat Lalcheta<br>