How do I bulk add or remove DL/DA on phone numbers?




Directory Listing and Directory Assistance (DL/DA) makes a phone number, user information, and/or address available in the local White Pages, via 411 assistance, or both. This article explains how you can enable or disable the DL/DA feature on up to 5,000 phone numbers at once in the Bandwidth Dashboard. For API information, please see our developer docs

Looking to add or delete DL/DA on a single phone number? Check out how to add or remove DL/DA on a phone number.

Note: You can determine which of your phone numbers have DL/DA enabled by looking at the DL/DA Name and DL/DA Address columns in your Full Phone Number Details report.

How do I add DL/DA to phone numbers in bulk?

  1. Log into the Bandwidth Dashboard.
  2. In the top navigation bar, select Numbers and click My Numbers.
  3. Select Line Features and click the download a template .csv file link. This will download the CSV file into your web browser.

Line Features tab

Note: If you don’t see the file, please make sure your browser is set to allow pop-ups from the Bandwidth Dashboard and try again. If you still can’t locate it, check the Downloads section in your browser or the Downloads folder on your computer.

  1. Once you open the template, you'll see sample data that shows how the file needs to be filled out for various features. Please erase all information in rows 3-6 prior to entering your own. 
  2. In the TN | TN column, enter the phone numbers that you want to add to DL/DA. Please use the 10-digit format without spaces, parentheses, or dashes.
  3. In the DLDA | SubscriberType column, enter Business for a business customer, or Residential for a residential customer.
  4. In the DLDA | ListingType column, enter Listed if you want to update both DL and DA, or NonListed if you want to only update DA.
  5. In the DLDA | ListAddress column, enter TRUE if you want to include the address in the listing, or FALSE if you want to only display the name and phone number.
  6. In columns DLDA | FirstName, DLDA | FirstName2, and DLDA | LastName, enter the subscriber's name:
    • If this listing is for a business, type the first word of the business name in the DLDA | FirstName column, the second word of the business name in the DLDA | FirstName2 column, and the rest of the business name in the DLDA | LastName column.
    • If the listing is residential, type the resident's first name in the DLDA | FirstName column (if you'd like to add a joint name, such as Susan and William Jones, add the second name in the DLDA | FirstName2 column), and put the last name in the DLDA | LastName column.

Template CSV DLDA columns

  1. Leave columns DLDA | Designation through DLDA | PlaceListingAs blank.
  2. In the DLDA | ServiceType column, enter New.

Template CSV DLDA columns

  1. In columns ADDR | HousePrefix through ADDR | Zip+4, enter the address information. You can leave any non-applicable address fields blank.

Template CSV ADDR columns

  1. Once you're done, save the file in the .csv format and return to the Line Features tab.  
  2. Drag and drop the file into the Choose a .csv file to import field or click Browse to search for it on your computer.
  3. Enter an optional Customer order ID that can be used to identify any orders created as a result of this file import.
  4. Click Import to upload your file.

Note: If you encounter any errors, please double-check that the formatting is correct. Errors may occur due to an incorrect file type (anything other than .csv), spaces in the file name, or formatting issues in the file itself. 

It may take up to 72 business hours for the information to populate to 411, and up to one business week for it to be added to the local White Pages database. Printed information will appear in the next local White Pages book release, as long as it was provided to the book publisher before the print cut-off date.

How do I remove DL/DA from phone numbers in bulk?

To remove DL/DA from multiple phone numbers or to confirm whether it's already been removed, please open a ticket with your Bandwidth Support Team.

Article is closed for comments.