Rate export

Link copied to clipboard

If you’re a wholesale service provider, you need to regularly update customer rates and send these updates to your customers (carriers whose calls are terminated to your network). You can download rates in a specific file format and structure with rate export functionality. It eliminates manual file processing and allows sending the exported rates to your customers right away. Let’s say you need to send files with up-to-date rates to your wholesale customers in a specific format and structure. To save time on editing the file with rates each time you download it, you create a rate download template and customize it:

  • Specify the output file format (e.g., .xls).
  • Remove unneeded columns (e.g., “Off-peak First Price”, “Off-peak Next Price”, and other off-peak related columns).
  • Change the column order (e.g., move the “First Price” column next to the “Destination” column).
  • Set the custom date format and remove a timestamp (e.g., the European date format (DD-MM-YYYY) for the “Effective From” column).

This chapter provides instructions on how to set up your template and download ready-to-send files with either all the tariff rates or specific ones.

Create rate download template

Link copied to clipboard
  1. Go to My company and select Templates.

    Select My company and click Templates

  2. Open the Create a template panel and fill in the template details:
    • Name – type the template name, e.g., “Wholesale customers”.
    • Type – select Rate download.
    • File format – select the format, in our example Microsoft Excel 1997-2003 (.xls).
    • Tariff type – select Normal. The tariff type defines the default set of data fields in the template.
      • Normal – the default template for rate download.
      • Quantity-based – the rate download template for a tariff used for quantity-based services (IPTV, messaging service, data service, etc.).
      • Routing – the rate download template for a vendor tariff with routing enabled.
  3. Click Save.

    Create a template

Customize rate download template

Link copied to clipboard

On the Template panel, click Columns and configure the data fields on the Columns data fields panel. Columns data fields

Remove unneeded columns

Link copied to clipboard

Exclude “Off-peak First Price”, “Off-peak Next Price”, and other off-peak related columns from the template.

  1. Hover over the “Off-peak First Price” data field and click Edit edit.
  2. In the Edit data field dialog, select None in the Column field.
  3. Click OK.

    Edit data field - remove

  4. Repeat the steps 1-3 to remove other columns.

Change the column order

Link copied to clipboard

Move the “First price” column next to the “Destination” column.

  1. Hover over the “First price” data field and click Edit edit.
  2. In the Edit data field dialog, specify “B” in the Column field, which means that this will be the second column in the output file.
  3. Click OK.

    Edit data field - change the order

Set the custom date format and remove a timestamp

Link copied to clipboard

Change the date format to European (DD-MM-YYYY) for the “Effective From” column.

  1. Hover over the “Effective From” data field and click Edit edit.
  2. In the Edit data field dialog, open the Format dropdown list, select Other:
  3. Specify “DD-MM-YYYY” in the Formatting rule field.
  4. Click OK.
  5. Click Save.

    Edit data field - formatting rule

    Refer to Template data fields chapter for more information.

Set the template as default for a specific tariff

Link copied to clipboard
  1. Go to the Service catalog and select Tariffs.
  2. Open a specific tariff, e.g., “Termination price list”.
  3. On the Tariff panel, click Upload/download configuration.
  4. In the Web download template dropdown list, select the “Wholesale customers” template.
  5. Click Save.

    Web download template

Download rates using custom template

Link copied to clipboard
  1. Open the “Termination price list” tariff and click Rate download on the toolbar.

    Rate download from tariff panel

  2. In the Rate download dialog, click Download.

    The “Wholesale customers” template is already selected, as it’s assigned to the tariff as default.

    Rate download with the template assigned

    The rate download operation is scheduled.

  3. Once the file is ready, you get a Notification notification icon. Open the notification panel and click Download.

    Notification for download

    Now, you can send the downloaded file with up-to-date rates to customers’ emails.

    Downloaded file with up-to-date rates

You can use a quicker way to download the customer rates:

  1. Go to Service catalog > Tariffs.
  2. On the Tariff list panel, select a specific tariff, e.g., “Termination price list” and click Rate download file download.

    Rate download from tariff list

Download specific rates

Link copied to clipboard
  1. Go to Service catalog, select Tariffs and open a specific tariff, e.g., “Termination price list”.
  2. On the Tariff panel, click Rates.
  3. On the Rate search panel, filter the rates, e.g., by the Destination group “Europe”.
  4. On the Rate list panel, select checkboxes for specific rates.
  5. Click Download on the toolbar.

    Download specific rates

  6. Repeat the steps 2 and 3 from the Download rates using custom template section.

    The file with specific rates is downloaded. You can send this file to customers’ emails.

    Downloaded file with selected rates

On this page