hi, i saw the cdr file called Master.csv and i want to know what these represent. examples "","","4","incoming","","Zap/1-1","Zap/4-1","Voicemail","u8888","2003-11-07 17:43:04","2003-11-07 17:43:04","2003-11-07 17:43:22","ANSWERED","DOCUMENTATION" "","","19373693874","incoming","","Zap/1-1","IAX[Voicepulse]/1","Dial","IAX2/password@voicepulse/19373693874","2003-11-07 17:43:04","2003-11-07 17:43:04","2003-11-07 17:43:22","ANSWERED","DOCUMENTATION" please help me. i want to store these into mySQL database. what can be done? ====Designs __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree
C M wrote:>hi, > >i saw the cdr file called Master.csv and i want to >know what these represent. examples >Take a look in the root of the source (/usr/src/asterisk) at the README.cdr and in the /cdr/cdr_csv.c file for descriptions of the fields..> >please help me. i want to store these into mySQL >database. what can be done? >The MySQL support has been moved out of the /asterisk source for some licencing issue and into the asterisk-addons CVS repository.. Just as you checked out the asterisk source you checkout the addons (eg "cvs co asterisk-addons") and then "make install" the mysql_cdr module from there.. Search the mailing list archives for planty more info on this.. :) Later..
C M wrote:> hi, > > i saw the cdr file called Master.csv and i want to > know what these represent. examples > > "","","4","incoming","","Zap/1-1","Zap/4-1","Voicemail","u8888","2003-11-07 > 17:43:04","2003-11-07 17:43:04","2003-11-07 > 17:43:22","ANSWERED","DOCUMENTATION" > > "","","19373693874","incoming","","Zap/1-1","IAX[Voicepulse]/1","Dial","IAX2/password@voicepulse/19373693874","2003-11-07 > 17:43:04","2003-11-07 17:43:04","2003-11-07 > 17:43:22","ANSWERED","DOCUMENTATION" > > please help me. i want to store these into mySQL > database. what can be done?You can read the page http://www.voip-info.org/tiki-index.php?page=Asterisk+billing as a start! /Olle
Hello! Does anyone know where I can find out about the CDR fields? I know most of them are self expiatory, but what is "disposition" for? I've done a search in Google, I even went to dictionary.com to check the meaning of the word, but I don't know why it always equals 4 in my CDR! :) Ben ______________________________ Benjamin Wakefield ben@team.dcsi.net.au http://www.dcsi.net.au/ DCSI - We do Internet. 64 Queen Street Warragul, VIC 3820 AU Ph: (+61) 1300 665 575 Fx: (+61) 1300 556 595
Asterisk wrote:> Hello! > > Does anyone know where I can find out about the CDR fields? > > I know most of them are self expiatory, but what is "disposition" for? >answer, busy, etc etc
On Wed, Nov 26, 2003 at 09:26:18AM -0800, Richard Lyman wrote:> > Asterisk wrote: > >Hello! > > > >Does anyone know where I can find out about the CDR fields? > > > >I know most of them are self expiatory, but what is "disposition" for? > >I came up with this header record after looking through the /usr/src/asterisk/README.cdr and the /usr/src/asterisk/cdr/cdr_csv.c file. Seems to work OK. Walker -- ******** DataCrest, Inc. -- Technically Superior ****************** Walker Haddock http://www.datacrest.com DataCrest, Inc. e-mail: wh@datacrest.com 1634A Montgomery Hwy. phone: 1-888-941-3282, 1-205-335-8589 Birmingham, AL 35216 fax: 1-205-823-7838 ***********************************************************************
On Wed, Nov 26, 2003 at 12:12:06PM -0600, Walker Haddock wrote:> On Wed, Nov 26, 2003 at 09:26:18AM -0800, Richard Lyman wrote: > > > > Asterisk wrote: > > >Hello! > > > > > >Does anyone know where I can find out about the CDR fields? > > > > > >I know most of them are self expiatory, but what is "disposition" for? > > > > > I came up with this header record after looking through the /usr/src/asterisk/README.cdr and the /usr/src/asterisk/cdr/cdr_csv.c file. Seems to work OK. >This.... "clid","src","dst","dcontext","callid","channel","dstchannel","lastapp","lastdata","start","answer","end","duration","billsec","disposition","amaflags","accountcode","posted","uniqueid"> Walker > -- > ******** DataCrest, Inc. -- Technically Superior ****************** > Walker Haddock http://www.datacrest.com > DataCrest, Inc. e-mail: wh@datacrest.com > 1634A Montgomery Hwy. phone: 1-888-941-3282, 1-205-335-8589 > Birmingham, AL 35216 fax: 1-205-823-7838 > *********************************************************************** > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users-- ******** DataCrest, Inc. -- Technically Superior ****************** Walker Haddock http://www.datacrest.com DataCrest, Inc. e-mail: wh@datacrest.com 1634A Montgomery Hwy. phone: 1-888-941-3282, 1-205-335-8589 Birmingham, AL 35216 fax: 1-205-823-7838 ***********************************************************************
Hello!> > Does anyone know where I can find out about the CDR fields? > > > > I know most of them are self expiatory, but what is "disposition"for?> > > > I've done a search in Google, I even went to dictionary.com to checkthe> > meaning of the word, but I don't know why it always equals 4 in myCDR!> http://www.voip-info.org/wiki-Asterisk+cdr+csv > > Explanations found in the source code, actually :-)Bugger! I was looked in Brian's super groovy unixODBC source. It is all in the cdr_csv source. Thanks! Ben ______________________________ Benjamin Wakefield ben@team.dcsi.net.au http://www.dcsi.net.au/ DCSI - We do Internet. 64 Queen Street Warragul, VIC 3820 AU Ph: (+61) 1300 665 575 Fx: (+61) 1300 556 595