Printers.exe Utility

This utility is available on any workstation that has a Queue installed. When that is the case, the utility may be launched by navigating to the Queue directory on that workstation, locating the Printers.exe application file, and executing it. This will require the use of an ODBC connection to the database from that workstation.

Note: If this workstation is also the IIS, the utility's ODBC connection must be different than the standard ODBC connection to the Millennium data database which is used by the IIS.

This utility provides the following information:

• It lists all printers that are available to the workstation from which this utility is executed. The list includes the Printer Name, Printer Driver and Printer Location designation for each printer. This list is useful if you prefer, instead of using this utility, to set up Reporting Printers for your Queues on the System Information page.
• It lists all of the Queues that have been created for Millennium, via System Information, Reporting Queues before this utility is launched.
• It lists the printers that are already associated with each Millennium Queue. This list includes the Printer Description, Printer Name, Printer Driver and Printer Location for each Millennium Queue.

This utility will do the following:

• Add a printer to one of the established Millennium Queues.
• Edit the description for any one of the printers that have already been added to one the Millennium Queues.
• Delete a printer from one of the Millennium Queues.
• Fix the nomenclature (numbering scheme) for the location of a printer that is available to the workstation from which this utility is executed and which has been assigned to one of the Millennium Queues.

When any of these tasks are performed, updates are made to the report_printers system table and are therefore reflected in the System Information, Reporting Printers display.

Utility Prerequisites

1. You must have established an ODBC connection to the database on the workstation from which you are working. You must log on as either the database administrator (sa or MILLORA User ID) or a Millennium system administrator.

   Note: If this workstation is also the IIS, the utility's ODBC connection must be independent from the standard ODBC connection to the Millennium data database which is used by the IIS.

2. A Reporting Queue must already be installed on the workstation from which you are working. See Create a Reporting Queue, for details.

Utility Classification

This utility is classified as a system administrator tool for performing system setup and maintenance.

Printers Utility Application Window

The Printers Utility is executed apart of the Millennium interface. From the specific machine on which the Queue is installed, use the Windows Explorer to navigate to the copy of Printers.exe found in the Queue folder. If you are working on the IIS machine, a copy of the utility is also located in X:/Inetpub/wwwroot/mill/tools.

Launch the utility by double clicking the file name. The utility will open in a separate application window, described below.

Available Printers

At the top of the application window you will see the Printers Available for this Workstation list box. Each entry in this list is shown as a single row, containing the Name, the Driver, and the Location of each printer (each item is separated by an asterisk) that is available to your workstation. The label just above this list box will remind you of this order.

This list shows the information for all printers that have been installed and configured on this workstation only. Printer installation and configuration takes place outside of the Millennium interface; for example, via Windows Explorer. The Location for each installed and configured printer is specific to your workstation, and is system-defined. If you were to run the Printers utility from one workstation but use the information from the utility it to associate a printer to a Queue that actually resides on a different workstation, the location specifications would not necessarily be correct. It is important then, to use this utility on the same workstation that hosts the particular reporting Queue with which you are working if you are using it to Auto Fix that Queue's printer's location.

Important! If the length of the name of a printer installed and configured on your workstation is more than 90 characters in length, then that printer will not be shown in the Printers Available for this Workstation list box. If you want to make it available to the utility, you must edit its name (outside of the Millennium interface) first.

Printers configured for queue

Below the list of Available Printers is a pull-down list box of all Queues that have been created through Millennium prior to launching the utility. This Queue information is maintained in the report_servers system table in the MILLREPORTS database. This list will include all Queues created through Millennium - those that are located on other machines as well as Queues located on this workstation.

The entries in this pull-down list show the Queue name and the UNC Path for the Queue location, for each Queue. When you highlight an entry in the queue list, the Printers Associated with the Selected Queue list box will display a row for each printer that is already associated with the highlighted Queue name and Queue location. The information displayed in each row consists of the Printer Description, Printer Name, Printer Driver, and Printer Location (each piece of information is separated by an asterisk). The label just above will remind you of this order.

Action Buttons

The Add, Edit, Delete, and Auto Fix Action buttons at the bottom of the application window are used to make additions and changes to the Reporting Printers setup.

The Finished Action button is used to close the utility's application window.

Add a Printer to an Millennium Queue

1. Highlight the desired printer in the Printers Available for this Workstation list box.
2. Select the desired Queue name and Queue UNC path from Millennium Queues list.
3. Click Add.
4. Enter a Description for the printer. The description must be unique for the Queue name that you have selected in Step 2.
5. Click OK. A new row is inserted into the report_printers system table, the new Reporting Printer information is added to the System Information page, and the new information is added to the Associated Printers list box.

Edit a Printer Description

1. Select the desired Queue name and Queue UNC path from Millennium Queues.
2. Within the Associated Printers list box, highlight the printer information for the printer whose description you want to change.
3. Click Edit.
4. Enter a new Description for the printer. The description must be unique for the Queue name that you have selected in Step 1.
5. Click OK. The relevant row in the report_printers system table is updated to reflect this new Description, the Description information for this Reporting Printer is updated on the System Information page, and the configured printer's entry in the Printers Available for this Workstation list box will show this new Description.

Delete a Printer from an Millennium Queue

1. Select the desired Queue name and Queue UNC path from Millennium Queues.
2. Within the Printers Available for this Workstation list box, highlight the printer information for the printer you want to delete from this Queue.
3. Click Delete.
4. Click Yes to confirm your intention to delete. The relevant row in the report_printers system table is deleted, the printer's association with this Queue is removed from the System Information page, and the printer's information is no longer listed in the list box located directly above the Action Buttons.

Auto Fix

At times, the addition of a printer to a workstation (this is not the same as adding a printer to an Millennium Queue) can cause your network to assign or even re-align the numbering scheme (nomenclature) for the location of other printers already added to your workstation. Auto Fix is used to realign the location specification for a printer that has already been associated with an Millennium Queue so that it conforms with the location on the current workstation, as shown in the Available Printers list box.

1. Select the desired Queue and Queue UNC path from Millennium Queues.
2. Compare the location and driver information of each printer listed in the Printers Associated with the Selected Queue list box with those same printers listed in the Printers Available for this Workstation list box. If they are identical, then do not run Auto Fix. If they differ, then click Auto Fix.
3. You will be warned that Auto Fix should only be run from the machine where the selected Queue resides (the location nomenclature for the same printer may be different on different machines). If you are not on the workstation that is hosting the selected Queue, exit the utility and re-launch from the correct Queue workstation. If you are, then click Yes to continue.

The utility will update the report_printers system table to reflect the correct printer driver and location information for ALL of the printers that are associated with the selected Queue. These updates will also show on the System Information page.

Top of Page