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
Hi Steve,Could you please confirm the eB version you are using?
Hi Manav
Do you have any update on this?
RegardsSteve
Hi Steve,Sorry for coming late on this, please find the below link for Provisioning sheet to update all the templates in bulk:
https://bentley.sharefile.com/d-s4a27512a9a94decb
I recommend to take help from Professional Services team use the spreadsheets as it will make the changes to the data directly.