QUESTION Asterisk logs into

Costas

New Member
Joined
Jul 22, 2016
Messages
1
Reaction score
0
Hello, I have a setup of Asterisk with Elastix(v4) installed succeffully, working like a charm. In the intranet we have another server where we host our CRM program (works on MS SQL). I am looking for a way to insert the CDR logs/info from asterisk into the CRM DB so the CRM can make use of these data.

- I found that asterisk exports call logs on a file called master.csv and i could set a cronjob to insert the csv every eg 5mins. Such a solution would be helpfull if i had only the logs of the day.
- A developer suggested me to link the MySQL database into MS SQL - but in such a case will it be possible to create a new column (on the linked db) and write/update data that have been succeffully imported?
- Do you have another solition how i could collect the calls log and insert them in the MS SQL server?

Thanks in advance,
C
 

Members online

No members online now.

PIAF 5 - Powered by 3CX

Forum statistics

Threads
22,566
Messages
138,904
Members
14,673
Latest member
vicndf