Exporting videos as a CSV

    Follow

    You can export all your videos including their meta data to a CSV file (CSV stands for comma separated values) that you can open in a spreadsheet application. In the list media view there is a button on the top right hand side "Export to CSV". Clicking this will download a CSV file including all the metadata for all videos matching your current search criteria. So if you for example want a list of all videos in the "News" category, simply filter on "News" and then click the "Export to CSV" button.

    What data is exported

    The file will contain one row for each video with the following columns:

    • mediaid - the unique id of the video
    • title - the title of the video as seen in console
    • description - the description of the video as seen in console
    • downloads_started - the number of times the video has started playing
    • posted - the date and time the video was uploaded. Note that the time will be in timezone UTC.
    • height - the height in pixels of the original video resolution
    • width - the width in pixels of the original video resolution
    • categoryname - the name of the category that the video belongs to
    • categoryid - the unique id of the category that the video belongs to
    • storage - the total amount of storage that the video is taking up
    • duration - the length of the video in milliseconds
    • realname - the name of the owner of the video
    • username - the e-mail address of the owner of the video
    • userid - the unique id of the owner of the video
    • status - the processing status of the video. Most often either successful or failed
    • thumbnail - the url of the thumbnail (small image) being used as poster image
    • image - the url of the image being used as poster image
    • mediatype - indicating type. One of video, audio and binary
    • properties - extra meta data defined by you
    • tags - comma separated list of tags
    • rating - the average rating for the video
    • numratings - the total number of times someone rated your video

    Useful tip

    If you wish to make a batch edit of meta data for many videos it can sometimes be inefficient to use console. Instead you can edit the values in the downloaded CSV file and submit the edited version to Screen9 support and we will apply the update for you. This way you can easily edit the meta data of hundreds of videos in one go. Not all fields in the downloaded CSV are editable, read more about the details here.

    Was this article helpful?
    0 out of 0 found this helpful

    Comments