Hi Dean,

Option 1 - Break it into smaller chunks

For this, you can copy the record numbers into an excel worksheet (which will have all your 25k numbers listed) and then you can 'copy + paste' 5000 record numbers back into your work tray clearing out your work tray each time you do the next 5000.

If you wanted to, you can do this with your favourites as well, but this would then allow you to open up 2x CMs (one on your favourites, and one on your work tray) to process 2 lots of 5000 at a time and get through twice as fast.

Option 2 - Use DataPort

Depending on the update, do an export of the record numbers and the field you want to update using DataPort. Change the values to be the NEW values in the export, and then re-import using DataPort. Make sure to have the RecordNumber exported and mapped back in for import so it updates the records instead of creating new.

Option 3 - Use a script

Similar to option 1, but once all the Record Numbers are in the spreadsheet then use Excel with a Macro or PowerShell to do the update via the SDK - its a bit more involved but I've had scripts process hundreds of thousands of items. There are also ways of once you have the script working, to then run multiple copies at the same time. This would allow you to get through it 2x or 4x times as fast (depending on how many copies you run)

-Scotty

Thanks Scotty, very helpful.  Using Opt1 immediately and then investigate the others.