Hi
I am importing data into an object for the first time. Sadly I did not read @adam.mills post on this Importing data into an object.
I have managed to import some 600 empty records! I have now sorted my problem, but how can I delete all these records without doing it one at a time, and without deleting the object?
This can be done by creating a signal to fire a rule.
Within the Rule Response select the ‘Delete Record’ action, this will clear all records from your object.
If you wish to just clear out the 600 blanks or other items with an identical trait, create a subset on the object first and apply that to the rule response.
Because it is a signal you can set it to fire manually from the signal screen without needing to create an interface to house a button.
It is worth noting that a signal behaves differently to a rule in this instance as there is no record context in which to operate so it acts across the whole object. A rule would act within the context of where it was fired.
Thanks Adam. That worked a treat
Also, when deleting records please don’t forget to remove any other (orphaned) related data that could get automatically created along with those 600 empty records.
Thanks so much for this, I’m so glad I didn’t have to manually delete 350 records!! 
Hi Jonathan,
Things have moved on a little and we now have a handy little widget called the Object Clean Up tool I created, this allows you to cleanse data from an object in a variety of useful ways such as by subset, date, last 100 etc.
It’s available on AppShare.
https://community.netcall.com/appshare/i/object-clean-up-tool/
Something that often gets overlooked with regards to orphaned records, especially those which exist across child relationships is that you can configure in the object settings that if a parent record is deleted the child is too.
In the child objects "Data Retention Tab "set the “Delete When Orphaned By” to the parent object.
Hope this helps someone!
