Importing from CSV files

Importing from CSV files and Bulk Editing

To quickly to modify the same property of a group of users (bulk editing), you can export them to a CSV or to a Microsoft Excel XML file, modify it and import it again in the IAS database.

To create a group of users from scratch, you just download a CSV template file from the web interface, fill it with the values, and load it to the IAS database.

Procedure to create a group of users

A green icon means that all the users have been imported. A yellow icon means that some user has been skipped. A red icon means that an error occurred.

Reports

When the Import process is completed, the "Show reports" link is displayed. All the details can be found in the report file. If a user or a specific column content has been skipped, you'll find the information you need to identify the CSV file row and fix it. Click on the "Download" icon to the left to open the report as a text file.

Preliminary concepts

CSV File Encoding

When you want to import users which include non-US characters, pay special attention to the file encoding. Supported encodings are:

Note: Excel only supports ANSI CSV files. To preserve non-ansi characters you have to save the file as "Unicode text".

Example 1: enable fax for all the users

Example 2: add voicemail only for the users who have a primary extension which starts by 3



Article ID: 184
Last updated: 12 Dec, 2016
Revision: 4
Imagicle AppSuite Cross Platform -> User Management -> Importing from CSV files
https://kbp.imagicle.com/kb/entry/184/