I will send the full specification of the CSV to the sucessful bidder
I need just the following code to be done
Log into a POP account and receive Emails containg the CSV file. (1 file per email)
Process the File(s) and place data into a Access Database (I Will provide the database for you.)
Also need to be able to drag and drop an email into the app for manual processing of the attachment.
The CVS file has 5 parts to it
a Main Header
A Doc Header
Document Details
Document Trailer
Main Trailer
Eg.
"0000001","A","D","SHP",,,"60 082 376 289",,"C001A/1",,"20030702","1646",,
"0000002","H","EX43982","20030702"
"0000003","D",,"HLA201S","(C) DAVID KB","03 RAZOR BLACK MXR XXS $",,,,,,,,,,,,,,,,,,,,,,,,0.00,,21.9450,,,10.00,1.9950,,1,"MDE",,"A",21.95,"20030820",""
"0000004","D",,"HLA202S","(C) DAVID KB","03 RAZOR BLUE MXR XXS $",,,,,,,,,,,,,,,,,,,,,,,,0.00,,21.9450,,,10.00,1.9950,,1,"MDE",,"A",21.95,"20030820",""
"0000005","T","EX43982",19,412.06,,37.46,,
"0000006","Z","C001A/1",19,412.06,,37.46
All numeric fields are delimited by commas and all alpha fields are enclosed in double quotes(“). Field sizes are shown as maximum and include decimal places where applicable.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
## Platform
Windows 98/2000/XP
Visual Basic 6.0