For uploading user data to Open LDAP, Avaya Aura® Device Services uses files in CSV format. The following is an example of a CSV file used to uploading user data to Open LDAP:

Given Name,Last Name,Email Address,Phone Number,Image,Department
Aiden,Johnson,aiden_johnson@company.com,123456789,Images/aiden_johnson.jpg,Sales
James,Edwards,james_edwards@company.com,123450001,,Support
Harry,Anderson,harry_anderson@company.com,123451111,Images/harry_anderson.jpg,Support

In a CSV file, the first data record is a header, which is Given Name,Last Name,Email Address,Phone Number,Image,Department in the example. This header is not processed by Avaya Aura® Device Services and is used for informational purposes only.

Each subsequent data record in a CSV file is a sequence of comma-separated user attributes in the following order:

<Given Name>,<Last Name>,<Email Address>,<Phone Number>,<Image>,<Department>

The following table describes these attributes:

For example:

Aiden,Johnson,aiden_johnson@company.com,123456789,Images/aiden_johnson.jpg,Sales.

If you do not want to provide optional attributes, do not include these attribute values in the data record. For example, if you do not want to use user photos, provide the user attributes as follows: James,Edwards,james_edwards@company.com,123450001,,Sales.

To upload user photos, include a photo directory in a ZIP archive used for bulk import. The Photo attribute specifies the relative path to the user photo, starting from that directory.

For example, to upload a file called picture.jpg, which is located in a directory called Images, you must enter Images/picture.jpg.

Optional structure of a CSV file if using Microsoft Excel

If you are using Microsoft Excel to create the CSV file, you can provide each attribute in a separate column. If you do not want to provide certain attributes, leave the corresponding cells blank. For example: