Exporting a V5 Catalog to CES

About Exporting a V5 Catalog to CES

In order to search for, instantiate, compare, or perform any other CES functionality on existing parts or products, CATIA V5 catalogs must be integrated into the CES database. The CATIA V5 catalog is first converted into a standard export format, XML or CSV. The converted material is then used to create the data in the CES database.

For more information about catalogs, refer to:

  • Component Catalog Editor User Guide

When Exporting a V5 Catalog to CES

  • The converted file that is created describes the catalog structure.
  • If the export fails, an error message appears.
  • The exported file can be edited to:
    • Add keywords
    • Add hierarchy information
    • Regroup the existing hierarchy
    • Sort descriptions
    • Split or modify part families.
  • There are pros and cons to each of the two possible technologies:
    XML CSV
    Provides tools to describe the catalog classification Catalog classification must be described using a separator character.
    Provides a parser to build and retrieve semantic information. Parser must be developed.
    Cannot edit in Excel:

    1. xsd file required to import or export  the xml file to or from Excel. The xsd file  describes the grammar used in the xml file. It is similar to the dtd file.

    2. Excel does not support the Recursive Structure used in xsd.

    Can edit in Excel.
  • XML is powerful for describing semantics, but is weak in editing capabilities.
  • CSV can be edited in Excel, but you have to develop your own parser. CSV is used for this documentation.
  • When edited in Excel, the catalog structure is described as the following array:
    • Object Path: This describes the catalog classification. Each chapter or description is described by its path. The # character is the separator character in the path.
    • Object Type: This describes the type of classification object. This can be one of the following:
      • CHAPTER: catalog chapter
      • DESCRIPTION: description
      • PART_FAMILY: part family
      • EXT_CHAPTER: external chapter
    • PointedEltPath: This describes the path to the referenced element, pointed to by this object. If the referenced element is not file based, this object is empty.
    • PartNumber: This describes the part number of the element referred to in PointedEltPath. It has a value only if the referenced element is stored in a database. Otherwise this object is empty.
    • RevisionNumber: This describes the revision number of the element referred to in PointedEltPath. It has a value only if the referenced element is stored in a database. Otherwise this object is empty.
    • PointedEltType: This describes the type of element referenced by PointedEltPath. This can be one of the following:
      • DOCUMENT: The referenced element is a document.
      • FEATURE: The referenced element is a feature.
      • GENERIC_PART: The referenced element is the generic part of a part family.
    • Keyword Name: This describes a keyword referenced by the chapter of the referenced element.
    • Keyword Value: This contains the value of the corresponding Keyword Name.
  • The ; character is used in the csv file as a separator.
  • The Chapters and Description names must not contain the # character because it is used as a separator character during export.

How To Export a V5 Catalog to CES

This task explains how to prepare a CATIA V5 catalog for export to CES:
This example assumes that:
  • you have an existing catalog that you want to export to CES
  1. In CATIA, open a catalog that you wish to export to CES. Login to ENOVIA V5 VPM and CES. For more information on logging in, refer to Logging in to ENOVIA V5 VPM in CATIA and Accessing CES Functionality.

  2. From the File menu select Save As. The Save As window appears. Browse to the appropriate location. Set the desired name for the file and save the catalog as csv.

  3. Once the catalog has been converted to .csv, it can be imported to CES as part of the data migration handled by Services. For information about importing data to CES, refer to the CES Enterprise Catalog Administration and Installation : CES DBLoad Administration.

 

Save As Window

This table describes the fields displayed in the Sourcing Search Results window.

Fields Description
Save in Contains the folder in which to save the document.
File name Contains the name of the file to save.
Save as Type Contains a list of file types in which to save the document.
Save as new document Select this to save a file as a new document.


This table describes the buttons displayed in the Sourcing Search Results window:

Button Description
Save Click this to see the entire search criteria text in a separate window. Notice that this button is only enabled if the search criteria text is too long for the Search Criteria field.
Cancel Click this to return to the Sourcing Search window and edit your search. Please note that if you previously entered values for any Additional Properties attributes, these values will be clear when you return to the Sourcing Search window.