Importing a File into the Data Element Library

Although the data element library makes it very easy for you to create and update data elements inside the SundaySky platform, there may be times when you will prefer using a spreadsheet to create all your data elements and values, using a batch operation. And there may be times when you'll want to import a file only when you want to make changes to existing data elements or values.

However you decide to work, remember that the data element library and the files you import work in perfect harmony. Depending on the number of data elements and values that you need for personalizing your videos, you can decide how and when to use the tools that SundaySky provides you with.

It is important to remember that the file you prepare and upload to the data element library only defines the library schema (structure). When you are ready to publish your video, you will upload a different file that is used to generate the video links. Every time you upload a schema file, it overwrites the current library and determines what data elements and values are available for your use.


To import a file into the data element library:

1.

Access the relevant video.

2.

Select Data in the sidebar.

 

Select_data_in_sidebar.png

3.

Click Import From File.

click_import_from_file.png

4.

Click Download Library CSV.

download_library_csv.png

The current data element library is opened in Excel, displaying all the data elements and values that have been created in the library. You can now begin making changes in the spreadsheet.

Current_data_element_library.png

5.

Update the data element library as required.
▶ In the example below, the following changes were made:
   a. A new data element, Age Group, was added.
   b. Four values were added to the Age Group data element: Gen X, Gen Y,
       Gen Z, and Baby Boomer.

Updated_spreadsheet.png

As you update the spreadsheet, make sure to follow the guidelines below to ensure that the data library is structured properly:

a.

Every column must have a column header. The column header is the name of the data element.

b.

The column header must be unique and differ from the other column headers.

c.

The id column is mandatory.

d.

The column header id must be in lowercase.

e.

The spreadsheet must contain columns for all the data elements (and values) that are in use.

f.

Before removing a data element or value, make sure that it is not being used in any of the scenes.

g.

A data element column that is not included in the file will be deleted from the data library.

h.

Save the file in CSV UTF-8 (Comma delimited) format.
If you encounter a problem in saving the file in Excel, we recommend saving the file in a basic text editor (such as Notepad) using UTF-8 encoding.

6.

When your updated data library is ready for uploading, click Upload CSV.
▶ Before uploading, make sure that all the data elements and values that are in use exist in the updated file. Any data element or value that is not in use and that does not exist in the file will be permanently deleted from the data library.

Upload_csv.png

7.

Upload your CSV 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.

file_upload.png

After the file has uploaded successfully, a confirmation message is displayed, indicating the changes made to the data library:

upload_successful.png

The updated data element library is displayed.
▶ In the example below, the data element Age Group was added, together with its associated values (see step 5 above).

Updated_data_library.png

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

Comments

0 comments

Article is closed for comments.