OK. I'll try to help you through it.

If you are not confident with SQL, try and ask someone else for help. I can provide access (but so can others), but I don't want to spend time doing stuff that anyone else can do. Teach a man to fish & all that.

Step 1: Define the elections (you're done! great)
Step 2: Create the SQL to create the elections. See http://wiki.maemo.org/Maemo.org_team...ng_an_election - especially "Create election in database". Short description: For each election, add to a file "elections.sql":

insert into elections values(
${election_id}, 'elections', '${election_title}', '${start_date}', '${end_date}', ${num_seats}, '${question}');

The election_id should be different for each election. Get the biggest current election_id from http://maemo.org/vote/ (it's 10 right now, so your election_ids will be 11, 12, 13, etc).

Then, add underneath:

INSERT INTO election_choices VALUES
(0, ${election_id}, '${choice_1}'),
(0,${election_id}, '${choice_2}'),
(0,${election_id}, '${choice_3}'),
(0,${election_id}, '${choice_4}'),
...
);

Repeat for each election.

Step 3: Get users.csv off Henri, and run exactly the command I put in the wiki to get the electorate into the database.

Step 4: Modify election instructions (see "Generate election tokens and send out emails") to be what you want people to receive, and give me an email address other than mine which will be the "From" for the emails. Then run the scripts referred to there to generate tmp tokens and email notices out to people.

You're done. The only places where you need help are:
1. Getting users.csv off Henri
2. Need access to the server to run the scripts that create the elections, import the electorate, generate tmp tokens, and send voting instructions.

The things you can (and should) do on your own:
1. Generate the .sql file that creates the elections
2. Modify instructions.txt, and give me an email address to use
3. Handle all of the email related with the election

Ideally, I'll get someone shell access to the server so that you can even do 2 on your own (and you will have to resend tokens to some people too, so I'd prefer that).

Dave.