Import users from CSV file
PiNet includes a utility to batch import users from other systems using a CSV file. It was initially designed for use with SIMS.net, but there is no reason it couldn’t be used with any application that can export users as a CSV file.
Data format
The CSV file must be in the form of an MS-DOS Comma Separated Values file (Microsoft Excel) or a Text CSV file (Libreoffice). Other CSV file formats may not be supported.
The formatting required is very simple
| 1 | 2 |
|---|---|
| Username | Password |
| Username | Password |
| Username | Password |
Or just
| 1 | 2 |
|---|---|
| Username | |
| Username | |
| Username |
An example CSV file can be found here.
Importing CSV file
You will be asked to enter a default password when importing the users, if any of your users don’t have an attached password (in column 2), then the selected default password will be used.
-
Open PiNet and select
Manage-Users.
-
Select
Import-Users.
-
Select
Yesto continue.
-
Select Ok to continue.
-
Using the folder navigator, select the .csv file you have copied to the server. All folders are preceeded by a
/and to move up a folder, select../.
-
Next, enter a password to use as the default password if any of the users don’t have a password assigned to them.
-
Finally, verify the correct credentials for each user are shown on screen. If you are happy with them, select
import. If not, selectcanceland double check your CSV file, make sure you have followed the required pattern.
-
The users will then be imported 1 by 1 and once the process is complete, a dialog box will be displayed informing you it is complete.
