File Upload enables you to upload data directly to the SundaySky Video Platform, after which you get back a list of unique video links for each of the records.

With this method, you can upload a data file at any time that you want.

If you have created a landing page on your own, continue reading. If you are using the SundaySky Landing Page Builder to create your landing page, see Using the Landing Page Builder to learn how to generate the video links.

Generating the Video Links

1.

In Your Videos, locate the relevant video.
2.

Click the three-dot menu on the video thumbnail and then select Video Page.
▶ Alternatively, you can click the video thumbnail to access the video page.
 

click_video_page.jpg
3. Click the three-dot menu on the right side of the page.
Click_the_three_dot_menu.jpg
4.

Select Generate video links.
▶ If you do not see this option, the video has not yet been published.
Generate_video_links.jpg 
5.

Upload your data file using either of the following options:
a. Drag and drop the file to the area bordered by the dotted lines.
b. Click Upload From Computer and then locate and upload the file from your local or cloud storage.
▶ See Preparing the Data File for specific guidelines on how to structure and prepare this file.
 

Click_upload_from_computer.jpg
6.

Enter the URL of the landing page where the video will be played and then click Next.
▶ This is the webpage in which the SundaySky video player is embedded.
 

Enter_landing_page_URL.jpg
7.

Click Download Video Links.
▶ At this stage, the data is saved in the SundaySky platform and the unique video links are generated.
 

Click_download_video_links.jpg
8.

Open the downloaded file with the video links.
▶ This file can also be sent to your email service provider.

video_links.jpg

In the SundaySky player, the video appears similar to the example below:

SundaySky_player.png

Preparing the Data File

1.

Click Your customized CSV Template to download the data file template.
 

Your_customized_csv_template.jpg
2.

Open the data file template on your desktop. This template includes the data elements used for personalizing your video. Each data element name is a column header.
The data file that you upload needs to be in the same format as this file. In addition, the letter casing must also match.
▶ In the example below, there are three column headings: id, First Name, and Customer Type. According to this example, the column headings in the uploaded file must exactly match the column headings in the template: id in column A, First Name in column B, and Customer Type in column C.

csv_template_example.png
3. Prepare the data file using one of the following methods:
  Method 1 Copy the header columns from the data file template to your company data file. Make sure that the values beneath each column header are relevant to the column header (data element).
  Method 2 Use the data file template as your data file and enter the relevant values in each row.
  Method 3 Use the data file template only as a reference. Compare the column headings in your data file to the template to make sure that the format is correct.

Important Notes:

a.

Every column must have a column header.
b.

The column header name must be unique and differ from the other column header names.
c.

The id column is mandatory and must always be the first column (A). The column header id must always be written in lowercase.
d.

Every row (record) must have an id value. Values for all other column headers (fields) are optional. In the case of an empty value, the message shown in the video will be according to the default message defined in the video.
e.

The id value in each row must be unique. This is for two reasons:
a. A unique video link is created for each record.
b. The id value is used in detailed reports.
4.

Save the file in CSV UTF-8 (Comma delimited) format.

More articles from Data Integration

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

Still Have Questions?

SundaySky Support is here for you

contact support