CSV Manifest File

When ingesting videos, you can use CSV manifest files to specify extra metadata (including the video title, description, flight times, labels, and custom metadata), as well as thumbnail and closed caption files. You can use CSV manifest files when you ingest content with FTP or Aspera.

Note: This topic applies to both OIS v2.5 and OIS v1. Certain sections, where indicated, apply to just one version.
The CSV format of the metadata file supports fewer features than does the XML format. The CSV format allows you to specify thumbnails (preview images) and custom metadata to associate with a video. The XML format supports these features as well as the association of the names of existing defined of ad sets.

CSV Manifest Column Headings

The following fields are the first line (column headings) of your CSV file, with actual data fields following on subsequent rows (one row per video).
Note: You can specify these columns in any order, and you can omit columns that you do not need, as long as the data in the data rows match the headings exactly.
Column Heading Description
video Filename of the video or the URL where the video is located. The URL can include http:// or https://.
title Name or title of the video.
thumbnail Filename of the thumbnail or the URL where the thumbnail is located.
content_type (OS v2.5 only) Content type (video or remote asset). If the filename specified in the video column is a URL where the video is located, and if you want to define a remote asset, change the value of the content_type column (from "video", the default) to “remoteasset”. See Ingesting Remote Assets.
description Description of the video.
hosted_at Permanent URL where you embed the video. Maps to the value of the hosted_at property for a remote asset.
Note: After a remote asset has been created, its propagation to the various CDNs might be delayed 60 seconds or more. If you request a remote asset too soon after its creation, the results will be cached by the CDNs, which might take several minutes to clear. Best practice: after creation, wait 30 or 60 seconds, query with the Backlot API [GET] /v2/assets/asset_id route, and after retrieving the remote asset's embed code (content ID or asset ID), then proceed to embed the asset.
flight_start_time The start time when the asset can be played, in UTC. Example: 2011-06-01T00:00:00Z
flight_end_time The end time when the asset can be played, in UTC. Example: 2011-07-01T00:00:00Z
durationInMs (OS v2.5 only) The duration representing the length of the video (in milliseconds). Required when content_type=remoteasset.
labels One or more labels, separated by commas. For example: /sports,/sports/jogging. For background, see Labels.
metadata Custom metadata for the video. You can have a column for each type of metadata (for example, metadata:type_1 metadata:type_2 and so on). See Custom Metadata for format requirements.
embed_code (Reserved). Content ID in Backlot of the video asset.
id Maps to the created asset's external ID property: a custom identifier you define that you can use instead of the content ID. See Updating Asset Metadata Using CSV or XML Manifest Files.
subTitle Closed caption file. See Ingesting Closed Caption Files. One of the following:
  • Filename of a closed caption file. Example: caption-1.dfxp
  • URL where the closed-caption file is located. The URL can include http:// or https://. Example: http://ooyala.com/captions/caption-1.dfxp
profileguid ID of the processing profile, which is a group of encodes that define the formats a master video must be converted into during transcoding. Contact your Ooyala support representative for details.

Example CSV Manifest File (OIS v2.5)

  test.mp4,Test CSV,This is an example,"test,example,csv",http://www.ooyala.com,my_test_guid_csv,my_thumbnail.jpg,my_caption.dfxp,2016-01-01T15:15:00-07:00,2022-01-01T16:00:00-07:00,57d5a5a10f654fe79ef954dc8d29a108 

Example CSV Manifest Data in Excel (OIS v1)

Creating a CSV Manifest File

Keep the following in mind when generating a CSV metadata file:

  • If a text value in a data field has a comma (,), you must enclose the field in double quotes (").
  • If a text value in a data field has a double quote (") in it, you must enclose the field in double quotes and escape the double quote character in the text field with a second quote (e.g., "She said, ""Have a nice day.""" )

If you are creating your CSV metadata file from Excel, it automatically handles escaping.

To create a CSV metadata file:

  1. Upload one or more videos.
  2. Open a spreadsheet program, such as Microsoft Excel.
  3. Add the column headings to the first row.
  4. Add a row for each video.
  5. Save the file as a CSV. For example, you might select Save as from the File menu. When prompted, select the comma-separated value file type.
  6. With your upload method of choice, upload the CSV file as you uploaded the video(s). See either FTP or Aspera.

Was this article helpful?