Creating a poll orientated site - Need advice

Posted by Bobuido on August 28, 2007 at 7:41pm

Hi,

I've been set the task of creating a poll to stimulate public debate

I only have "extend" control panel access

I believe the webhost has disabled temporary tables
(not sure how this will affect my requirements)

I also have a PHP memory limit which currently won't allow the modules I have enabled plus views :(

Relevant Enabled Modules

Poll
Advanced poll (+Voting API)
Profile (Thought I needed an extra module. Turns out I hadn't enabled "Profile")
Forums
Advanced user

Basic Requirements

New Poll every month (Calendar month)
Discuss issues arising from the polls topics and their results
Register users with profession / status

So half the task was pretty simple thanks to Drupal and its users

Advanced Requirements - In order of importance

Option to Mass mail poll results to flagged users profiles every month
(Installed "advanced user" but shows errors :S)
Query profile and poll to mix results (e.g. give me all votes for A from Drupal Lovers)
Create user and submit vote in one submit

Questions

Will views allow me to accomplish "Query profile and poll to mix results"? - If so...
Could anyone provide a rough guide to how to go about this?
Any other mass mailer options other than "advanced user"?

Any help / advice with the above would be great

Thanks in advance

Rob

Comments

Views / VotingAPI / Memory / MySQL - Update 290807

Posted by Bobuido on August 29, 2007 at 9:57pm

Now have enough memory - Luckily I was able to drop in a php.ini to up the memory limit a bit
One more problem solved
Also our I.T. consultant seems to think his hosting company will enable temporary tables if we ask - Which is nice

Having now got enough memory to enable views - It seems to be what I'm looking for

What I'm looking to do is have a table of results per poll with

Username - Profession - Vote

From what I can see you need to give node ID as an argument to give you a per poll set of results
:S
Do I need to do anything particular for the relationships?
(i.e. This user has cast this vote)

Even with Node: ID as an arg (and viewing the node) I was still getting a list of all nodes

Also the voting API fields didn't show anything - Just blank rows

Did see a votingAPI patch which I may as well give a go

Slightly baffled, appreciate some help from the views / Drupal masters

Thanks in advance

Current (Main) Project: http://www.takraw-association.org.uk