Editing Maemo.org team/Generating election results
Warning: You are not logged in.
Your IP address will be recorded in this page's edit history.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
- | |||
- | Instructions for generating election results once an election is completed | + | Instructions for generating election results once an election is completed. |
# Go to http://maemo.org/vote/ | # Go to http://maemo.org/vote/ | ||
# Click on election link - get to http://maemo.org/vote/results.php?election_id=8 | # Click on election link - get to http://maemo.org/vote/results.php?election_id=8 | ||
- | # Click on | + | # Click on "List of all votes" - http://maemo.org/vote/votes.php?election_id=8 |
- | # Click on | + | # Click on "Download the ballots": http://maemo.org/vote/blt.php?election_id=8 |
# Browser proposes open or save - save the file (election.blt) | # Browser proposes open or save - save the file (election.blt) | ||
- | # Launch | + | # Launch OpenSTV.py (version 1.5 is latest as of writing) (downloaded from http://www.openstv.org/) |
# File->New election | # File->New election | ||
- | # Load election.blt file - Method: Fractional transfer STV | + | # Load election.blt file - Method: Fractional transfer STV |
# 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 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 | # 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 | # Edit HTML file to take care of MySQL formating (escape quotes, backslashes, etc) and remove HTML headers - manual process | ||
#* remove <html> and <head>, | #* remove <html> and <head>, | ||
- | #* change <body> into | + | #* change <body> into <div> |
#* sed/\'center\'/\"center\"/g | #* sed/\'center\'/\"center\"/g | ||
#* Ensure HTML attributes are quoted (colspan, rowspan, border, cellspacing) | #* 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) | #* 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 | + | # Insert results in non-production database to test: |
#: mysql -uelection -p election | #: mysql -uelection -p election | ||
- | #: $ insert into election_results values (8 <the election_id on the results URL above>, | + | #: $ insert into election_results values (8 <the election_id on the results URL above>, '<copy & paste HTML file>'); |
# Check that results display correctly, and massage results field if needed. | # 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): | # 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): |
Learn more about Contributing to the wiki.