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 ,

The name of the groups is Worksheet 2 Column C, which is mapped with column A in 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

<be>

4. Go to BILLING > Tariff Import > Import Rules > Rate Import Rules to create Rate Import Rules

5. Configure Rate Import Rules according to your specifications

In this example we changed these values:

Max Increase: 50%. If the rate increase is higher than 50%, such a rate will be automatically rejected.

Max Decrease: 50%. If the rate increase is higher than 50%, such a rate will be automatically rejected.

Max Rate: 1.99. If the rate is higher than 1.99, such a rate will be automatically rejected.

6. Go to BILLING > Tariff Import > Import Rules to create Tariff Import Rules

7. Configure Tariff Import Rules according to your specifications

The minimum that you should change from default:

Rate Import Rules: set to Import Rules created in step 5.

Target Tariff: set to the Tariff you want to import rates into.

Import Template: set to Template created and configured in step 3.

Email/Attachment Validation: set to valid date for your Provider. The data in the screenshot is only an example and does not represent real values for Deutsche Telekom Provider.

8. Once email(s) will be received, you will see them in BILLING > Tariff Import > Inbox If the Tariff Import Rules have been correctly entered in the previous step, the Import Job will be created automatically.

9. Click on the Import Job link. This will redirect you to the Tariff Jobs page.

Here we can see that Tariff Job is waiting for confirmation and that there are 217883 rates to be updated and 202 rejected rates.

10. Click on the ANALYSIS link to view a detailed analysis

By default, the Tariff Job Analysis page shows only rejected Rates. There are rejected rates, because Max rate in the Rate import Rule is configured to 1.99

in this case, so we can press the CONFIRM button to import all not rejected rates or decide to import them all by reconfiguring the rate import templates and repeat the process. We decide to import all non-rejected rates and press CONFIRM

11. Go to BILLING > Tariff Import > Jobs to check the Tariff Jobs status again. We can see that status is Imported.

12. The process is completed. Let’s go to Billing > Tariffs to confirm this

We can see that 217681 (217883 total - 202 rejected) rates have been imported to Tariff Deutsche Telekom.