Downloading Customer and Vendor UET Data

Use the UET C/V Activity Download to PC program to transfer customer and vendor monthly activity data for further analysis. The system downloads data only for customers who are listed in the UET/PC Customer Report Table and vendors listed in the UET/PC Vendor Report Table.

To download customer and vendor UET data:

From the Events > Unquality Event Tracking menu, select UET C/V Activity Download to PC to display the UET C/V Activity Download to PC window.

In the Branch field, enter the branch or territory where the unquality event occurred to include only unquality events from that branch in the download.

In the Start Date and End Date fields, enter the date range to include activity for the download.

The system populates the DOS Path field with the file name and location on the computer of the ASCII file the system creates. The default is C:/ASCII/UETEOM.ASC. You can edit the path, if necessary.

Note: Before you can use the system default, you must create a directory on your C drive named "ASCII."

In the Download Type field, select the format that is best for the program you are using for analysis.

Prompt	Definition
ASCII - No Conversion	Text in UNIX format. Data is read as ASCII. Each line is terminated with a line feed.
ASCII - LF = CR/LF	Text in Windows format. Data is read as ASCII. Each line is terminated with a carriage return/line feed.
ASCII,LF=CR/LF,Tab col	An ASCII file where all line feed characters are combined with carriage returns and data is delimited into columns with Tab characters.
ASCII,LF=CR/LF,Tab col&pad	An ASCII file where all line feed characters are combined with carriage returns and data is delimited into columns with Tab characters and blank spaces.
Spreadsheet Reformat	A file optimized for importing into common spreadsheet programs, such as Microsoft Excel.
Fix Block - Remove LF	A file optimized for common spreadsheet programs in fixed block format without line feeds.
Binary	A simple binary file.

From the File menu, select Download to begin the data download process.

When complete, the system displays the file size and destination. Press Enter to clear the prompt.

Note: If you receive system message DOWNLOAD IMPOSSIBLE, check that the download path is correct and that the necessary folders exist on your hard drive.