{"id":17628,"date":"2022-12-12T11:00:13","date_gmt":"2022-12-12T08:00:13","guid":{"rendered":"https:\/\/trueconf.com/blog\/?p=17628"},"modified":"2025-02-04T13:49:14","modified_gmt":"2025-02-04T10:49:14","slug":"how-to-add-user-accounts-from-a-file","status":"publish","type":"post","link":"https:\/\/trueconf.com/blog\/knowledge-base\/how-to-add-user-accounts-from-a-file","title":{"rendered":"How to add user accounts from a file"},"content":{"rendered":"

After you have successfully deployed TrueConf Server, you need to add user accounts in the TrueConf Server control panel<\/a>. You can either add user accounts manually one by one or add a group of users straight from a file with the help of TrueConf Server API<\/a>.<\/p>\n

As an example we will show you how to add user accounts from a file and divide them into the user groups. The code sample is available on GitHub<\/a>.<\/p>\n

Getting started<\/h2>\n

Code sample is written in Python. If you use Windows, please download Python from the official Python website<\/a> and install it on the computer where you\u2019re going to run the executable file (if you use Windows OS). If you use Linux you may have an integrated Python interpreter that allows you to run scripts from the terminal. To check if Python is installed on Linux, run the command python3 -V<\/code> (as of 2022, version 3 remains the current version of Python).<\/p>\n

Please note that it is not recommended to run the script on an operating system with TrueConf Server already installed. The best way to run the script is to use another computer in your local network which has access to TrueConf Server via IP or FQDN.<\/p>\n

You also have to set up HTTPS connection<\/a> and create OAuth application as shown in our article on how to get started with TrueConf Server API<\/a>.<\/p>\n

Step 1. Creating a file for import<\/h2>\n

Create a file with a list of users. The following formats are supported: .csv<\/b>, .ods<\/b> and Excel formats .xls<\/b> and .xslx<\/b>. According to the provided code sample, If a .csv file is used, it is necessary to specify the separator used in this file (check the README file<\/a> in the project repository).<\/p>\n

The table below will be used as an example:<\/p>\n\n\n\n\n\n\n\n\n\n
Column name<\/b><\/td>\nDescription and example<\/b><\/td>\nRequired parameter<\/b><\/td>\n<\/tr>\n
display_name<\/b><\/td>\nDisplayed user\u2019s name: James Smith<\/b><\/td>\nYes<\/td>\n<\/tr>\n
login_name<\/b><\/td>\nlogin (TrueConf ID): Smith<\/b><\/td>\nYes<\/td>\n<\/tr>\n
password<\/b><\/td>\nUser password: 12345<\/b><\/td>\nYes<\/td>\n<\/tr>\n
email<\/b><\/td>\nEmail address: smith@company.name<\/b><\/td>\nYes<\/td>\n<\/tr>\n
groups<\/b><\/td>\nGroup name a user belongs to. If a user belongs to more than one group you should specify all the group names separated by commas and without spaces, e.g.: IT,Sales<\/b><\/td>\nNo<\/td>\n<\/tr>\n
avatar<\/b><\/td>\nPath to the avatar image: avatars\/01.png<\/b><\/td>\nNo<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Step 2. Reading data from the file<\/h2>\n

Build groups and users list using the Excel file you created earlier. We used pyexcel<\/a> package to code as an example.<\/p>\n

Step 3. Adding user groups<\/h2>\n

API 3.2 introduced in TrueConf Server 4.5 is used in this and subsequent commands. If you are using the video conferencing server supporting the later version of the API, you can substitute v3.2<\/b> with the proper version in the HTTPS request string. Read this guide<\/a> to check the correspondence between TrueConf Server versions and its APIs.<\/p>\n

Use Create Group<\/a> POST request for each group name in the list you built in step 2<\/a>, for example:<\/p>\n

https:\/\/server.company.name\/api\/v3.2\/groups?access_token={{$access_token}}<\/pre>\n
where {{$access_token}}<\/code> is an access token created as shown in our article on how to get started with TrueConf Server API<\/a>, e.g., dvN1tpoy7BmVhN8nUMzXcqJ8vsDYt4IN<\/code>.<\/p>\n
Specify a JSON group name in the request body, e.g.:<\/p>\n
{\"display_name\":\"IT\"}<\/pre>\n
If the group has been added to TrueConf Server successfully you will get JSON object Group<\/a>.<\/p>\n
Step 4. Adding users<\/h2>\n
Use Create User<\/a> POST request for each user name in the list you built in step 2<\/a> e.g.:<\/p>\n
https:\/\/server.f.ru\/api\/secompany.name\/api\/v3.2\/users?access_token={{$access_token}}<\/pre>\n
and specify filled object User<\/a> JSON in the request body, for example:<\/p>\n
{\r\n\r\n\u00a0\u00a0\u00a0\u00a0\"display_name\":\"Ian Taylor\",\r\n\r\n\u00a0\u00a0\u00a0\u00a0\"login_name\":\"taylor\",\r\n\r\n\u00a0\u00a0\u00a0\u00a0\"password\":\"123qwerty\",\r\n\r\n\u00a0\u00a0\u00a0\u00a0\"email\":\"taylor@company.name\"\r\n\r\n<\/pre>\n
If the user has been added to TrueConf Server successfully you will get JSON object user with the user\u2019s data.<\/p>\n
You can also edit existing TrueConf Server user accounts by using Edit User<\/a> PUT tag.<\/p>\n
Step 5. Adding avatars<\/h2>\n
Use Create Avatar<\/a> POST request to add an avatar to a user account:<\/p>\n
https:\/\/server.company.name\/api\/v3.2\/users\/ivanov\/avatar?access_token={{$access_token}}<\/pre>\n
To add an avatar you should convey the image file in POST request. For instance, if you use Postman<\/a> testing algorithm you should choose\u00a0 form-data <\/b>data type in Body<\/b> tab below the POST request area and choose file <\/b>parameter in the drop-down list on KEY <\/b>area, then register image<\/code> parameter and click Select Files <\/b>to choose an image:<\/p>\n
\"\"<\/p>\n
Step 6. Adding users to groups<\/h2>\n
To divide users into their respective groups you should do the following:<\/p>\n
    \n
  1. Use Get Group List<\/a> GET request to obtain TrueConf Server group list:<\/li>\n<\/ol>\n
    https:\/\/server.company.name\/api\/v3.2\/groups?access_token=dvN1tpoy7BmVhN8nUMzXcqJ8vsDYt4IN<\/pre>\n
      \n
    1. Register each group name to which you need to add a user, e.g. IT<\/b>.<\/li>\n
    2. Find a name of the respective group you need in the groups list, i.e., \"display_name\":\"IT\"<\/code>, and save its unique ID, e.g., \"id\": \"0001\"<\/code>.<\/li>\n
    3. Use Add User<\/a> POST request to add a user to the respective group by its ID:<\/li>\n<\/ol>\n
      https:\/\/server.company.name\/api\/v3.2\/groups\/0001\/users?access_token=dvN1tpoy7BmVhN8nUMzXcqJ8vsDYt4IN<\/pre>\n
      and specify the sent JSON object:<\/p>\n
      {\"user_id\":\"ivanov\"}<\/code> as account ID.<\/p>\n
      Deleting data on TrueConf Server<\/h2>\n
      You can delete multiple TrueConf Server user accounts at the same time by specifying the list of their TrueConf IDs. To delete the chosen user accounts, please make Delete User<\/a> DELETE request.<\/p>\n
      If you want to delete the group you should get its unique ID from the group list (as in Step 6 when adding users to the groups). You can delete the respective group by using Delete Group<\/a> DELETE request.<\/p>\n
      Please note that the data will be deleted permanently without the confirmation request. Pay proper attention while making DELETE requests and make sure that you specify the required parameters.<\/p>\n","protected":false},"excerpt":{"rendered":"
      After you have successfully deployed TrueConf Server, you need to add user accounts in the TrueConf Server control panel. You can either add user accounts manually one by one or add a group of users straight from a file with the help of TrueConf Server API. As an example we will show you how to […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[260],"tags":[246],"class_list":["post-17628","post","type-post","status-publish","format-standard","hentry","category-knowledge-base","tag-api-and-sdk","wpautop"],"_links":{"self":[{"href":"https:\/\/trueconf.com/blog\/wp-json\/wp\/v2\/posts\/17628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trueconf.com/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trueconf.com/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trueconf.com/blog\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/trueconf.com/blog\/wp-json\/wp\/v2\/comments?post=17628"}],"version-history":[{"count":17,"href":"https:\/\/trueconf.com/blog\/wp-json\/wp\/v2\/posts\/17628\/revisions"}],"predecessor-version":[{"id":33962,"href":"https:\/\/trueconf.com/blog\/wp-json\/wp\/v2\/posts\/17628\/revisions\/33962"}],"wp:attachment":[{"href":"https:\/\/trueconf.com/blog\/wp-json\/wp\/v2\/media?parent=17628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trueconf.com/blog\/wp-json\/wp\/v2\/categories?post=17628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trueconf.com/blog\/wp-json\/wp\/v2\/tags?post=17628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}