database download/edit/upload
Project ID: 1265726993
Project Details
  • Status:
    Closed (Cancelled)
  • Posted:
    2/9/2010 at 9:49 EST
  • Cancelled:
    2/17/2010 at 0:19 EST
  • Project Creator:
  • Budget:
    N/A
  • Description:
    I have a semi "normalized" online database (I do the best I can :-) and I need a tool developed that will allow an admin user to do the following.

    1. Backup current tables in MySQL database.

    2. User will download the database as a CSV file
    - this will need to convert "normalized" data (i.e. the Type field is a number corresponding to the TypeID in another table, which has a label associated with it) so that when the user opens in Excel, they can actually make sense of it.

    3. User will make edits in Excel, and then export as CSV.

    4. The uploaded file will be converted back to normalized data.

    5. If the user has added a label in a column that doesn't match the label in the other table (the one with IDs and labels) then they need to be prompted to either (1) add that as a new entry in that table or (2) correct the entry -- a SELECT box of all the possible values for that would be cool.

    There is one main data table and about 6 other tables that have the ID / label that need to be matched up. There is also a separate script that needs to convert ranges like 4-7 into comma separated numbers (i.e. 4,5,6,7)

    PHP 4 or 5 and MySQL.
  • Tags:
Project Bids
Programmer Bid Delivery Time Time of Bid Rating  
kopihangat $50 3 days 2/9/2010 at 10:18 EST (No Feedback Yet)
I am new here, and I have not created my portfolio yet... please do me apologize for that... but I do know what is your need... and do hope to give you a help as soon as possible... Thank you
kabirchy $195 3 days 2/9/2010 at 11:38 EST 9.73/10
(790 reviews)
HI, I am ready to start. Please view PMB. Thanks
mitchy $199 2 days, 12 hours 2/9/2010 at 11:00 EST 9.03/10
(21 reviews)
WIth over 12 years coding and PHP experience you should choose a professional. And just so happens I'm free right now. I just did a project like this from SQL to EXCEL and back. I guarantee satisfaction and happiness! I'm willing to work with you so let's get started :D Also willing to do minor updates and free bug fixes for you, which NO other SL coders offer. My feedback speaks for itself. Let's get started my friend :) Yours truly Mitch
abhijuyal $200 Immediately 2/9/2010 at 10:27 EST 10.00/10
(1 review)
hi your third point is difficult to every programmer. when user enter wrong value in csv files.
wrdesign $200 2 days 2/9/2010 at 10:37 EST 7.00/10
(9 reviews)
hi, i can make it for you .. thanks
dragondance $200 3 days 2/9/2010 at 10:57 EST 9.95/10
(156 reviews)
I'm clear about the requirements.
uploadsafe $208 Immediately 2/9/2010 at 11:45 EST 10.00/10
(2 reviews)
Hello, my name is James Rozee, a freelance web developer located in Swindon, United Kingdom. to view my portfolio, information about myself and client feedback, please contact me. If you would like to know how I would go around doing your project, and the time to complete please contact me asap or award the bid to me. Regards, James Rozee. Portfolio: http://www.awesomeness.me.uk
adroit2009 $250 4 days 2/9/2010 at 11:27 EST 10.00/10
(35 reviews)
Greetings.. Thank you for taking the time to review our bid.As we have gone through your bid description we would like to work on this project.check PM for details
jack $270 2 days 2/9/2010 at 10:50 EST 10.00/10
(296 reviews)
I can do this with the best quality. Please contact me for the further details.
rajeshsoni $300 1 day 2/9/2010 at 9:53 EST 10.00/10
(499 reviews)
Clear with Requirement. Ready to get started. Quality work Assured. Thanks.