|
Arrow Telecom's ArrowBilling Rate Table Upload Guide (version 1.5) |
PDF
|
| Print |
|
Creating New Rate Table from FileCreating 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 ImportInformation 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: - Origin - country code or * for all origins;
- Destination - country code;
- Description - destination country name;
- Status - 1 to enable this destination, 0- to block calls to this destination;
- Base - 1 if item is Base Item, 0- if item is Dependant Item;
- Rate per minute - units per minute, use . (point) as separator;
- Rate per call - units per call, use . (point) as separator;
- Currency ID - numeric value;
- 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 - format: HH:MM:SS, 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 actually call will last while using some IVR - enabled devices. Integer value between 1 and 60, default is 60 (seconds)
- 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;
- 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;
- 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.
ExamplesExample 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.
|
|
|