Forum Auto Downloader

Notes

•	The server that this script will be running on will have a parent folder with many subfolders.
	These subfolders will be the name of each genre (which also matches the individual forum titles).

•	There will be a separate .csv file named after each genre in the parent folder. The file will have 3 columns
	named [title, url, status]. The column headers will be located in A1, A2 & A3.

		[title] will hold the extracted forum post title.
		[url] will hold the forum post url.
 		[status] will display a 0 or 1 :

		0 if the Zippyshare link url displays an error message of "expired or does not exist".

		1 if the save as download dialog appears, or if the Zippyshare download button is available.
 		(Whatever is better recommended for longevity).


Steps of the Script

1.	Check the .csv file for a match in the [url] field. If there is a match, stop the script.
2.	Extract the [title] of the post.
3.	Save the extracted [title] to the .csv file. Place in cell A2.
4.	Select the next post.
5.	Extract the [url] of the post.
6.	Save the extracted [url] to the .csv file. Place in cell B2.
7.	Click the download link inside of the forum post, opening a zippyshare link.
	a.	The download link is in the form of an image, which is static across all forum posts.
8.	Download the file from the Zippyshare link.
	a.	The download link is in the form of an image, which is static across all Zippyshare urls.
9.	Use the extracted title from step [3], which is stored in A2, as the title of the downloaded audio file.
10.	Once the download has started, mark the [status] field in the spreadsheet 1.
11.	If the download is not available Zippyshare will display the error
		"File has expired and does not exist anymore on this server”
 		If the error is displayed, mark the [status] field 0.
12.	Loop from step [2]
13.	If the script runs 40 times, navigate to the next page on the forum.
	a.	The next page link is in the form of a image, which is static at the bottom of the each page.
	b.	The script will run 40 times, because this is the number of post entries per page.


Notes:

•	After the file is saved successfully, the next entry should move down one row in the .csv sheet.