Hi all,
FTP server contains some of the most important information that goes into our models. Timely download of this data is critical to timely execution of our work.FTP releases data (file1-file5) on the first working day (EST) and we wanted to have this data downloaded & unzipped in the night itself by some automated process, so that it can be processed without any delay.
Please note that all the files have extension as “.zip” except for one file, which is a doc file. Download to the mentioned location and unzip the files to same location. Also do not delete the zipped file.
No. FilName.extn RenameTo DownlodTo Frequency
1 db1.zip N/A VL_Rawdata\YYYYMMDDvl Monthly
2 db2.zip N/A Monthly
3 Dead_db2.zip N/A Monthly
4 ESTDBASE.ZIP N/A Monthly
5 quart.zip N/A Monthly
------------------------------------------------------------
6 Bulletin.doc Bulletin_x \VL_Rawdata\20100831vl\Bulletin Weekly
------------------------------------------------------------
Important Notes:
- New directory has to be created at the location \VL_Rawdata with the name as YYYYMMDDvl (case-sensitive).
Date convention is bit tricky here. Bulletin files come weekly (available on Monday every week by EST). Rest other files (1-5) comes on the first working day (EST). YYYYMMDD is the last calendar (may be a holiday as well) of the last month, where current month can be taken from the time stamp of the file1-file5.
We may have 4-5 bulletin.doc files depending upon number of Fridays in the last month.
-Bulletin files should be renamed to Bulletin_x, otherwise new bulletin file will overwrite the previous one.
Where x can be 1, 2,3,4,5 or timestamps of the particular file, whichever is easy to implement.
Please give us a solution for the above scenario. Please let me know if something is left unclear
Thanks
Sanjay
