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.
CSV Manifest Column HeadingsThe following fields are the first line (column headings) of your CSV file, with actual data fields following on subsequent rows (one row per video).
|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:
|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)
video,title,description,labels,hosted_at,id,thumbnail,subTitle,flight_start_time,flight_end_time,profileguid 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:
- Upload one or more videos.
- Open a spreadsheet program, such as Microsoft Excel.
- Add the column headings to the first row.
- Add a row for each video.
- 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.
- With your upload method of choice, upload the CSV file as you uploaded the video(s). See either FTP or Aspera.