Creating the User List CSV file
The User List CSV file defines the basic values required to add a new user entry in PrinterOn’s IMCAS database. You can create the file in any text editor, or you can create a spreadsheet and export it as a CSV file.
Note: Password are not set using the User List CSV file. Instead the SQL script simply assigns a password of “password” to every new user added to the table; users can set their own passwords upon logging in for the first time.
📘 Instructions
To create a User List CSV file:
In a text editor or spreadsheet editor, create a new text file or spreadsheet.
Add an entry for each user. Each line in the file must contain the following five values, each separated by a comma:
Value | Description |
|---|---|
Row | The entry order for the user. The first entry in the CSV file must always have a value of 1, and subsequent lines must increase sequentially. |
User ID | The name with which the user signs into PrinterOn service |
First Name | The first name of the user. |
Last Name | The last name of the user. |
The email address associated with this user. |
For example:
1,mberenyi,Miki,Berenyi,mberenyi@mycompany.com
2,jcole,Jeremy,Cole,jcole@mycompany.com
3,sbraithw,Stuart,Braithwaite,sbraithw@mycompany.com
4,engyuen,Eddie,Nguyen,engyuen@mycompany.com
5,nnahrin,Nowshi,Nahrin,nnahrin@mycompany.com,
6,jlannerh,Julia,Lannerheim,jlannerh@mycompany.comWhen you have added all the entries, save the file. By default, the SQL script provided by PrinterOn requires the file to be called csv.txt, and that it be located in the root C:\ folder.
Once you have created a User List CSV file, you can import that file into the IMCAS database. For more information, see Running the SQL script