Exporting Type Instance Data
You can export type instance data using a command-line tool. This exports all data for a given type and its subtypes, including the data for any instances of that type that exist. For example, if you export the instance data for the Product type, then the system exports all products, as well as any existing instance data for Product subtypes.
The ExtractFile command is used to export instance data for a type. This command exports the instance data for the selected type and all of its subtypes.
The usage is: java com.lcs.wc.load.ExtractFile <directory><delimiter><object><object> …
• <directory> specifies the directory to extract to.
• <delimiter> specifies the delimiter to use. TAB specifies tab delimited.
• <object> specifies the list of object types to extract. ALL specifies all object types.
• ZIP (optional) specifies that output files generated by the extraction should be packaged in a ZIP archive.
When exporting type instance data, the following situations apply:
• When exporting a type that has more than one word, put quotes around the name of the type (for example, “Material Color” or “Document Collection”).
• When exporting instances of the Palette type, both the parent palette and sub-palettes are exported. However, the relationships between the palettes are not exported.
• When exporting synchronized types, only the primary type can be exported. Secondary types cannot be exported independently. For example, the Material type can be exported, but the Material Supplier type cannot be exported on its own. Some secondary types are included when exporting the primary type:
◦ Construction (primary)
◦ Construction Detail (secondary)
◦ Material (primary)
◦ Material Supplier (secondary)
◦ Measurements (primary)
◦ Measurements POM (secondary)
◦ Test Specification (primary)
◦ Test Condition (secondary)
◦ Test Details (secondary)
◦ Test Method (secondary)
◦ Test Property (secondary)
◦ Test Standard (secondary)
Examples
To export all Color instance data in a comma delimited file in the c:\exports directory, use the following command:
windchill com.lcs.wc.load.ExtractFile c:\exports , Color
To export instance data from all supported types in tab delimited files in the c:\exports directory, use the following command:
windchill com.lcs.wc.load.ExtractFile c:\exports TAB ALL
To export instance data from the Material Color type in a tab delimited file in the c:\exports directory, use the following command:
windchill com.lcs.wc.load.ExtractFile c:\exports TAB "Material Color"