Bulk file import requires a Channel Admin user license. Contact LivingLens Support via Medallia Knowledge Center to request a Channel Admin user license for any channel requiring bulk import.
Bulk file import enables a user to import multiple media files and associated data to a LivingLens channel by configuring and uploading a .CSV template.
A user must have a Channel Admin user license for the required channel.
Media files must be hosted in Dropbox cloud storage.
Configure the template by fill out every column for each media file unless the column is noted as Optional. See Configure a bulk import template.
Configure a bulk import template:
1. Upload media files to a Dropbox folder.
2. Download the bulk media import .CSV template here. Row 2 in the template demonstrates how to format media data.
Important: Do not edit, delete or move any of the headings in row 1.
3. Populate video data into the .CSV.
Column A URL — Starting with row 2, paste sharable Dropbox links into column A of the template. To generate sharable Dropbox links,
Click Share>Create Link>Copy Link.
Change end of link to “dl=1” (the links have dl=0 as default).
Column B Source — Insert public into every row or use a spreadsheet editor Fill> Down.
Column C Title — Input the title of each media file. A Title has a 75 character maximum.
Column D Description — Optional. Input a description of the media. A Description has a 600 character maximum.
Column E LanguageCode — Input the code for the media spoken language eg. en if media is in English. For a full list of language codes, see Transcription and Translation supported languages.
Column F CountryCode — Input the media country of origin eg. US for United States, GB for the United Kingdom, CA for Canada. For a full list of country codes, see LivingLens supported country codes.
Column G Tags — Optional. Input tags for media. Separate multiple tags with a comma.
Column H-J Transcription and Translation — Set transcription (and translation if applicable) for each media file.
The template is set to request Machine Speech Recognition (column I Machine SpeechRecognition — yes). Replicate Columns H-J to request Machine Speech Recognition (speech to text) for media files. For non-English media, setting column I to yes automatically also requests a machine translation.
If you require human transcriptions and translations, set columns H-J accordingly.
Important: Human transcriptions and translations incur additional costs. Click here for a full list of costs.
Column H HumanTranscription — input yes in column H to request Human Transcription. Input no in column I.
Column J HumanTranslation — For non-English media, input yes in column J to request Human Translation. Only input yes in column J if you first input yes in column H to request Human Transcription. Input no in column I.
Restriction: You can only request Human Translation if you also request Human Transcription for a media file.
Column L and above Filter — Optional. Input filter data in columns L and above. Input one filter per column. Format is filter group:filter name, with no space on either side of the colon. See the following format examples:
Note: Verify there are no colons in filter data aside from the colon between the filter group and filter label e.g. Age:21-38. Additional colons prevent filter data from importing correctly.
4. Before importing your files into LivingLens, double check the format is correct.
Verify all Dropbox links end in “dl=1” (Links will have dl=0 as default).
Verify required columns are filled out. Recommended A-C, E, F, H-L.
Verify filter data is in the correct format e.g. Age:21-38, Gender:Male etc. and there are no colons in filter data aside from the colon between your filter category and filter label e.g. Age:18-25
Check that the file is saved in .CSV format
See here for an example of what a completed .CSV template should look like.
5. Upload the .CSV to the LivingLens channel.
a) Log in to LivingLens and navigate to the correct channel.
b) Open the menu next to the left of the channel name and select Imports.
c) Click Import Media.
d) Select the .CSV file in your file explorer.
Note: If you prefer to outsource bulk file import to the LivingLens team, please contact your account administrator.
Upload media (upload files one by one)