How can I move Compliance Certification Templates with Conditions, between instances?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2024 11:25 AM - edited ‎02-26-2024 04:59 AM
Hello
I have several Compliance Certification Templates all with Certification Attribute Conditions. When i try to move everything via update set, the Certification Template is moved but the conditions aren't included. I have tried export / Import from the [cert_template] table, but the conditions still aren't moved over? Am I missing something really obvious?
Thanks
EDIT: Finally found my solution so thought I would update incase anyone else finds it useful. While the Certification Templates are stored in the [cert_template] the Certification Attribute Conditions are stored in a separate table [cert_attr_cond]. I had to find all of the conditions relevant for my templates and add them to the update set too.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2024 11:51 AM
Hi, these tables, cert_filter, cert_attr_cond, cert_related_list_cond,
do not appear to have attribute 'update_synch' (at least not in the instance I checked) and so would not be included in update-set.
Customizations tracked by update sets (servicenow.com)
Meaning it looks like you would need to include the related records\data manually and
I would export the records from these tables to xml and import them after you have deployed your template.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2024 12:18 PM
Hi Tony,
Thanks for your reply. I have tried exporting the records from the cert_template table and importing into the higher instance but I still only get an empty template with no Certification Attribute Conditions.
.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2024 12:25 PM
Hi, I have just tested this by creating a cert in a non-prod instance and then exporting the cert and related records to xml before importing to a PDI and did not have any issues.
How exactly did you export\import your data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2024 12:34 PM
Hi Tony,
I'd already tried moving everything over in an update set, so the blank templates where already in the higher instance. I went to the cert_template table in DEV, found one of my templates and exported to xml. I then imported it in to the same table in the higher instance, but the Certification Attribute Conditions still weren't showing.