Running the SQL script
PrinterOn provides a SQL script that you can use to import your User List CSV file into your IMCAS database.
Note: The PrinterOn script relies on a default filename and location for the User List CSV file (C:\csv.txt), and creates or modifies a default table in the database (CSV2.txt).
If you want to change these default values in the script, you can modify the script as necessary. However, modifying the SQL script is outside the scope of this document.
📘 Instructions
The PrinterOn script performs the following tasks:
Creates a table in the IMCAS database named CSV2.txt.
Opens the csv.txt file located in the C:\ folder.
Populates the CSV2.txt table with contents of the csv.txt file.
Sets a default user password of “password” for all users.
To execute the SQL script
Download and extract the SQLQuery2.sql script from the following location: dl.printeron.com/imcas/SQLScript.zip
Launch SQL Server Management Studio.
In SQL Server Management Studio, click File > Open, then browse to the location of the SQLQuery2.sql script file and select it.
Click Execute.