Data Exports
Last updated
Was this helpful?
Last updated
Was this helpful?
Users in both export security groups are allowed to transfer data from their Stronghold environments to outside systems. 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, type, and number of files being transferred. Here's how it works:
First transfer the data to the xfer server via SFTP from inside your Stronghold environment
Users must be part of the sh_<tenant>_export_wsecurity group for their tenant to complete this step
Then transfer the data off of the xfer server from a system outside your Stronghold environment
Users must be part of the sh_<tenant>_export_rsecurity group for their tenant to complete this step
In order to upload your export your data you will first have to set up the xfer server as a site inside of your Stronghold workstation
From your Stronghold workstation, open FileZilla and click File > Site Manager
Click New Site and enter a name for it (e.g. "stronghold").
Under the General tab, add the following entries, replacing <tenant> with the tenant you were assigned and <username> with the same username used to access Stronghold.
Host: <tenant>.stronghold.brown.edu
Port: 2222
Protocol: SFTP - SSH File Transfer Protocol
Logon Type: Interactive
User: <username>
Under the Transfer Settings tab:
Transfer mode: Active
Limit number of simultaneous connections: CHECK
Maximum number of connections: 1
Click Connect to begin the login process
Accept the server’s host key by clicking OK
You will first be prompted for your password, enter the same password used access your workstation and click OK
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.
On the Remote site (right) pane, you should see an import and export directory. Double-click the export directory to expand it.
On the Local site (left) pane, browse to the location of the file(s) you’d like to upload. Drag the file(s) to the Remote site 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:
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.
In order to download your export data from Stronghold you must first set up the xfer server as a site outside of your workstation.
From a system outside of Stronghold, open FileZilla and click File > Site Manager
Click New Site and enter a name for it (e.g. "stronghold").
Under the General tab, add the following entries, replacing <tenant> with the tenant you were assigned and <username> with the same username used to log in to Workday.
Protocol: SFTP - SSH File Transfer Protocol
Host: <tenant>.stronghold.brown.edu
Port: 2222
Logon Type: Interactive
User: <username>
Under the Transfer Settings tab:
Limit number of simultaneous connections: CHECK
Maximum number of connections: 1
Click on the Edit drop down menu and select Settings…
In Select Page and under Connection, click on FTP
Change Transfer Mode to Active
Click Connect to begin the login process.
Accept the server’s host key by clicking OK.
You will first be prompted for your password, enter the same password used to access Stronghold and click OK
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.
On the Remote site (right) pane, you should see an import and export directory. Double-click the export directory to expand it.
On the Local site (left) pane, browse to a folder located somewhere inside /data. Drag your export 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:
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.
