ProViewer

ProViewer allows incredibly fast viewing of large Parts PRO files with word-wrap, sorting and the ability to export to flat files. A ProViewer license is included with ProMapper or available separately.

Here are some of the features (and instructions):

  1. When you first run the program, you’ll need to download (from the NAPA ftp site) and open both the ValidVehicles.mdb and the Comment file (comment.txt and pcc.txt must exist in the same directory). The program will remember these and use them in the future. You can change them whenever you get new versions from NAPA. The version dates are shown in the status bar.

  2. Use File > Open Source File… (or the folder icon) to select the delivery file to view. You can also drag and drop a file on the program icon or grid window.

  3. Use View > Word Wrap to turn on/off in-cell word wrapping. It will adjust the row height to the deepest one so you can see all the data.

  4. If you want to see more text on a line you can adjust the column widths (just drag them). The program will remember these widths next time it is run.

  5. If you want to only see columns with data in them, use the “Hide Empty Columns” menu. It is toggled on/off with a check mark showing the state.

  6. Double-Click a row (or use View > Row Details…) to bring up a Row Viewer if you want to see the raw data stored in the file along with the actual database values. You can keep this window open (move it off the grid if you like) and it will update automatically as you navigate around the grid.

  7. If a code is not found in the database, it is surrounded by angle brackets (for example, <345>). This can happen if you’ve used an old database with a newer data file.

  8. Use File > Export File… (or the export icon) to save the grid to a csv file. This is handy if you want to filter or print the data in Excel.

  9. Use View > Find… (or Ctrl-F) to perform a case-insensitive search beginning after the current row. If one or more columns are selected, only those columns will be included in the search. If columns are selected, look at the “row indicator” arrow in the left gutter to see which row contains the search string. Note that the first search can be much slower than subsequent ones.

  10. Use View > Sort… (or Ctrl-S) to bring up a sort dialog. Move the columns you want sorted into the right-hand list (you can multi-select). The order of the columns is significant to the sort and can be changed with the up and down arrow buttons. The default is Ascending for each column. You can change this with the +/- button. If you check the “Move Sort Columns in Grid” checkbox, the sort columns will be shown together at the front of the grid. To revert back to the natural order of the file, just select no columns to sort by. Part Numbers are ordered intelligently by alpha/numeric segmentation.

  11. The program will run in TRIAL mode until you purchase as license and enter the registration information in the Help > Register… screen.

There isn’t much error checking; the file is assumed to be valid. ProViewer currently only supports the 25 field format.

Revised: 2017-01-30