Pronestor Visitor does not per default delete or anonymize visitor information.
You can delete your Visitor history manually with this guide link
Or, you can set up a scheduled job to anonymize the data instead.
We will not remove/delete activities on visits but we will overwrite the visitors personal data, and the entries will be GDPR compliant afterwards.
Table of contents
Requirements
Access to your SQL database
The script
update participant set
firstname = 'f_' + cast(participant_id as char) ,
lastname = 'l_' + cast(participant_id as char),
company = 'c_' + cast(participant_id as char),
email = 'e_' + cast(participant_id as char),
MobilePhone = '',
deleted = 1
where not participant_id in
(select participant_id from badge where left(end_date,8) > CAST(CONVERT(VARCHAR(10), dateadd(year, -1, getdate()), 112) AS INT))
Testing the script
You can test whether the script is running as intended by running this on the database after the scheduled job has run:
Select * from participant where participant_id in (select participant_id from badge where end_date > 20180130000000)
The shown data should not contain any personal information. If it does, please rollback your database.
How to set the script as a scheduled job
Run the attached script on the database for Pronestor.
When performed - a stored procedure with the name of "AnonymizeVistors" should appear within Programmability->Stored Procedures
Creating a scheduled job
- Open SQL Server Agent Open jobs
- Right click and choose New Job
- Within "Steps" - click "New"
- Give it a name - ex. "AnonymizeVisitor"
- In Database choose the Pronestor database
- In Command - type (set daysbackintime for from when visitors should be anonymized)
-
EXEC [dbo].[AnonymizeVistors]
@daysbackintime = 120
GO - Go to "Schedules" and configure it to run everynight
Comments
0 comments
Article is closed for comments.