Skip to main content

How to delete data in regular fields (not in columns in a table) in bulk?

  • Mar 15, 2023 5:26 AM UTC
  • Sep 16, 2024 9:07 PM UTC
  • 5 replies
  • 281 views
  • Translate All

How to delete data in bulk (excluding tables without historical data (effective dates) and historical fields)?

If you want to delete data in bulk, just follow the next steps:

 

Regular individual fields:

  1. Create an excel sheet with 2 columns:
    a) Employee email
    b) The field you want to delete data from

  2. Under the second column insert: <DELETE>

 

 

  1. Save the file and upload it through Settings > Imports > Go to people Import > Update people

 

 

Historical Tables (example using the employment table)

  1. Go to Analytics > Reports > Add new > Report >Use a template > Employment History report to obtain the template data.

  2. Use the column picker so you only include the fields Email, Effective date and the fields you want to delete. Below we’re deleting the “Vacation calendar” field:

 

  1. The important thing here is: if there are employees you don't want to update to "Site calendar" then you should filter them out of this report otherwise, this will be updated for them too. To filter the people you want to update, use the advanced filters provided.

  2. Now go ahead and download the excel report.

  3. To ensure these employees' calendar changes to "Site calendar" you will need to fill the Vacation calendar column to "<DELETE>" as shown below:

 

  1. Ensure to keep the effective date unchanged. By using the delete option the current calendar for the employees will be deleted and then replaced by the default "Site calendar" option.

  2. You can perform the import by going to Settings > Import > Go to people import > Choose Employment in the drop down table > Then use the template you have created with the dowloaded report data, with the Vacation calender column filled with <DELETE>.

 

 

This can work for multiple fields as well, as long as you have in the first column the employee email.

Here is the help center article with more information.

5 replies

Thanks for this article. Really interesting.

Could you please provide a screenshot or upload a file with an example? 

I’m not sure I understand your second step (Under the second column insert: <DELETE>).

Best!

Translate

Lindsay Sinenberg
Bobber

@Angeles Rodriguez Feel free to refer to the image below as an example 😊

-You will list the employee email in the 1st column and the field you want to delete in the 2nd column (work phone in the image).
-Then you can list <DELETE> for the rows underneath the 2nd column. This will be the data you’re trying to delete
 

 

Mod edit: Updated original post to help clarify what is required to do. Thanks for your feedback here, @Angeles Rodriguez.

Translate

Thanks Lindsay. That is very useful!

Translate

Pierre Buteau

Hello!

Would it be possible to use the same technic to delete time off request in bulk?

Thanks,

Pierre

Translate

Lindsay Sinenberg
Bobber

Hi @Pierre Buteau! This would be a different process which you can access from the People’s Time Off section by navigating to Time> People’s Time Off> Manage Requests> select the users/requests from the list> Actions> select the item of your choosing

Feel free to also refer to this Help Center article for the information on this process!

Translate