Closed

Export User Data From vBulletin SQL to CSV File

This project received 7 bids from talented freelancers with an average bid price of $143 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
7
Project Description

I need to extract data from my vBulletin SQL database in order to import into Access. It needs to do the following:

Select users of usergroup "MIGClub Member"

Output to comma delimited .CSV file in the following way:

User id number, Membership Expiry (DD/MM/YY), Username, email address, Title, Real First Name, Real Second Name, Address 1, Address 2, Address 3, Address 4, County, Postal Code, Car Model, Car Registration Mark

While this is outputted, the case of fields needs to be forced so that all use proper case (upper case first letters) except Postal code and Car registration mark which will need to be entirely upper case. Username should remain unchanged.

Also, sort by expiry date.

Interface should be such that the .CSV file can be downloaded from a link on a webpage.

The above is guide only, full accurate details will be provided when required.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online