Difference between revisions of "Freeside:3:Documentation:Administration:VoIP"

From Freeside
Jump to: navigation, search
Line 1: Line 1:
* '''Rate plans''' - You can edit regions/prefixes, rates and rate plans under ''Configuration | Billing | View/Edit call rates and regions''
+
= Rate plans =
** Sample scripts for importing initial rate information are available in <code>bin/rate.import</code> and <code>bin/rate-us.import</code>
+
* You can edit regions/prefixes, rates and rate plans under ''Configuration | Billing | View/Edit call rates and regions''
** Region groups can be used to group regions together for included minute billing
+
* Sample scripts for importing initial rate information are available in <code>bin/rate.import</code> and <code>bin/rate-us.import</code>
 +
* Region groups can be used to group regions together for included minute billing
  
* '''Service definitions''' ''(Configuration | Provisioning, services and packages | View/edit service definitions)'' - Service definitions for VoIP are setup as '''svc_phone''' services.  Set '''countrycode''' to "fixed (unchangeable)" and to your country code ("1" for US, Canada, NANP countries).  <strike>You can optionally use the inventory stuff to assign DID#s from a pool for svc_phone services.</strike>  You can optionally use an internal_did export to assign DID#s from the internal phone number inventory.
+
= Service definitions =
 +
* ''(Configuration | Provisioning, services and packages | View/edit service definitions)'' - Service definitions for VoIP are setup as '''svc_phone''' services.  Set '''countrycode''' to "fixed (unchangeable)" and to your country code ("1" for US, Canada, NANP countries).  <strike>You can optionally use the inventory stuff to assign DID#s from a pool for svc_phone services.</strike>  You can optionally use an internal_did export to assign DID#s from the internal phone number inventory.
  
* '''Package definitions''' ''(Configuraiton | Provisioning, services and packages | View/edit package definitions)'' - Package definitions for VoIP are setup using the "VoIP/telco CDR rating (standard)" price plan.
+
= Package definitions =
** Pick a "Rate plan" from above.
+
* ''(Configuraiton | Provisioning, services and packages | View/edit package definitions)'' - Package definitions for VoIP are setup using the "VoIP/telco CDR rating (standard)" price plan.
** Make sure to set a "Recurring fee frequency"
+
* Pick a "Rate plan" from above.
** Don't change the "Region rating method"
+
* Make sure to set a "Recurring fee frequency"
** Minutes included when using the "single price per minute" or "prefix" rating method: Can be used to offer free minutes in packages.
+
* Don't change the "Region rating method"
 +
* Minutes included when using the "single price per minute" or "prefix" rating method: Can be used to offer free minutes in packages.
  
* '''Pre-rating CDRs''' - The daemon freeside-cdrrated runs continuously, searches for CDRs which can be pre-rated, and rates them.  CDR's will only be pre-rated when the charged_party or source number of the CDR matches a configured svc_phone service within Freeside.
+
= Pre-rating CDRs =
** Configuration options
+
* The daemon freeside-cdrrated runs continuously, searches for CDRs which can be pre-rated, and rates them.  CDR's will only be pre-rated when the charged_party or source number of the CDR matches a configured svc_phone service within Freeside.
*** cdr-prerate: Enables pre-rating of CDR's (Freeside restart required)
+
* Configuration options
*** cdr-prerate-typenums: Determines which CDR's will be pre-rated
+
** cdr-prerate: Enables pre-rating of CDR's (Freeside restart required)
** Current configuration incompatibilities
+
** cdr-prerate-typenums: Determines which CDR's will be pre-rated
*** Included minutes: Not considered when pre-rating CDR's.
+
* Current configuration incompatibilities
*** bill_inactive_svcs: CDR's can only be pre-rated when the charged party or source matches an existing,non-canceled svc_phone service.
+
** Included minutes: Not considered when pre-rating CDR's.
 +
** bill_inactive_svcs: CDR's can only be pre-rated when the charged party or source matches an existing,non-canceled svc_phone service.
  
* You can import CDRs directly into the Freeside database using [http://www.voip-info.org/wiki/view/Asterisk+cdr+pgsql cdr_pgsql] or [http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql cdr_mysql], or you can import CDRs from CSV files under ''Tools | Import | Import Call Detail Records (CDRs) from CSV file''.  Both methods have been used with success.
+
= Importing CDRs =
  
* cdr.charged_party from imported CDRs is matched to svc_phone.phonenum in a provisioned phone service
+
== Import methods ==
 +
 
 +
* You can import CDRs directly into the Freeside database using [http://www.voip-info.org/wiki/view/Asterisk+cdr+pgsql cdr_pgsql] or [http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql cdr_mysql]
 +
* You can import CDRs from CSV files under ''Tools | Import | Import Call Detail Records (CDRs) from CSV file''.
 +
* You can SCP / FTP / SFTP files from a remote server and import them with the freeside-cdr-sftp_and_import script
 +
 
 +
 
 +
* Typically, cdr.charged_party from imported CDRs is matched to svc_phone.phonenum in a provisioned phone service.  Other matching methods are available (accountcode, svc_pbx matching, etc.)
 +
 
 +
= Reporting =
  
 
* You can view simple reports of CDRs (unprocessed vs. processed) under '' Reports | Rating data | Call Detail Records (CDRs)''
 
* You can view simple reports of CDRs (unprocessed vs. processed) under '' Reports | Rating data | Call Detail Records (CDRs)''
 +
 +
= Toll free =
  
 
* 800/877/etc. calls should be correctly handled by rating based on the originating region rather than the destination region.  If you want toll-free usage to be billed at different rates than outgoing calls, you can use a different package definition and rate plan.
 
* 800/877/etc. calls should be correctly handled by rating based on the originating region rather than the destination region.  If you want toll-free usage to be billed at different rates than outgoing calls, you can use a different package definition and rate plan.
 +
 +
= Invoicing =
  
 
* To attach a CSV file of CDRs to customer invoices:
 
* To attach a CSV file of CDRs to customer invoices:
Line 31: Line 48:
 
** Enable the "Attach CDRs as CSV to emailed invoices" checkbox on one or more customers
 
** Enable the "Attach CDRs as CSV to emailed invoices" checkbox on one or more customers
  
=== See Also ===
+
== See Also ==
  
 
* [[:3rd_party_software/Asterisk]] Discusses how cdr_pgsql is setup to record CDR entries into Freeside.
 
* [[:3rd_party_software/Asterisk]] Discusses how cdr_pgsql is setup to record CDR entries into Freeside.

Revision as of 14:17, 10 December 2014

Rate plans

  • You can edit regions/prefixes, rates and rate plans under Configuration | Billing | View/Edit call rates and regions
  • Sample scripts for importing initial rate information are available in bin/rate.import and bin/rate-us.import
  • Region groups can be used to group regions together for included minute billing

Service definitions

  • (Configuration | Provisioning, services and packages | View/edit service definitions) - Service definitions for VoIP are setup as svc_phone services. Set countrycode to "fixed (unchangeable)" and to your country code ("1" for US, Canada, NANP countries). You can optionally use the inventory stuff to assign DID#s from a pool for svc_phone services. You can optionally use an internal_did export to assign DID#s from the internal phone number inventory.

Package definitions

  • (Configuraiton | Provisioning, services and packages | View/edit package definitions) - Package definitions for VoIP are setup using the "VoIP/telco CDR rating (standard)" price plan.
  • Pick a "Rate plan" from above.
  • Make sure to set a "Recurring fee frequency"
  • Don't change the "Region rating method"
  • Minutes included when using the "single price per minute" or "prefix" rating method: Can be used to offer free minutes in packages.

Pre-rating CDRs

  • The daemon freeside-cdrrated runs continuously, searches for CDRs which can be pre-rated, and rates them. CDR's will only be pre-rated when the charged_party or source number of the CDR matches a configured svc_phone service within Freeside.
  • Configuration options
    • cdr-prerate: Enables pre-rating of CDR's (Freeside restart required)
    • cdr-prerate-typenums: Determines which CDR's will be pre-rated
  • Current configuration incompatibilities
    • Included minutes: Not considered when pre-rating CDR's.
    • bill_inactive_svcs: CDR's can only be pre-rated when the charged party or source matches an existing,non-canceled svc_phone service.

Importing CDRs

Import methods

  • You can import CDRs directly into the Freeside database using cdr_pgsql or cdr_mysql
  • You can import CDRs from CSV files under Tools | Import | Import Call Detail Records (CDRs) from CSV file.
  • You can SCP / FTP / SFTP files from a remote server and import them with the freeside-cdr-sftp_and_import script


  • Typically, cdr.charged_party from imported CDRs is matched to svc_phone.phonenum in a provisioned phone service. Other matching methods are available (accountcode, svc_pbx matching, etc.)

Reporting

  • You can view simple reports of CDRs (unprocessed vs. processed) under Reports | Rating data | Call Detail Records (CDRs)

Toll free

  • 800/877/etc. calls should be correctly handled by rating based on the originating region rather than the destination region. If you want toll-free usage to be billed at different rates than outgoing calls, you can use a different package definition and rate plan.

Invoicing

  • To attach a CSV file of CDRs to customer invoices:
    • Enable the voip-cust_email_csv_cdr config option
    • Enable the "Attach CDRs as CSV to emailed invoices" checkbox on one or more customers

See Also