Page Comparison

Description:

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:

...

Column Necessity Required
Settings
first_name
Required
A name
last_name Required A name
email Required
An email address
extension Required A number up to 4 digits long
password Required A combination of letters, numbers, and symbols
mac_address Optional The MAC address of the phone
brand Optional
No Device: Can be left blank or labeled as None
Device: Reference the list of valid brands located in the Audian-CSV-Sheet
family Optional
No Device: Can be left blank or labeled as None
Device: Reference the list of valid families located in the Audian-CSV-Sheet
model Optional
No Device: Can be left blank or labeled as None
Device: Reference the list of valid models located in the Audian-CSV-Sheet
softphone Optional
No Device: Can be left blank or labeled as no
Device: label the cell as yes

Methods:

Info

icon	false

false

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

Expand

title	1. 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.

Open the Audian-CSV-Sheet.
Determine how many users you would like to add then select the brand, family, model, and softphone cells labeled as None.
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.
Click and drag the mouse down equal to the number of users you would like to add and then release the click.

Warning

icon

Adding users without labeling the devices Brand as None even if the user does not have one will result in an error. The same can be said with the softphone column if it is not set to no or yes.

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

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.

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

Info

icon	false

Expand

title	2. How to Upload the Form

Versions Compared

Old Version 2

New Version 3

Key

Description:

Column Reference:

Methods:

Column	Necessity	Required Settings
first_name	Required	A name
last_name	Required	A name
email	Required	An email address
extension	Required	A number up to 4 digits long
password	Required	A combination of letters, numbers, and symbols
mac_address	Optional	The MAC address of the phone
brand	Optional	No Device: Can be left blank or labeled as None Device: Reference the list of valid brands located in the Audian-CSV-Sheet
family	Optional	No Device: Can be left blank or labeled as None Device: Reference the list of valid families located in the Audian-CSV-Sheet
model	Optional	No Device: Can be left blank or labeled as None Device: Reference the list of valid models located in the Audian-CSV-Sheet
softphone	Optional	No Device: Can be left blank or labeled as no Device: label the cell as yes

Page Comparison

Versions Compared

Old Version 2

New Version 3

Key

<span class="diff-html-removed" data-a11y-before="Start of deleted content" data-a11y-after="End of deleted content" id="removed-diff-0">[data-colorid=wy7s221tzl]{color:#333333} html[data-color-mode=dark] [data-colorid=wy7s221tzl]{color:#cccccc}</span>Description:

Column Reference:

Methods:

Description: