BatchGuru - transform metadata in Relativity

BatchGuru from vdiscovery and Nikolai Pozdniakov's Hashtaglegal, is a set of tools to be used in a Relativity workspace which helps you easily transform metadata in existing fields.

If you need to remove email addresses from email metadata to, from, cc, or bcc fields for the purposes of generating output for a document index or privilege log, you can use the 'Remove Email Address' function which creates a new field with the addresses listed with domains deleted, and the email name aliases left in:

You can set it up simply by creating a batch and specifying source and destination fields:

BatchGuru also facilitates the export of native files. Create a new batch using 'Native Exporter' as the data source, and specify a metadata field to be used to designate the filenames:

. . . the output goes to another module in BatchGuru named, 'Native Exporter - Pick Up':

. . . which then links to a zip file containing the exported native files:

This function has limitations because the zip file which is generated is added to the workspace. Multiple exports of large numbers of native files can increase the size of the workspace considerably.

BatchGuru includes many other tools which will allow fields to be split by specified delimiters; generate 'autopreviews' of the first few lines of emails in document lists; and count the number of recipients listed in a single email message. Check out what's possible with it today!

The GDPR's ROPAs

Article 30 of the General Data Protection Regulation requires controllers of personal data to maintain a 'record of processing activities' which includes seven key pieces of information:

1. Controller name and contact information.

2. Purpose for the processing.

3. The categories of personal data and data subjects.

4. The categories of recipients to whom data will be disclosed.

5. Transfers of data to third countries or international organizations.

6. The time range for which the data will be held and then erased.

7. The security measures taken to protect the data.

You can find a good example of a spreadsheet used to track ROPA data on the site of the UK's National Health Service.

Compare this with an example on the site of the Commission nationale de l'informatique et des libertés (CNIL), the French agency charged with enforcing data privacy laws.

Supporting documentation is often required for ROPAs, such as vendor DPAs, (Data Processing Agreements) which address the terms under which a service provider processes personal data for a company, and DSAR responses (Data Subject Access Requests), which are actions taken to remove, alter, or access personal data on the request of the person whose data is involved.

Organizations often prepare data maps to track the personal data they are holding. Some service providers such as BigID have developed systems which help companies assess private data on their network.

Powershell script to automate screen grabs of each page from a book

This night's post shows how you can use a PowerShell script to save each page of an online book as a PDF.

The process involves using an add-in for Chrome called Screenshot Capture.   See: https://chromewebstore.google.com/detail/screenshot-capture/giabbpobpebjfegnpcclkocepcgockkc

When this is installed, when you press ALT + S it will automatically save a .png file of the open page to a specified location.  Use these settings, with the option for ‘Capture Viewport’.

This is the script:

Add-Type -AssemblyName System.Windows.Forms

$pathToChrome = 'C:\Program Files\Google\Chrome\Application\chrome.exe'

$tempFolder = '--user-data-dir=c:\temp' # pick a temp folder for user data

$startmode = '--start-fullscreen' # '--kiosk' is another option

$startPage = 'https://archive.org/details/islandofdoctormo00welluoft/mode/2up'

Start-Process -FilePath $pathToChrome -ArgumentList $tempFolder, $startmode, $startPage

Start-Sleep -Seconds 5 # Wait for the browser to load

for ($i = 0; $i -lt 10; $i++) {

    # Press Alt+S

    [System.Windows.Forms.SendKeys]::SendWait('%s')

    Start-Sleep -Milliseconds 5000 # Small delay between key presses

    # Press Page Down

    [System.Windows.Forms.SendKeys]::SendWait('{PGDN}')

    Start-Sleep -Milliseconds 5000 # Small delay between key presses

    }

 Be sure to confirm that the path on the second line is where you have Chrome installed on your PC.

Enter the url of the web page on the line beginning, ‘$startPage’

Indicate the number of pages you need to grab here [in this example it’s 10 pages]

 for ($i = 0; $i -lt 10; $i++) {

The PowerShell script in effect presses ‘ALT + S’ and then the page down key for you.

It’s possible that the script can get thrown off if a page takes a long time to load, so the last part of the script pauses for a set amount of milliseconds.   So 5000 equals 5 seconds.

In Chrome, be sure to enter full screen mode by pressing F11.

Just enter the script in the white pane at the top, and then press the play button.

After the script ends and the .png files are generated, you can easily convert them to a single PDF in Adobe Acrobat.