Importing videos in bulk
Using the Import button in the header of Media Manager, videos can be uploaded in bulk from rows in a spreadsheet.
Creating the spreadsheet
The first row of the spreadsheet should contain column headings. Whilst column names do not need to match one from the table below, columns that are recognised will be pre-filled in the import form.
Available video fields
| Field | Notes |
|---|---|
| title | Required field. Video title. |
| url | Required field. Video file URL, Include http(s):// |
| description | Video description. |
| tags | Comma separated text, each tag may contain spaces. |
| folder | Folder ID to save the video to, defaults to the root folder for the team. Folder IDs are the number in the URL path when viewing a folder. |
| thumbnail | Image file URL, Include http(s):// |
| downloadable | 0 = Not downloadable, 1 = Downloadable. Default 0. |
| previewable | 0 = Not previewable, 1 = Previewable. Default 0. |
| published | 0 = Not published, 1 = Published. Default 0. |
| intro_start | Number of seconds into the video the introduction starts. |
| intro_end | Number of seconds into the video the introduction ends. |
| recap_start | Number of seconds into the video the recap starts. |
| recap_end | Number of seconds into the video the recap ends. |
| custom_button_url | Add a button in the player that links to this URL. |
| custom_button_title | Text to show when the mouse is hovering over the custom button. |
Custom fields
To add custom fields to a video from a spreadsheet import, add a column into the spreadsheet per custom field. The column name will become the field key/name with any spaces replaced by underscores. On the field mapping screen, add each custom field using the dropdown, click add once selected for each item (see screenshot).
Sample spreadsheet
The table below illustrates the format for importing videos using public facing video file URLs.
| title | description | url | tags |
|---|---|---|---|
| Annual General Meeting Highlights | Jane Doe reports from the Annual General Meeting in London. | https://example.com/path/to/video.mp4 | AGM,London |
| Information video for industry experts | https://example.com/path/to/video2.mp4 |
Import videos from a legacy Media Manager account
By selecting the Media Manager options on the first screen of the import form a Media Manager ID can be used in place of the url field to obtain the video data directly from a legacy Media Manager account. In this case the title field is not required to be included in the spreadsheet, any additional fields provided will override values from legacy Media Manager.
| mmid |
|---|
| 5de98024d404a021af81d1b9 |
| 5fb2f6e5d404a04e7f03cb6a |
The import will ask for a Client ID and API key. The Client ID is the first part of the website domain when looking at the legacy Media Manager account; after https:// and before .getmediamanager.com. The API key can be found in the Full Access Key field under the API tab in the Account section of a legacy Media Manager account.
Uploading the spreadsheet
Once video information has been compiled into a spreadsheet, uploading to Media Manager is quick and easy. The form has only a handful of short steps:
- Select if videos are being transferring from a legacy Media Manager account or uploaded from file URLs
- If transferring from a legacy Media Manager account, add the Client ID and API key
- Upload the spreadsheet
- Match the columns up to fields that Media Manager recognises
Once the form has been submitted a page will be shown that details the status of all videos being processed from the spreadsheet (shown in screenshot below). If this is the first import for the active team an additional link in the left hand menu will now show called Imports.
To automatically refresh the results press the Auto-refresh button, marked as ① in screenshot. It will highlight green to indicate that the auto-refresh is active. When an error is found, or a video finishes uploading or processing the results will update without the need to refresh the page.
An import can be given a more identifiable name by clicking edit, marked as ② in the screenshot.
Any rows that Media Manager was not able to validate will show in a list of errors. The easiest way to re-process rows that did not succeed is to download the errors CSV file (marked as ③ in the screenshot). This can be amended and re-uploaded in a new import.
Deleting imports
Imports can be deleted from the imports list accessible from the left hand menu. Deleting an import will not remove the videos that were created as part of the import, you have to do this on the video grid. If all imports for a team are deleted the link in the left hand menu will be hidden from view.