Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Wed Sep 18, 2019 10:35 pm
Auto Dialer Software


All times are UTC




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: automating data collection, call Reports
PostPosted: Thu Feb 27, 2014 12:23 pm 
Offline

Joined: Thu Feb 27, 2014 11:57 am
Posts: 2
HI all,

At the end of each month I am finding myself login into A2Billing portal going to Call Reports->cdrs, picking a client, selecting dates and exporting as CSV. We have a lot of clients and the whole process is tedious.

Would anyone be able to advise me on how can I automate it? Is there any API I could use?

I have programming experience, not so much in PHP mostly Ruby but i can understand the code, and I am looking for some suggestions as of which direction I should go?

Are there any ready solution for this?
Where should I start looking if I would like to create the service that would connect to A2Billing and export cdrs automatically?

I haven't done a lot of research yet, I just started to think about it and I am hoping that maybe someone would be able to save me some research time.

Thank you for any suggestions.

Lukasz.


Top
 Profile  
 
 Post subject: Re: automating data collection, call Reports
PostPosted: Fri Feb 28, 2014 9:19 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi

It should be possible to create a MySQL query that selects all the CDR on a per customer basis and downloads them to a text file. It should be then quite straightforward to email them to you. This can all be done via a shell script and cronjob, although other programming languages can be used.

Joe


Top
 Profile  
 
 Post subject: Re: automating data collection, call Reports
PostPosted: Sat Mar 08, 2014 3:01 pm 
Offline

Joined: Thu Feb 27, 2014 11:57 am
Posts: 2
Hi Joe,

Thank you for your replay.
I will look in to this.

I have looked at the code today and it seams that cc_call table is the main table for cdr's.

Would you, or someone else, be able to confirm that cc_call table is all I need for what I have described earlier? I dont have access to the system at the moment and I would be able to thinker about it over the weekend and test it on Monday.

Thank you,
Lukasz.


Top
 Profile  
 
 Post subject: Re: automating data collection, call Reports
PostPosted: Sat Mar 08, 2014 4:59 pm 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi

cc_call does contain the CDR, but you may have to be doing some inner joins to get customer and destination information.

Joe


Top
 Profile  
 
 Post subject: Re: automating data collection, call Reports
PostPosted: Sun Mar 09, 2014 2:18 pm 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
Someone wrote this a while back that you may be able to use as a starting point - http://sysadminman.net/blog/2012/a2bill ... spend-3774

It doesn't extract the actual CDRs, but does do a monthly usage report that can be used to generate invoices externally.


Top
 Profile  
 
 Post subject: Re: automating data collection, call Reports
PostPosted: Thu Mar 20, 2014 2:47 pm 
Offline
User avatar

Joined: Tue Dec 09, 2008 4:05 am
Posts: 95
Location: Canada
We simply do this in phpmyadmin. Export the cc_call table to csv. Match the a2billing account ID with a customer in our database and invoice.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 
VoIP Billing solution


All times are UTC


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group