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. Please 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 (Origin Rates) and worksheet 3 (Origin Dialcodes). 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