Versions Compared

Old Version 5

changes.mady.by.user David Klein

Saved on

compared with

New Version 6

changes.mady.by.user David Klein

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description:

Tip

This article will show you how to do the following.

  • Column reference settings
  • How to bulk add new users with or without devices, softphones, and feature keys with the Audian excel sheet.Column reference settings

CSV File: Audian-CSV-Sheet.xlsx

Column Reference:

ColumnNecessity

Field Description

Required
Settings

first_name

Required

A name

last_nameRequiredA name
emailRequired

An email address

extensionRequiredA number up to 4 digits long
passwordRequiredA combination of letters, numbers, and symbols
mac_addressOptionalThe MAC address of the phone
brandOptional

No Device: Can be left blank or labeled as None

Device: Reference the list of valid brands located in the Audian-CSV-Sheet

familyOptional

No Device: Can be left blank or labeled as None

Device: Reference the list of valid families located in the Audian-CSV-Sheet

modelOptional

No Device: Can be left blank or labeled as None

Device: Reference the list of valid models located in the Audian-CSV-Sheet

softphoneOptional

No DeviceSoftphone: Can be left blank or labeled as no

DeviceAdd Softphone: label the cell as yes

Methods:

Info
iconfalse
Expand
title1. How to Fill Out The Form

Description: The form uses data validations to include all of the devices Audian have configuration files for. You will need to copy these fields in order to add more users.

  1. Open the Audian-CSV-Sheet.
  2. Determine how many users you would like to add then select the brand, family, model, and softphone cells labeled as None.
  3. Hover your mouse pointer over the bottom right corner of the selected cells where the green square is located, you should see a + symbol appear.

  4. Click and drag the mouse down equal to the number of users you would like to add and then release the click.

  5. Next, fill out the rest of the fields for each user you would like to add.

    Note

    all of these fields besides MAC_Address are required and will cause an error if left blank in the CSV app.

  6. Use the dropdowns for For each new user assign the brand, family, and model to determine what phone each user is assigned to by clicking on the drop-down for each cell.

    Note

    If you do not see the a specific device on in the list then the user will need to be added in manually, leave the device section blank and add it from inside the Smart PBX app.

  7. Set the softphone cell to yes for if the users who need softphones.
    Image Added

  8. Save the file as a CSV format.
Info
iconfalse
Expand
title2. How to Bulk add Users, Devices, and Feature Keys
  1. Log in to the Audian Portal.
  2. Click on the Apps button and select CSV Onboarding app.
  3. Click on the link or drag and drop the file to upload it.
  4. Click on the Proceed button.
  5. Click on the Proceed button again once you have verified the first 5 entries and if no error messages are prompt.
    Image Added
  6. Use the drop-downs to add feature keys as needed for all the new usersdevices.
  7. Click the Proceed button again to apply the feature keys or press cancel to not add feature keys.