Automate FTP ISPI rates with a script
Overview
Automate downloading rate files from FTP.
Environment
Rate File Emails (ISPI)
Resolution
- This can only be done if you download rate files via FTP
- Contact your Account Managerif you want access to rate files via FTP
Create a script to automatically sign into the FTP folder and download the files to a specific location on your computer.
| Script Template | Example Script |
|---|---|
| C:\Windows\SysWOW64\ftp.exe -s:%0 open FTP.Taxrates.com USERNAME PASSWORD cd FTP_FOLDER_NAME lcd PATH_TO_SAVE_TO get FILE_TO_DOWNLOAD bye |
C:\Windows\SysWOW64\ftp.exe -s:%0 open FTP.Taxrates.com AvaTest password cd ftp025_AvaTest lcd "C:\Rate Files" get TAX.ZIP bye |
Add more "get" commands followed by the FILE_TO_DOWNLOAD if you would like to download multiple files at once.
- You can set this to download any file that is in your download folder by adding another GET command to it.
If you get an error saying it cannot find the FTP program, you may need to change the first line to the location of your FTP.exe program. On a 32-bit system it is generally in the c:\Windows\System32 folder.
Create a ftp-docs.bat file to automate this. Use it each month to get your new rates each month or set this to run as a Windows task. To set as a task you will want to run the CMD program and set your "Add Arguments (Optional)" to /c PATH_TO_BAT_FILE.
Note: For security, delete permissions aren't allowed on FTP folders containing rates.