Help new to Nextcloud import users from list

ℹ️ Support
1

Hello everybody,

I am pretty new to Nextcloud .
I looking to find a way to import users from csv or excel file.

I am using nextcloud on hosting server .

thanks in advance.

2

Afaik such a function doesn’t exist in the GUI, but you can e.g. create a bash script and use the command line tool to do the job:

> ./occ user:add --help
Usage:
  user:add [options] [--] <uid>

Arguments:
  uid                                User ID used to login (must only contain a-z, A-Z, 0-9, -, _ and @)

Options:
      --password-from-env            read password from environment variable OC_PASS
      --display-name[=DISPLAY-NAME]  User name used in the web UI (can contain any characters)
  -g, --group[=GROUP]                groups the user should be added to (The group will be created if it does not exist) (multiple values allowed)
  -h, --help                         Display this help message
  -q, --quiet                        Do not output any message
  -V, --version                      Display this application version
      --ansi                         Force ANSI output
      --no-ansi                      Disable ANSI output
  -n, --no-interaction               Do not ask any interactive question
      --no-warnings                  Skip global warnings, show command output only
  -v|vv|vvv, --verbose               Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug
3

Maybe this script works for you?

4

Hello I tried to launch nc-userimporter on linux ubuntu 20.04 but i get this issue :
Traceback (most recent call last):
File “nc-userimporter.py”, line 324, in
File “/usr/lib/python3.5/codecs.py”, line 321, in decode
UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xe9 in position 164: invalid continuation byte
[149957] Failed to execute script nc-userimporter

5

Most likely your csv files isn’t encoded correctly or characters in different encodings are used. Make sure that it is saved in utf-8 format. See also:

6

Thanks a lot, I’ll have a look on it !

7

It seems to work better but for the moment I have a self-signed certificate and the operation of user creation stopped because of it, I think !!

[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:645)
The CURL request could not be performed.
Press [ANY KEY] to confirm and end the process.

8

https://www.cyberciti.biz/faq/how-to-curl-ignore-ssl-certificate-warnings-command-option/

9

so does anyone has a way to import users to a self-sighed certificate server???
does the curl ignore works fine ???

many thanks

10

Did you try the nc-userimporter script, mentioned here? It has an option to disable the ssl check:

https://github.com/t-markmann/nc-userimporter/blob/master/config.xml

<sslverify>True</sslverify> <!-- leave this on True for improved security. If you use a self-signed SSL/TLS certificate, set this to False -->

11

i did yes and i get the same error over an over again.
Max retries exceeded with url: /ocs/v1.php/cloud/groups?search=Lehrkraefte (Caused by SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate (_ssl.c:1056)’)))

any ideas???

12

Make sure you enter ‘False’ with a capital F. Other than that, sorry, I never tested the script my self. Maybe you can open an issue in their GitHub repo…

13

i have tested with False i know what you mean!!!but still nothing…

since i am new into this maybe someone wiser guide me to the correct path…

14

so just an update. i will be more careful next time in readying !!!it was not a fault of the F but password limit!!!always read the debugger lol !!