openaustralia / electionleaflets

Live election leaflet monitoring for Australia.

Setup Instructions

The electionleaflets folder has to be hosted on an Apache HTTP server. A sample Apache configuration file is supplied in electionleaflets/config/dev.electionleaflets.org.au.

The includes, includes/PEAR and config folders must be added to the PHP include_path variable which is set in the example Apache configuration file or can be set in an Apache .htaccess file eg. https://groups.google.com/d/topic/openaustralia-dev/fg1dENEjm18/discussion

The timezone must also be set as a PHP variable eg. php_value date.timezone "America/Chicago" in a .htaccess file.

PHP

Requires cURL, php5-imap, php5-gd, php-mbstring

Database

Create a MySQL database and user:

echo "CREATE DATABASE electionleaflets" | mysql --user=root --password
echo "GRANT USAGE ON *.* TO 'electionleaflets'@'localhost' IDENTIFIED BY 'electionleaflets'" | mysql --user=root --password
echo "GRANT ALL PRIVILEGES ON electionleaflets.* TO 'electionleaflets'@'localhost'" | mysql --user=root --password

The create the database schema using the script in schema/electionleaflets.sql and schema/australian_postcodes.sql

cat schema/electionleaflets.sql | mysql --user=root --password electionleaflets
cat schema/australian_postcodes.sql | mysql --user=root --password electionleaflets

Config file

Make a copy of config/general.php.example as config/general.php then edit the variables for you local setup.

You must point it to the MySQL database you just created and set ROOT_DIR, VHOST_DIR, WWW_SERVER, ADMIN_SERVER, and DOMAIN appropriately.

Folder structure

Run these commands to create the following folders:

mkdir -p data/smarty_compile
mkdir -p data/cache
mkdir -p data/temp
mkdir -p data/images
mkdir -p data/images/small
mkdir -p data/images/original
mkdir -p data/images/large
mkdir -p data/images/medium
mkdir -p data/images/thumbnail

Also ensure they are writable by the webserver.

On a SELinux based distro (Fedora, RHEL, CentOS etc.) you will also have to give these folders the correct security context

chcon -Rv -t httpd_sys_content_t data

Setting up an election

To run Election Leaflets you need to collect and upload some data about the election, things like its name and what parties are running candidates.

Requirements

You'll need to collect the following data before you begin:

• Election name and date
• A list of parties running candidates
• A list of categories important to this election
• A list of constituency names
• Mappings between postcodes and constituency names (e.g. 2042, Sydney)

Set up

There is an admin interface available at /admin/ of every Election Leaflets install. To access it you need to set a username password in the general.php configuration file. From there it should be pretty self-explanatory.

It's important to note that elections created via this interface are not immediately visible. In the election table you will need to set the enabled field to '1' for it to go live - think of this as a final sanity check.

DANGER

You have the ability to edit elections. If there are already leaflets uploaded for an election this is probably Not A Good Idea as you can remove parties and categories that may already have data uploaded.

With great power...

Help

If you need any help, contact the OpenAustralia Community list.

map (django application)

The map is actually a separate django application. To get this working you will need the following installed:

python-django
python-mysqldb
libgeos-c1
python-gdal
proj
libapache2-mod-python
python-imaging

Local PHP server for local development

cd docs php -d include_path=".:../includes:../includes/PEAR:../config" -d date.timezone="Australia/Sydney" -S localhost:8000

electionleaflets's Issues

Add download leaflet function to leaflet page (EL-37)

Issue details imported from Jira:

Detail	Value
Assignee	Teresa Leung
Reporter	Teresa Leung
Created	2010-07-17 21:56:20
Updated	2010-09-19 10:30:09

---

Imported Jira Comments

Henare Degan - 2010-07-18 21:35:43

Does the "view larger image" link not cut it?

How do you think it should be done? i.e. expected behaviour

Henare Degan - 2010-07-29 07:16:57

Assigning to Teresa for UX response.

Teresa Leung - 2010-09-19 10:30:09

My intention was to create an easy way for users to save the leaflets in one go, rather than saving each jpg separately.

Perhaps this isn't fulfiling a real user need? It'd perhaps be a lot of work for little effect?

Change all instances of Constituency/Constituencies to Electorate/Electorates throughout website content (EL-45)

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Teresa Leung
Created	2010-07-18 09:21:40
Updated	2010-07-18 18:17:02

---

Imported Jira Comments

Matthew Landauer - 2010-07-18 10:48:22

Including redirect the url /constituencies/canberra/ to /electorates/canberra/

Henare Degan - 2010-07-18 18:17:02

Fixed: http://github.com/openaustralia/electionleaflets/commit/d5c5ad158926e292397ad29741a7ae01858a28a4

And config change deployed to test.

Add search functionality (EL-43)

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 22:06:38
Updated	2010-07-29 07:04:20

Leaflet analysis doesn't work (EL-16)

http://test.fairdinkum.org.au/analyze.php

Just throws you back to the above page after saying "Let's start"

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Henare Degan
Created	2010-07-13 23:27:04
Updated	2010-07-29 10:31:08

---

Imported Jira Comments

Matthew Landauer - 2010-07-18 09:06:44

I suggest that we disable this page initially. It's fairly useless anyway until a good number of leaflets have been collected.

Improve image viewer on leaflet page (EL-36)

Improve how multiple images are displayed (e.g. slideshow, lightbox etc)

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 21:55:10
Updated	2010-07-29 07:04:34

---

Imported Jira Comments

Matthew Landauer - 2010-07-18 09:13:09

Can you describe what needs improving?

Implement visual design changes (EL-28)

Make changes to the TSC's CSS and front-end code.

Pre-req's:

Finalised homepage wireframe and visual design from Teresa

---

Issue details imported from Jira:

Detail	Value
Assignee	Jack Zhao
Reporter	Teresa Leung
Created	2010-07-17 21:13:55
Updated	2010-07-29 10:45:17

📎 Jira attachments: https://tickets.openaustraliafoundation.org.au/attachments/EL/EL-28

---

Imported Jira Comments

Teresa Leung - 2010-07-18 13:15:55

I'll get cracking on the design tonight. Would a photoshop or illustrator file suffice?

Matthew Landauer - 2010-07-18 13:22:28

@teresa - is that a question for Henare and I or for Jack?

Henare and I would like new html and css for the design changes. Even better, if possible, would be patches to the current codebase (but that is optional)

Teresa Leung - 2010-07-18 14:07:49

The psd/ai file was a question for Jack.

Henare Degan - 2010-07-18 22:24:48

Hey Teresa, Jack,

How's this work coming along? I've made good progress today and stand ready to integrate the visual changes that we were planning to get an initial version of tonight.

Cheers, Henare

Teresa Leung - 2010-07-18 23:39:09

Still working on the design. I'm sending this over to Jack tonight. Plan is for him to work on it tomorrow night after work.

Teresa Leung - 2010-07-19 00:33:16

Hi Jack - jpg and fonts attached here. I will YouSendit the psd file to you - it's bigger than the 10mb upload limit.

I've used a free font called Pigiarniq which I'm hoping you can implement using @font-face. If we run out of time to do this, let's look at using another default font for the headings.

I haven't had a chance to do a second generic page tonight but I'll send you something early tomorrow night.

Please give me a call when you start work on this so I can give a more complete handover of the design & discuss any potential issues.

@team - hope design suits - I took the tactile paper approach - obvious I know..

Teresa Leung - 2010-07-19 00:41:23

@henare & Matt

Jack also had a question about getting a local copy (of the code I think) for him to work on.

Can either of you advise what's the best way for Jack to integrate his work into yours?

Henare Degan - 2010-07-19 08:29:55

@teresa

Wow - design looks great, awesome work! Thanks very much for the update about timing too.

@jack

>Jack also had a question about getting a local copy (of the code I think) for him to work on.

As per my email a while back - if you have any questions, please do not hesitate to ask. I'll be happy to help.

>Can either of you advise what's the best way for Jack to integrate his work into yours?

With the amount of time we have - whatever way suits you Jack.

If you want to get a local copy running, modify the templates and provide Git patches back, that's awesome. However, if you want to make your own static HTML files, we'll just live with that too. Whatever works.

Please don't hesitate to discuss this with me (over the phone if need be), the most important thing is that we get something quickly so we can start producing new iterations and iron out the issues. I don't need to say it again but I will - we don't have much time

Jack Zhao - 2010-07-19 09:42:50

I think instead of me trying to get a local copy working, I'll work on static XHTML/CSS templates and send them over to one of you guys to merge.

I will work on it tonight after work.

Henare Degan - 2010-07-19 09:51:39

Sweet, Jack no problem.

I'm sure I don't need to tell you but remember we'll be integrating into the existing dynamic code so the closer you stay to the original code structure the easier it will be for us.

The CSS: http://github.com/openaustralia/electionleaflets/tree/master/docs/css/
The templates: http://github.com/openaustralia/electionleaflets/tree/master/templates/

Are you aiming to get us a first cut tonight?

Cheers, Henare

Jack Zhao - 2010-07-19 09:55:44

no problem, Henare. will use the current template as the base.
should be able to finish the first cut tonight.

Henare Degan - 2010-07-19 10:17:54

That's awesome Jack, thanks!

Henare Degan - 2010-07-19 10:25:16

@teresa

A couple of minor points about the design:

• The pipe separated list under the title should be (not so worried about the wording, just the grouping): 2010 Federal Election | Live Election Leaflet Monitoring
• At the bottom of the cool paper background thing I assume there's another 'cut', it kinda looks weird - what about a gradient fade to white? (You may have already tried this, ignore me if you have
• The nav bar at the top - we're getting rid of "Map" and "Analysis" for the moment, yeah?

Teresa Leung - 2010-07-19 23:28:40

Thanks Henare!

• Pipe fixed
• Cut looked weird to me too but had to pull the trigger last night (too sleepy). There's a new solution now (jpg preview attached)
• Jack & Andrea will remove 'map' and 'analysis'

Some notes about the calls to action on the homepage...

The wording was changed from TSC version to accommodate mobile users since it was recommended by TSC to capitalise on this feature.

From Henare's explanation, it seems that the workflow for emailing leaflets doesn't make much sense for any other users apart from mobile phone users (I could be wrong, please correct me). It's a convoluted process for users with digital files on their computer - it's quicker if they upload them directly instead.

This lead to the idea of splitting up instructions to suit the 3 types of users:

• mobile phone users who have to email their files
• users who don't have smart phones but have digital files should upload directly to save time
• people who want to post their leaflets via snail mail

So I looked at TSC wording:

• Are the instructions...take a photo with a camera and scan with a scanner etc.. really necessary. And if so, this is common to emailers & uploaders. To do this means it's just visually complicated.
• With the new wording, I've tried to allude to that process without spelling it out like TSC.

Jack & Andrea have simplified the wording even more:
Upload them online now (photograph or scan them first)
Email them straight from your phone ([email protected])
Post them to us via snail mail (PO Box address...)

Jpg attached

Teresa Leung - 2010-07-19 23:31:44

• New wording for calls to action
• Divide between paper & white background changed

Jack Zhao - 2010-07-20 01:02:30

initial draft template based on design.
to do:

• Teresa's slightly new design
• "crease" lines
• footer styling
• make "add a leaflet" icons clickable
  ... other css styling issues.

Henare Degan - 2010-07-20 10:39:46

>initial draft template based on design.

Can I be the first to say, "oh boy, oh boy, oh boy!". Great stuff Jack - looks awesome at initial pass.

I'm not sure of Matthew's availability right now but I'll put my hand up to start work on this straight after work.

Jack Zhao - 2010-07-20 22:44:28

Templates:
home (home.html)
upload (addupload_new.html)
listing (latest_new.html)
detail (detail_new.html)
full view (full_new.html)

Jack Zhao - 2010-07-20 22:46:33

IMPORTANT:
all templates must use 'home_files/main.css'

Matthew Landauer - 2010-07-21 01:35:01

Even at this late stage there are too many small problems left with the css/html implementation for this to go live for the launch.

Henare can fill you in on the details of these.

I'm disappointed you weren't able to deliver working css/html.

It would be great if you could iron out the remaining problems in the next couple of days so we can update the site as soon as possible.

Teresa Leung - 2010-07-21 07:14:05

Oh bummer. We deliberately de-prioritsed visual refinements on the homepage - we intend to fix these in the next couple of days. Henare, details of the functional fixes would useful.

I've uploaded our logo as png & photoshop without the background image. We need to overlay this over the clouds to at least inject a portion of our identity into the TSC version & make the header less dodgy-looking.

Teresa Leung - 2010-07-21 07:50:47

Interim header files

Henare Degan - 2010-07-21 19:50:24

Hi all,

Just as a random idle experiment I thought I'd see if I could rebase my design changes from last night onto our latest code and... it worked!

I've pushed it as a new topic branch to my fork: http://github.com/henare/electionleaflets/tree/EL-28

You can see the code differences here:
http://github.com/openaustralia/electionleaflets/compare/openaustralia:master...henare:EL-28

And I've checked it out on the test site so you can see what it all looks like: http://test.electionleaflets.org.au/

Teresa Leung - 2010-07-24 18:02:46

Jack - lots to do to tighten up the design.. I've attached a pdf with my comments. Also have provided design templates for the leaflet pages to show where we need to get to.

I'm still working on the leaflet gallery page.. will send that through later tonight.

Teresa Leung - 2010-07-24 18:05:15

Photoshop file with type specs on leaflet page

Teresa Leung - 2010-07-24 22:48:03

Jpg and psd file for the leaflet gallery page template:

http://www.electionleaflets.org.au/leaflets/?page=3

However, live site has issues with text and image overlapping.

Google image search results - possible solution - resize images to fit within a set area to resolve spacing issues:

http://www.google.com.au/images?q=election+leaflets&hl=en&client=firefox-a&hs=H7y&rls=org.mozilla:en-US:official&prmd=i&source=lnms&tbs=isch:1&ei=dttKTL2_OYnUvQOfo7W7Cg&sa=X&oi=mode_link&ct=mode&ved=0CBcQ_AU

Teresa Leung - 2010-07-24 22:55:44

Refinements for About us page:

• Narrow the text column to 820px to reduce line length to readable width.
• Apply hyperlink style to links within the body text (brown with underline)

Jack Zhao - 2010-07-25 01:42:32

implemented most the design changes. see them on the test site.

gallery page is in progress, should be able to finish today (sunday).

Teresa Leung - 2010-07-25 12:13:34

LOOKS AWESOME!

Can't wait til this goes live.

We should probably add a badge or something to acknowledge the redesign so that previous visitors don't think they've landed on the wrong site.

Also, some minor adjustments attached in the pdf (notes_r2).

I'll work on a 'new design' badge now.

Teresa Leung - 2010-07-25 13:34:01

If we want to add this...

Design for a little flag saying 'new design launched' which we can keep for a week or so, then remove as needed...

jpg and EPS attached

Henare Degan - 2010-07-25 15:47:49

Wow, you guys have done an amazing job!

Henare Degan - 2010-07-25 15:56:42

Committed: http://github.com/henare/electionleaflets/commit/405ffcc49cd41587fc7c30312a8de287662aa1ce

Jack Zhao - 2010-07-25 23:12:16

majority of visual design changes now completed.

please create new tickets for new changes/fixes.

Improve layout of name and address fields (EL-46)

Current form asks for two answers with one question: 'Enter your name and email address' and shows the fields side by side (jpg attached).

Improve UX by:
Separating into two questions
Please enter your name (your name won't be made public)
Please enter your email address (your name won't be made public)

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-18 09:24:44
Updated	2010-07-29 07:04:21

📎 Jira attachments: https://tickets.openaustraliafoundation.org.au/attachments/EL/EL-46

Localise data from TSC (EL-23)

Noticed on the wave that you have completed:

1. Constituencies
2. Parties
3. Election

Is there anything else?

---

Issue details imported from Jira:

Detail	Value
Assignee	Matt Joyce
Reporter	Teresa Leung
Created	2010-07-17 20:47:05
Updated	2010-07-18 11:30:07

---

Imported Jira Comments

Matt Joyce - 2010-07-17 23:00:05

The geo needs to be done.

Matthew Landauer - 2010-07-18 11:30:07

Geo still needs to be done but that's in separate tickets

Homepage redesign (EL-27)

Redesign the homepage for the Australian Federal Election 2010

Deliverables:

• Wireframe
• Visual design

---

Issue details imported from Jira:

Detail	Value
Assignee	Teresa Leung
Reporter	Teresa Leung
Created	2010-07-17 21:09:39
Updated	2010-07-29 10:45:17

---

Imported Jira Comments

Teresa Leung - 2010-07-18 11:52:59

http://gomockingbird.com/mockingbird/index.html?project=f79bc88f2b8ae5d3127dc84f83feb372340343e0

Teresa Leung - 2010-07-18 20:39:11

Wireframes v2

http://gomockingbird.com/mockingbird/index.html?project=f79bc88f2b8ae5d3127dc84f83feb372340343e0

Teresa Leung - 2010-07-20 00:41:22

We've moved onto the visual design and implementing CSS/html now, so need for this ticket. Any new mods can be logged as a new ticket.

Add sparklines (EL-38)

Sparklines show:
Total volume (on homepage)
Total per electorate (on electorate leaflets page)

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 21:57:43
Updated	2010-07-29 07:04:35

Make sure that emailing of leaflets works (EL-48)

On the front page there's an email address to email leaflets to. Are these emails handled automatically. If so, make sure it works

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Matthew Landauer
Created	2010-07-18 10:37:09
Updated	2010-07-18 21:00:14

---

Imported Jira Comments

Henare Degan - 2010-07-18 19:38:54

Test server configured to receive leaflets, email [email protected]. Currently polling every 5 mins so you'll have to wait up to 5 mins.

Henare Degan - 2010-07-18 21:00:14

Marking this as resolved.

The email processor extracts the name and email address from the email, it also runs the extract_postcode function from the geocoder class on the subject and body and returns the postcode.

Unfortunately, nothing is done with these at the moment, see the improvement ticket EL-59.

show leaflet volume next to category (EL-13)

On page http://test.fairdinkum.org.au/leaflets/ there is a list of categories.
It would be useful to indicate the leaflet volume attributed to each category.

eg

Crime (1)
Litter (15)
Foo (200)

---

Issue details imported from Jira:

Detail	Value
Assignee	Matt Joyce
Reporter	Matt Joyce
Created	2010-07-12 23:13:34
Updated	2010-07-29 10:45:16

---

Imported Jira Comments

Matt Joyce - 2010-07-25 15:38:02

This is resolved by EL99
http://github.com/openaustralia/electionleaflets/commit/e4d85417478091a2c7b01e6c7105eac728c1db19

Add a default page title (EL-3)

Add a default title so that you don't get pages with titles like "| Fair Dinkum"

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Henare Degan
Created	2010-07-11 20:14:26
Updated	2010-07-19 18:53:59

---

Imported Jira Comments

Henare Degan - 2010-07-19 18:53:59

Added a better one: http://github.com/openaustralia/electionleaflets/commit/ee17537371512f39262789484953faad59c08947

Update the AEC scraper (postcodes to divisions) (EL-20)

also, I'm wondering if the scraper cycles through every postcode extracting the divisions, rather than by division extracting postcodes, we may circumvent the multiple page problem.

http://auspost.com.au/products-and-services/download-postcode-data.html
http://www.aec.gov.au/About_AEC/Publications/Electoral_Divisions/index.htm

---

Issue details imported from Jira:

Detail	Value
Assignee	Matthew Landauer
Reporter	Matt Joyce
Created	2010-07-14 10:21:37
Updated	2010-07-29 10:45:16

---

Imported Jira Comments

Matt Joyce - 2010-07-14 10:22:52

In case geo2gov doesn't come through, we should just gen our own lookup table.

Matthew Landauer - 2010-07-14 10:27:03

Geo2gov won't help with this problem unfortunately as geo2gov is focused on finding the electoral division for a specific point on a map. A postcode is an area on the map.

When you do a postcode lookup on geo2gov it converts it to a single point somewhere inside the postcode area. That will only ever map to a single electoral divison whereas in truth there might be several electoral divisons inside a single postcode area.

Matthew Landauer - 2010-07-14 10:28:29

Current scraper is here: http://github.com/openaustralia/openaustralia-parser/blob/master/parse-postcodes.rb

Matthew Landauer - 2010-07-14 10:34:47

It looks to me like the current scraper does in fact cycle through the valid postcodes and looks up the electoral divisions rather than the other way around.

Matt Joyce - 2010-07-14 12:41:40

My bad, I saw that the code flagged lookups which resulted in multiple pages and assumed no postcode would result in more than one page of divisions.

OK, let's run the scraper and I'll fix up the exceptions.
I'm not familiar with ruby, it looks a bit like python.

Regarding the geo issue, we can still do Long/Lat->Postcode->List of Divisions.
IIRC the Long/Lat of a postcode is in fact a post office location, not the centre of an area. Might be wrong.

Henare Degan - 2010-07-14 14:41:27

>IIRC the Long/Lat of a postcode is in fact a post office location, not the centre of an area. Might be wrong.

Doesn't appear to be with Google's geocoder (which is what Geo2Gov is using) - it's certainly not for 2042 anyway.

Matt Joyce - 2010-07-14 15:19:15

Hmm, might have been a "post offices" PIO data for GPS units, that I'm thinking of.

Matthew Landauer - 2010-07-16 15:20:16

Updated the scraper so that it works with the current version of the AEC website.

Also, removed the caching proxy and most importantly of all made the pages with multiple pages of results work automatically

See http://github.com/openaustralia/openaustralia-parser/blob/master/parse-postcodes.rb

Note that the postcode.csv file hasn't yet been updated.

Matthew Landauer - 2010-07-16 18:50:15

It turned out previously I wasn't quite there. Should be fixed now.

Also, I've generated the 2010 (after redistribution) postcode -> electoral division mapping here:

http://git.openaustralia.org/?p=openaustralia-parser.git;a=blob;f=data/postcodes_2010.csv;h=62f2737556757c18b30e72b4e501c61cab11ebe6;hb=HEAD

So, we should be good to go.

Site not pretty-404ing like TheSC does (EL-2)

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Henare Degan
Created	2010-07-11 20:05:24
Updated	2010-07-11 20:13:19

---

Imported Jira Comments

Henare Degan - 2010-07-11 20:13:19

Hmm, looks like TheSC's is broken: http://www.thestraightchoice.org/404

Ours is fixed now: http://test.fairdinkum.org.au/404

Create a form for mobile users to upload their leaflet images (EL-39)

Design & build an upload leaflet form specifically for mobiles.

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Teresa Leung
Created	2010-07-17 22:00:12
Updated	2010-07-18 21:38:52

---

Imported Jira Comments

Henare Degan - 2010-07-18 21:37:51

I checked my mobile browser (Android) and it specifically blocks uploads which, while crap, is pretty common I think.

Tidy up code for choosing storage strategy. (EL-10)

I had to comment out stuff to disable S3 storage. Should be a config directive.

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Matt Joyce
Created	2010-07-12 00:14:29
Updated	2010-07-12 00:23:54

---

Imported Jira Comments

Matt Joyce - 2010-07-12 00:18:19

I added some logic and renamed a directive.
Commited.

Henare Degan - 2010-07-12 00:23:54

Deployed.

New name for Fair Dinkum (EL-26)

Finalise selection of a new name for Fair Dinkum.

The name should ideally take into account the following:

• needs to be memorable
• be easy to look up online
• reflect what the website is about and/or the benefit to users
• infer that a credible, trustworthy organisation is behind the website

Names with votes so far:

fairelection.org.au (2)
electionleaflets.org.au (2)
electionflyers.org.au (1)
openelection.org.au (1)
keepingtheirword.org.au (1)
electionpromises.org.au (1)

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 21:07:57
Updated	2010-07-29 10:45:16

---

Imported Jira Comments

Matthew Landauer - 2010-07-18 11:42:12

Which term is more popular: leaflet, flyer or pamphlet?

See http://en.wikipedia.org/wiki/Lindsay_pamphlet_scandal#References

Out of the 31 references in http://en.wikipedia.org/wiki/Lindsay_pamphlet_scandal#References, 9 mention leaflet, 3 flyer and 3 pamphlet.

That means all variants are in common use by the media but leaflets is more popular than the others

Matthew Landauer - 2010-07-18 12:58:57

Done and decided.

We're opting for electionleaflets.org.au

with a full name of Election Leaflets Australia

Add functionality to filter results by party on the leaflets listing page (EL-30)

Default display is by reverse chronological order (newest first).
Add functionality to allow the user to sort by party as well.

Corresponding page from TSC:
http://www.thestraightchoice.org/constituencies/stockton_south/

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 21:18:42
Updated	2010-07-17 23:26:25

Database needs to be reset to not reference leaflets and images which don't exist. (EL-5)

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Matt Joyce
Created	2010-07-11 21:58:56
Updated	2010-07-11 22:15:20

---

Imported Jira Comments

Matt Joyce - 2010-07-11 22:05:07

TRUNCATE TABLE `leaflet`;
TRUNCATE TABLE `leaflet_category`;
TRUNCATE TABLE `leaflet_category_seq`;
TRUNCATE TABLE `leaflet_constituency`;
TRUNCATE TABLE `leaflet_election`;
TRUNCATE TABLE `leaflet_image`;
TRUNCATE TABLE `leaflet_image_seq`;
TRUNCATE TABLE `leaflet_party_attack`;
TRUNCATE TABLE `leaflet_party_attack_seq`;
TRUNCATE TABLE `leaflet_seq`;
TRUNCATE TABLE `leaflet_tag`;
TRUNCATE TABLE `leaflet_tag_seq`;
TRUNCATE TABLE `promise`;
TRUNCATE TABLE `rate_interesting`;
TRUNCATE TABLE `rate_value`;
TRUNCATE TABLE `tag`;
TRUNCATE TABLE `tag_seq`;

Matt Joyce - 2010-07-11 22:05:25

Maybe take a dump before too?

Henare Degan - 2010-07-11 22:15:20

Done.

Mapping electoral boundaries to postcode / street address / GIS data (EL-22)

Resolve how users upload their leaflets to their correct electorate

Latest discussions are:

Geo2Gov postcode to Federal division issues
http://groups.google.com/group/openaustralia-dev/browse_thread/thread/d1412c791caf7b7a

and

Election Leaflet project
http://groups.google.com/group/openaustralia-dev/browse_thread/thread/9e08387abb6e39b4

---

Issue details imported from Jira:

Detail	Value
Assignee	Matthew Landauer
Reporter	Teresa Leung
Created	2010-07-17 20:45:01
Updated	2010-07-29 10:45:16

---

Imported Jira Comments

Henare Degan - 2010-07-18 11:18:51

Assigned to me to split out tasks.

Matthew Landauer - 2010-07-20 23:57:07

First solution to this problem. Not nice, but probably good enough for the launch

Add a title to the 404 page (EL-4)

There's no HTML title on the 404 page.

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Henare Degan
Created	2010-07-11 20:15:08
Updated	2010-07-12 00:13:27

Remove map altogether (EL-49)

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Teresa Leung
Created	2010-07-18 11:33:27
Updated	2010-07-29 10:45:17

---

Imported Jira Comments

Henare Degan - 2010-07-18 16:58:46

Is this just this map? http://www.thestraightchoice.org/map/leaflets/

Do we just want the link in the nav bar removed?

Henare Degan - 2010-07-18 17:08:41

The /map URL goes off to the Django app stored in /djangoleaflets, that's why it 404s on the test site.

Matthew Landauer - 2010-07-19 18:03:20

I've done it. Sorry Henare for stealing your tickets!

Henare Degan - 2010-07-19 18:25:15

Hey - haven't you got something better to do!

Show leaflet volume next to parties (EL-14)

Like EL-13, show volume of leaflets on the http://test.fairdinkum.org.au/parties/ page.

Maybe add to the right column so it says, "View 3 leaflets published by this party | View 16 leaflets attacking this party"

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Henare Degan
Created	2010-07-13 08:08:06
Updated	2010-11-28 18:33:51

---

Imported Jira Comments

Matt Joyce - 2010-08-04 14:01:30

This will add the count of leaflets to the parties page.
http://github.com/mattjoyce/electionleaflets/commit/dcfb5a496e2f4e05160f2af5e012cbd03661fe04
Accept the above commit for now.

Have not figured out how to list all parties, and count live attack leaflets.
This is my sql so far

SELECT party.name, party.party_id, party.url_id, party.colour, COUNT( leaflet_party_attack.leaflet_id ) AS count
FROM party
LEFT JOIN leaflet_party_attack ON leaflet_party_attack.party_id = party.party_id
GROUP BY party.name, party.party_id, party.colour
ORDER BY party.name
LIMIT 0 , 30

Matt Joyce - 2010-08-05 12:56:09

eek, removed an unsightly print_r
http://github.com/mattjoyce/electionleaflets/commit/bfc542f5c7789e291715826fb60fa40f8139552e

talk about leaving the forceps in the patient!

please merge both commits.

Add background information for leaflets (EL-35)

Add background information for each leaflet (e.g. current member, candidates)
Information is the same for leaflets in the same electorate.

The solution will need to involved users being able to fill in this information themselves.

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 21:49:52
Updated	2010-07-29 07:04:34

Add browse leaflets by date at the bottom of the 'Browse by,, ' page (EL-33)

Corresponding page from TSC:
http://www.thestraightchoice.org/browse.php

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 21:42:40
Updated	2010-07-29 10:53:31

---

Imported Jira Comments

Teresa Leung - 2010-07-29 10:53:31

Add another section that categorises leaflets by date so that users can access leaflets by date.

E.g leaflets from another year or a specific month or week.

Could be useful for when the site can accommodate multiple elections.

Allow users to browse by electorate hot spots on the homepage (EL-41)

Add map to homepage with hotspots showing

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 22:03:14
Updated	2010-07-29 07:04:34

Solve mobile upload issue (EL-40)

Issues:

• clicking on the 'send them straight from your phone' link triggers mail client but this is useless (I can only tell from my iPhone - is it true for all smartphones?). They have to select the photo FIRST then email it to us.
• to do this, they have to memorise or cut n paste our email from the homepage back into their email 'To' field... annoying!
• users can only email one photo at a time, with no way of being able to tie the photos together as relating to the same leaflet

Is the solution a mobile app?

Let's change the process so that it sets up the right expectations and work flow from the user perspective.

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 22:00:35
Updated	2010-07-25 23:19:52

---

Imported Jira Comments

Teresa Leung - 2010-07-25 23:19:52

Duplicates EL-98

Write text for homepage (EL-44)

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 23:43:56
Updated	2010-07-25 23:20:13

---

Imported Jira Comments

Henare Degan - 2010-07-18 14:24:32

Wave to collaborate on the copy:

https://wave.google.com/wave/waveref/googlewave.com/w+tl4IqstSB

constituency.url_id not populated in test system (EL-12)

Same as EL-1

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Henare Degan
Created	2010-07-12 00:22:23
Updated	2010-07-12 23:09:15

📎 Jira attachments: https://tickets.openaustraliafoundation.org.au/attachments/EL/EL-12

---

Imported Jira Comments

Matt Joyce - 2010-07-12 00:30:36

Is this url_id, similar to the issue with parties?
Use same approach?

Henare Degan - 2010-07-12 00:32:23

Yep, same deal.

Matt Joyce - 2010-07-12 22:01:47

SQL attached.
Replaces all constituency records.
Destructive.

Henare Degan - 2010-07-12 22:36:32

Phoar, some borkage in there mate Fix in the attached file.

Changes updated on the site.

Henare Degan - 2010-07-12 22:48:20

Sorted in the code: http://github.com/openaustralia/fairdinkum/commit/5fcb9bd6e851b6d7b16f7b14bbcc198fc78dd185

Matt Joyce - 2010-07-12 23:06:53

oops nasty apostrophes.

Henare Degan - 2010-07-12 23:09:15

Yarr

Remove Public Whip header (EL-47)

This is showing up on the upload leaflet pages.

Find and remove yellow header bar from all pages where it appears (jpg attached).

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Teresa Leung
Created	2010-07-18 09:27:11
Updated	2010-07-18 17:18:38

📎 Jira attachments: https://tickets.openaustraliafoundation.org.au/attachments/EL/EL-47

---

Imported Jira Comments

Henare Degan - 2010-07-18 17:18:38

Done: http://github.com/openaustralia/electionleaflets/commit/4d3d332b6977efef52f716730f08f83d1500717e

Some links are to the .php pages, not the rewritten URLs (EL-15)

For example, on this page: http://test.fairdinkum.org.au/leaflets/

The link "View all parties" goes to /parties.php, not just /parties/ as it could.

Is this a problem or is there a good reason for having it like this?

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Henare Degan
Created	2010-07-13 08:10:32
Updated	2010-07-13 23:38:31

---

Imported Jira Comments

Henare Degan - 2010-07-13 08:11:36

What are you thoughts on this?

I was just about to go ahead and start fixing some of these when I realised there might be a good reason not to change them.

Matt Joyce - 2010-07-13 22:45:03

I'm not sure, does rewriting url/like/that impact the way parameters are passed?

Henare Degan - 2010-07-13 22:48:45

No, you/just/?do=it&like=this /or?this

Plus, it's just direct links I was seeing, so converting this.php into /this/

Matt Joyce - 2010-07-13 22:56:35

agreed, I see not adverse impact. looks way better.

Henare Degan - 2010-07-13 23:38:31

Done:

http://github.com/openaustralia/fairdinkum/commit/7632efa85133b91d582ffd71f7352e78544671c0
http://github.com/openaustralia/fairdinkum/commit/44838a86653a9f6bdec66cb782deb0b1a67c588a

When uploading an image, a UK postcode is required (EL-9)

Issue details imported from Jira:

Detail	Value
Assignee	Matthew Landauer
Reporter	Henare Degan
Created	2010-07-11 22:43:33
Updated	2010-07-29 10:45:16

---

Imported Jira Comments

Matt Joyce - 2010-07-13 23:33:37

Do we have a strategy?
As postcodes can resolve to multiple divisions we needs to offer the user a choice.
However a choice of division is less than helpful and users may not know their division.

AEC even say 'call us'

http://apps.aec.gov.au/eSearch/LocalitySearchResults.aspx?filter=2133&filterby=Postcode
We could offer a map encompassing all the localities covered by the divisions, which match the post code.

Thoughts?

Henare Degan - 2010-07-13 23:40:52

>Do we have a strategy?
>Thoughts?

Geo2Gov seems the obvious way.

Matt Joyce - 2010-07-14 06:46:55

The AEC shows the following for my postcode 2133
http://apps.aec.gov.au/eSearch/LocalitySearchResults.aspx?filter=2133&filterby=Postcode

Two possible divisions, Grayndler or Watson.

Output form geo2gov for the same postcode
http://geo2gov.com.au/json?location=New+South+Wales+2133

No mention of Watson, or Grayndler.

Henare Degan - 2010-07-14 07:38:57

Sigh. And I'd just been pretending it was just me - I've seen quite a few problems lately but just dismissed them as minor bugs.

It gets my postcode wrong too - 2042 can be in Sydney or Grayndler, which the AEC gets right but which Geo2Gov insists I'm in Grayndler.

It's probably worth emailing the creators of it, Adam and Jeffrey, and seeing what's up.

Henare Degan - 2010-07-14 09:39:50

Emailed: http://groups.google.com/group/openaustralia-dev/browse_thread/thread/d1412c791caf7b7a

Matthew Landauer - 2010-07-20 23:57:52

Fixed. Accepts australian postcodes now.

party.url_id is a short URL string, not an AEC URL (EL-1)

On the test site, when you click one of the "Top parties" links it sends you to a bad URL - it's because the data in party.url_id is not supposed to be a URL but just a short ID.

We should just lower case the party names and replace strings with underscores.

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Henare Degan
Created	2010-07-11 20:04:06
Updated	2010-07-11 22:21:21

📎 Jira attachments: https://tickets.openaustraliafoundation.org.au/attachments/EL/EL-1

---

Imported Jira Comments

Matt Joyce - 2010-07-11 21:46:24

I came to report the same issue!
Attached is sql to insert a replacement for the data. (destructive).

Henare Degan - 2010-07-11 21:53:36

Beaut! I've updated the test DB.

Henare Degan - 2010-07-11 22:21:20

An updated DB schema has been added to the repo.

Configure S3 storage (EL-21)

I've signed up for an account for OpenAustralia Foundation for S3

Let me know when you're ready to do that and I'll send you the api key & secret

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Matthew Landauer
Created	2010-07-17 13:13:36
Updated	2010-07-29 07:06:24

---

Imported Jira Comments

Matt Joyce - 2010-07-25 15:36:46

I found a section where the S3 / Local has not been coded.
I added MJFIXME to the original port, so should still be there.

Matt Joyce - 2010-07-26 22:36:55

OK, I added a condition based on the STORAGE_STRATEGY directive.
http://github.com/openaustralia/electionleaflets/commit/6c331c391e7f6f485e73df4dae1bd96874042efa

Matthew Landauer - 2010-07-29 07:06:24

S3 appears to all be working and is happy and live on the site.

Thanks so much Matt for getting this all fixed up

Country is hardcoded in a couple of places. (EL-11)

country_id=225 is for the UK.
should be 13, Australia.
should be a directive.

(I guess the future should have an admin page and elections should be defined, etc)

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Matt Joyce
Created	2010-07-12 00:22:03
Updated	2010-07-12 00:31:52

---

Imported Jira Comments

Matt Joyce - 2010-07-12 00:28:14

Still hardcoded, but not in general.php
Committed.

Henare Degan - 2010-07-12 00:31:52

Deployed!

Google Analytics key is hard coded (EL-18)

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Henare Degan
Created	2010-07-14 00:15:17
Updated	2010-07-18 17:19:32

---

Imported Jira Comments

Matt Joyce - 2010-07-17 22:36:55

Moved to general.php
http://github.com/openaustralia/fairdinkum/commit/9ca93cd5cba5a84d120842a6481f2a5e6491c530

Need new tracker ID

Matthew Landauer - 2010-07-18 08:57:59

Can't do anything about this until we have the domain name sorted: EL-26

Matthew Landauer - 2010-07-18 13:28:38

Google Analytics tracking codes:

test.electionleaflets.org.au
UA-3107958-9

www.electionleaflets.org.au
UA-3107958-8

Henare Degan - 2010-07-18 17:19:32

Deployed to new test site.

Update homepage title to "General Election 2010" (EL-7)

Should be moved to a directive in general.php. and corrected.

---

Issue details imported from Jira:

Detail	Value
Assignee	Teresa Leung
Reporter	Matt Joyce
Created	2010-07-11 22:22:13
Updated	2010-07-20 18:26:45

---

Imported Jira Comments

Henare Degan - 2010-07-13 18:22:13

All yours Teresa

Teresa Leung - 2010-07-17 20:54:20

Thanks Henare but I'm not sure what the description means. Is this something I need to fix in the code?

Matt Joyce - 2010-07-17 21:25:20

My idea was to move the text "Election 2010" (or whatever) to data and then render it over the image.
But given the time pressure, I think just replacing the image would be fine.

Teresa Leung - 2010-07-17 22:12:24

In that case, this ticket is still mine.

Teresa Leung - 2010-07-20 18:26:45

Homepage redesigned and renamed.

Improve map functionality (EL-34)

This is low priority - not for first launch.

Add a hover state on the map so that it shows the electorate name & no's of flyers in a tooltip
Add an 'on' state when an electorate is selected

Corresponding page from TSC:
http://www.thestraightchoice.org/map/leaflets/

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 21:46:22
Updated	2011-03-14 16:44:37

Change Jira project key (EL-50)

http://confluence.atlassian.com/display/JIRA/Changing+the+Project+Key

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Henare Degan
Created	2010-07-18 11:55:37
Updated	2010-07-18 16:57:26

---

Imported Jira Comments

Henare Degan - 2010-07-18 16:57:26

All sorted.

Make site name references not hard coded (EL-17)

There's a bunch of places where the site name is hard coded and it doesn't need to be.

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Henare Degan
Created	2010-07-13 23:47:19
Updated	2010-07-14 00:02:52

---

Imported Jira Comments

Henare Degan - 2010-07-14 00:02:52

I think I got most of them: http://github.com/openaustralia/fairdinkum/commit/7ed1a3b156cc4162f5c326519172c8855382cf71

email address on landing pages is wrong (EL-6)

Should be moved to a directive in general.php

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Matt Joyce
Created	2010-07-11 22:13:52
Updated	2010-07-11 23:12:13

---

Imported Jira Comments

Matt Joyce - 2010-07-11 23:05:09

Added new directive LEAFLETS_EMAIL and changed template.
Committed.

Henare Degan - 2010-07-11 23:12:13

And deployed.

Add sort function for leaflets listings (EL-31)

Sort by:

• party
• category
• electorate
• date: newest leaflets first (default)

Pages this effects - see corresponding pages from TSC:

By party:
http://www.thestraightchoice.org/parties/liberal_democrats/

By latest uploaded:
http://www.thestraightchoice.org/leaflets/

By categories:
http://www.thestraightchoice.org/categories/18/

~~~~~
This ticket requires a solution for how to show sorted results

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 21:22:11
Updated	2010-07-29 07:04:34

Add leaflets from a particular party to your own site (EL-25)

Is this popular enough to keep?

On the Straight Choice:

Add leaflets from the Conservative Party to your site:

http://www.thestraightchoice.org/parties/conservative_party/

We were debating how useful this was to the regular user.

• Who would need or want to embed ALL the flyers from a particular party to their own site?
• If it's for a minority of users, does the benefit of including a highly technical widget for a few expert/dedicated users
• Can we replace with permalink and sharing tools for individual flyers to solve this user need?

---

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 20:51:56
Updated	2010-07-25 23:23:58

---

Imported Jira Comments

Teresa Leung - 2010-07-25 23:23:58

Live site includes this feature

Add permalink and share tools (EL-32)

Add this to:

• individual leaflet page
• pages which display listings of leaflets

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Teresa Leung
Created	2010-07-17 21:40:46
Updated	2010-08-11 10:39:06

---

Imported Jira Comments

Henare Degan - 2010-07-30 08:16:35

I've added this to a topic branch: http://github.com/henare/electionleaflets/commit/6c3192f0099b7dd9d633623e280ab4d8fe811121

Henare Degan - 2010-07-30 08:22:25

I've deployed this experimental branch to test - Teresa can you please let me know what you think?

Thanks, Henare

Henare Degan - 2010-08-11 00:06:39

Deployed: http://github.com/openaustralia/electionleaflets/commit/c20f540814022ee6e3b8aaf35244a2c13ebcc2c1

Matt Joyce - 2010-08-11 10:39:06

nicely done.

Decide whether to keep the TSC's question 'what parties does this leaflet attack?' (EL-29)

This question is asked at time of uploading.

Resolve whether we keep this question for Fair Dinkum.

---

Issue details imported from Jira:

Detail	Value
Assignee	Teresa Leung
Reporter	Teresa Leung
Created	2010-07-17 21:17:03
Updated	2010-07-29 10:45:17

---

Imported Jira Comments

Matthew Landauer - 2010-07-18 09:08:14

Seems a fair enough question as it is fairly common for leaflets to be negative

Teresa Leung - 2010-07-18 09:42:05

Agree.. seeing these leaflets grouped together is rather telling of the party who creates them.

Matthew Landauer - 2010-07-18 11:34:01

Agreed

The analysis page has hard codes for UK parties. (EL-8)

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Matt Joyce
Created	2010-07-11 22:27:22
Updated	2010-07-29 10:31:08

Add commenting to leaflet page (EL-42)

Issue details imported from Jira:

Detail	Value
Assignee	Unassigned
Reporter	Teresa Leung
Created	2010-07-17 22:03:43
Updated	2010-07-29 07:04:20

Look at the outstanding tickets for the upstream project and log them (EL-19)

There's a bunch of outstanding tickets here: http://code.google.com/p/theelectionleafletproject/issues/

Someone needs to go through them and see what's relevant to Fair Dinkum and log them here so we can fix them (and hopefully send the fixes upstream).

---

Issue details imported from Jira:

Detail	Value
Assignee	Henare Degan
Reporter	Henare Degan
Created	2010-07-14 00:30:55
Updated	2011-11-20 15:23:10

---

Imported Jira Comments

Henare Degan - 2011-11-20 15:23:10

Upstream has moved to Django so this is not relevant.

Publicity (EL-24)

Craft a message to ask our contacts to spread the word about the project and/or seek participation to upload leaflets

List of potential contacts for publicising the leaflet project:
https://wave.google.com/wave/#restored:wave:googlewave.com%252Fw%252BnBSEBaNAA.1

---

Issue details imported from Jira:

Detail	Value
Assignee	Kat Szuminska
Reporter	Teresa Leung
Created	2010-07-17 20:48:14
Updated	2010-07-29 06:44:28

---

Imported Jira Comments

Matthew Landauer - 2010-07-18 11:21:09

This ticket needs splitting up

Matthew Landauer - 2010-07-29 06:44:28

I'm closing this ticket as the core of it is done. I'm sure there is lots more publicity to come but those should be new tickets.