I have a database of customer information that includes names and addresses. I need to find phone numbers for these customers. You will be provided with a sample tab-delimited text file of this database. I need a script that will read this text file and do a search on [url removed, login to view] to find a phone number for the customer, then store the phone number in the tab-delimited format. Your final product must include an interface to upload future files through a web browser and store them on the server for processing. The text file has these fields: firstname lastname house # street city state zip code telephone Your script should search [url removed, login to view] using the last name, the first initial (first character of the firstname field) and the zip code. For each result that comes back, the phone number should be stored in the phone number field. If there are multiple results, all phone numbers should be stored in the phone number field, separated by slashes. Some entries will already have a phone number, your script must not erase the existing numbers (but can add to them if more numbers are found). For customers who are businesses, the business name is in the firstname field and the lastname field is blank. In this case you should search only on the business name and zip code, storing the phone number(s) in the same manner. You can write this script in any web language that will run on a Linux server. PHP is preferred but not required. I'm setting the deadline for five days but I can be flexible. If that amount of time is unreasonable to you, please include in your bid the amount of time you would require to complete this project.
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. You are free to use any GPL resources that will make your work easier.
Linux web server PHP preferred, but open to alternatives