Mass data deletion

The Data Loader provides an option for deleting uploaded data for a complete object or group of related objects. You can use this option for example:

• If your data loading process includes a test data load which you subsequently need to delete.

• If you discover the data you loaded contains a repeated or systemic error that has affected multiple records. It is often easier to fix the error in the file to be uploaded and then reload, having first deleted the affected data.

• If you load a set of records in error.

Mass Data Deletion also provides an option for deleting Import Row data. Import Row data is data held in temporary storage that is normally deleted by the Data Loader on completion of an upload operation. Under some circumstances, such as an uncompleted abort or other interrupted process, temporary data may not be fully cleared.

Mass data deletion enables you to select an object and delete all the records held for that object. There is no limit on the number of records that can be deleted at one time. You are asked to confirm your deletion.

To use mass data deletion:

1. On the Data Loader Home page, select Mass Deletion:

   

   Sage People displays the Mass Data Deletion object selector page:

   

   For the purposes of mass deletion, objects are arranged hierarchically so that selecting an object that has fields used by another object also selects the child object(s):

   Selecting this object...	...also selects these objects
   Team Member	All other
   Employment Record	Absence
   	Benefit
   	Bonus
   	Job History
   	Salary
   Absence	No other
   Benefit	No other
   Bonus	No other
   Dependant	No other
   Education	No other
   Emergency Contact	No other
   Experience	No other
   Job History	No other
   Performance Review	No other
   Salary	No other
   Skill	No other

2. Check the boxes to select the object(s) for which you want to delete all records.

   The display changes to show selected objects in red:

   

   Child objects cannot be deselected without deselecting the parent object.

3. When you have selected the objects you want, select Delete.

   Sage People displays the Mass Data Deletion confirmation page:

   

4. Check that the objects listed are the ones for which you want to delete all records.

5. If the correct objects are listed, select I understand that this will permanently delete ALL rows for the selected objects.

   Sage People permanently deletes all records stored for the objects you selected.

6. If the list is not correct, select Abort to cancel the deletion and return to the object selector page.