Automated Batch uploading of csv files to POSTGRE SQL database

About the client

United Kingdom

Posted on Jan 20, 2016 / Est. budget $ 100 / Project closed

Awarded winner(s):


I have a large number of csv files in excel that I need to automatically upload into a POSTGRE SQL database. It is possible that the csv files could be batch loaded manually also. The csv files contain information on the location, speed and direction of travel of fishing vessels recorded approximately every minute. I need to be able to concatenate large numbers of these csv files into a single database so that I can start to anyalyse them. Ultimately I will then want to pull subsets of the data into QGIS. I am not familiar with POSTGRE as a database but assume that this POSTGIS add-on will make it straight forward to use with QGIS? But happy to use MySQL also if that is easier.

Project bids (2)

Bids are visible only by project owner and Premium members.