Domain Statistics - Minute Usage, Cost Calculation, Adjustable Date Range

[Dan]

We have been developing a small Domain Statistics "app" for FusionPBX, to make accounting easier and provide a quick global usage overview. The main repository is on our Gitlab instance, with a mirror (Github) also available. There are a few other FusionPBX "apps" we should be pushing out as we document their workings better and clean up the provisioning process (many are for the Grandstream GXP2140 and newer), and we have begun to attempt to document the apps in the FusionPBX-Apps repository on Github.

Another app that complements this quite well is Domain Counts, it provides an overview of configured extensions, ring groups, IVRs and such. Let me know if you have any questions or comments, we are interested in extending this to be more useful as time goes on.

 

[Andrew Pickett]

This works great in 4.4.1 Thankyou

 

[Andrew Pickett]

I know its not a billing engine but how much work do you think it would take to apply a basic rate card tool. Im not even on about a full billing solution but it would be very useful to see in CDR's a call amount and then in your Domain App a total cost per domain based on this instead of your cost per minute. We have different cost per minute for all destinations as im sure most do.

Kind Regards

Andy

 

[Dan]

If your looking for proper billing for FusionPBX, I paid Finn years ago to build a billing app for FusionPBX. It has rough edges, we actually ended up on InvoicePlane with a few lines of scripting to handle toll free calls, leveraging the CDR API that Finn also wrote. His notes/complaints about FusionPBX's expectations and hooks for any app named billing are here and are definitely worth reading, I did not give Finn sufficient time to debug this app when I had him build it. It mostly works though...

I don't think there is much interest in building or paying to have built a proper billing app for FusionPBX, while I think its not the right funding model, the proprietary app does have a gofundme to make it open source. IMO funding for building & maintaining a billing system should use snowdrift.coop's model, as there is no incentive for maintenance of the app post-release via that GoFundMe.

 

[brickrat]

If your looking for proper billing for FusionPBX, I paid Finn years ago to build a billing app for FusionPBX. It has rough edges, we actually ended up on InvoicePlane with a few lines of scripting to handle toll free calls, leveraging the CDR API that Finn also wrote. His notes/complaints about FusionPBX's expectations and hooks for any app named billing are here and are definitely worth reading, I did not give Finn sufficient time to debug this app when I had him build it. It mostly works though...

I don't think there is much interest in building or paying to have built a proper billing app for FusionPBX, while I think its not the right funding model, the proprietary app does have a gofundme to make it open source. IMO funding for building & maintaining a billing system should use snowdrift.coop's model, as there is no incentive for maintenance of the app post-release via that GoFundMe.

I had a look at this, Getting errors all round in the app. (Failed to execute SQP Statement etc.)

 

[Dan]

I had a look at this, Getting errors all round in the app. (Failed to execute SQP Statement etc.)

What version of FusionPBX did you try this on, and could I get a copy of the errors? It is very hard to attempt to replicate the issue with no information, the post you wrote essentially says its broken without any useful info that I could use to attempt to recreate the breakage

Edit: Do you have any Call Detail Records yet? If no calls have been placed in any domain (for example on a new FusionPBX install), you will get a SQL error when accessing the Domain Statistics app.

 

[brickrat]

What version of FusionPBX did you try this on, and could I get a copy of the errors? It is very hard to attempt to replicate the issue with no information, the post you wrote essentially says its broken without any useful info that I could use to attempt to recreate the breakage

Edit: Do you have any Call Detail Records yet? If no calls have been placed in any domain (for example on a new FusionPBX install), you will get a SQL error when accessing the Domain Statistics app.

Hi. Inhave just been busy with family. Will send you some screenshots later on

 

[brickrat]

What version of FusionPBX did you try this on, and could I get a copy of the errors? It is very hard to attempt to replicate the issue with no information, the post you wrote essentially says its broken without any useful info that I could use to attempt to recreate the breakage

Edit: Do you have any Call Detail Records yet? If no calls have been placed in any domain (for example on a new FusionPBX install), you will get a SQL error when accessing the Domain Statistics app.

Hi

I am running Fusion 4.4.1
This is the app i am talking about - https://git.callpipe.com/fusionpbx/billing

First thing I get is file not found - and realised that the application is looking in a different folder for the files, not billing, So i corrected that by renaming the billing folder to "AccelerateBilling"

Now if I go to Billing->Invoice i get the following


If I go to Billing->Billing Domains i get the following


These are only 2 examples.

I dont know if the project was abandoned half way or has it changed.

 

[Dan]

This is the app i am talking about - https://git.callpipe.com/fusionpbx/billing

With regard to your first post, I thought you were referencing errors about Domain Statistics. This thread is about Domain Statistics discussion and support, not trying to have it go off on a tangent about/debugging our attempt to re-implement billing on FusionPBX 4.2 (circa 2 years ago).

A few pointers, there needs to be a contact for billing (in the contacts app) and the app defaults/ database schema needs to be updated, go to Advanced => Upgrade and choose Schema (likely part of the issue here), App Defaults and Menu Defaults. Another thing, to use the billing hooks that FusionPBX has (for now) the app must be named billing.

 

[brickrat]

With regard to your first post, I thought you were referencing errors about Domain Statistics. This thread is about Domain Statistics discussion and support, not trying to have it go off on a tangent about/debugging our attempt to re-implement billing on FusionPBX 4.2 (circa 2 years ago).

A few pointers, there needs to be a contact for billing (in the contacts app) and the app defaults/ database schema needs to be updated, go to Advanced => Upgrade and choose Schema (likely part of the issue here), App Defaults and Menu Defaults. Another thing, to use the billing hooks that FusionPBX has (for now) the app must be named billing.

Ok thnx