CSV feed into MySQL database
$30-100 USD
Paid on delivery
A stock feed is currently setup on an FTP site that updates itself every day.? The data is in CSV format.? I require a Cronjob setup to take this feed and put it into a MYSQL database (already setup) every day at midnight.
## Deliverables
The Project:
Take a CSV feed and create a cronjob that dumps it into a MySQL server every night at midnight.
Lunarpages, my host, already has the option of using cronjobs
<[url removed, login to view]>
Some additional requirements:
The database table is already setup with correct headers, however, the timestamp in the feed is written in Unixtime and will need to be converted into a date (0000-00-00) before being put into the database.?
Also, the data will be added to the database each night (a continually growing database), rather than empty the table and start over.
Project ID: #3193489