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

From Freeside
Jump to: navigation, search
m
 
(8 intermediate revisions by 5 users not shown)
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''' - You can edit regions/prefixes, rates and rate plans under ''Configuration | Billing | View/Edit call rates and regions''
  
Line 10: Line 11:
 
** Don't change the "Region rating method"
 
** Don't change the "Region rating method"
  
* The current way to get CDR records into the internal CDR tables is under ''Tools | Import | Import Call Detail Records (CDRs) from CSV file''
+
* 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.
 +
 
 +
* cdr.charged_party from imported CDRs is matched to svc_phone.phonenum in a provisioned phone service
  
 
* 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)''
  
 
* 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.
 +
 +
=== See Also ===
 +
 +
* [[:3rd_party_software/Asterisk]] Discusses how cdr_pgsql is setup to record CDR entries into Freeside.
 +
[[Category:svc_phone]]

Latest revision as of 11:56, 26 February 2008

  • 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

  • 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.
  • Package definitions (Configuraiton | Provisioning, services and packages | View/edit package definitions) - Package definitions for VoIP are setup using the "VoIP rating by plan of CDR records in an internal SQL table" price plan. The "or external" part doesn't work yet, but everything should be in place for it.
    • Pick a "Rate plan" from above.
    • Make sure to set a "Recurring fee frequency"
    • Don't change the "Region rating method"
  • You can import CDRs directly into the Freeside database using cdr_pgsql or 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.
  • cdr.charged_party from imported CDRs is matched to svc_phone.phonenum in a provisioned phone service
  • You can view simple reports of CDRs (unprocessed vs. processed) under Reports | Rating data | Call Detail Records (CDRs)
  • 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.

See Also