Using the tc_attribute_bulk_update utility arguments to update property values in bulk

When performing a simple update using the tc_attribute_bulk_update utility (updating a few values on a small number of properties on a few different object types), use the command line arguments to provide the query/update information. You must use a combination of the -type argument and condition property name/property value pairs, along with update property name/property value pairs 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. Query arguments These arguments are the equivalent of the WHERE clause in an SQL phrase. They identify the property type, property names, and property values to be queried. -type -cond_prop -cond_value -cond_operator (optional) The two condition property name/property value arguments must always be used in conjunction with the update property name/property value arguments. The -type argument specifies the object type to be updated, such as item, dataset, or StructureContext. This argument accepts only a single value. You can use multiple instances of this argument to specify multiple object types. Each instance must be paired with the -cond_prop and -cond_value arguments. The -cond_prop argument specifies the internal name of the property to be queried for, as opposed to the display name. This argument accepts multiple values in a comma-separated list. Each value must be a valid property on a Teamcenter object. For example: -cond_prop=object_name,last_mod_date You can use multiple instances of this argument, but it must always be paired with the -cond_value argument. The -cond_value argument specifies the current value of the property specified by the -cond_prop argument. This argument accepts multiple values in a comma-separated list. Each value must be a valid property on a Teamcenter object. For example: -cond_value=TextData_es_ES,"01-DEC-2011 00:00" You can use multiple instances of this argument, but it must always be paired with the -cond_prop argument. You can use the -cond_operator argument to specify an operator to be used with the -cond_prop and -cond_value arguments. This argument must be placed after the -cond_prop and -cond_value arguments and accepts the following values: EQ Equal NE Not equal GT Greater than GE Greater than and equal LT Lesser than LE Lesser than and equal For example: -cond_prop=object_name -cond_value="My obj #1" -cond_prop="last_mod_date" -cond_value="01-DEC-2011 00:00" -cond_operator="LE" -cond_prop="last_mod_date" -cond_value="01-DEC-2010 00:00" -cond_operator="GE" Update arguments These arguments are the equivalent of the UPDATE clause in an SQL phrase. They identify the property names and values to be updated. -update_prop -update_value Update property name/property value pairs must always be used in conjunction with the condition property name/property value pairs. The -update_prop argument specifies the internal name of the property to be updated (as opposed to the display name), for example, object_desc, char VLA, and so on. This argument accepts multiple values in a comma-separated list. Each value must be a valid property on a Teamcenter object. For example: -update_prop=object_name,object_desc You can use multiple instances of this argument. Each instance of this argument should be paired with the -update_value argument. The -update_value argument specifies the new value for the property specified by the -update_prop argument. This argument accepts multiple values in a comma-separate list. For example: -update_value=folder,"Home folder" You can use multiple instances of this argument. Pair each instance of this argument with the -update_prop argument. The following examples illustrate the use of the condition property name/property value pairs and update property name/property value pairs with the tc_attribute_bulk_update utility: To update prop3 to value3 and prop4 to value4 for type1 objects (when prop1 equals value1 and prop2 is greater than value2) in batches of 400, enter a command with the following form on a single line: Copy tc_attribute_bulk_update -u=tc-admin-user -pf=d:\password.txt -g=group -type=type1 -cond_prop=prop1 -cond_value="value1" -cond_prop=prop2 -cond_value="value2" -cond_operator="GT" -update_prop=prop3 -update_value="value3" -update_prop=prop4 -update_value="value4" -batchsize=400 To update an object description to blue Desc and the int_VLA to 10,3,0,99 for all datasets where the object_name property is TextData_es_ES and the last_mod_date property is 01-DEC-2011 00:00 or greater, enter the following command on a single line: Copy tc_attribute_bulk_update -u=tc-admin-user -p=password -g=group -type=Dataset -update_prop=object_desc -update_value="blue Desc" -update_prop="int_VLA" -update_value="10,3,0,99" -cond_prop=object_name -cond_value="TextData_es_ES" -cond_prop="last_mod_date" -cond_value="01-DEC-2011 00:00" -cond_operator="GE"