Migrating Piping Data from Legacy PTD Files to CSV Format

Piping > Setting Up Piping Library > Piping Specification Database > Master Catalog (MCAT) Files > Migrating Piping Data from Legacy PTD Files to CSV Format

Migrating Piping Data from Legacy PTD Files to CSV Format

You can convert the master catalog files from the PTD format to the CSV format by importing them into an editor such as Microsoft Excel. The converted files need some modifications before they are ready to use. Refer the following sections for more details on converting each type of file:

• Piping Master Catalog Directory file

• Bend Machine file

• Bend Spring Back and Elongation file

• Pipe Master Catalog file

• Insulation file

• Fitting file

• Bolt Nut Selection file

• End Compatibility file

• Combined Size Code file

Converting Legacy Piping Master Catalog Directory File to CSV Format

Refer the file at <Creo load point>/text/piping_data/master_catalog as an example. The following table provides details for consolidating the Piping MCAT Directory PTD files to a single csv file.

Legacy PTD files	New CSV File	Required Configuration option	PTD	CSV
piping_mcat_dir.ptd	piping_mcat_dir.csv	piping_mcat_dir_file	Yes	Yes

Convert the Piping Master Catalog Directory PTD file to the CSV format and delete the following columns:

• PIPE_OD_FILE

• PIPE_THK_FILE

• BOLT_NUT_CODE

Converting Legacy Bend files to CSV Format

Refer the bend file at <Creo load point>/text/piping_data/master_catalog/bend as an example. The following table provides details for consolidating the Bend PTD files to a single csv file.

Legacy PTD files	New CSV File	Required Configuration option	PTD	CSV
bend_steel.ptd	bend_steel.csv	piping_mcat_dir_file	Yes	Yes
piping_units_system_dic_file.ptd	bend_steel.csv	units_system_dic_file	Yes	No

Refer the color coding in the following image for mapping contents from the PTD files to the CSV file:

Converting Legacy Bend Machine File to CSV Format

Refer the bend machine file at <Creo load point>/text/piping_data/master_catalog/bend_machine as an example. The following table provides details for consolidating the bend machine PTD files to a single csv file.

Legacy PTD files	New CSV File	Required Configuration option	PTD	CSV
bend_machine.ptd	bend_machine.csv	piping_mcat_dir_file	Yes	Yes
piping_units_system_dic_file.ptd	bend_machine.csv	units_system_dic_file	Yes	No

Refer the color coding in the following image for mapping contents from the PTD files to the CSV file:

Converting Legacy Bend Spring Back and Elongation File to CSV Format

Refer the bend spring back and elongation file at <Creo load point>/text/piping_data/master_catalog/bend_machine as an example. The following table provides details for consolidating the bend machine PTD files to a single csv file.

Legacy PTD files	New CSV File	Required Configuration option	PTD	CSV
bend_springback_elong_steel.ptd	bend_springback_elong_steel.csv	piping_mcat_dir_file	Yes	Yes
piping_units_system_dic_file.ptd	bend_springback_elong_steel.csv	units_system_dic_file	Yes	No

Refer the color coding in the following image for mapping contents from the PTD files to the CSV file:

Converting Legacy Miter File to CSV Format

Refer the miter file at <Creo load point>/text/piping_data/master_catalog/miter as an example. The following table provides details for consolidating the bend machine PTD files to a single csv file.

Legacy PTD files	New CSV File	Required Configuration option	PTD	CSV
miter_steel.ptd	miter_steel.csv	piping_mcat_dir_file	Yes	Yes
piping_units_system_dic_file.ptd	miter_steel.csv	units_system_dic_file	Yes	No

Refer the color coding in the following image for mapping contents from the PTD files to the CSV file:

Converting Legacy Pipe Mater Catalog Files to CSV Format

Refer the Pipe MCAT file at <Creo load point>/text/piping_data/master_catalog/pipe as an example. The following table provides details for consolidating the Pipe Master Catalog PTD files to a single csv file.

Legacy PTD files	New CSV File	Required Configuration option	PTD	CSV
pipe_steel.ptd	pipe_steel.csv	piping_mcat_dir_file	Yes	Yes
piping_units_system_dic_file.ptd		units_system_dic_file	Yes	No
piping_material.ptd		piping_material_file	Yes	No
piping_manufacture_dir.ptd		piping_manufact_dir_file	Yes	No
od_steel.ptd		piping_mcat_dir_file	Yes	Yes
thk_steel.ptd		piping_mcat_dir_file	Yes	Yes

Refer the color coding in the following image for mapping contents from the PTD files to the CSV file:

Converting Legacy Insulation Files to CSV Format

Refer the Insulation file at <Creo load point>/text/piping_data/master_catalog/insulation as an example. The following table provides details for consolidating the Insulation PTD files to a single csv file.

Legacy PTD files	New CSV File	Required Configuration option	PTD	CSV
exhaust.ptd	exhaust.csv	piping_mcat_dir_file	Yes	Yes
piping_units_system_dic_file.ptd		units_system_dic_file	Yes	No
piping_material.ptd		piping_material_file	Yes	No

Refer the color coding in the following image for mapping contents from the PTD files to the CSV file:

Converting Legacy Fitting Master Catalog Files to CSV Format

Refer the Insulation file at <Creo load point>/text/piping_data/master_catalog/insulation as an example. The following table provides details for consolidating the Insulation PTD files to a single csv file.

Legacy PTD files	New CSV File	Required Configuration option	PTD	CSV
coupling_sw_steel.ptd	coupling_sw_steel.csv	piping_mcat_dir_file	Yes	Yes
piping_mcat_dir.ptd		piping_mcat_dir_file	Yes	Yes
piping_material.ptd		piping_material_file	Yes	No

Refer the color coding in the following image for mapping contents from the PTD files to the CSV file:

Converting Legacy Bolt Nut Selection File to CSV Format

Refer the bolt nut selection file at <Creo load point>/text/piping_data/master_catalog as an example. The following table provides details for consolidating the Insulation PTD files to a single csv file.

Legacy PTD files	New CSV File	Required Configuration option	PTD	CSV
piping_bolt_nut_select.ptd	piping_bolt_nut_select.csv	piping_bolt_nut_select_file	Yes	Yes
bolt_nut_mcat.ptd	piping_bolt_nut_select.csv

Refer the color coding in the following image for mapping contents from the PTD files to the CSV file:

Converting Legacy End Compatibility File to CSV Format

Save the end compatibility file at <Creo load point>/text/piping_data/master_catalog as a CSV file to convert it to the csv format.

Legacy PTD files	New CSV File	Required Configuration option	PTD	CSV
piping_end_compatibility.ptd	piping_end_compatibility.csv	piping_end_compatibility	Yes	Yes

Converting Combined Size Code File to CSV Format

Save the combined size code file at <Creo load point>/text/piping_data/master_catalog as a CSV file to convert it to the csv format.