Uploading Data Sets in one Data Template
You can upload a Data Set using a .CSV file by clicking on the Upload button after opening the data set of the template:
To create a new CSV file and upload it into Subject7, you can enter data on a new spreadsheet to match the columns as you see in Subject7.
Example:
Your images will be uploaded to the data set as below. Click Save once you finish uploading.
datasets by going to the data template and opening the dataset. Then, you can use the Upload link to upload a collection of datasets in CSV file format.
Create a new file to upload into Subject7 and save it as CSV format. The first column will be used as a 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 dataset names (rebecca_production_user and jamie_production_user) and their usernames and passwords are specified in columns B and C.
| Info |
|---|
For best results when your dataset includes encoded characters, please save the file as CSV UTF-8 |
You will be prompted to replace the existing values if the dataset name is the same. You can either click Yes or No.
Your datasets will be uploaded as below. Notice that the default dataset which was automatically generated is still visible. You can remove it, but first you must select another dataset as the default one.
In order to set another dataset as a default one, simply click on the checkbox next to it and click Default.
| Info | ||
|---|---|---|
| ||
You can upload data sets using REST API by navigating to: |
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.
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.
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.
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 | ||
|---|---|---|
|
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 | ||
|---|---|---|
|
*PS: To practice uploading, you can download the attached "Data Files.zip" below which includes the .csv files used in the videos.
View file