ArrowBilling Rate Table Upload Guide (version 1.5) PDF Print
Wednesday, 07 March 2007

Creating New Rate Table from File

Creating huge rate tables may be time consuming when using system's web interface. System provides tools for importing tables creating with external application.

Note. File upload link is located in Rates section.

File Format for Rate Table Import

Information in import file 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 header row or empty rows in the table.

The fields are in following order:

  1. Origin - country code or * for all origins;
  2. Destination - country code;
  3. Description - destination country name;
  4. Status - 1 to enable this destination, 0- to block calls to this destination;
  5. Base - 1 if item is Base Item, 0- if item is Dependant Item;
  6. Rate per minute - units per minute, use . (point) as separator;
  7. Rate per call - units per call, use . (point) as separator;
  8. Currency ID - numeric value;
  9. Start Weekday - 0-Sunday, 1-Monday, ... 6 - Saturday, must be 0 for Base Items;
  10. End Weekday - 0-Sunday, 1-Monday, ... 6 - Saturday, must be 6 for Base Items;
  11. Start Time - format: HH:MM:SS, must be 00:00:00 for Base Items;
  12. End Time - format: HH:MM:SS, must be 23:59:59 for Base Items;
  13. Increment Seconds - integer value starting from 1;
  14. Grace Seconds - integer value starting from 0;
  15. Minimum Charge Seconds - integer value starting from 0;
  16. Minute Flex (optional field) - Used to declare longer call times than actually call will last while using some IVR - enabled devices. Integer value between 1 and 60, default is 60 (seconds)
  17. Minimum Digits (optional field) - minimum number of digits in destination number (default 3). If called number will contain less digits than specified here, call will be rejected;
  18. Maximum Digits (optional field) - maximum number of digits in destination number (default 32). If called number will contain more digits than specified here, call will be rejected;
  19. Invoicing Group (optional field) - Name of destination group which will appear on invoices. This is text field, and is optional. The text displayed in this field can be used in invoices to display summary of usage.

Examples

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.

Short Format (Only required fields)

 

 

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

Full Format (All optional fields)

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


IMPORTANT

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



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