The CSV import should be relatively easy. I have written many scripts that import CSV to MySQL database.
The site scraping script depends on knowing the layout of the site in question. I have written many scripts that automate content gathering, too.
Really, I could do these both in one or two days. I think the site scraping tool would be about 60-70% of the workload.
Generally, I write scripts in PHP scripting language, however, I am versed in a few others, such as Python and Perl. I have not done any site-scraping scripts in Python, I have done a few in Perl and many in PHP.