Process for updating property values in bulk

You can update the values of object properties in your Teamcenter database in bulk using the tc_attribute_bulk_update utility. This utility replaces the previous method for updating property values in bulk, which entailed using the attribute_export utility to export the property values and the tcxml_import utility to import the updated property values into the database. Tip You can also use live updates to update property values. Use the tc_attribute_bulk_update utility to: Query for the objects that satisfy the conditions specified through condition property name/property value pairs. Provide new values for the properties to be updated on the found objects. Export the data to a TC XML file. Import the data from the TC XML file into the database. The scope of your bulk updates can range from changing a few values on a few properties (simple) to changing many values on all properties throughout the database (complex). The scope of your planned update determines which format to use to provide query criteria and replacement values to the tc_attribute_bulk_update utility. Simple updates Use this method when updating a few values on a small number of properties for a few object types. Example The designers at Manufacturing, Inc. create two new colors for their spinning widgets and discontinued another color. Accordingly, their Teamcenter administrator must add the slide_green and twisting_turquoise values to the color property on the widget_spin object and remove the boring_brown value. Specify the condition property name/property value pairs and update property name/property value pairs for the utility. Optionally, you can also specify an operator for condition property name/property value pairs. -cond_prop -cond_value -update_prop -update_value -cond_operator Complex updates Use this method when changes to your business practices require sweeping changes to existing property values throughout the database. Example At Acme Company, every workspace object includes Division as a required property. Valid Division values are the different business divisions of Acme. A reorganization changes the list of existing business divisions significantly and creates new subsectors. Acme’s Teamcenter administrator must update the Division values on every workspace object in the database. Create an XML input file to specify property name/property value pairs to query for the objects to be updated, and then specify property name/property value pairs to update the found objects.