How to Import and Export Data in TSD

Go directly to Data import and export

Important Information

File naming conventions

It is important that the file name will respect few important rules:

  1. First character can be any number, character, hyphens or underscores excluding "." (namely 0-9a-zA-Z_- )
  2. Subsequent characters may be any number, character, hyphens or underscores including "." (namely 0-9a-zA-Z_-. )
  3. You can use the Norwegian characters æøåÆØÅ
  4. You can not use spaces, other special characters or other alphabets (cyrillic, etc.).

How to import and export data using the web file transfer

You can import files from your web browser using the web file transfer service. Read more about it here.

Importing Data

The imported data is stored in file-import  folder of the durable volume of your project - /tsd/pXX/data/durable/file-import/pXX-member-group.

Exporting Data

The exported data is read from the file-export folder of the durable volume of your project - /tsd/pXX/data/durable/file-export.

Browser requirements

Please use an updated version of either Google Chrome, Firefox, Egde or Internet Explorer. In order to use the service you need to have javascript and cookies enabled.

Using the API via the command line client

For researchers who prefer working on the command line, it is possible to use the same upload service with the TSD API client. There is no limitation on the size of data uploads when using the TSD API client. Files larger than 1 gigabyte will automatically be resumable. If for some reason your current upload fails, then you can resume it without having to upload the same data more than once.

For researchers who need to incrementally synchronise datasets into TSD, we recommend the S3 API. This is an object storage service, compatible with Amazon Web Services' S3 API. This service, which is available on request, and allows uploads with restart capabilities, and incremental synchronisation.

You can download and install the latest version of the command line client for both the file API, and the s3 API here.

Transferring data from closed hospital networks

Note: we will soon replace the fx03 solution with the API, and will be in contact with all users of the fx03 service to enable the transition.

We have designed the fx03 solution to allow import and export of non-encrypted sensitive data from sites where there is a control of the network from end to end. We have established fx03 solution with the following end-sites:

  • OUS - AMG/NSC Ullevål     (ull-gen-c2960g port 19 og 20)
  • OUS - Radium                     (radium-c2960g  port 1-4
  • UIO - NSC                           (bioe-9-sw port 12)

To set up the connection initially

  1. Check that you have the folders /fx/import_alt/ and /fx/export_alt in your TSD file system. These are the folders connected to fx03.
  2. Find the MAC adress of the server(s) you wish to hook up and send these MAC adresses to tsd-drift@usit.no.
  3. After getting the OK from TSD, please hook up your server to the correct port number in the switch and try connecting sftp to tsd-fx03.tsdintern.
  4. You can now transfer files, preferrably by creating a Tar/Zip file first.

SSH fingerprint

  • An important part of the security of FX03 data transfer is that the traffic is sftp encrypted between the project and TSD.
  • The ECDSA key fingerprint is ae:bc:70:e2:1c:d2:80:ee:e4:3b:5e:2a:51:1d:60:6f.
  • If projects see other fingerprints, please contact tsd-drift@usit.uio.no and stop any transfer of data.

How to encrypt files

Use 7-zip

This is only for TSD users using Windows on the inside and outside of TSD:

  1. Download and install 7-Zip.
  2. Start the 7-Zip program.
  3. Disconnect your computer from the internet (the best is to disable Wifi and unplug the internet cable).
  4. Attach the storage with your sensitive data.
  5. Add files into the 7-Zip.
  6. Click next.
  7. Click encrypt files (this automaticly writes files back to the same directory as the raw data was). NB! Be sure to tick off "Do not erase original data".
  8. Store encrypted files on computer somewhere that you are able to find later.
  9. Remove all attached storage devices with sensitive data, and sensitive files you stored on the computer before encryption.
  10. Connect to the internet, use the standard TSD "fil-sluse" to import data into TSD.
  11. Log in to TSD.
  12. Double-click your 7-Zip files.
  13. Type in your password and press decompress.
  14. Your files are decrypted.

Please have a look at the illustrated Norwegian Version.

Did you find what you were looking for?
Published June 30, 2016 4:15 PM - Last modified Oct. 9, 2019 11:50 AM