# Import multiple users from CSV

**URL:** https://community.learningequality.org/t/import-multiple-users-from-csv/1264
**Category:** Kolibri
**Created:** [August 14, 2019, 5:38pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264 "2019-08-14T17:38:29Z")
**Posts on this page:** 13
**Page:** 1

<div class="post-metadata">

### Author: ![maxwellfundi](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/maxwellfundi/32/227_2.png) [@maxwellfundi](https://community.learningequality.org/u/maxwellfundi)
#### Post date: [August 14, 2019, 5:38pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/1 "2019-08-14T17:38:29Z")

</div>

If you have a specific technical inquiry, construct your post with the following:

## Summary

_I have a CSV file with usernames that I want to import into kolibri. When I run - **C:\Program Files (x86)\Kolibri\> kolibri manage importusers C:\Users\Fundi\Documents\KolibriFile.csv**_ as indicated on the manual, then what it does is odd, because it opens Kolibri on the browser and doesn’t do anything relating to importing the users. The users are not added and Kolibri doesnt through any error.

This is the screen to goes to

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/learneq/original/1X/99b191e29057d9f75072ed7c68801d3bb3eec8b3.png)

Initially i tried running the commands from the command line as indicated on the manual but it doesnt seem happy with the Kolibri command

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/learneq/original/1X/73c37b7ad564438d8edf39da0f0055e2edcc62c7.png)

## Technical details

- Version: 0.12.7
- OS: Windows-8-6.2.9200
- Installer: Windows
- Server: Kolibri internal server
- Database: C:\Users\Fundi.kolibri\db.sqlite3
- Device name: Fundi
- Free disk space: 44 GB
- Server time: Wed Aug 14 2019 20:29:36 GMT+0300 (East Africa Time)
- Server timezone: Africa/Nairobi

---

<div class="post-metadata">

### Author: ![jonathan](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/jonathan/32/314_2.png) [@jonathan](https://community.learningequality.org/u/jonathan)
#### Post date: [August 14, 2019, 5:56pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/2 "2019-08-14T17:56:18Z")

</div>

Hi @maxwellfundi, could you try something for me? On the windows command prompt, could you type `kolibri --help`? (two dashes before the `help`). I’m wondering if you get an output like this (or if it just opens Kolibri in the browser like before).

```auto
C:/> kolibri --help

Kolibri 

Supported by Foundation for Learning Equality
www.learningequality.org

Usage:
  kolibri start [--foreground] [--port=<port>] [options]
  kolibri stop [options]
  kolibri restart [options]
  kolibri status [options]
  kolibri shell [options]
  kolibri services [--foreground] [options]
  kolibri manage COMMAND [DJANGO_OPTIONS ...]
  kolibri manage COMMAND [options] [-- DJANGO_OPTIONS ...]
  kolibri diagnose [options]
  kolibri plugin [options] PLUGIN (enable | disable)
  kolibri language setdefault <langcode>
  kolibri plugin --list
  kolibri -h | --help

```

---

<div class="post-metadata">

### Author: ![maxwellfundi](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/maxwellfundi/32/227_2.png) [@maxwellfundi](https://community.learningequality.org/u/maxwellfundi)
#### Post date: [August 14, 2019, 6:01pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/3 "2019-08-14T18:01:38Z")

</div>

@jonathan Doesnt seem to do anything still- Are there any environment variables i need to set before hand?

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/learneq/original/1X/d3cddb1d4ef278ab4894d973d71fe79a9c71339f.png)

---

<div class="post-metadata">

### Author: ![jonathan](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/jonathan/32/314_2.png) [@jonathan](https://community.learningequality.org/u/jonathan)
#### Post date: [August 14, 2019, 6:12pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/4 "2019-08-14T18:12:05Z")

</div>

Yes, it looks like `kolibri` isn’t on your system’s PATH (so you can call programs without providing their exact location). Could you confirm that you have Kolibri 0.12.7 installed, since that installer is supposed to automatically set up the PATH for you.

Otherwise, you would need to add kolibri.exe to your PATH environment variable yourself. ~~I’m not familiar with Kolibri on windows, so I’m not sure where that is on the file system. I’m asking the team right now.~~ The kolibri executable should be located at `C:/Python34/scripts/kolibri`

---

<div class="post-metadata">

### Author: ![maxwellfundi](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/maxwellfundi/32/227_2.png) [@maxwellfundi](https://community.learningequality.org/u/maxwellfundi)
#### Post date: [August 14, 2019, 6:22pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/5 "2019-08-14T18:22:45Z")

</div>

@jonathan I have actually figured out why this was not working. I have 0.12.7 installed and I checked my Path environment and it seems its on the **C:\Python34\Scripts** so after running --help here it seems to do something i would expect.

So let me now see what happens when I do the other things

---

<div class="post-metadata">

### Author: ![maxwellfundi](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/maxwellfundi/32/227_2.png) [@maxwellfundi](https://community.learningequality.org/u/maxwellfundi)
#### Post date: [August 14, 2019, 6:36pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/6 "2019-08-14T18:36:15Z")

</div>

@jonathan many thanks for your help on this- Now I have manged to run the command from the

> [@maxwellfundi](#):
>
> C:\Python34\Scripts

and created all the users i needed.

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/learneq/original/1X/48a5b8260aa27fb54486afa3d4ccecf4562d4c5f.png)

---

<div class="post-metadata">

### Author: ![maxwellfundi](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/maxwellfundi/32/227_2.png) [@maxwellfundi](https://community.learningequality.org/u/maxwellfundi)
#### Post date: [August 14, 2019, 6:37pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/7 "2019-08-14T18:37:06Z")

</div>

@laura I think adding this to the documentation would greatly help other people out there who might have similar issue.

---

<div class="post-metadata">

### Author: ![jonathan](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/jonathan/32/314_2.png) [@jonathan](https://community.learningequality.org/u/jonathan)
#### Post date: [August 14, 2019, 6:38pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/8 "2019-08-14T18:38:33Z")

</div>

I’m glad you figured it out @maxwellfundi! It does look like a problem that you weren’t able to use `kolibri manage importusers` outside of `C:/Python34/scripts`, since kolibri should be added to the PATH as of version 0.12.7. We’ll look into it.

---

<div class="post-metadata">

### Author: ![maxwellfundi](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/maxwellfundi/32/227_2.png) [@maxwellfundi](https://community.learningequality.org/u/maxwellfundi)
#### Post date: [August 14, 2019, 6:47pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/9 "2019-08-14T18:47:25Z")

</div>

Perfect thanks @jonathan

> [@jonathan](#):
>
> since kolibri should be added to the PATH as of version 0.12.7. We’ll look into it.

Seems it adds the environment variable and its actually pointing the **C:/Python34/scripts**

 ![image](https://canada1.discourse-cdn.com/flex035/uploads/learneq/original/1X/c22fedaeb794cded4c1eab026848d716d076c6e1.png)

---

<div class="post-metadata">

### Author: ![jonathan](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/jonathan/32/314_2.png) [@jonathan](https://community.learningequality.org/u/jonathan)
#### Post date: [August 14, 2019, 6:50pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/10 "2019-08-14T18:50:29Z")

</div>

Oh interesting. Could you look at the “Path” variable 3 rows below and see if that folder appears there as well?

---

<div class="post-metadata">

### Author: ![shrenik](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/shrenik/32/179_2.png) [@shrenik](https://community.learningequality.org/u/shrenik)
#### Post date: [April 15, 2020, 9:29am UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/11 "2020-04-15T09:29:34Z")

</div>

@jonathan the %KOLIBRI\_SCRIPT\_DIR% does not appear in the Path. This is from Kolibri 0.13.1 on Windows 10.

So this needs a fix as well as needs to be documented. @laura

---

<div class="post-metadata">

### Author: ![devon](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/devon/32/481_2.png) [@devon](https://community.learningequality.org/u/devon)
#### Post date: [April 15, 2020, 4:02pm UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/12 "2020-04-15T16:02:22Z")

</div>

I believe that environment variable should be set during the installation wizard [at this point in the code](https://github.com/learningequality/kolibri-installer-windows/blob/bdc22c4a0731929eb47158518285902ce863b90e/src/installer-source/KolibriSetupScript.iss#L590-L597). @shrenik if you’re seeing otherwise, would you mind filing an issue in the [Windows installer repo](https://github.com/learningequality/kolibri-installer-windows)?

Thank you!

---

<div class="post-metadata">

### Author: ![shrenik](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/shrenik/32/179_2.png) [@shrenik](https://community.learningequality.org/u/shrenik)
#### Post date: [April 20, 2020, 7:52am UTC](https://community.learningequality.org/t/import-multiple-users-from-csv/1264/13 "2020-04-20T07:52:58Z")

</div>

Thanks @devon

> <https://github.com/learningequality/kolibri-installer-windows/issues/161>
>
> Test Environments:
> I have executed this test on at least two Windows 10 systems.
> System 1 - Kolibri has been upgraded on this...
