Skip to main content
Skip table of contents

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:

  1. On the Printers main tab, click Tools.

  2. 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:

  1. At the top of the Printers main tab, click Tools.

  2. In the drop-down box, click Import.

  3. 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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.