Need to code to parse 180 pages of wikipedia api code and input into mysql database.
Step 1: gather links from [url removed, login to view]:Visa_requirements_by_nationality
Input into database table: Links available
Step 2: scroll through each link and parse the visa requirements into 1 table "visa requirements" columns should be consistent with timatic format (nationality= | destination= | type= | residence= | embarkation= | health= | date= | accessdate=) as the additional wikipedia formatted columns visa_required (yes/no), visa_required_text, and notes.
So from: [url removed, login to view]
For the visa to Albania, the mysql entry would be (skipping the blank timatic fields)
yes|Visa not required|nationality=CA|destination=AL|accessdate=26 November 2013|90 days
Timatic format [url removed, login to view]:Timatic