Ruby on Rails / XML
We need a Rake Task that retrieves a .csv from an ftp, parses the data and updates a mySQL database.
This task should retrieve the most-recent file from a specific directory on an FTP server. It should parse the retrieved file and create update queries to be run against a MySQL database.
We can provide sample files.
Also ...we'll want unit tests (to ensure correct behavior for corrupt / malformed files)