To upload a DID file, in the DID Inventory Upload dialog box, specify the file location (you can use the Browse button to select a file in the explorer dialog box).
Enable Update vendor costs for existing DIDs if you wish to modify the activation and / or periodic fees for the DIDs already in the inventory.
Click Upload.
Upon upload, the status of DIDs is Frozen. When they are frozen, they are stored in the DID inventory and are therefore unavailable for usage. To use DID numbers, perform one of the actions described in DID Inventory.
You can upload DID numbers from a .csv file. The structure of the .csv file should be as shown in the following table:
Field | Mandatory | Format | Description |
---|---|---|---|
DID Number |
Yes |
Number or text |
Phone number. |
Vendor Batch |
Yes |
Text |
Name of the vendor batch this DID belongs to. NOTE: The vendor batch must only be associated with vendors that have on-demand DID provisioning disabled. |
Description |
|
Text |
Description of a particular DID number. |
Activation Cost |
|
Number |
A one-time cost paid to a vendor for the DID number activation. |
Recurring Cost |
|
Number |
A monthly amount charged by a vendor for the provisioned DID number. |
Release Date |
|
YYYY-MM-DD HH:MM:SS Must be earlier than the upload date and time |
The date that this number was released from the customer it was previously assigned to |
FREE |
|
Y/N |
When a DID number is assigned to a customer or a reseller from this batch, no charges apply |
Country |
|
Two-letter country code (ISO 3166-1 alpha-2); “--“ for “Not Applicable” |
The country that this number belongs to. |
Area |
|
Text |
The area that this number belongs to. |
NOTE: A. The field order is important! B. The first row in the file is skipped, since it usually contains column titles and not actual data.
When importing DID numbers, PortaBilling® first checks that the country and area names from the file match the ones in the database. Then, if a typo is detected or if a country / area is absent from the file, PortaBilling® tries to find the destination that matches the DID number.
If there is no match in the destination list, the system adds the DID number as is (without the country / area set). For example, since there is no 1205 destination in the system, PortaBilling® adds 120566612345 without a DID country and area.
Let’s consider different cases and see how they work:
The 1205 – USA – Alabama destination exists in the system. The file that you upload contains the 120566612345 DID number.
PortaBilling® processes this DID during upload and adds it to the inventory as follows:
The country is defined, the area is empty or has a typo. PortaBilling® finds the destination and checks the country:
– the countries match. PortaBilling® sets the country and area based on the destination’s parameters (e.g. 120566612345 – USA – Alabama.)
– the countries do not match. PortaBilling® defines the country using information from the file.
For example, let’s say in the file you wrote Canada instead of USA with 120566612345 as the DID number. Since the area is absent, PortaBilling® checks the destination and detects that the countries do not match. So PortaBilling® adds this DID as Canadian without a defined area.
Note that if PortaBilling® detects a typo, the system corrects the typo and sends the notification.
The country is empty, the area has any value. PortaBilling® sets the country and area based on the destination’s parameters (e.g. 120566612345 – USA – Alabama).
Note that if the area is defined in the file, but not set for the destination, PortaBilling® considers the area as not defined.
For example, let’s say that 1205 has only the country set (USA) but in the file, you only wrote the area (Alabama) for the 120566612345 DID number.
Since the country is absent, PortaBilling® checks the destination and detects that the country is USA. However, there is no area specified for this destination. PortaBilling® then adds the country and replaces the area with an empty value (blank) and sends a notification to you. (e.g. 120566612345 – USA).
So, when PortaBilling® detects that a DID’s location is missing in the file, it tries to add it, based on the destination match. Otherwise, it adds the DID number without a location.