Before you start this procedure, edit the AllCodeLists.xls workbook to match any customization in the PDS project.
-
In Windows Explorer, navigate to the software installation folder.
-
Under [Product Folder]\CatalogData\PDSTranslator\Bin, double-click PDSDatatranslator.exe.
The Workstation setup includes the PDSTranslator folder only if you have specified the Project Management option during installation.
-
Select the Translate PDS Reference Data option on the PDS Piping Reference Data Translator Dialog.
-
Under Commodity Code Option, specify either the contractor commodity codes or the industry commodity codes.
-
In the PDS ASCII Files Location box, browse to the location that stores your PDS reference data.
-
In the PDS Translation Rules box, browse to the location that stores the edited PDS translation rules, which are in Excel workbook (.XLS) format. Type the name of a workbook.
The software includes two translation rules workbooks in the [Product Folder]\CatalogData\PDSTranslator\Docs folder: Piping Translation Rules DIN.xls and Piping Translation Rules.xls. You can edit these workbooks according to your project.
-
In the PDS Code Lists box, browse to the location where the codelist information is stored, and type the name of a workbook.
-
The translation process does not convert PDS codelists.
-
The process uses two Smart 3D codelists that relate to dimensional data. These codelists are located in AllCodeLists.xls.
-
-
In the SmartPlant 3D Piping Excel File box, browse to the location where you want the Excel workbooks to be stored, and type the name of a workbook. The format is Excel workbook format (.XLS).
If you provide a name for the Excel file, the translator uses this name as a prefix for the names of the generated Excel workbooks. For example, if you type PdsTranslation.xls, the utility exports two files: PdsTranslation_Catalog.xls and PdsTranslation_Specification.xls.
-
In the Translator Error Log box, browse to the location where you want the log file stored, and type the name of the log file.
-
Click Translate. When the process finishes, the status bar on the translator displays Finished.
-
Review the error log.
Based on the errors, you can decide to do one of the following: 1) Revise the input data, delete the output files, and re-translate, OR 2) edit the output files.