Maemo.org team/Generating election results
OBSOLETE see http://wiki.maemo.org/Maemo.org_team/Creating_an_election
Instructions for generating election results once an election is completed. In this example, the election ID is 8.
- Go to http://maemo.org/vote/
- Click on election link - get to http://maemo.org/vote/results.php?election_id=8
- Click on "List of all votes"
- Click on "Download the ballots"
- Browser proposes open or save - save the file (election.blt)
- Launch OpenSTV (version 1.5 is latest as of writing)
- File->New election
- Load election.blt file - Method: Fractional transfer STV (for the character survey, I chose the Borda method, because fractional transfer didn't make any sense)
- Election options: Seat number = number of desired elected candidates (1 for referendum, 5 for council, etc); Threshold = Droop, Static, Whole; Delay surplus transfer = Off; Batch elimination = Zero; click OK
- Election results generated - you can see the winners & count details. To generate HTML version: Results->Save results as HTML - save file election_results.html
- Edit HTML file to take care of MySQL formating (escape quotes, backslashes, etc) and remove HTML headers - manual process
- remove <html> and <head>,
- change <body> into <div>
- sed/\'center\'/\"center\"/g
- Ensure HTML attributes are quoted (colspan, rowspan, border, cellspacing)
- Massage output as necessary (removing "symbols are elected" for characters survey, replacing characters with HTML entities, etc)
- Insert results in non-production database to test (ensure that the file is world readable & the directory hierarchy is world executable, and that the DB user has the FILE privilege):
- mysql -uelection -p election
- $ insert into election_results values (8 <the election_id on the results URL above>, LOAD_FILE('/path/to/html/file');
- Check that results display correctly, and massage results field if needed.
- Dump insert from non-prod DB to send for insertion in prod DB (as an SQL statement, to make it as easy as possible - ensures quoting & character escaping is done correctly):
- mysqldump -uelection -p -t -w 'election_results.election_id=8' election election_results > results.sql
- On production database, mysql -u<db user> -p < results.sql
- This page was last modified on 6 September 2015, at 23:52.
- This page has been accessed 9,422 times.