Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Uploading Data Sets in one Data Template

You can upload data sets datasets by going to the data template and opening the data setdataset. Then, you can use the Upload link to upload a collection of data sets datasets in CSV file format.

Image RemovedImage Added

Create a new file to upload into Subject7 and save it as CSV format. The first column will be used as a data set dataset name in Subject7, so you need to make sure this is a universal name which has not been used in the platform before. The following is an example of a file that includes 2 data set dataset names (rebecca_production_user and jamie_production_user) and their usernames and passwords are specified in columns B and C.

Image Added

Info

For best results when your dataset includes encoded characters, please save the file as CSV UTF-8

Image Added

You will be prompted to replace the existing values if the dataset name is the same. Image RemovedYou can either click Yes or No.

Image Added

Your data sets datasets will be uploaded as below. Notice that the default data set dataset which was automatically generated is still visible. You can remove it, but first you must select another data set dataset as the default one.

Image RemovedImage Added

In order to set another data set dataset as a default one, simply click on the checkbox next to it and click Default.Image Removed

Image Added


Info
titleTip

You can upload data sets using REST API by navigating to:

https://platform.subject-7.com/spec/index.html#/

Uploading Multiple Data Sets into Multiple Data Templates

If you have a large amount of data (in .csv files) that you need to upload as data sets datasets into multiple data templates, you can use the Multiple Data SetsDataSets feature by following steps below:

1- In Data Templates, select the data templates where you would like to upload multiple data sets datasets by clicking on the checkbox next to each template.

Image RemovedImage Added

2- Click Import Data Sets from the toolbar.

3- A popup window will appear. Click +Add Files to Select files(s) to select files from your device. 

Image RemovedImage Added

4- Note that the first column of the file must include a unique name for the data set dataset reserved in Subject7, the remaining columns will be inserted into the fields you created in the data template.

5- Once you select all the needed files, now it is time to organize where each data file will go into which data template to be uploaded as a data setdataset. You can do that as below:

...

6- When finished organizing, click Import and the data sets will get imported directly into the data templates. You will be prompted to overwrite data sets if they already exist inside the templates you are uploading.

Image Added

7- If you have data set dataset names that are repeated in other data templates, an error message will appear to let you know that you need to rename them in the files or rename the already existing data setsdatasets.

8- Once uploading is complete, you can delete the default data set dataset entered by the system and set another one as your default.

Example Video (1): The video below shows how the 3 files with several data will be uploaded into 3 data templates:

1- file_1.csv        >             data_template_1

2- file_2.csv        >             data_template_2

3- file_3.csv        >             data_template_3

Widget Connector
urlhttp://youtube.com/watch?v=mLdisHR74Uc

Example Video (2): The video below shows how 28 individual files will be uploaded into 3 data templates:

1- file_1.csv        to            file_24.csv           data_template_1

2- file_25.csv      to            file_26.csv           data_template_2

3-file_27.csv       to            file_28.csv           data_template_3

Widget Connector
urlhttp://youtube.com/watch?v=Uf0T2o3KQrk

*PS: To practice uploading, you can download the attached "Data Files.zip" below which includes the .csv files used in the videos.

View filenameData Files.zipheight250