Sharing something we built and released for free: ...
# general
s
Sharing something we built and released for free: a NetSuite bulk-delete tool (Suitelet + Map/Reduce) for clearing sandbox/test data. This takes a different approach from the Saved Search deletion scripts, and instead has a filter-based approach, and it also offers an intelligent deletion order. Handling deletion order is important. NetSuite will not delete a record that something else depends on, such as a customer with invoices, a bill with a payment against it. So records have to be removed in the right sequence. The toolkit clears all 22 record types in one pass, in dependency order. The tool can filter by any one or combination of: Subsidiary, Record type (single or grouped), Created Date, Transaction Date (if a transaction), and/or External ID. We built this because we kept needing to delete data in Sandboxes between migration dry runs. Then the NS Consultants we work with asked for it, so we figured we'd just offer it to the world. It's totally free to use on your own data, and if you are a NetSuite consultant, then it's also free to use for your customers. And the underlying source code is published to GitHub. We'd love any feedback you have! More info is here, suitemigration.com/netsuite-admin-toolkit And you can download it (or check out screenshots) on GitHub, github.com/Uranus-io/suitemigration-admin-toolkit
d
Does it work out dependencies dynamically or is there just a list of records and dependencies in code somewhere? Will it handle custom records with parent/child relationships defined?
s
It has a preprogrammed order for dependencies, and currently only handles standard objects. We plan on expanding this to handle custom objects someday. If you have a feature request, please feel free to email me at stony@suitemigration.com and I'll see if the developers can add that. And if the feature request is for custom objects, please provide as much context as you can, thanks! :-)
🙌 1