Accessing CDR table

Accessing CDR table

Postby mariense » Sat Aug 02, 2014 9:42 pm

I need to be able to get the data in the asterisk CDR table (calls log) and write the details to a CRM.
Basically I want to record in the CRM when a user called a certain customer (date, time and duration).

Is this possible?
If not directly to the mySQL database, can it be done via the API?

Thanks in advance
mariense
 
Posts: 1
Joined: Sat Aug 02, 2014 9:37 pm

Re: Accessing CDR table

Postby Shuttle Team » Mon Aug 04, 2014 10:02 am

Hello,
there aren't API to access this data out of xCally Shuttle.
Anyway, as you correctly observed, this data can be read from the database "xcally", table "cdr".
If you prefer, you can access elaborated data in the table "call_log". The records with "status" equal to "DIAL" are Outgoing calls. The others are about Incoming calls.
The mysql user to access xcally database is
user: xcall
pw:xcall1234
Pay attention: any changes in the xcally database can cause malfunctioning in xCally Shuttle. Handle with care.

Best regards.

xCally Team
User avatar
Shuttle Team
 
Posts: 84
Joined: Mon Jun 16, 2014 3:14 pm


Return to Cally Square

Who is online

Users browsing this forum: No registered users and 1 guest

cron