Hello, there is a site vk.com which is actually social network, (but that's not very important in current context).
There is a people search link https://vk.com/search
where you may select(at the right side)
4.1 university and
4.4 attending year
The task: get the list of schools and universities with faculties and department (in proper hierrachical tree view which must be remapped into MySQL database.
How can we automatically grab that data and put that into mysql corresponding tables? Do we need to write some web-utility which will automatically get those data fields?
The structure of mysql tables are following (without country and city) attached