We are in Sales and Marketing- resort memberships (NOT Timeshare...) We have a MySQL/PHP database developed several years ago (will not function in a PHP environment over 5.0) and there is one major monthly task I must complete with it. Every month we receive a prospects list from a business partner in an Excel workbook- between 8,000 and 15,000 records. Data entry originally performed by simians. The data I receive is fairly messed up; data in incorrect fields, data badly formatted, bad phone numbers, convoluted first/last names.
It takes me about three hours to prepare the spreadsheet to be entered into a special Access DB I created for the purpose of automating the remainder of the task which is supposed to allow me to import a tab-delimited text file into our database in the cloud.
This second part takes a lot of time also as it all requires human eyes to distinguish between a true middle name, or a spouse first name entered into the middle name field. (
(One of many examples.)
I have begun a sort of user's manual for this operation. It is incomplete and still has typos, but I'm attaching it to give you some idea of what I have to go through to end up with an up-loadable file.
[login to view URL]
7 freelanceri licitează în medie 494$ pentru acest proiect
Hi, I have just checked your requirements and very interested in your PHP, MySQL job.I am senior php developer with 8+yrs experience in PHP also frameworks. Being a senior php developer, i have rich experience in lar Mai multe
Hello Thanks for your post. I have read your requirements and pdf file carefully. As a database/mysql expert, I am interested in your job. I am sure that I can help you with your job in my skills in a short time. Pleas Mai multe
MASTERS SOFTWARE ARCHITECTURE DATA BASE PROGRAMMING EXPERT 8YRS EXPERIENCE HELLO, I have GONE through your REQUIREMENTS, and I believe I have the personnel and SKILL needed to FINISH this project. I have done NUMEROUS Mai multe
Hi vistar. Nice to meet you I own useful and efficient technologies, including writing backend RESTful APIs and integrating with 3rd party APIs, Stripe, and other payment systems. I am familiar with PHP, Laravel, Expre Mai multe