Quick database editing script needed

Discussion in 'Programming' started by winsoar, Mar 20, 2009.

  1. #1
    I have a CSV file that needs importing into a hosted MySQL database.

    I then need an operator to be able to log onto an admin screen and be presented with details of the company they call.

    They will then add some details onto the entry in the database for that company and move on to the next record.

    On some occasions they may need to set a call back date and time. I would like the script to automatically make that entry appear at the correct time.

    Whenever they edit an entry it should be date stamped and marked to say we have contacted that company.

    After all records have been updated I would like the option to export the data back to CSV format.

    If you can do this please let me know your expected price.
     
    winsoar, Mar 20, 2009 IP
  2. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    This can be realized in different ways. As an example: CSV can be transformed at localhost as sql dump, than Imported by phpmyadmin to your host;admin panel can be password protected by php code,htaccess or both.
    I will need more info please
     
    koko5, Mar 20, 2009 IP
  3. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    As Seller:
    100% - 0
    As Buyer:
    100% - 1
    #3
    i also need more details

    $20 per hour

    50% advance

    Regards

    Alex
     
    kmap, Mar 20, 2009 IP
  4. Ilyes

    Ilyes Banned

    Messages:
    129
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    What si your budget ?
     
    Ilyes, Mar 20, 2009 IP
  5. cyber boy

    cyber boy Member

    Messages:
    218
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #5
    I can write a script in PHP with mysql database able to importing and exporing the CVS file Including the admin area for operator.
    Please contact me on PM or messenger so we can discuss this in details.
     
    cyber boy, Mar 20, 2009 IP
  6. winsoar

    winsoar Well-Known Member

    Messages:
    1,363
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    108
    As Seller:
    100% - 0
    As Buyer:
    100% - 2
    #6
    I need this ready by Monday.

    The records are chosen in date order. To begin with all records would have a fictitious date. If the operator sets a call back date and time then the record should appear at that time for a call back.

    All company details are stored in one record. There is a field for operator notes.
     
    winsoar, Mar 20, 2009 IP
  7. atlantaazfinest

    atlantaazfinest Peon

    Messages:
    389
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #7
    Beware user never paid me for JavaScript work that was done.!

    Contact me asap winsoar
     
    atlantaazfinest, Mar 20, 2009 IP
  8. winsoar

    winsoar Well-Known Member

    Messages:
    1,363
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    108
    As Seller:
    100% - 0
    As Buyer:
    100% - 2
    #8
    I don't appreciate you hijacking this threat atlantaazfinest. I see you have already sent me a PM about a payment I may have overlooked. I will get round to it. I've got a good itrader.

    Back to this topic...

    If nobody can do this for a reasonable fee then I will use the Google Apps shared spreadsheet tool.
     
    winsoar, Mar 21, 2009 IP
  9. cyber boy

    cyber boy Member

    Messages:
    218
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #9
    How much do you want to spend on this project?
     
    cyber boy, Mar 21, 2009 IP
  10. winsoar

    winsoar Well-Known Member

    Messages:
    1,363
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    108
    As Seller:
    100% - 0
    As Buyer:
    100% - 2
    #10
    I've decided the best solution will be Google Shared Apps in this case.

    I will post another project in the future for the actual web site once the data is prepared.
     
    winsoar, Mar 22, 2009 IP