Help! Accidentally overwrote catalog items, how to revert to prev version?

matthew_magee1
Giga Guru

Hi,

I ran a transform map and forgot to turn off colesce on a field. In doing so, 200+ items got their description overwritten.

 

If I look at each catalog item, I see version. I can go through each item and revert back to the previous version, but that would take a lot of time. Is there a way to revert all 200+ items back to the previous version?

 

or is there a way to 'undo' my transform map I just ran?

 

TIA

5 REPLIES 5

Mike Allen
Mega Sage

Do you have a subprod that has the true values there?   You could export from there, with sys_id, and then re-import from excel.



According to the wiki: You can export all fields by setting the sysparm_default_export_fields parameter to all (available starting with the Dublin release).


Hey Mike,



Actually not sure i want to go that route just yet. I'll use this if there are no other options.



Stay tuned


Mark Stanger
Giga Sage

It may be possible to script this, but it's not simple at all and would probably take longer than it would to revert the versions one-by-one.   I agree with Mike that the simplest solution (if the data is good) is to export the XML from another instance and import.   If you don't want the entire record and could just get the descriptions, you could export the descriptions and item IDs to a CSV and run another transform.


matthew_magee1
Giga Guru

Mark/Mike,


Both feedbacks helped. I'll export all the records out of a 'good' environment, save just the descriptions and meta data, and run a new transform to write over all the records I updated. Looks like I panicked for nothing



Thanks much guys-


Matthew