Upload Connectivity Rates

Upload Rates allows an operator to import an Excel file containing connectivity rates to be charged a customer for local connectivity or for a customer who has roamed to another country or PLMN. The Excel file contains the rates of all services offerings, such as SMS volume and Data streaming.

NOTE: The rates imported apply to the provider root account. However, the connectivity rates of the Excel file are also applied to the operator’s sub accounts.

The following is an example of an Excel file of connectivity rates that may be uploaded and applied:

Attribute Description
Provider IMSI provider alias (Provider 1, 2, etc.); in the selected Country. Each alias replaces a specific provider, as defined by each operator.
Country The country where the sub-account is operating
Operator Local operator that the IMSI is roaming on
PLMN Operator code (combining country and operator):
  • When provided, the connectivity rate is applied to that specific operator
  • When not provided, the connectivity rate is applied to the entire Country (including all operators within that Country)

Note: Requires authorization.
smsOut Rate charged for a single SMS messageRange: Decimal numerical value
  • Mandatory if Data/MB is not provided
smsOutPriceType Range:
  • Percentage_Markup: Percentage markup value
  • Monetary_Markup: Monetary markup value
  • Fixed_Price: Monetary fixed amount
  • Block(ed): Do not allow SMS service
Data/MB Rate charged for 1 MB of data Range: Decimal numerical value
  • Mandatory if smsOut is not provided
dataPriceType

Range:

  • Percentage_Markup: Percentage markup value
  • Monetary_Markup: Monetary markup value
  • Fixed_Price: Monetary fixed amount
  • Block(ed): Do not allow Data service
Currency

The payment currency

  • Ignored if sms/dataPriceType is set at Percentage_Markup or Block
gsm2g Not active
gprs Not active
umts3g Not active
lte4g Not active
chargeIntervalData
  • Decimal numerical value:
  • Units: KB units
  • Default: 1 KB
chargeIntervalVoice

Decimal numerical value:

  • Units: seconds
  • Default: 1 second
  • The connectivity rates are defined by:
  • IMSI provider
  • Country
  • Operator within each country
  • PLMN

NOTE: Each country can have multiple operators and multiple PLMNs.

The connectivity rates are charged per service type and the currency of the transaction is also defined in the Excel file.

The Upload Rates functionality supports these features:

  • Full upload that replaces all current rates
  • Editing of specific PLMN rates without replacing other effective rates
  • Deleting specific PLMN rates
  • Block individual PLMN so that no SIM in the PLMN can be connected
  • All uploads are effective immediately with no latency

To upload the Connectivity Rates Excel file:

  1. Click Select Account |Sub-Account
  1. Click the Upload button. The Upload IMSI Rates Sub-Account dialog is displayed.
  1. Click Upload Mode and select the desired Upload action from the list:
    • New/Update: New rates that have been added to the Excel file, but not yet loaded into the system, are added. Existing rates whose values have been changed in the Excel file, but not yet updated in the system, are updated.
    • Delete: PLMN rates in the Excel file delete the same PLMN rates from the system; PLMN rates not in the Excel file are not deleted from the system.
    • Full Upload: Replace all existing system account rates with those in the Excel file. New PLMN rates that are in the Excel file, but not in the system, are added. PLMN rates that exist in both the Excel file and in the system are updated with the values in the Excel file. PLMNs with Fixed rates that are in the system, but not in the Excel file, are reset to the parent default rate + set markup.
  1. Click Select IMSI Provider and select the relevant IMSI provider.
  1. Browse or drag the Excel file into the Drag Your Files field and click Upload. The Excel file is uploaded, and the action is executed in the background. Viewing the changes in the UI can take up to 30 seconds.

NOTE: The Excel file is automatically validated when you upload it. An appropriate error message indicates any errors, for example, when you attempt to upload an Excel file with a PLMN that is not available to you.