# Data Imports ## Overview Data imports allow users in correct security groups to transfer data from outside systems into their Stronghold environments. **Please note that all files transferred to the xfer server will be virus scanned, during which time they will be unavailable for transfer off of the server. This should only take a few minutes to complete, though it is dependent on the size and type of file being transferred.** Here's how it works: 1. First transfer the data to the xfer server via SFTP from a computer outside of your Stronghold environment * Users must be part of the `sh__import_w`security group for their tenant to complete this step 2. Then transfer the data off of the xfer server from inside your Stronghold environment * Users must be part of the `sh__import_r`security group for their tenant to complete this step ## Instructions ### 1. Transferring Import Data to Xfer Server from Outside System In order to import data into Stronghold you must first set up a site outside of your workstation. From a system outside of Stronghold, open **FileZilla** and click **File > Site Manager** ![FileZilla File Tab](https://lh6.googleusercontent.com/zjXOzbfnQnI_2tLssCWVxgI09TvHLlghvgCSLc8RvJGZAiVd-Ga9RWLy46Lra0iV-y4MCh0rO1AVR0H70GoejXgEIZqpGeVSTOggEWs9Up52DrY2skPG-DXQt_KXRM1waDuZxJZF) Click **New Site** and enter a name for it (e.g. "stronghold"). Under the **General** tab, add the following entries, replacing `` with the tenant you were assigned and `` with the same username used to log in to Workday. * Host: `.stronghold.brown.edu` * Port: `2222` * Protocol: `SFTP - SSH File Transfer Protocol` * Logon Type: `Interactive` * User: `` ![Site Manager Window](https://lh5.googleusercontent.com/vRSSQVWYeC_L8ZnbMYffkxKUB3cYDh_9CDHg3bRWtj25Pqf4edtUIcErW-CgGtlzwh_SSLfds5SphadDeHhx_Pa0mbcxlHNFRQ9enPuvnhYujd9bPVutMsVbIPkbQ6A55XHw8D24) Under the Transfer Settings tab: * Limit number of simultaneous connections: `CHECK` * Maximum number of connections: `1` ![Site Manager Transfer Settings Tab](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-LtPyMI69wwKVMrufbTA%2F-LtPySM3oEeuNx8bPxpy%2Ftransfer_settings.PNG?alt=media\&token=3f6f9188-18f1-4e03-b497-764746066944) Click `OK` to close the **Site Manager** window and click on the **Edit** drop down menu and select **Settings…** * In **Select Page** and under **Connection**, click on **FTP** * Change **Transfer Mode** to `Active` ![Settings Window](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-LtPyXUdAq536Inp6KLj%2F-LtPz4MmMsp64Ry5EDWf%2Fimage.png?alt=media\&token=ad4a4d91-9ff1-400e-8794-a603855df07e) Click `Connect` to begin the login process. Accept the server’s host key by clicking `OK`. You can check the box to `always trust this host`. ![](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-LtPzMBBOnVY7_IihoF9%2F-LtPzbWjyXxZLZFhg6bb%2FFilezilla_unknown_host_key.PNG?alt=media\&token=ce6accdf-803c-4ffd-a6bd-d06b818c2738) You will first be prompted for your password, enter the same password used to log in to Workday and click `OK` ![](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-LtPzMBBOnVY7_IihoF9%2F-LtPzkkI49bvBc47YwzG%2FFilezilla_password.PNG?alt=media\&token=194df6f4-161e-488a-b595-bc4881dc17b7) Next you will see what looks like another password prompt, but if you read the text you’ ll see it’s actually prompting you to select a Duo authentication method. Enter the number of your choice and click `OK`. Confirm your Duo authentication in the manner you selected. ![](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-LtPzMBBOnVY7_IihoF9%2F-LtQ0aZrwm-sZVQa1Yex%2Fduo.PNG?alt=media\&token=037ab69c-41d6-40b6-92f3-ce0135db104b) On the Remote site (right) pane, you should see an **import** and **export** directory. Double-click the **import** directory to expand it. ![](https://lh6.googleusercontent.com/iFumWyW8BgLYNAeYLCdMqV462iWxrqdkjUP49hXijlIxZuzqMLXyBv8ktTCxqRoYWTA_DG7z-JPjipK_eibmeWxlq4YTHnoxAYU0IQAVquD__X3bwQSDV4VY2pldeapCW4dTXp5q) On the Local site (left) pane, browse to the location of the file(s) you’d like to upload. Drag the file(s) to your user directory in the Remote site under your import directory and wait for the upload process to complete. **Next, the files will be virus scanned, during which time they will be unavailable for transfer off of the server. You can see if a file has not yet been scanned by checking the** `Owner/Group` **of the file in FileZilla:** ![The file is owned by root](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-M20163DKWSg3B3aoTUg%2F-M23k7n3Twh9T7nLxkZh%2Fsftp_permissions.png?alt=media\&token=aef4ae8f-8606-42e9-a39f-6fad8505da95) If `Owner/Group` is listed as `root root` the files have not finished being virus scanned. **You will not be able to access the files until the virus scan completes.** ### 2. Transferring Import Data from Xfer Server to Workstation In order to download your import data you will first have to set up a site inside of your Stronghold workstation From your Stronghold workstation, open **FileZilla** and click **File > Site Manager** {% hint style="info" %} * If your Stronghold tenant is running **Windows** or **Linux (pre-HyperV migration)**, you can skip this hint box and proceed with the main steps. * If your Stronghold tenant is **Linux (post-HyperV migration)**, please follow the steps below to launch FileZilla: * 1\) Click the top-left **Stronghold** menu and select **Terminal Emulator**. * 2\) Run `module load filezilla` command in the terminal to load FileZilla module: * 3\) Run `module load gcc/8.3.0 wxWidgets/3.0.4 nettle/3.4 libfilezilla/0.15.1 gnutils/3.5.18` command to load the required dependencies. * 4\) Run `filezilla` to launch FileZilla. {% endhint %} ![FileZilla File Tab](https://lh5.googleusercontent.com/7z_HURGJqRnLIvavkFthrAEnmDh7lwQ9agggR15lImTYELJaoc_gmCp0-_onhVIboEwtu8lHeQhUssggu_yNSYN8l2bphHaxKsHfsgPrykSGURD7a6SlYzubKeQZbAmY8bHwcNDK) Click **New Site** and enter a name for it (e.g. "stronghold"). Under the **General** tab, add the following entries, replacing `` with the tenant you were assigned and `` with the same username used to log in to Workday. * Host: `.stronghold.brown.edu` * Port: `2222` * Protocol: `SFTP - SSH File Transfer Protocol` * Logon Type: `Interactive` * User: `` ![Site Manager Window](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LcWdZhwLCll1J0u091B%2Fuploads%2FcFtJBJXHshGQYRe8zwDk%2Fstronghold-transfer.png?alt=media\&token=4c798860-bfd8-4843-ae34-4f8257c4b546) Under the Transfer Settings tab: * Transfer mode: `Active` * Limit number of simultaneous connections: `CHECK` * Maximum number of connections: `1` ![Transfer Settings Tab in SIte Manager](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-LtVynXuDA4FgoUOqEaZ%2F-LtVzV-sHzhULmSx44kU%2Fimage.png?alt=media\&token=ad976bbc-224e-44f5-9062-8b834383266b) Click `Connect` to begin the login process. Accept the server’s host key by clicking `OK` ![](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-LtVynXuDA4FgoUOqEaZ%2F-LtVzij0AeW83TgFE1On%2Fimage.png?alt=media\&token=3f35682c-1644-40b9-9436-1c3569b94d29) You will first be prompted for your password, enter the same password used to access Stronghold and click `OK` ![](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-LtPzMBBOnVY7_IihoF9%2F-LtPzkkI49bvBc47YwzG%2FFilezilla_password.PNG?alt=media\&token=194df6f4-161e-488a-b595-bc4881dc17b7) Next you will see what looks like another password prompt, but if you read the text you’ ll see it’s actually prompting you to select a Duo authentication method. Enter the number of your choice and click `OK`. Confirm your Duo authentication in the manner you selected. ![](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-LtPzMBBOnVY7_IihoF9%2F-LtQ0aZrwm-sZVQa1Yex%2Fduo.PNG?alt=media\&token=037ab69c-41d6-40b6-92f3-ce0135db104b) On the Remote site (right) pane, you should see an **import** and **export** directory. Double-click the **import** directory to expand it. ![](https://lh6.googleusercontent.com/iFumWyW8BgLYNAeYLCdMqV462iWxrqdkjUP49hXijlIxZuzqMLXyBv8ktTCxqRoYWTA_DG7z-JPjipK_eibmeWxlq4YTHnoxAYU0IQAVquD__X3bwQSDV4VY2pldeapCW4dTXp5q) On the Local site (left) pane, browse to a folder located somewhere inside /data. Drag the import files from the Remote site to the folder you selected and wait for the download process to complete.\ \ Pay attention to the `Owner/Group` of the files you are trying to move. If `Owner/Group` is listed as `root root` the files have not finished being virus scanned. **You will not be able to access the files until the virus scan completes.** If the virus scan is complete, `Owner/Group` will be your username and a group which you are a member of: ![The file is owned by kbrown59](https://240799936-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LcWdZhwLCll1J0u091B%2F-M20163DKWSg3B3aoTUg%2F-M23oCPfFWoTpozYFoQf%2Fsftp_kbrown59.png?alt=media\&token=850e55a7-79f0-4314-8bc5-cdd9b4da8de7) **Note:** FileZilla does not refresh automatically. In order to continue to check if your files are ready yet, you either will need to navigate to a different folder and back again OR close FileZilla and reopen the connection.