Before you can upload a data file:
- You must have FTP client software which supports the SFTP protocol and AES-256 cypher strength (most recent clients offer this support as standard) such as WinSCP, FileZilla and the PuTTY PSFTP program.
- You must have the domain name of the Workspaces SFTP server, which can be supplied by your Workspace Administrator or your organisation's Service Desk.
Connecting to the SFTP using WinSCP
To upload data using the SFTP service using the popular SFTP client WinSCP you must:
- Download and install the WinSCP client – https://winscp.net/eng/download.php.
- Start the WinSCP client.
- Insert your SFTP credentials:
- host name: xxxxxxx@host.com
- username: your Workspaces username
- password: your password
- click 'Login'
- Select the files to upload from your local machine and drag them to the data upload folder – this example uses the Iris dataset.
- Drag and drop iris.csv to the Data folder.
- Once the data file has been copied in full to the Data folder, the platform will automatically start to load the data into the workspace.
Once the data processing has been completed a log file reporting the success or failure of the upload, giving detailed information on the process of how data was loaded in case of the successful upload, or why the upload failed is created in the upload folder. The resulting file has a name in the following format:
<filename>_<success/fail>_<year> <month> <day>_<hours> <mins> <secs>.txt
For example:
iris_success_20160306_121535.txt
iris_fail_20160307_142743.txt
The time needed to upload and process the data is dependent on the size of the data file and the speed of the network connection. If your SFTP client supports it, enabling compression can reduce the transfer time.