Changing the Calculated Mask

We have approximately 45,000 eB Document Templates across 8 production eB communities.  Our company's document naming convention is changing which means the calculated mask in all templates needs to be changed to support the new naming standard.  Is there a way that the calculated mask can be updated in bulk rather than each template having to unapproved, the mask altered and then reapproved?

Current mask = IFNULL(Projects.Project.Code, '?')+'-'+IFNULL( Responsibilities.Organization.Code, '?' )+'-'+Class.Code+'-'+TRIM(LEFT(IFNULL(Attributes["Global", "Discipline"].Value, '?'),3))+'-'+'######'

New mask = CASE Projects.Project.Attributes["Global", "Document Code Format"].Value WHEN 7 THEN IFNULL(Projects.Project.Code, '?')+'-'+IFNULL( Responsibilities.Organization.Code, '?' )+'-'+CASE GroupedVirtualItems.GroupedVirtualItem.VirtualItemGroup.Code WHEN 'VOL' THEN GroupedVirtualItems.GroupedVirtualItem.VirtualItem.Code ELSE '?' END +'-'+Locations.Location.Code+'-' +Class.Code+'-'+TRIM(LEFT(IFNULL(Attributes["Global", "Discipline"].Value, '?'),3))+'-'+'######' WHEN 8 THEN IFNULL(Projects.Project.Code, '?')+'-'+IFNULL( Responsibilities.Organization.Code, '?' )+'-'+CASE GroupedVirtualItems.GroupedVirtualItem.VirtualItemGroup.Code WHEN 'VOL' THEN GroupedVirtualItems.GroupedVirtualItem.VirtualItem.Code ELSE '?' END +'-'+Locations.Location.Code+'-' +Class.Code+'-'+TRIM(LEFT(IFNULL(Attributes["Global", "Discipline"].Value, '?'),3))+'-' +TRIM(LEFT(IFNULL(Attributes["Global", "Role"].Value, '?'),1))+'-'+'######' ELSE IFNULL(Projects.Project.Code, '?')+ '-'+IFNULL( Responsibilities.Organization.Code, '?' )+'-'+Class.Code+'-'+TRIM(LEFT(IFNULL(Attributes["Global", "Discipline"].Value, '?'),3))+'-'+'######' END

Parents Reply Children