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 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.
Thank you Manav. I did not appreciate the provisioning sheet could also be used to amend objects in the database, We certainly use the sheet to create new objects e.g. document templates, organisations, people etc
I'll contact Professional Services for further advice.
Thank you
Steve
Answer Verified By: Carma De Villiers