<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=Arial size=2>Here is a reference cdr:</FONT></DIV>
<DIV>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR onmouseover="bgColor='#C4FFD7'" onmouseout="bgColor='#FFFFFF'"
bgColor=#ffffff>
<TD class=tableBody vAlign=top><FONT face=Arial size=2>29. </FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>2005-12-28 13:02:01</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>Zap/1-1...</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>8103970196</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>8103970196<8103970196></FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>5100</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>ANSWERED</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>78</FONT></TD></TR>
<TR onmouseover="bgColor='#C4FFD7'" onmouseout="bgColor='#F2F8FF'"
bgColor=#f2f8ff>
<TD class=tableBody vAlign=top><FONT face=Arial size=2>30. </FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>2005-12-28 12:59:54</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>Zap/1-1...</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>8104590192</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>8104590192<8104590192></FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>5128</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>ANSWERED</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>23</FONT></TD></TR>
<TR onmouseover="bgColor='#C4FFD7'" onmouseout="bgColor='#FFFFFF'"
bgColor=#ffffff>
<TD class=tableBody vAlign=top><FONT face=Arial size=2>31. </FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>2005-12-28 12:56:01</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>Zap/1-1...</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>8102320369</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>8102320369</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>5162</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>ANSWERED</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>165</FONT></TD></TR>
<TR onmouseover="bgColor='#C4FFD7'" onmouseout="bgColor='#F2F8FF'"
bgColor=#c4ffd7>
<TD class=tableBody vAlign=top><FONT face=Arial size=2>32. </FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>2005-12-28 12:54:19</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>Zap/2-1...</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>2489220303</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>2489220303</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>5162</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>ANSWERED</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>40</FONT></TD></TR>
<TR onmouseover="bgColor='#C4FFD7'" onmouseout="bgColor='#FFFFFF'"
bgColor=#ffffff>
<TD class=tableBody vAlign=top><FONT face=Arial size=2>33. </FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>2005-12-28 12:54:16</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>Zap/71-1...</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>2480365108</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>Mika<2480365108></FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>15860360822</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial size=2>NO
ANSWER</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>25</FONT></TD></TR>
<TR onmouseover="bgColor='#C4FFD7'" onmouseout="bgColor='#F2F8FF'"
bgColor=#f2f8ff>
<TD class=tableBody vAlign=top><FONT face=Arial size=2>34. </FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>2005-12-28 12:51:11</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>Zap/71-1...</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>2480365123</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>Gary<2480365123></FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>12402240667</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial size=2>NO
ANSWER</FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2>24</FONT></TD></TR>
<TR onmouseover="bgColor='#C4FFD7'" onmouseout="bgColor='#FFFFFF'"
bgColor=#ffffff>
<TD class=tableBody vAlign=top><FONT face=Arial size=2></FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2></FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2></FONT></TD>
<TD class=tableBody vAlign=top align=middle><FONT face=Arial
size=2></FONT></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am using a PBX behind our asterisk server, so
calls coming from the PBX may be extensions or forwarded calls from
outside.</FONT></DIV>
<DIV><FONT face=Arial size=2>To add consistency, I have set all of the callerID
info for asterisk extensions to be 10 digit numbers.</FONT></DIV>
<DIV><FONT face=Arial size=2>Outbound calls from asterisk start with a 9, but
there is no 9 from the PBX, so I have 2 sets of outbound rules. (1 for each
context)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What I would like to do:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When DID calls come in, I would like to record a 10
digit number in the "dst" cdr field.</FONT></DIV>
<DIV><FONT face=Arial size=2>When outbound calls are made, I would like to store
them as 10 digits as well. either stripping off the 1 from PBX calls or the 91
from asterisk calls.</FONT></DIV>
<DIV><FONT face=Arial size=2>I would also have to take International calls into
account. removing the 9 from the 011X. from the PBX or just leaving the
011X. in tact from asterisk calls</FONT></DIV>
<DIV><FONT face=Arial size=2>This alteration would have to after the call is
made, to make sure that we are still dialing the number correctly.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I will figure out the rules if someone can just
point me in the right direction for altering the "dst" field in the cdr, or at
least tell me that it can not be done.</FONT></DIV>
<DIV><FONT face=Arial size=2>If not, I will have to see if I can do it via SQL
after the fact.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>please advise.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><BR><FONT face=Arial size=2>-- <BR>-- <BR>Steven</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>May you have the peace and freedom that come from
abandoning all hope of having a better past.<BR>---
- --- - -
- -
- - - -- - - - --- -
------ - - --- - - -- - - - --
- - -</FONT></DIV></BODY></HTML>