Code must be written with VB.NET latest version, and latest framework.
My requirements are:
Pre-requisites:
? 1. Must use VB.NET.
? 2. Must have comments in every call of any sub.
? 3. must use only the existing .net components.
? 4. If a third party component is needed, then let me know before you start, so we can discuss if it is really necessary.
STEP 1:
Get a group of files (binary files)from a ftp server using binary transfer mode, on hourly basis. make sure the next get process does not get the ones he got the hour ago.
it should look into only the new files generated after the last get.
STEP 2:
process the files one by one in a particular way I will describe :
Note: the files does not have the same size.
you can consider this file as just one very long line divided in blocks of 200 characters.
example: if a file is of size 576,000 bytes, than it will contain 576,000 / 200 = 2880 blocks. each block represents one record.
and each record is having 200 CHARACTERS (BYTES).
The program should show me a setting form where I can enter the fields and the character length for the record. this will give me flexibility to increase or decrease the size of the block in the future.
Note2: the files does not have extention.
STEP 3 :
Migrate the results you get as records into a database . Microsoft SQL server.
name the database: datavolume
name the table : tablevolume
you got the point.
I don't want to invest in oracle/sybase or whatever.
STEP 4:
Put the sorted files(binary files) as text ( rename them with .TXT extension),to an ftp server, into a certain directory structure (you can suggest).
Once phase 1 is completed successfully, then 4 other phases will come. having same or more complexity.
If you are a good coder in VB.NET (socket programming/ text manipulation) and SQL server. then you can apply. if not, please don't.