I have an Access database with contact info for 1500 people and need to convert this database to MySQL. The trick is, I'm using a content management program called pmachine([login to view URL]). I want to import all the contact info into the members table of the pmachine MySQL database. I'll need my data from the Access database filtered and toyed with a little. For example, say for any given name, I'll need the username field to take the first letter of the first name and the rest of last name and put into the username field. Joe Smith = jsmith. I'd like the password to be their date of birth. 01/14/78=011478, but it will need to be md5 encrypted. Also the member_id field will need to use php functions mt_srand to seed the random number generator, and then uniqid to make a random id. Lastly, I'll need the rest of the fields to be placed in given tables straight up, no trickiness(other than the birthday day, month and year fields converted from 01/14/78). I hope this makes sense.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows XP