To a user of WWW::Mechanize, this should be simple.
The task is to call a website, login, and drill down to data. The data will contain locations times and descriptions. This needs to be matched to a database entry also containing locations times and descriptions.
Occasionally the descriptions on the website will not directly match because of spaces being different or because of punctuation being included - which in itself is simple. however sometimes the descriptions are slightly misspelled - so the time and location matching needs to be checked. We would expect 99.5% success rate in matching to be achievable.
The output needs to be an SQL insert query comprised of cross referencing record numbers to our primary database.
It would be best if this was a package rather than a standalone script as the functions will need to be extended by the successful bidder for other sites on a regular basis
Hi! I can realise this task as a function, that you can call from your code. If there are a lot of data records to drill, the multithread model can be used (if it supports by your Perl version of course). I've got an experience of data drilling projects and can send you some demos of it