Data Manager

Data ManagerThe Data Manager can be used to export, import, update, and delete; printers, printer deployments, drivers, driver profiles, and users en masse using a CSV or XML file.

Actions

Exporting

Go to Tools -> Import / Export -> Data Manager. Select the Action, select the Data Type, and select the Format click Go, and save the CSV or XML anywhere you want.

Importing, updating, deleting

Go to Tools -> Import / Export -> Data Manager. Select the Action, select the Data Type, and select the Format click Go, and select the CSV or XML file containing the objects to be added.

Data Types

TCP/IP Printers

With this feature you can export, import, update and delete, printer objects from a list of all TCP/IP printers in the Printer Installer database to a CSV or XML file. This can be useful as a reference for auditing the printer objects with a third-party utility. It can also be a convenient way to convert a large number of unmanaged direct IP printers to PI-managed direct IP printers. Information contained in the CSV or XML includes the printer's name and folder, settings on the General tab, Port tab, Drivers tab, and Drivers / Profiles tab.The only column that is required is "Printer Name". If "Printer Folder" is not specified, the entire tree will be searched for a printer with a matching name. If more or less than one printer with that name is found, an error will occur. Printers will be identified by "Printer Name" and "Printer Folder". If "Printer Folder" is not specified, the entire tree will be searched for a printer with a matching name. If more or less than one printer with that name is found, an error will occur. If a column is not specified for a particular field, that field on the printer will not be modified. If the column is specified, but the value is blank, it will blank out the field on the printer.

TCP/IP Printer Deployments

Printer deployments can be imported and edited in bulk with this method. It can be a convenient way to make or edit a large number deployments for a single printer or multiple printers.

Drivers

Drivers and driver profiles can also be exported using the Data Manager. It can be a convenient way to import or replace many new drivers into printer installer.

Users

Non-Administrator users and user roles can be created or modified using the Data Manager. Information contained in the CSV or XML includes: user name, parent folder, node name (folder), and Role. You can modify and add new users for non-administrator roles by adding the

Formatting notes

The import/export format MUST be:
  • Comma-delimited fields.
  • The double quote (") character around any field containing a comma.
  • Fields containing a quote (") in them, should be escaped by using two in a row. This is the default import/export format of Microsoft Excel. However, OpenOffice does not support the this method of escaping, so OpenOffice users will need to escape the quote character with a slash-quote (/").
  • Folder values are delimited by the backslash character (\). Folder names containing the (\) (/) and (&) characters must be escaped using (&bs;) (&fs;) and (&) respectively.
  • Example folder path: My Company -> Engineering \ "QC" -> London, ON -> First/Second floor & penthouse
    • In Excel: My Company\Engineering &bs; "QC"\London, ON\First&fs;Second floor & penthouse
    • Raw CSV file: "SomeField","My Company\Engineering &bs; ""QC""\London, ON\First&fs;Second floor & penthouse","SomeOtherField"
  • The special characters that need to be escaped within a folder value are automatically escaped properly when exporting to a CSV file.
  • Using a XML file is the preferred method when using the Data Manager.