In Progress

read text file and change a flag in database

I want the coder to only use visual basic 6 (ONLY) as i will include minor modifications to it, and i would like it to have a simple program which will allow me to manuelly run everyday.

The program will check for a FAILED status in the line then process that line.

When the failed is found it will then process on that line and extract the fax number, failed status/HEADER->"result".

these two things are the only importance for this project.

Any lines containing success are skipped lines.

Once you have the results you need to loop through each one and check the db table and field for the fax number if it is found then change the flag column to value of -> "FAILED".

needing to know the result is important so it would be nice to have it also put in another field the same table called column name "RESULTINFO" --> "the_value_of_result_here".

The connection must be to SQL server, and i have included what the interface will look like and have included the text file.

The connection to the db must be through odbc and i must be able to change the information via the interface i have included.

the log is currently at 24,000 lines, i would like after it reads the lines and is done changing the flag in the db to rename the file to the current date with underscores example

[url removed, login to view]

I've included the LOG file too with 4-5 lines of real data that it will have.

The file is connected via a network path !

PLEASE VIEW ATTACHED FILES TO SEE THE PROJECT BETTER !

Ive made the basic forms via visual basic and included the text file

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

windows xp only

Skills: Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL, Visual Basic

See more: what is the importance of software, what is package in sql, read real, c read example, text file, sql odbc, flag, data to text file, simple database visual basic, failed receive data, found log files, web data table extract, php read text file, windows process network, change package name, package name change, change column, odbc code, please check log files, visual read files, change text file, php read txt, extract lines file name, read lines, column text

About the Employer:
( 22 reviews ) United States

Project ID: #3355996

Awarded to:

maramayvw

See private message.

$38.25 USD in 2 days
(94 Reviews)
5.5

13 freelancers are bidding on average $35 for this job

Premshanks

See private message.

$33.15 USD in 2 days
(337 Reviews)
6.4
sixthsensevw

See private message.

$21.25 USD in 2 days
(107 Reviews)
6.4
sawamu

See private message.

$21.25 USD in 2 days
(215 Reviews)
5.9
ebshightechvw

See private message.

$29.75 USD in 2 days
(81 Reviews)
5.4
juran

See private message.

$42.5 USD in 2 days
(15 Reviews)
4.9
tlacorte

See private message.

$42.5 USD in 2 days
(4 Reviews)
4.8
DigitalDreamz

See private message.

$17 USD in 2 days
(34 Reviews)
4.5
onesource

See private message.

$42.5 USD in 2 days
(23 Reviews)
3.9
khurrambinumer

See private message.

$25.5 USD in 2 days
(13 Reviews)
1.9
mail2veejay

See private message.

$42.5 USD in 2 days
(2 Reviews)
1.9
mesc

See private message.

$42.5 USD in 2 days
(3 Reviews)
1.8
lhcampos

See private message.

$51 USD in 2 days
(0 Reviews)
0.0
tilenvw

See private message.

$14.45 USD in 2 days
(0 Reviews)
0.0
anilambedkarvw

See private message.

$51 USD in 2 days
(0 Reviews)
0.0