Bulk Import Phone Numbers

Need to add multiple phone numbers to an account, but don't have a lot a time? Bulk import enables you to quickly activate bulk phone numbers on the account by importing (uploading) a .csv file, eliminating the need to add each phone number individually.

Using the bulk import tool, you can port phone numbers from other carriers or activate new numbers on the account from local or dynamic inventory or via BYOTN. This template cannot be used to assign phone numbers to users.

Quick Links

• Bulk Import Steps
• Import Summary Email
• Activation Status and Alerts
• Troubleshooting
  • File Errors
  • Output Errors
  • 
    

Bulk Import Steps

The process is simple, but it’s important to fill out the template correctly. Read through each step below to learn how to use the template, upload it to the portal, and troubleshoot any errors.

1. In the Admin Portal, go to Account > Phone Numbers.
2. Click the menu in the top right and select Bulk Import Phone Numbers.
3. Click [Import Phone Number Template] to download a blank .csv file.
4. Fill out the required fields for each phone number or group of numbers you want to import, then save your changes. See Bulk Import Phone Numbers Fields for a template with example data and descriptions of each field.
5. Upload the completed file to the account.
6. On the Bulk Import Phone Numbers page, either drag and drop the file from your computer to the upload area or click the link in the upload area, then select the file from your computer and click [Open].
   
7. Before the file is applied to the account, it’s scanned for syntax errors, such as an incompatible file type or invalid column headers.

   • File uploaded successfully. If no errors are detected and you're sure the information in the file is correct, click [Submit] to process it. Proceed with caution; once the file is submitted, the action cannot be canceled or reversed.

   • File import failed. If one or more errors are detected, click the button to download the report, then resolve the errors and re-upload it when you're done. 

8. Once submitted, the phone numbers are added to the account as each row is processed. Small files will take a few seconds, while large files may take a few minutes. Do not retry the upload during this time.
   
   Wait until you receive the summary email (below) before refreshing the Phone Numbers page to see all the numbers added to the account.
   

   For more information, see Bulk Import Phone Numbers Fields.

Import Summary Email

When the file is finished processing, an email is sent to you with a summary of the results. If any phone numbers could not be added, the email will contain a link to an error report. Click the link to download the report and use it to resolve the issues in your import file. The link is valid for 15 days.

Activation Status and Alerts

Now that your import is complete, you can refresh the Phone Numbers page in the Admin Portal to manage the numbers that were successfully added to the account.

For each phone number, two “In Progress” activation banners are displayed on the page, one for the phone number and another for the 911 Service Request (E911 address) until the activation is complete.

If any of the numbers require further action, such as a 911 service request rejection, the error(s) will be displayed here and in Management > Service Activation. Click [Edit] on the banner to modify the address and resubmit.

Troubleshooting

The following information is an overview of how to resolve the most common errors that occur during each phase of the import. If you have any questions or need help troubleshooting an error, please contact Technical Support.

File Errors

The import file must meet certain requirements before it can be applied to the account. These are the most common errors that occur during the pre-validation phase.

Output Errors

Once an import file is submitted, all phone numbers that can be added to the account will be. However, if any rows could not be added during processing, you can fix the import file and try again.

1. Open the error report and your import file side by side, then use the error report to locate the problematic fields: Column A is the error message and column B is the affected row.
   
2. Next, resolve the error(s) in each field. The error message should be self-explanatory. For example, "TelephoneNumberRequired" means that a required phone number is missing, so you need to enter a number in the Phone Number field. However, if you don't know how to resolve an error, compare what you've entered in that field to the Field and Descriptionstable in Bulk Import Phone Numbers Fields to see if you can pinpoint the issue.
3. Before you re-import the file, remove all rows that were successfully added in the previous session. Duplicate phone numbers will result in more errors.
4. Finally, save your updated file and import it to the account.