How to rollback an import

Nithya Devi
Tera Contributor

Hi,

Could anyone suggest how to rollback the import that done via data source.

Data source Import;

Type- File.

Format- CSV

File Retrieval Method- Attachment.(manual attachment)

 

regards,

Nithya.

 

 

1 ACCEPTED SOLUTION

Chaitanya ILCR
Mega Patron

Hi @Nithya Devi ,

 

Directly rolling back an import set in ServiceNow, in the same way you might rollback an update set, is not a built-in feature. Once an import set has transformed data into target tables, the changes are committed.

 

you can can go through the import records and their targets

if the operation is insert you can delete the target record

 

if the operation is update it's going to be complex

if you the audit is enabled on the table you can try to go through the audit data and undo the changes

 

also I found this, see if this is of any use to you

https://www.servicenow.com/community/servicenow-ai-platform-articles/rollback-import-sets/ta-p/23060...

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

View solution in original post

7 REPLIES 7

Chaitanya ILCR
Mega Patron

Hi @Nithya Devi ,

 

Directly rolling back an import set in ServiceNow, in the same way you might rollback an update set, is not a built-in feature. Once an import set has transformed data into target tables, the changes are committed.

 

you can can go through the import records and their targets

if the operation is insert you can delete the target record

 

if the operation is update it's going to be complex

if you the audit is enabled on the table you can try to go through the audit data and undo the changes

 

also I found this, see if this is of any use to you

https://www.servicenow.com/community/servicenow-ai-platform-articles/rollback-import-sets/ta-p/23060...

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

Bhuvan
Kilo Patron

@Nithya Devi 

 

It is not supported out of box. Try below solution in development environment and see if it works,

 

https://developer.servicenow.com/connect.do#!/share/contents/7322031_rollback_import_sets?t=PRODUCT_...

 

If this helped to answer your query, please mark it helpful & accept the solution. 

 

Thanks,

Bhuvan

Hi Bhuvan,

 

Let me try this on my pdi and let you know.

 

Regards,

Nithya.

@Nithya Devi 

 

Did you get a chance to review this as I believe information I provided would help to answer your query.

 

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan