Uploading Data Sets in one Data Template
You can upload data sets by going to the data template and opening the data set. Then, you can use the Upload link to upload a collection of data sets 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 data set 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 names (rebecca_production_user and jamie_production_user) and their usernames and passwords are specified in columns B and C.
Your data sets will be uploaded as below. Notice that the default data set which was automatically generated is still visible. You can remove it, but first you must select another data set as the default one.
In order to set another data set as a default one, simply click on the checkbox next to it and click Default.
Tip
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 into multiple data templates, you can use the Multiple Data Sets feature by following steps below:
1- In Data Templates, select the data templates where you would like to upload multiple data sets 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 from your device.
4- Note that the first column of the file must include a unique name for the data set 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 set. You can do that as below:
A- If you have a data file for each data template, simply select the data template where each data file will go.
B- If you have many data files which will go into different data templates, upload all data files, select the first batch of data files, select the default data template for them from the “Default Template” field and then click Apply Default. Select the second batch of data files and select their default data template as before.
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 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 sets.
8- Once uploading is complete, you can delete the default data set 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
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
*PS: To practice uploading, you can download the attached "Data Files.zip" below which includes the .csv files used in the videos.