User import via CSV

You can import an user base via CSV within the admin panel.

The import process can be started in the Users section of the VIMP backend by clicking the “User Import” button.

Next, you can upload a CSV file that contains your user data row-by-row. The user fields must be separated with the separator you defined in the  User import configuration.

The minimum fields that have to be included into the CSV file are:

• username
• password
• email

Further fields are optional and depend on the custom user fields that you want to be filled.

Here’s an example of a CSV import file:

username;password;email;firstname;lastname;birthday;role;city
user1;Test1!;user1@user.com;firstname1;lastname1;1990-01-01;user,moderator;Munich
user2;Test2!;user2@user.com;;lastname2;1988-06-01;;Toronto
user3;Test3!;user3@user.com;firstname3;;1997-05-05;administrator,moderator;London

Here is an extended example with the assignment of groups, clients, channels and channel roles:

username;password;email;firstname;lastname;groups;client;channels;channel_role;
csv1;csv1;csv1@1.com;csv1name;csv1lastname;"1,2,3,4";1;"1,3,6";"1-2,6-1,8-0";
csv2;csv2;csv2@2.com;csv2name;csv2lastname;1;1;1;
csv3;csv3;csv3@3.com;csv3name;csv3lastname;3;1;1;

The roles are assigned as follows, based on the above example (as of VIMP 5.1.6):

"1-2,6-1,8-0,5-4":
- for the channel with ID 1, the user gets the channel permission Channel Administrator (2)
- for the channel with ID 6, the user gets the channel permission Channel Moderator (1)
- for the channel with ID 8, the user gets the channel permission Channel User (0)

- for the channel with ID 5, the user gets the channel permission Channel Editor (4)