Create a script to populate a table to show the Dictionaries with Grammars

[peteroatley]

Background:
The Grammar page on Webonary provides links to the Grammar page for those dictionaries which have grammars. Currently data is supplied from a spreadsheet but this is not working properly. It would be better if the data was obtained programmatically to eliminate the maintenance burden.

Only languages which have a Grammar should have a Grammar page. At present there are some old template and holding pages which need to be removed to clean up the data.

The data imported from the spreadsheet consists of 5 fields:
Language name, Language family, Country, Publication Date, Page Link

Some languages have more than one dictionary and could have more than one Grammar description.
The language family name isn't included in any data and so would need to be added to each dictionary if we wanted to include this.
I think Publication Date is the date the dictionary was published on Webonary so this may not be helpful.

I suggest we use the following information:
Language name, Language family, Country, dictionary name as link to grammar page

Phil suggests the data is updated every 24hrs to reduce the load on the website but also have a button for an immediate update.

Request:
Create a table to show dictionaries with grammars. Updated once a day but have a button on the Webonary site WP-Admin interface to update immediately.

Only published dictionaries should be scanned for a Grammar page.

On the dictionary sites Webonary admin page add the option to include the language family from a list.

The fields to be included in the table are:
Language name, Language family, Country, dictionary name as link to grammar page

The table should be sortable for each column.