To add multiple devices using a *.csv or .xls file, Guide for user – Yealink RPS User Manual

Page 8

Advertising
background image

Guide for User

4 |

Yealink

3 Mass adding devices by uploading a Comma-Separated Value

(CSV) File

Through this feature, you can add a large number of MAC addresses at one time. You can save these
devices’ MAC addresses in a *.csv or *.xls file on your PC, and then upload it to the RPS.

To add multiple devices using a *.csv or .xls file

1. Open a new document using a spreadsheet application(i.e., Microsoft Excel™)
2. In the first column, enter the MAC addresses of the devices you want to add to the RPS. One example

is shown as Figure 3.1

Notes:

1

You must type the MAC addresses in the first column. Other columns will be ignored.

2

00-15-65-00-00-01 format is recommended. In addition, 001565000001, 00 15 65 00 00 01,
00:15:65:00:00:00:01 are also supported.(001565000001 format is not available in *.csv file,
because the “00” in the beginning will cause incompatibility problem.)

Figure 3.1

3. Save your file on your PC using “Save as” in the format “.csv” or “.xls”. And the name can be

user-defined.

Notes:

1

The file must be less than 1MB in size.

2

To check the validity of your .csv file, open it from plain-text program (i.e., Notepad, TextEdit).Make
sure there are no extra commas, other than between fields.

3

*.xlsx file is not supported at the moment.

4. On the summary page, click Devices on the left menu, then Devices page displays as Figure 3.2:
5. Click Upload button, the Upload File dialog displays as Figure 3.2:

Figure 3.2

6. In the File to Upload field, click <Browser…> to find the file you saved on your PC.
7. In the Server filed, generally select None or specially select the server added by you.

Advertising