Maemo.org team/Generating election results - Revision history

joerg_rw: sort of obsolete

2015-09-06T23:52:48Z

sort of obsolete

← Older revision		Revision as of 23:52, 6 September 2015
Line 1:		Line 1:
		+	'''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.		Instructions for generating election results once an election is completed. In this example, the election ID is 8.

dneary: Update instructions to use the much easier "LOAD_FILE" rather that copy & paste results file

2010-03-31T11:12:03Z

Update instructions to use the much easier "LOAD_FILE" rather that copy & paste results file

← Older revision		Revision as of 11:12, 31 March 2010
Line 17:		Line 17:
	#* 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 (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		#: mysql -uelection -p election
-	#: $ insert into election_results values (8 <the election_id on the results URL above>, '~~<copy & paste HTML~~ file>');	+	#: $ 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.		# 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):

dneary at 09:59, 5 January 2010

2010-01-05T09:59:07Z

← Older revision		Revision as of 09:59, 5 January 2010
Line 13:		Line 13:
	# 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 <~~pre~~><div></~~pre~~>	+	#* change <body> into <nowiki><div></nowiki>
	#* 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)

dneary at 09:53, 5 January 2010

2010-01-05T09:53:56Z

← Older revision		Revision as of 09:53, 5 January 2010
Line 1:		Line 1:
-
	Instructions for generating election results once an election is completed. In this example, the election ID is 8.		Instructions for generating election results once an election is completed. In this example, the election ID is 8.

Line 14:		Line 13:
	# 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 <div>	+	#* change <body> into <pre><div></pre>
	#* 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)

dneary at 18:55, 22 December 2009

2009-12-22T18:55:35Z

← Older revision		Revision as of 18:55, 22 December 2009
Line 1:		Line 1:

-		+	Instructions for generating election results once an election is completed. In this example, the election ID is 8.
-	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 ~~"List of all votes" -~~ http://maemo.org/vote/votes.php?election_id=8	+	# Click on [http://maemo.org/vote/votes.php?election_id=8 "List of all votes"]
-	# Click on ~~"Download the ballots":~~ http://maemo.org/vote/blt.php?election_id=8	+	# Click on [http://maemo.org/vote/blt.php?election_id=8 "Download the ballots"]
	# Browser proposes open or save - save the file (election.blt)		# Browser proposes open or save - save the file (election.blt)
-	# Launch OpenSTV~~.py~~ (version 1.5 is latest as of writing~~) (downloaded from http://www.openstv.org/~~)	+	# Launch [http://www.openstv.org/ OpenSTV] (version 1.5 is latest as of writing)
	# File->New election		# File->New election
-	# Load election.blt file - Method: Fractional transfer STV	+	# 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 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

dneary: How to generate election results after an election, step by step.

2009-12-22T18:50:47Z

How to generate election results after an election, step by step.

New page

Instructions for generating election results once an election is completed.

# 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" - http://maemo.org/vote/votes.php?election_id=8
# Click on "Download the ballots": http://maemo.org/vote/blt.php?election_id=8
# Browser proposes open or save - save the file (election.blt)
# Launch OpenSTV.py (version 1.5 is latest as of writing) (downloaded from http://www.openstv.org/)
# File->New election
# 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 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:
#: mysql -uelection -p election
#: $ 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.
# 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

[[Category:Maemo.org]]