Anonymize Visitors - only relevant for the older version of Visitor

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
• The script
• Testing the script
• How to set the script as a scheduled job

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