Exporting and Importing Printers
On the Printers main tab, you can export and import lists of printing devices and related metadata.
Export Printers to CSV
To export a list of printing devices:
On the Printers main tab, click Tools.
On the drop-down box, click Export.
The printer admin password column is always empty. You cannot Export plain text passwords due to security reasons. However, you can Import passwords in plain text in the same column.
Import Printers from CSV
You can import a list of printers from a CSV file. The first row of the file must contain the column names, as in the following example:
PRINTER;LOCATION;IPADDRESS;SCANNERIP;ASSETNUMBER;CONTACT
To import a list of printing devices:
At the top of the Printers main tab, click Tools.
In the drop-down box, click Import.
Browse for your CSV file and click OK.
Your printers are now imported and visible in the Printers tab.
A sample file called Printers_example.csv
is included in ProgramData\MyQ\Data\Import
. Customize this file for your own use.
Supported Columns
Export
PRINTER
LOCATION
IPADDRESS
SCANNERIP
ENFORCEDMODEL
ASSETNUMBER
CONTACT
PURCHASEDATE
MODEL
SERIAL NUMBER
MAC
B&W PRINT
COLOR PRINT
B&W COPIES
COLOR COPIES
SCANS
FAX
C
M
Y
K
A4 PAPER
A3 PAPER
A5 PAPER
B4 PAPER
B5 PAPER
OTHER PAPER
FOLIO PAPER
LEDGER PAPER
LEGAL PAPER
LETTER PAPER
STATEMENT PAPER
REST OF PAPER
PRINT COLOR PAGES (L1)
PRINT COLOR PAGES (L2)
PRINT COLOR PAGES (L3)
COPY COLOR PAGES (L1)
COPY COLOR PAGES (L2)
COPY COLOR PAGES (L3)
PRINTER ADMIN
PRINTER ADMIN PASSWORD
Import
PRINTER (required)
IPADDRESS (required)
LOCATION
SCANNERIP
ENFORCEDMODEL
SERIAL NUMBER
MAC
ASSETNUMBER
CONTACT
PRINTER ADMIN
PRINTER ADMIN PASSWORD