Replace variant condition column with variant formula column for classic variants

The Variant Conditions column is available by default in Structure Manager. This column is applicable only to classic variants. If a structure has Product Configurator variability, this column does not display any values. In such cases, you can replace it with the Variant Formula column for all users. To know how to add or remove columns, see Insert or remove a property column. Modifying the sequence of columns in Structure Manager If an individual user modifies the sequence of columns, the system creates user level instances of the PortalPSEColumnsShownPref, PSEDisplayNameWithTypeColumnsShownPref and PortalPSEColumeWidthsPref preferences and rearranges the columns for that user. If users do not modify the sequence of columns, these preferences remain as site level preferences. If there are no user level instances of the PortalPSEColumnsShownPref, PSEDisplayNameWithTypeColumnsShownPref and PortalPSEColumeWidthsPref preferences, the system administrator modifies site level preference values by changing the bl_variant_condition value to bl_formula value in the TC_DATA\tc_preferences.xml file. If there are any user level instances of the PortalPSEColumnsShownPref, PSEDisplayNameWithTypeColumnsShownPref and PortalPSEColumeWidthsPref preferences, a system administrator can run the preferences_manager utility in cleanup mode to modify the preference values from bl_variant_condition to bl_formula for a few or all users. Running the preferences_manager utility As a systems administrator, you can run the preferences_manager utility in cleanup mode to modify the preference values for specific users or all users. While running the utility, if you specify the -u_target argument with a comma separated list of users who have user instances of preferences, the columns are changed only for those users. If you do not specify this argument, columns are modified for all users who have user instances of preferences. Run the utility in dry run mode: preferences_manager -mode=cleanup -u=admin_user -p=password -g=dba -action_file=actionfile.xml -u_target=user1,user2 -dry_run actionfile.xml file contents: Copy

<action name="replace">
    <preference name="PortalPSEColumnsShownPref">
        <value to_replace="bl_variant_condition">bl_formula</value>
    </preference>
    <preference name="PSEDisplayNameWithTypeColumnsShownPref">
        <value to_replace="BOMLine.bl_variant_condition">
		     BOMLine.bl_formula</value>
    </preference>
</action>

<action name="add">
</action>

<action name="rename">
</action>

On running the utility in dry run mode, the log file specifies for which all users the preferences would be modified in non dry run mode. Run the utility in non dry run mode: preferences_manager -mode=cleanup -u=admin_user -p=password -g=dba -action_file=actionfile.xml -u_target=user1,user2 Saving column configuration The following is an example of how a user saves a column configuration and the system administrator runs the preferences_manager utility to change all such column configuration preferences created by users.

Procedure In Structure Manager, right-click and choose Save Column Configuration. Save the column configuration. The system creates new preferences. Apply the column configuration. To do so, right-click and choose Apply a Column Configuration.

Note You must apply the column configuration only after the system administrator runs the preferences_manager utility. The Variant Formula column is displayed after applying the column configuration.