Dr. Chythlook!

Here's an example of the FTP automation setup we're using at KSDP. I'm using the APRN Morning ECONOMIC report for this example on a Windows 7 machine.

This automation routine has two main goals:
a) Get the ECON Report MP3 from the APRN FTP site every weekday morning.
b) Clean up and blank out the file so we don't have a repeat.

Software Used:
WGET: A command-line utility for retrieving files using HTTP, HTTPS and FTP protocols.
	ABOUT - https://www.gnu.org/software/wget/
	DOWNLOAD - https://eternallybored.org/misc/wget/current/wget.exe

NOTEPAD: Notepad is a basic text-editing program and it's most commonly used to view or edit text files.
http://windows.microsoft.com/en-us/windows/notepad-faq

ROBOCOPY: Robocopy (the name is short for Robust File Copy) was introduced with the Windows Server 2003 Resource Kit and is included in all editions of Windows 7. Its many strengths include the ability to copy all NTFS file attributes and to mirror the contents of an entire folder hierarchy across local volumes or over a network.
https://technet.microsoft.com/en-us/magazine/ee851678.aspx

TASK SCHEDULER: Schedule computer tasks to run automatically.

1) Download WGET.exe & place in "C:\Windows\System32".  The other three programs are included in Windows.

2) Unzip the attached folder (ksdp-aprn-ftp-econ-example.zip). 

3) REMOVE ".txt" from the filename "10-wget-econ.bat.txt". Right-click & "edit" the BATCH (.bat) file titled "10-wget-econ.bat". It is a txt document with a couple lines of scripting on it & will open up with NOTEPAD. If you right-click and select "open" - Windows'll run the script and tell WGET to download the ECON MP3 from APRN's FTP site and save it in the local folder "transfer/aprn/". It also renames the MP3 from "0010.mp3" to "econ.mp3". 

4) Now that we have a BATCH script to download our audio file, let's use TASK SCHEDULER and tell it when to do that. I included "ECON.xml" as an example task you can import. When you import it, you'll have to change the "ACTIONS" tab to select the location of the BATCH script you want to use. Other than that, it should schedule itself to download ECON.mp3 every M-F at 7:45AM. 

5) Since we don't want to ever air old news programs, we'll use ROBOCOPY to overwrite "econ.mp3" with a BLANK audio file every day after it airs. REMOVE ".txt" from the filename "robocopy-aprn-blank-mp3.bat.txt". Right-click & "edit" the BATCH (.bat) file titled "robocopy-aprn-blank-mp3.bat". It is a txt document with a couple lines of scripting on it & will open up with NOTEPAD. If you right-click and select "open" - Windows'll run the BATCH script to overwrite the MP3 with a blank/laser audio file.

6)  Now that we have a BATCH script to overwrite our audio file after it has aired, let's use TASK SCHEDULER and tell it when to do that. I included "APRN cleanup.xml" as an example task you can import. When you import it, you'll have  to change the "ACTIONS" tab to select the location of the BATCH script you want to use. Other than that, it should schedule itself to overwrite ECON.mp3 every day at 5pm.