I've rushed a simple group roster a couple of months ago for The Black Watch using the rpuk api, I'll just share it here it takes away the pain manually filling a spreadsheet.
Since I've rushed this, SQL uses no prepared statements and the script doesn't contain an installer so you need to edit...