Rate Table Upload Guide 1.4
Thursday, 01 June 2006

Creating New Rate Table from File

NOTE! This guide applies to ArrowBilling versions 1.4 and earlier. For guide to version 1.5 and higher, please see this link.  

Creating huge rate tables may be time consuming when using the web interface. Therefore the Arrow Billing system provides tools for importing tables from the computer created with external applications.

Please note that the link for Rate Table Upload is located in the Rates section of the left navigation menu.

File Format for Rate Table Import

Information in the file to be uploaded must be ordered in rows with one Rate Item in each row.

File format is plain text. Rows must end with "carriage return" character. Fields must be separated with "TAB" character. There should not be any header row or empty rows in the table.

The fields are in following order:

  • Origin: Country code or * for all origins.
  • Destination: Country code.
  • Description: Destination country name.
  • Base: 1 if the item is Base Item, 0 if the item is Dependant Item.
  • Rate per minute: units of cost per minute, use decimal point as separator.
  • Rate per call: units of cost per call, use decimal point as separator.
  • Currency ID: Numeric value of the currency (1 for USD).
  • Start Weekday: 0-Sunday, 1-Monday, ... , 6 - Saturday; must be 0 for Base Items.
  • End Weekday: 0-Sunday, 1-Monday, ... , 6 - Saturday; must be 6 for Base Items.
  • Start Time: Format: HH:MM:SS; must be 00:00:00 for Base Items.
  • End Time: Same format as previous field; must be 23:59:59 for Base Items.
  • Increment Seconds: Integer value starting from 1.
  • Grace Seconds: Integer value starting from 0.
  • Minimum Charge Seconds: Integer value starting from 0.
  • Minute Flex (optional field): Used to declare longer call times than the time the call will last for while using some IVR - enabled devices. Integer value between 1 and 60, default is 60 (seconds).
An example of destination having discounted rates during off-peak times is provided below. Note that one destination contains six rows: one with Base = 1 and five with Base = 0. If you do not need different rates depending on time of day or day of week, only first row should be used.

Orig Dest Descr Base RateMi RateCal Curr Stday Endday Sttime Endtime Incr Grace MinDur MinFlex
* 1 USA 1 0.045 0.0 2 0 6 00:00:00 23:59:59 1 0 1 60
* 1 USA 0 0.06 0.0 2 1 1 07:00:00 19:59:59 1 0 1 60
* 1 USA 0 0.06 0.0 2 2 2 07:00:00 19:59:59 1 0 1 60
* 1 USA 0 0.06 0.0 2 3 3 07:00:00 19:59:59 1 0 1 60
* 1 USA 0 0.06 0.0 2 4 4 07:00:00 19:59:59 1 0 1 60
* 1 USA 0 0.06 0.0 2 5 5 07:00:00 19:59:59 1 0 1 60


IMPORTANT
  • When creating Rate Table with Microsoft Excel, save file as Text (Tab delimited)(*.txt).
  • Before saving make sure that there are no header rows in worksheet.



Digg!Del.icio.us!Slashdot!Technorati!Free social bookmarking plugins and extensions for Joomla! websites! title=
 
[ Back ]