Difference between revisions of "ATI - Deutsche Telekom example"
| Line 30: | Line 30: | ||
<br><br> | <br><br> | ||
As you can see, there are two tabs on this page: Primary Data and Secondary Data. | 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) | For Primary data, we will use Worksheet 1 (DTGC Hubbing Rates) | ||
<br><br> | <br><br> | ||
| Line 50: | Line 51: | ||
<br><br> | <br><br> | ||
Secondary data will be imported from worksheet 2 and worksheet 3. | 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. | The structure is a bit complicated because the rate of destination is based on the country of origin. | ||
Will be created [[M4_Rates#CLI_Groups|CLI Groups]] , Name of the groups is Worksheet 2 Column C, which is mapped with column A in the Worksheet 3 | Will be created [[M4_Rates#CLI_Groups|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 | and a list of the prefixes belonging to the Cli Groups is in Column A of Worksheet 3 | ||
| Line 72: | Line 74: | ||
<br><br> | <br><br> | ||
[[M2TIImage109.png]] | [[File:M2TIImage109.png]] | ||
<br><br> | <br><br> | ||
Revision as of 05:48, 24 October 2025
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
