Hi,
We are a market research recruitment company looking for an IT specialist that can (on an ongoing basis) help us with our IT requirements.
Our business is finding people to take part in research across the UK asking them to register their details to our website.
Our current set up is that people register their details to our website that information is then passed via php through to mysql, which is then uploaded to a webpage. This is then copied and pasted to an excel sheet for our use. This process has become slow and out dated and so we are looking for the following:
Firstly, the forms that we have on our website are very out dated and aren’t actually providing us with the information we need. Ideally we’d like them ‘spruced up a little’ so they look a little more professional and an additional mandatory field for ‘Nearest City’ (after address fields) with options of London/Birmingham/Manchester/Leeds/Newcastle/Edinburgh/Bristol/Cardiff/Dubllin/Brighton/Local Research Only. We are also receiving a large amount of spam entries (especially on the business form), I’m unsure of why and I’d very much appreciate it if you have any suggestions on how to stop this.
These forms are then linked via PHPMyAdmin and MYSQL. We then download the data and copy onto an excel sheet.
Ideally moving forward we would like this data sent directly to an ACCESS database which in hand provides an interface for members of staff to use showing all individual details for each of our respondents. We would also like all of our current 5000+ records migrated from the excel spreadsheet that we are currently using to the access database.
We currently have our website running via 123reg and our e-mails via Webfusion, we have the facility to migrate everything over to Webfusion which we would like to do (my limited knowledge, makes this really difficult).
Ideally for budgeting purposes we are currently looking for a one off quotation for this work to be completed and thereafter some kind of IT support on a regular basis.
I can provide all Dreamweaver files and my SQL/PHP My Admin log in details if needed however at this time if you are able just to provide a quote that would be really helpful.
In a nutshell we are looking for:
• MySQL to MS Access conversion tool
• Migration of Excel database to MS Access
• MS Access front end
• Redesign of Public Registration form
• Redesign of Business Professionals Registration form
• Migration of mail server from 123-reg to Webfusion
• Captcha verification to reduce bot spam
Many thanks,
Andrew
