baikgd的博客

技术是工具，生活是目的，更好的生活是目标！

日志

关于我

baikgd

文章分类

Asterisk CDR的CSV格式的应用

2009-10-15 23:54:56| 分类： linux | 标签： |举报 |字号大中小订阅

下载LOFTER 我的照片书 |

如今有了图形界面,一般都用数据库方式存储Asterisk的CDR(Call Detail Record)记录.其中最常用的就是Mysql了.由于License的关系,Asterisk CDR对Mysql的支持是放在add-ones中的.但在trixbox和Elastix中,都启用了cdr_mysql.但这并不是asteriskCDR的全部.

　　在一个项目中,客户不愿意放弃他们现有的计费系统(支持串口或文件获取数据),而且也找不到计费系统的开发商来支持.这个时候,Asterisk的默认CDR方式就派上用场了.

　　Asterisk的cdr_csv.so模块将CDR数据保存在/var/log/asterisk/cdr_csv/目录下的Master.csv文件中(看到csv,联想到什么?--对了,就是excel支持的一种以逗号分隔数据域的文本格式,可以直接导入到excel中的)

　　Master.csv字段(数据域)顺序是
"${CDR(clid)}","${CDR(src)}","${CDR(dst)}","${CDR(dcontext)}","${CDR(channel)}","${CDR(dstchannel)}","${CDR(lastapp)}","${CDR(lastdata)}","${CDR(start)}","${CDR(answer)}","${CDR(end)}","${CDR(duration)}","${CDR(billsec)}","${CDR(disposition)}","${CDR(amaflags)}","${CDR(accountcode)}","${CDR(uniqueid)}","${CDR(userfield)}"

各个字段的定义如下
${CDR(clid)} = callerid for the call (with the name)

${CDR(src)} = callerid number for the call

${CDR(dst)} = destination extension

${CDR(dcontext)} = Destination context

${CDR(channel)} = Src channel

${CDR(dstchannel)} = Destination channel if appropriate

${CDR(lastapp)} = this is the last application in the dialplan used, on an outgoing call this will be DIAL.

${CDR(lastdata)} = these are the parameters given to the last application used in the dialplan

${CDR(start)} = time of the start of the call

${CDR(answer)} = time when the call was answered

${CDR(end)} = time when the call got hung up

${CDR(duration)} = duration of the call

${CDR(billsec)} = duration of the actual call (without the ringing)

${CDR(disposition)} = status of the call (ANSWERED, BUSY, NO ANSWER)

${CDR(amaflags)} = flag for the type of CDR (can be set in a.o. sip.conf)
　　default: Sets the system default.
　　omit: Do not record calls.
　　billing: Mark the entry for billing
　　documentation: Mark the entry for documentation.

${CDR(accountcode)} = the accountcode as set for this channel with for example SetAccountcode in the dialplan (Extensions.conf) or in the channel configuration file (e.g. per user in sip.conf, iax.conf and per channel in zaptel.conf)

${CDR(uniqueid)} = a unique id for this call

${CDR(userfield)} = a userfield set by the dialplan command SetCDRUserfield

　　由此我们可以根据这些字段的定义将Master.csv文件转化为计费软件需要的内容
实际上,Asterisk CDR也考虑到这点,在/etc/asterisk/目录下有个cdr_custom.conf文件可以让你从这些字段中自定义需要的内容,这样我们获得CDR记录的目录变为/var/log/asterisk/cdr_cusotm
　　呵呵，再拓展一下，可以将Asterisk的csv格式的文件重定向到串口,呵呵这样就更省事了

评论这张

转发至微博

阅读(729)| 评论(0)

历史上的今天

this.p={  m:2,
              b:2,
              loftPermalink:'',
              id:'fks_083067085094088068081084081095087083085067086082095070',
              blogTitle:'Asterisk CDR的CSV格式的应用',
              blogAbstract:'<P\>如今有了图形界面,一般都用数据库方式存储Asterisk的CDR(Call Detail Record)记录.其中最常用的就是Mysql了.由于License的关系,Asterisk CDR对Mysql的支持是放在add-on<wbr\>es中的.但在trixbox和Elastix中,都启用了cdr_mysql.但这并不是asteriskCDR的全部.</P\>\r\n<P\>　　在一个项目中,客户不愿意放弃他们现有的计费系统(支持串口或文件获取数据),而且也找不到计费系统的开发商来支持.这个时候,Asterisk的默认CDR方式就派上用场了.</P\>\r\n<P\>　　Asterisk的cdr_csv.so模块将CDR数据保存在/var/log/asterisk/cdr_csv/目录下的Master.csv文件中(看到csv,联想到什么?--对了,就是excel支持的一种以逗号分隔数据域的文本格式,可以直接导入到excel中的)</P\>',
              blogTag:'',
              blogUrl:'blog/static/354024952009915115456617',
              isPublished:1,
              istop:false,
              type:0,
              modifyTime:0,
              publishTime:1255622096617,
              permalink:'blog/static/354024952009915115456617',
              commentCount:0,
              mainCommentCount:0,
              recommendCount:0,
              bsrk:-100,
              publisherId:0,
              recomBlogHome:false,
              currentRecomBlog:false,
              attachmentsFileIds:[],
              vote:{},
              groupInfo:{},
              friendstatus:'none',
              followstatus:'unFollow',
              pubSucc:'',
              visitorProvince:'',
              visitorCity:'',
              visitorNewUser:false,
              postAddInfo:{},
              mset:'000',
              mcon:'',
              srk:-100,
              remindgoodnightblog:false,
              isBlackVisitor:false,
              isShowYodaoAd:false,
              hostIntro:'',
              hmcon:'1',
              selfRecomBlogCount:'0',
              lofter_single:'<iframe width="140" height="560" style="overflow:hidden;" src="http://www.lofter.com/mailEntry.do?blogad=1&blog" frameBorder="0"></iframe>'
            }

{list a as x}
    {if !!x}
    <div class="iblock nbw-fce nbw-f40">
      <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
      {if x.visitorName==visitor.userName}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}&r=${visitor.imageUpdateTime}"/>
      {else}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}"/>
      {/if}
      </a>
      <div class="cwd vname thide">
        {if x.moveFrom=='wap'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/wapblog.html?frompersonalbloghome"><span title="来自网易手机博客" class="iblock wapIcon"> </span></a>
        {elseif x.moveFrom=='iphone'}
          <a class="noul pnt" target="_blank"><span title="来自iPhone客户端" class="iblock iphoneIcon"> </span></a>
        {elseif x.moveFrom=='android'}
          <a class="noul pnt" target="_blank"><span title="来自Android客户端" class="iblock androidIcon"> </span></a>
        {elseif x.moveFrom=='mobile'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/emsblog.html?frompersonalbloghome"><span title="来自网易短信写博" class="iblock wapIcon"> </span></a>
        {/if}
        <a class="fc03 m2a"  target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
          ${fn(x.visitorNickname,8)|escape}
        </a>
      </div>
    </div>
    {/if}
    {/list}

<#--最新日志，群博日志--> <#--推荐日志-->

<p class="fc06">推荐过这篇日志的人：</p>
    <div>
      {list a as x}
      {if !!x}
      <div class="iblock nbw-fce nbw-f40">
        <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
        <img alt="${x.recommenderNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.recommenderName)}"/>
        </a>
        <div class="cwd thide">
          <a class="fc03 m2a" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
            ${fn(x.recommenderNickname,6)|escape}
          </a>
        </div>
      </div>
      {/if}
      {/list}
    </div>
    {if !!b&&b.length>0}
    <p  class="fc06">他们还推荐了：</p>
    <ul>
    {list b as y}
      {if !!y}
        <li class="rrb"><span class="iblock">·</span><a class="fc03 m2a" target="_blank" href="http://blog.163.com/${y.recommendBlogPermalink}/?from=blog/static/354024952009915115456617">${y.recommendBlogTitle|escape}</a></li>
      {/if}
    {/list}
    </ul>
    {/if}

<#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇，下一篇--> <#-- 热度 -->

{list a as x}
    {if !!x}
    <div class="hotItem iblock nbw-fce nbw-f40">
      <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/">
      {if x.publisherUsername==visitor.userName}
      <img alt="${x.publisherNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.publisherUsername)}&r=${visitor.imageUpdateTime}"/>
      {else}
      <img alt="${x.publisherNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.publisherUsername)}"/>
      {/if}
      </a>
      <div class="cwd vname thide">
        <a class="fc03 m2a"  target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/">
          ${fn(x.publisherNickname,8)|escape}
        </a>
      </div>
      <a class="f-myLikeIcons hottype {if x.type==1} js-liketype{elseif x.type==2} js-reblogtype{elseif x.type==3} js-sharetype{else}{/if}" target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/"> </a>
    </div>
    {/if}
    {/list}

<#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->

页脚

我的照片书 - 手机博客 - 下载LOFTER APP - 订阅此博客

baikgd的博客

导航

日志

Asterisk CDR的CSV格式的应用

历史上的今天

最近读者

热度

评论

页脚