Skip to main content
Avalara Help Center

Automate FTP ISPI rates with a script

Overview

Automate downloading rate files from FTP.

Environment

Rate File Emails (ISPI)

Resolution

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.

 

 

 

 

  • Was this article helpful?