We need a windows based script that will process number files in csv format from an ftp server, add a date column to those files and return the processed number files (input file) to the ftp server for reprocessing. This reprocessing will produce an output file which will then be downloaded.
Number files are updated every 8 hours. The file naming convention is standardized.
The processed number files take about 30 minutes to re-process.
The reprocessed files must be downloaded into our system and copied into a specific directory.
We currently use Core FTP to ftp files up and down. It can be used on the command line.
Download latest number files. You must be sure to download only files which are new/never have been downloaded before.
Download from: [url removed, login to view]
Name of file (example): 20090416 [url removed, login to view]
Note that the file is in YYYYMMDD HHMM-HHMM format. There will be 3 files generated per day. 0000-0800, 0801-1600, 1601-2359. Each updated number file must be downloaded every 8 hours.
Example of file contents:
Add date column to numbers and rename file so we know it’s processed. This is the input file.
New file name: 20090416 [url removed, login to view]
Example of updated file contents:
Upload input file to [url removed, login to view]
File will be processed and ready for download from [url removed, login to view]
The processed filename format will be:
Results20090416 [url removed, login to view]
Download output file.
Output file will be moved to a specific directory on remote server.