Need to insert the data (currently in CSV format) into the data base.
Process should include removal of duplicates and join of the similar records.
Attention!
My requirements to the programmer:
expert in PHP/MySQL.
ability to communicate through ICQ.
ability to be online during at least several hours every day.
normal Internet Connection.
desire to get another project right after this one.
I am available btwn 7AM and 9PM Pacific Statndard Time (Californian Time). So if you have some kind of pay-per-click Internet Connection and not able to communicate during this time, please do not bid. This is not quick hack project. I will carefully revice results and you might need to run a several queries after data will be in data base.
If you will meet my expectations, I will give you another assignment immediately. I am planning to launch several online Portals and will have projects for you posted in RAC on weekly basis.
## Deliverables
1) Complete well-formatted data in Buyer's data base, step-by-step Instructions and script that will allow to do next insertion. Step-by-step Instructions.
2) All deliverables will be considered "work made for hire" under U.S. Copyright law.
I am adding this clarification for you guys:
"Join Records" means that 2 or more records have valueable information that should not be deleted.
Example:
[[login to view URL]][1] - 3 - Z&S Motor Sports - - 458 Ranney Street Craig - CO - 81625 - - (970) 824-3915 - Dealerships - Auto Sport
[[login to view URL]][1] - 3 - Z and S Motor Sports - - We build custom sport cars - - - - (970) 824-3915 - Repair & Services - Auto Sport
[[login to view URL]][1] - - Z and S Motor Sports - (eMail) - - - - - Auto Sport
As you see all 3 records belong to the same company. If you will just delete the SIMILAR records, you will loose certain parts of information.
Following are Categories where the info should belong to: Dealerships - Auto Sport - Repair & Services.
Prefered info:
WWW, then eMail (if there are more emails then 1 we will insert it into the additional field), then Categories.
After that should be Business Name or link title (Z and S Motor Sports or Z&S Motor Sports - doesn't really matter).
Then Description of business. Take the one, which is longer.
Then address
Then phone numbers - insert into the extra field if there is more then 2.
I am expecting to be adviced when the JOIN of SIMILAR records should be done? Before the insertion or after.
See you tomorrow morning
## Platform
LINUX / PHP / My SQL