Mandatory system role to be able to load datasets: Database Creator. Ask your server supervisor for the role assignment if you need it.
How to upload your first Database
Compress your data using ZIP before uploading. Certain formats, such as CSV, can achieve significant size reductions of up to 10 times or more. By zipping your data files, you'll experience faster upload speeds and circumvent file size restrictions.
-
In DataTile Drive, click the '+' icon in the top menu and select 'Database’.
-
In the pop-up box, type in the name of a database, or it will be autogenerated from the file.
-
Select or drop the file. A quick file format validation is performed during upload. If everything is correct, the window is shown in green. If an error is detected, it is shown in red.
-
If the check is successful, click Upload.
You can drag and drop a file into the space to upload it. Loading of multiple files is forbidden.
Database upload with a codebook is performed using a single ZIP file.
A codebook (data map) helps refine data structure and provide additional information, including variable types, labels, data mapping, etc.
Supported file formats
DataTile supports the following formats of data files:
|
SPSS |
*.sav, *.zsav |
|---|---|
|
Excel |
*.xlsx, *.xls (note that support of XLS will be ceased in the future) |
|
Text formats |
*.csv, *.tsv |
|
Parquet |
It’s in development and will become available soon. |
|
IBM360 |
A legacy format that is mostly used for big syndicated databases. |
|
triple-s |
We have discontinued support for triple-s format due to their rarity and unwieldiness. If you require assistance, please reach out to our support team. |
-
Read our tips on preparing SPSS files.
-
Read our tips on preparing Excel files.
Upload additional datasets (survey waves)
DataTile supports the loading of multiple volumes united in a single database. You can add as many additional files as needed. After the first dataset is uploaded, all further management is handled in the DATA Panel.
Here, you can add new volumes or replace existing ones as needed. Both operations can be performed using the ‘Upload new file’ button.
When replacing, all previous data will be deleted. You need to give explicit consent to this.
All volumes are stored separately. Their visibility can be managed individually.
The more detailed information is provided in the article ‘Uploading multiple waves for tracking studies’.