Sample scripts are provided as-is with no warranty of fitness for a particular purpose. These scripts are solely intended to demonstrate techniques for accomplishing common tasks. Additional script logic and error-handling may need to be added to achieve the desired results in your specific environment.
jpmc_download_upload.s
JPMorgan Chase supports numerous automated banking applications (Lockbox, PositivePay, ACH, etc.) over the internet.
Robo-FTP provides all the functionality needed to securely automate the process of uploading and downloading files with JPMorgan Chase.
Their requirements include:
- A secure file transfer protocol such as FTPs, sFTP, or HTTPs (all supported by Robo-FTP)
- A file encryption method such as PGP (supported by Robo-FTP)
This sample script will use sFTP, although you could use FTPs or HTTPs if you prefer.
JPMorgan Chase will provide the information you need to get connected and to encrypt files for uploading:
- The URL for their sFTP server
- The user name they have assigned to you
- Their PGP public key (usually sent as a file attachment)
Once you have this information you can configure Robo-FTP. Here is a short summary of the steps you will need to complete in the Robo-FTP Configurator:
- Create an SSH key pair for authenticating to the sFTP server. This is done from the Configure SSH tab. The default settings are fine. Name the key file anything convenient (JPMorganChaseSSHKey is fine, for example).
- Email the public part of the SSH key to JPMorganChase. If you used the naming example given above, the public key will be named JPMorganChaseSSHKey.ssh2.
- If you plan to download files from JPMorgan Chase, create a PGP key pair from the Configure PGP tab. The default settings are fine.
- If you created a key pair in the preceding step, export the public part of that key and email it to JPMorgan Chase. You can export your public key by clicking the Manage Keys button in the Configure PGP tab.
- If you plan to upload files to JPMorgan Chase, you need to import their public key. You can import a public key by clicking the Manage Keys button in the Configure PGP tab.
The sample script below demonstrates how easy it is to communicate with JPMorgan Chase's sFTP server with Robo-FTP. This sample script logs on, encrypts and uploads any files to the incoming directory, then downloads and decrypts any files waiting for you in the outgoing directory.
1 ftplogon "url given by JPMC" /user=YourUserName /servertype=SFTP /keyauth /trust=all
2 ;; Encrypt and upload files
3 ftpcd "incoming"
4 workingdir "c:\JPMC\uploads"
5 :upload_loop
6 getnextfile "*" /oldest
7 IFERROR= $ERROR_NO_FILE_FOUND goto download_files
8 set encrypted_file = %nextfile + ".pgp"
9 PGPENCRYPT %nextfile encrypted_file /user="JPMC"
10 sendfile encrypted_file /delete
11 delete %nextfile
12 goto upload_loop
13 :download_files
14 ;; Download and decrypt files
15 ftpcd "../outgoing"
16 workingdir "c:\JPMC\downloads"
17 getsitefile "*" /oldest
18 IFERROR= $ERROR_NO_FILE_FOUND goto done
19 rcvfile %sitefile /delete
20 set decrypted_file = %sitefile
21 setright ext = decrypted_file 4 /split
22 pgpdecrypt %sitefile decrypted_file
23 delete %sitefile
24 :done
25 FTPLOGOFF
26 exit