Skip to content

Instantly share code, notes, and snippets.

@anayram
anayram / README.md
Last active April 9, 2024 19:11
WebVTT index conversion

WebVTT Index Conversion Project

Indexes have been created for recordings in the Aviary SpokenWeb collection. These indexes were oroginally created outside of the application (in Google sheets) in a custom format. See Metadata Preparation below for more details.

A script was developed to transform timestamps from a field- and format-normalized spreadsheet into WebVTT index format for ingest into Aviary. An index contains labels (segments) with a start and end time in timecode.

A spreadsheet template with field validation was created for future indexes. See Timestamp Template and Sample Metadata below.

Metadata Preparation