ATI - Deutsche Telekom example
Step-by-step example for Deutsche Telekom Tariff
1. Review Deutsche Telekom XLSX tariff structure
We can see that the XLSX document consists of three Worksheets: Worksheet 1 (DTGC Hubbing Rates), Worksheet 2 (Origin Rates) and Worksheet 3 (Origin Dialcodes).
2. Go to BILLING > Tariff Import > Import Rules > Templates to create a new Template
3. Configure Template for Deutsche Telekom XLSX structure
As you can see, there are two tabs on this page: Primary Data and Secondary Data. Do not confuse them with Worksheets, they are not related.
For Primary data we will use Worksheet 1 (DTGC Hubbing Rates)
Destination/Zone Column A, Prefix/Code Column B, Effective Date Column D
Rate Column C , Minimal Time second value from 0/1/1 and Increment third value from 0/1/1 in the Column E
Secondary data will be imported from worksheet 2 and worksheet 3. The structure is a bit complicated because the rate of destination is based on the country of origin. Will be created CLI Groups , Name of the groups is Worksheet 2 Column C, which is mapped with column A in the Worksheet 3 and a list of the prefixes belonging to the Cli Groups is in Column A of Worksheet 3
Explanation: Rate sheet 2 Headers rows 14 on worksheet 2, Prefix/Code Column B, Destination/Zone Column A CLI Group Column C and mapped with Worksheet 3, Headers rows 14 Columns A and B. Effective Date Column E
Rate Column D , Minimal Time and Increment Column F
Everything is ready and you can press button to save this template
