En curso

Binary file sorter to SQL server using VB.NET

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.

Habilidades: .NET, Ingeniería, Microsoft, MySQL, PHP, Gestión de proyectos, Arquitectura de software, Verificación de software, SQL, Visual Basic, Windows Desktop

Ver más: where to start programming, visual programming with vb net database table, vb note, use of binary, use in vb.net, t sql programming, sql to oracle, sql code oracle, socket programming in php, programming sql, programming in visual basic 2010, programming in sql, programming in binary, oracle framework, one hour ago, net socket programming, my name in binary code, my name in binary, microsoft visual basic programming, just want to start programming, hour ago, get file size using vb net, ftp framework, example of vb.net, example of vb net

Información del empleador:
( 2 comentarios ) Kuwait

ID de proyecto: #3095225

Adjudicado a:

cuebiztech

See private message.

$144.5 USD en 14 días
(114 comentarios)
5.9

11 los freelancers están ofertando un promedio de $151 para este trabajo.

customizedata

See private message.

$170 USD en 14 días
(133 comentarios)
6.3
ddumitrascu

See private message.

$153 USD en 14 días
(131 comentarios)
5.6
Ignytek

See private message.

$170 USD en 14 días
(23 comentarios)
5.3
dexcoder

See private message.

$153 USD en 14 días
(23 comentarios)
4.9
crichtonvw

See private message.

$170 USD en 14 días
(11 comentarios)
4.1
Fo2ch

See private message.

$170 USD en 14 días
(11 comentarios)
3.9
arunscariah

See private message.

$110.5 USD en 14 días
(13 comentarios)
3.6
farhanshahid

See private message.

$85 USD en 14 días
(1 comentario)
0.5
kirandeepvw

See private message.

$170 USD en 14 días
(1 comentario)
0.0
ManojKumarBisht

See private message.

$170 USD en 14 días
(0 comentarios)
0.0