0 like 0 dislike
74 views
asked Jun 12 in Education & Reference by Simmi (510 points) | 74 views
    

1 Answer

0 like 0 dislike

Step # 1 Introduce following columns in database table cdr:

starttime
answertime
endtime
cc_caller

unique_identifier
ALTER TABLE asterisk.cdr ADD COLUMN answertime DATETIME NOT NULL DEFAULT '' AFTER sequence;
ALTER TABLE asterisk.cdr ADD COLUMN starttime DATETIME NOT NULL DEFAULT '' AFTER answertime;
ALTER TABLE asterisk.cdr ADD COLUMN endtime DATETIME NOT NULL DEFAULT '' AFTER starttime;
ALTER TABLE asterisk.cdr ADD COLUMN cc_caller VARCHAR(80) NOT NULL DEFAULT '' AFTER endtime;

Step # 2

Add following section in asterisk file i.e. cdradaptiveodbc.conf. It will enable the CDR() function to recognize custom fields included in asterisk MySQL CDRs ODBC.

[adaptive_connection]
connection=asterisk
table=cdr
alias start => starttime
alias answer => answertime
alias end => endtime

Step # 3

Following is the dialplan (in file i.e. extensions.conf) to handle custom Asterisk MySQL CDRs ODBC.

[default-context]
exten => X.,n,Set(CALLERID(num)=${cccaller})
exten => X.,n,Set(CDR(cccaller)=${cc_caller})

Step # 4

You need to restart asterisk to apply such changes.
answered Jun 12 by Sam (1,380 points)

Related questions

0 like 0 dislike
2 answers
asked May 27, 2014 in Education & Reference by Yogi (180 points) | 88 views
1 like 0 dislike
1 answer
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

Mathe Forum Schule und Studenten
1,164 questions
1,304 answers
275 comments
1,589 users