GetAFreelancer.com - MySQL database refinements

MySQL database refinements

MySQL database refinements is project number 184490 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider eccentricworld)

Status: Closed

Budget: $100-300

Created: 10/09/2007 at 22:14 EDT

Bidding Ends: 10/12/2007 at 22:14 EDT

Project Creator: chomsky
Buyer Rating:
(4 reviews)

Description: I have a dating website that has over 60,000 fake profiles.The profiles are already integrated into the database, but some of them are missing the password field, so I need someone to auto-generate random passwords and apply them to the profiles that are missing them. They can be as simple as "test1", "test2", "test3" etc, or a string of random letters.

Next, I have a zip code database that is integrated as well, but it is incomplete or outdated, since a lot of people complain that they get errors when trying to register with their zip codes. I need someone to add on to, or replace the existing zip code database, with one that is complete for all US zips.

Finally, I need someone to enter in random zip codes to the appropriate field of the fake profiles (the real profiles must not be altered - I have the ID #'s of the real profiles. The fake ones are in one block, for instance id #1 - id #60 are real, then id #61 - id #61250 are fake, then all the ones after #61250 are real). Many of the fake profiles already have zip codes, but I want them all overwritten to include only zip codes from the 20 - 30 largest metropolitan areas in the US. For instance, for Detroit the zip codes for the city of Detroit could be used as well as zip codes for Warren, Pontiac, Ferndale, Southfield etc. can be used as long as these still show up when someone does a search for anyone within 50 miles of Detroit.

All three of these things should be easily accomplished by someone who is familiar enough with MySQL. I'd rather someone spend a week and do this right, then promise me they'll have it done in 2 days, and it ends up screwed up. I've hired freelancers on here before so read my feedback.

Job Type:

Data Entry
Data Processing

Database: MySQL

Operating system: Linux

Bid count: 28

Average bid: N/A

Related project

Nonpublic project #294888 ^Featured ^Nonpublic

Messages Posted: 5

If you are the project creator or one of the bidders for more options

Service Providers	PMB	Bid	Delivery Within	Time of Bid	Provider Rating
Bids are hidden by project creator. as the project creator or as one of the bidders to view bids.

[ GAF Top Users ] [ Website Design ] [ Outsourcing ]

What is GetAFreelancer.com? ( Read about the company )

Buy services with help from our secure escrow system. Outsourcing is hiring an outside organization to perform services such as information processing and applications development. A freelancer is an independent worker, not on salary, hired instead on a project basis. Our escrow feature is developed to protect both buyers and sellers. Outsourcing is the process of subcontracting network operations and support to an organization outside your own company. Try it free today! Companies of any size have used our web services.

We have thousands of satisfied clients around the world. Web Development doesn't have to be expensive. Outsourcing will cut your expenses by more than 50%. Deposit money and don't purchase until your project is completed. GetAFreelancer.com helps webmasters, web designers, programmers, software developers and business owners to develop their projects.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.