Add file to database

Help
2012-03-05
2013-06-06
  • Nobody/Anonymous

    Hi guys! Adminer is the solution I'm looking for from some time! I have to make database for small company, to add and store their customers and bills. Bills will be in exel files.
    So one record in table should have fields like name, id, address etc and one more field - bill in exel that is able to download from server to employer's PC.
    Is there any plugin to add files at server in adding new record and to download it while browsing records?

    Best regards
    Konrad

     
  • Paul

    Paul - 2012-05-15

    I don't think that a plugin is necessary, as there alternative syntax for MySQL for loading file data into a table.

    See this link:   http://dev.mysql.com/doc/refman/5.1/en/load-data.html

    I have NOT yet tried this with Adminer, but don't think it would be problematic. The tricky part will be getting the syntax correct dpending on the date that is to be imported.

     
  • Paul

    Paul - 2012-05-15

    Correction to previous post…

    that last part should say "…the DATA that is to be imported." 

     
  • Jakub Vrána

    Jakub Vrána - 2012-06-29

    You don't need any plugin, just use blob (or one of its variants) to store and download the files.

     
  • Nobody/Anonymous

    Just make sure that if your import csv file has dates, that they are in yyyy-mm-dd format. Mine weren't (mm-dd-yyyy) and I blew out 4,000 DOBs.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks