Background: We received word format e-mail on daily basis We would like to automatically populate into database.
Payment: Open and will pay a minimum of $100 for a satisfactory project that works and pass our tests and up to thousands of dollars if more automated.
you may wish to parse it into comma delimited files or directly import to Access. This program should be callable by batch files to process 50-200 words docs at once.
Here is a sample of input:
**_317 20th S San Jose 95116_** (_12_ ) Lot Tract
Trustor: Raul Castro 555 971 1234
TRUSTEE:3 Arch Trustee Services Inc 949 474 4505 TS#:001-6375 LN#:0320209901
BENE:Deutsche Bank C/o Trustee 949 474 4505 NOD#:17800562 Rec:5/20/2004 $15,948.29 Due as of: 5/19/2004 Delinq: 12/1/2003 D/T:16933940 Bk Pg: Rec:4/3/2003 LNAmt:$320,000
**APN: 467 51 046 -- Duplx** Lot:30x130 Zn:R2 YR:1956 Sq':1104 2Car
Sold 9/98 for $ 200,000
It should be parsed as follows; unimportant field in parenthesis.
Street Address: 317 20th S
City: San Jose
Trustor: Raul Castro
(Trustor ph): 555 971 1234
(Trustee): 3 Arch Trustee Services Inc
(Trustee ph): 949 474 4505
BENE: Deutsche Bank C/o Trustee 949 474 4505
NOD#: "17800562 Rec:5/20/2004 $15,948.29 Due as of: 5/19/2004 Delinq: 12/1/2003 D/T:16933940 Bk Pg: Rec:4/3/2003 "
**APN: 467 51 046
Prop Type: "Duplx** Lot:30x130 Zn:R2 YR:1956"
Note: " 2Car Sold 9/98 for $ 200,000 "
I have attached two samples word docs. The NOD one we received daily. The NTS one we receives weekly. They contain slightly different but substantially same info. All NOD are similar and all NTS are similar in format.
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): correctly parse the 50 randomly chosen NOD word files and import to access
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).
Windows 2000/XP. Word and Access or SQL Server.