1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Buying Need to Upload .csv files to MySQL with PHP

Discussion in 'Programming' started by scithe, Feb 8, 2017.

0
  1. #1
    I receive a weekly spreadsheet that I'd like to have uploaded into a MySQL database. The spreadsheet has 14 columns with headers in line 1.

    I would like to be able to go to a page on my site and upload the csv file each week. The page should also have an input box for me to enter the date. As the csv file is imported into the database, I would like an extra column with the value of the date I enter from the input box.

    Ideally the columns in the database would have the same names as the columns in the spreadsheet. Most of the fields would be varchars except two columns would be for ints and two would be decimals.

    I was thinking $20 would be fair for this project. If that's agreeable then let me know if you think this is something you can handle.
     
    scithe, Feb 8, 2017 IP
  2. simno

    simno Active Member

    Messages:
    20
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    60
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Have you actually found what would do this job quickly and professionally for 20 bucks?
     
    simno, Feb 9, 2017 IP
  3. udhimeisa

    udhimeisa Member

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    PM me .csv file example.
    Maybe i can help you
     
    udhimeisa, Feb 9, 2017 IP
  4. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,623
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    Sometimes, I just have to laugh at the cost someone thinks is "fair"... $20 would barely buy the time needed to look over the CSV...
     
    PoPSiCLe, Feb 9, 2017 IP
  5. MAYhem_exe

    MAYhem_exe Member

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #5
    20$ is not a fair price for this in any way but since i'm inbetween jobs right now and i need beer money.. I'll do it, PM me with details.
     
    MAYhem_exe, Feb 9, 2017 IP
  6. pigpromoter

    pigpromoter Well-Known Member

    Messages:
    542
    Likes Received:
    13
    Best Answers:
    1
    Trophy Points:
    165
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #6
    @PoPSiCLe $20 for a 15 minute job isn't that awful.
     
    pigpromoter, Feb 9, 2017 IP
  7. scithe

    scithe Well-Known Member

    Messages:
    224
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    130
    As Seller:
    100% - 2
    As Buyer:
    100% - 1
    #7
    Hi guys,

    Thanks for the responses. I've had 6 offers to work on this so I will update this post when I have more news.
     
    scithe, Feb 9, 2017 IP
  8. Wav3

    Wav3 Well-Known Member

    Messages:
    247
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #8
    If you say that 20$ is not a fair price for such an easy task, this means this task is not that easy for you which makes you not a very skilled programmer (not even a mediocre one - this is a damn easy and quick job).
    Some people earn 20$ per day of work. 20$ for 30 mins of work is more than enough. (20$*2*8hrs = 320$/day = 6400$/month)

    Also, if you expect to earn big money as a freelancer, I have bad news for you :)
     
    Wav3, Feb 10, 2017 IP
  9. scithe

    scithe Well-Known Member

    Messages:
    224
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    130
    As Seller:
    100% - 2
    As Buyer:
    100% - 1
    #9
    This project was completed. Thank you to everyone who replied. Perhaps we can work together on a future project.
     
    scithe, Feb 10, 2017 IP