Before running the Piping Commodity Filter Cleanup utility, you must convert at least
one PDS specification using the PDS translator. The conversion results in one specification
workbook and one catalog workbook per spec. The specification workbook contains the piping commodity filter
and piping nominal diameter information.
-
In Windows Explorer, navigate to the software installation folder.
-
Under [Product Folder]\CatalogData\PDSTranslator\Bin, double-click CleanupUtility.exe.
The Workstation setup includes the PDSTranslator folder only if you have specified the Project Management option during installation.
-
In the Excel file box, browse and select the Excel workbook (.XLS format) that contains the Piping Commodity Filter and Pipe Nominal Diameter sheets. This workbook must not be read-only.
-
In the Log file box, browse to the location where you want the log file stored.
-
Click Start Cleanup. As the utility processes the files, you can view the status messages on the dialog box. After completion, "Finished" appears on the dialog box.
-
The process overwrites the Excel workbook.
-
The process does not mark any records in the workbook as changed.