Snip-It

Installation

Prerequisites

• NodeJS
• FFmpeg
  • FFmpeg Tutorial - Mac

Transcription Prerequisite

For automatic transcription via Google Cloud Speech API, an account will need to be setup with Google Cloud.

Instructions can be found here: https://github.com/GoogleCloudPlatform/google-cloud-node#elsewhere

The keystore.json file generated should be stored safely, and it will be used when the tool is run if transcription is to be used.

Install Snip It

In the command line execute the following to install the tool:

npm install -g snip-it

Using

The tool operates on the macro enabled Interview Recording spreadsheet. Once an interview has been concluded the spreadsheet should be saved with a filename that matches the video filename. e.g. interview-user1.xlsx and interview-user1.mp4.

The video should be placed in a video folder, an example directory may look like the following:

├── interviews/
│   ├── interview-user1.xlsx
│   ├── interview-user2.xlsx
│   ├── video
│   │   ├── interview-user1.mp4
│   │   ├── interview-user1.mp4

In the above directory structure, navigate to interviews and run:

snip-it

This will create a folder called output which will contain the segmented videos based upon the timestamps created in the spreadsheet.

Transcription

Enabling transcription will require the following parameters:

Parameter | Example | Description --- | --- | --- projectId | snip-it | This is the project Id configured for Google Cloud which has the Google Speech API enabled keyFilename | /Path/To/keyfile.json | This is the path to the keyfile that has been generated

The command to execute to include transcription:

snip-it --transcription=true --projectId=snip-it --keyFilename=/Path/To/keyfile.json

In addition to the segmented videos, a new spreadsheet will be created in /output that will contain the transcriptions.