Undo Import?

[gerardjohnson]

Hello, I imported an xls using System Import Sets and it didn't work, producing incorrect entries.

Can i undo this, and so delete the entries the import created?

I'd like to try again fresh.

[tony_barratt · Accepted solution]

Hi Gerard,

Can you identify the unwanted rows via a list view and appropriate query?

http://wiki.servicenow.com/index.php?title=Encoded_Query_Strings#gsc.tab=0

If so the next step could be to create a script that used the encoded query to generate a list, or may be a count, of affected rows.

Assuming that the number of affected rows is too high to allow fixing the issue from the GUI.

I do not suggest actually deleting rows until you have completed a through analysis of the what the current situation, and what options you have to put it right. Plus carried out some validation, which might for example, include deleting a single record with a script to check results.

Probably other Community members have additional useful inputs too.

Best Regards

Tony

[gerardjohnson]

Hello thank you, from all I've read yes it is not recommended to delete anything, and imports should not be backed out of, but rather fix the problems using scripts.

In breaking this I've found other issues with business rules not firing to create other entries, so it's all good.

Thankfully this is all in dev

[Paul Curwen]

See this article: https://codecreative.io/blog/prepare-your-import-sets-for-rollback/