Versions Compared

Old Version 3

changes.mady.by.user David Klein

Saved on

compared with

New Version 4

changes.mady.by.user David Klein

Saved on

Key

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

...

Tip

This article will show you how to do the following.

  • 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:

ColumnNecessityRequired
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 Device: Can be left blank or labeled as no

Device: 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 the fields besides MAC_Address are required and will cause an error if left blank in the CSV app.

  6. Use the dropdowns for the brand, family, and model to determine what phone each user is assigned to.

    Note

    If you do not see the device on the list then the user will need to be added in manually.

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

...