Creating/Modifying Setup Data

atarget.gif (1372 bytes) This task shows you how to create or modify setup data that is needed to use your migrated V4 models.
Data that you migrate from V4 into V5 will usually be stored in directories that are separate from the directories in which V5 generated data is stored. Sample directories are included with this application for storing migrated data. The default location is: intel_a\startup\EquipmentandSystems\MigrationDirectory\XXX where XXX is a discipline like Tubing or Piping.

You need to create the following setup data in the directory that you use to store your resources, and which is referenced in the project resource management file. If you continue to use the sample directories the changes should be made there, if you choose to create a new location, that is where the setup data should be added.

In the instructions below it is assumed that you have created a new location. If you continue to use the sample directories then you should adjust the instructions accordingly.

ascenari.gif (1364 bytes)

 

1.

Discrete Values

You will need a set of discrete value text files as a default set of possible values for piping attributes.  You can copy these from the sample migrated piping discipline (\intel_a\startup\EquipmentAndSystems\MigrationDirectory\DiscreteValues) into your own \DiscreteValues directory.  You can throw away what you do not want, and edit what you want so you are satisfied with your set of text files.

Also, if you had user-defined attributes defined in your V4 Project Registration Model containing a discrete list of values, then you will need to create a discrete values text file in your \DiscreteValues directory containing the name of your mapped V5 attribute name and the values you want available in V5 for your user-defined attribute.

2.

Design Rules

\intel_a\startup\EquipmentAndSystems\MigrationDirectory\PipingSystems\V5_Migrated_Tables contains a directory called DesignRules.  Move this directory to your \Piping directory.  Copy the design rules catalog from the sample piping discipline into your \Piping\DesignRules directory.  Borrow additional design rule resources as desired from the sample piping disciplines, and rename and edit them as desired.  When you are satisfied you have all of the design rule data you want, you are ready to edit the design rules catalog.  Rename the design rules catalog you copied, as desired.  Bring up the application again and edit your design rules catalog as needed. Change the links to reference your own text files. Take out previous entries ("Remove description") and add your own entries.  Refer to the section Standards and Design Rules for more information.

3.

Standards

Under your \Piping directory create a directory called Standards.  Your migrated standard data in  \intel_a\startup\EquipmentAndSystems\MigrationDirectory\PipingSystems\V5_Migrated_Tables is separated in different directories for each standard.  Move these standard directories to your \Piping\Standards directory.  Copy the piping standards catalog from the sample piping discipline into your \Piping\Standards directory.  Borrow additional standard resources as desired from the sample piping disciplines, and rename and edit them as desired.  When you are satisfied you have all of the standard data you want, you are ready to edit the standards catalog.  Rename the standards catalog you copied, as desired.  Bring up the application again and edit your standards catalog as needed.  Take out previous entries ("Remove description") and add your own entries.  Refer to Standards and Design Rules for more information.

4.

Specifications

Under your \Piping directory create a directory called Specification.  Your migrated spec data in  \intel_a\startup\EquipmentAndSystems\MigrationDirectory\PipingSystems\V5_Migrated_Tables is separated in different directories for each specification.  Move these specification directories to your \Piping\Specification directory. 

Copy the piping specification catalog from the sample piping discipline into your \Piping\Specification directory, or copy a sample empty specifications catalog from \intel_a\startup\EquipmentAndSystems\MigrationDirectory\PipingSystems\V5_Catalog. Or create a new material specifications catalog by following the instructions in Creating a Specifications Catalog.

Borrow additional specification resources as desired from the sample piping disciplines, and rename and edit them as desired.  When you are satisfied you have all of the specification data you want, you are ready to edit the specifications catalog.  Rename the specifications catalog you copied, as desired.  Bring up the application again and edit your specifications catalog as needed.  Take out previous entries ("Remove description") and add your own entries.  You will notice that the specifications catalog has two logical sections under each specification - you see a list of tables and then a list of parts.  At this time, you are only editing the table entries.  After you have built your parts catalog, you will come back to this specifications catalog and edit and add entries for your parts.  Refer to Creating a Specifications Catalog for more information.

  5.

Parts Catalog

Under your \Piping directory create a directory structure called \PipingDesign\ComponentCatalogs\CatalogXXX, where XXX is your catalog number.  See the sample migrated piping discipline for an example.  In the \CatalogXXX directory you will place your migrated catalog parts and your parts catalog.

You will probably not want to borrow and edit an existing piping parts catalog because of the number of part entries you would have to delete.  You can copy the empty sample catalog in \intel_a\startup\EquipmentAndSystems\MigrationDirectory\PipingSystems\V5_Catalog, and rename it.  Bring up the application and add all of your parts to it. 

Refer to Modifying a Catalog for more information. You can use the Create/Modify catalog button to add your parts to the catalog.

  6.

PRM File

Edit the project resource management (PRM) file because the final two steps need to reference your standard data.  In \intel_a\startup\EquipmentAndSystems\ProjectData\Project.xml, you can define a new discipline in that PRM file, or copy it and rename it (e.g., ProjectABC.xml), and then edit the Migration section to reference your new discipline resources.

Before bringing up the application during the next steps, you need to set the CATDisciplinePath variable.

In Windows:        

set CATDisciplinePath=XXX\startup\EquipmentAndSystems\ProjectData

In UNIX:

          export CATDisciplinePath=XXX\startup\EquipmentAndSystems\ProjectData

Where XXX is your installation path.

When you bring up the application and open a piping document, you must go to Tools + Project Management and choose your discipline to make it active.

  7.

Specifications Catalog

Now that you have built your parts catalog, you can edit the parts sections of your piping specifications catalog.  You need to define part queries in your specifications catalog.    

To aid you in defining these queries,  you will need to reference your V4 class catalog definitions.  In V4, go to the PIPSETUP function and to the menu Catalog + Options, set your catalog number, then go to Catalog + Pipe Spc + Generate.  Select All, and then Export.  The file CLSEXxxx, where xxx is your catalog number, will be created in setup/PRO/catlg.  You will need to reference this file as you define your class queries in your V5 specifications catalog.

The first row of your CLSEXxxx file contains "/*".  The fifth row contains "*/".  Rows 2, 3, and 4 begin with PSPEC.  You can consider row 4 as containing the column headings of attribute names.  The rows that follow, starting with row 6, each contain a "part class query", with encoded values for certain attributes.  An asterisk ("*") beside a value indicates that this is a value for a "generic attribute", whose encoded value will be used in the part number of a fully resolved piping part.  You will see that the fourth part entry, row 9, has a pipe specification of CS150R, a pipe standard of ASTL, a part category of Valve, a part function of Gate Valve, a size range from .5 to .75, a (generic) material category of CS (carbon steel), a (generic) material code of A105, a rating1 of 800, a wall thickness1 of .0000, an end style1 of SW (socket weld), an end style2 of TH (threaded), and other (2/3/4) wall thickness values of .0000.

See Creating a Specification Catalog to learn how to create an attribute filter file and use it to define all your part queries.

CREATING A V5 ATTRIBUTE FILTER FILE

You can edit the V4 CLSEXxxx file and turn it into a V5 attribute file by following these instructions:

  1. In Windows NT, copy CLSEXxxx to CLSEXxxx.txt.  Open CLSEXxxx.txt. Remove rows 1(/*), 2, 3, 5, and 6(*/).  Old row 4 (PSPEC,Standards,Category ...) should now be the top row and the remaining rows should be the V4 queries.  Copy CLSEXxxx.txt to V5SpecxxxInput.csv. 
  2. Open V5SpecxxxInput.csv.  It will open in Microsoft Excel. Save it as V5SpecxxxInput.xls.
  3. Open V5SpecxxxInput.xls.  You may wish to save this beginning version and then save intermediate versions as you edit this file, because it will take several hours.  (Hint:  Replace All will do most of your work.  If you have many catalogs, you may wish to merge all of your V5SpecxxxInput.xls files together into one file, then edit headers and values once, then break the file apart again.  This is so you will not have to do the same Replace All operation in many different files.)
  4. The first row contains the headers for each column.  Delete all columns that are completely empty under the header name.  You may also wish to delete the Primary Option Flag column and the Wall thickness columns.
  5. Rename the column called Standards to Standard.  In front of this column insert a new column called PartType.
  6. For each row, under the column called PartType, enter the appropriate V5 part type.  Use the entries in the two columns Category and Function to determine the approximate name of the part type, and use the part type browser in CATIAV5 to determine the exact name of the V5 part type.  For example, for Category/Function Branches/Tee, use PartType Tee.  For Category/Function Valve/Gate Valve, use PartType Gate Valve.  For Category/Function Flanges/Blind flange, use PartType Blind Flange (note the f became F).  For Category/Function Elbows/90 Degree Elbow, use PartType Elbow (and delete any duplicate rows, because 45 Degree Elbow will also map to Elbow).  For Category/Function Gasket/, use PartType Gasket.  And for Category/Function Pipe/, use PartType Pipe with bends (do not use V5 Pipe; V4 pipes are bendable pipes not straight pipes).  Then delete the columns Category and Function.
  7. Rename the column called Material category to MaterialCategory.  Refer to your material category encode/decode table (e.g., Piping\Standards\ASTL\ASTL-MaterialCategory.txt) to edit each row in this column: change CS* to Carbon steel*; CS to Carbon steel; etc.
  8. Rename the column called Material code to MaterialCode. You will likely not have to edit the rows under this column, but check your material code encode/decode table (e.g., Piping\Standards\ASTL\ASTL-MaterialCode.txt) table to make sure.  If you edit any value with an * at the end, make sure it still has an * at the end after you finish your edit.
  9. Rename the column called Part name to PartName.  The rows under this column will likely already have the decoded values. 
  10. Rename the column called Part code to PartCode.  Make sure every code in the column is in your part code table (e.g., Piping\Standards\ASTL\ASTL-PartCode.txt).
  11. Rename the column called Rating 1 to Rating.  Refer to your rating encode/decode table (e.g., Piping\Standards\ASTL\ASTL-Rating.txt) to edit each row in this column: change 150 to 150#; change 300 to 300#; etc.
  12. Rename the column called Schedule 1 to Schedule.  Refer to your schedule encode/decode table (e.g., Piping\Standards\ASTL\ASTL-Schedule.txt) to edit each row in this column: change STD to STANDARD; change STD* to STANDARD*; change XS* to EXTRA STRONG*; change 160 to SCHEDULE 160; etc.  Be careful to maintain existing *, but do not add * when not needed.
  13. Rename the column called End style 1 to EndStyle.  Refer to your endstyle encode/decode table (e.g., Piping\Standards\ASTL\ASTL-EndStyle.txt) to edit each row in this column: change BW to BUTT WELD; change RF to RAISED FACE; etc.
  14. Rename the column called End style 2 to EndStyle2.  Refer to your endstyle encode/decode table (e.g., Piping\Standards\ASTL\ASTL-EndStyle.txt) to edit each row in this column: change SW to SOCKET WELD; etc.
  15. Rename the column called Start size range to MinOutsideDiameter(in).  You may wish to change in (inches) to mm (millimeters) or m (meters) or to another unit, depending upon the unit your data uses.  You will be editing the row values, changing them from V4 nominal size values to V5 actual size values (outside diameter real number, not nominal size character string).  Refer to both your nominal size table (e.g., Piping\Standards\ASTL\ASTL-NominalSize.txt) and your standard pipe dimensions table (e.g., Piping\Standards\ASTL\ASTL-PipeDimensions.txt).  Find the unit used for OutsideDiameter in your standard pipe dimensions table and use that unit for MinOutsideDiameter.  Your standard pipe dimensions table may have different outside diameter values for the same nominal size for different schedules.  Edit the V4 nominal size value in the MinOutsideDiameter(in) column with the appropriate V5 outside diameter value, taking care to use the correct value for the schedule defined in your row.  You may wish to use a slightly smaller value to insure against any roundoff errors.  For example, you may change 0.5 to 0.84 (or slightly smaller to 0.83) and change 6 to 6.625 (or slightly smaller to 6.62).
  16. Rename the column called End size range to MaxOutsideDiameter(in).  You may wish to change in (inches) to mm (millimeters) or m (meters) or to another unit, depending upon the unit your data uses.  You will be editing the row values, changing them from V4 nominal size values to V5 actual size values (outside diameter real number, not nominal size character string).  Refer to both your nominal size table (e.g., Piping\Standards\ASTL\ASTL-NominalSize.txt) and your standard pipe dimensions table (e.g., Piping\Standards\ASTL\ASTL-PipeDimensions.txt).  Find the unit used for OutsideDiameter in your standard pipe dimensions table and use that unit for MaxOutsideDiameter.  Your standard pipe dimensions table may have different outside diameter values for the same nominal size for different schedules.  Edit the V4 nominal size value in the MaxOutsideDiameter(in) column with the appropriate V5 outside diameter value, taking care to use the correct value for the schedule defined in your row.  You may wish to use a slightly larger value to insure against any round off errors.  For example, you may change 4 to 4.5 (or slightly larger to 4.55) and change 6 to 6.625 (or slightly larger to 6.63).
  17. Now save your file.  Also save it as an intermediate file for any future reference.  Copy this file several times, one for each Specification you have defined in it.  Name the new files with each specification name (e.g., V5SpecxxxInput_CS150R.xls and V5SpecxxxInput_CS300R.xls).
  18. Edit each of these input specification files.  Remove the rows that do not apply to this specification, and then delete the PSPEC column.  Save each file.
  19. Start CATIAV5R14.  Open your Piping Specifications catalog.  Double-click on the first specification defined, but not Default.  Select the icon for Create/Modify Catalog.  Define the Application as Piping.  Define the Parts directory (e.g., Piping\PipingDesign\ComponentCatalogs\Catalogxxx).  Define the Attribute filter (e.g., Piping\Specification\V5SpecxxxInput_CS150R.xls).  Select Documents: File base (since Model Migration can only be done in File base, not ENOVIA base).  Select OK.  This may take an hour or more, depending upon the number of catalog part documents and the number of rows in your attribute filter input file.  When done, save your Piping Specifications catalog and then repeat the process for each of your piping specifications.
  20. You now have a completed migrated Piping Specifications catalog.
  8.

Piping Lines

After performing the task Exporting V4 Piping Lines, you will have an Import file that you can use in V5 to create your V4 piping lines in V5.  Before performing the Import step of that task, you had to set up your piping discipline and PRM file. 

You will likely want to copy the V4 migrated piping lines and catalog from \intel_a\startup\EquipmentAndSystems\MigrationDirectory\Piping\SampleData\PipingLines to your own piping lines directory (\Piping\SampleData\PipingLines).  This will be the piping lines catalog your PRM file should reference and which your Import Line IDs operation will update.

aendtask.gif (1477 bytes)