Hello Drupal Community,

I'm turning to the forum to see if my website idea is feasible on Drupal, or if another platform would be more appropriate.

After logging in, users would use the site to enter about 8 pieces of information for each event (mostly selection from lists / radio boxes, at most one text field).

Aside from maybe an anonymized teaser "There are the last X events entered by our users" blurb on the home page, the events are not to be displayed / published. What will be displayed from the user's point of view, within each user's page, is statistical data about all the events they've entered, pie or bar graphs generated from said data, possibly a way for a user to query their and/or the entire community's aggregate data for comparison purpose.

I'm no web expert for sure, but knowing a bit of php, mysql and html, I handwrote a couple webpages:
- entering event data
- stats and graphs generated by a chart API using above data
- listing event data (mostly to debug, "see" data visually to make sure the line/bar graphs generated are correct)
I'm satisfied with how this single-user proof-of-concept currently works. I'm hoping Drupal is the right platform on which to transition to a more realistic, secure many-users site, because I certainly do not want to tackle user logging, security, css that won't break on various browsers, etc...

I hope I explained what I was interested in doing clearly. If you have any questions, feel free. Is Drupal right for this little project?

Thanks in advance

Comments

mradcliffe’s picture

The hardest part is to generate the graphs/charts.

Everything else is as simple as setting up a content type correctly for the event content (no publish rights), and adding fields to it (Drupal 7 fields).

Views would generate the simple list on the homepage although Views 3 for Drupal 7 is not production-ready (Views 2 for Drupal 6 is and you could do this in Drupal 6).

Depending on how complex the charts are you may be able to use things like the chart api or views charts. It looks like the only Drupal 7 module available, not production-ready, is charts, but I don't have much experience with chart stuff (my boss does). There are a plethora of chart modules for Drupal 6 and I don't have a recommendation there either (search drupal.org for charts views and choose the 'Modules' facet on the right). You'd need to try them out after you learn more about how Views & CCK interact.

thierrydallacroce’s picture

Using the chart API was fairly straight forward, at least from the small proof-of-concept php pages I wrote. It consisted mostly of constructing a long string containing lots of tidbits of information about the chart's type, size and data, and passing it to the API. I did spend plenty more time doing the graphical fine tuning (selecting colors and labelling axis not necessarily centered around zero) but getting a rough draft line or pie chart evocative enough to convey information was no problem.

In the above case, I knew exactly what the database table and its values were. While reading the table, the string was constructed and passed to the API. Obviously to do the same within Drupal, with which I'm not familiar with, is another story. I cannot yet tell if Drupal is more more suited to a user putting together something from already-existing modules, or a programmer trying to insert a few things within Drupal (I'm not talking about creating modules, though it may or may not be required...?) Some of the Drupal concepts seem like wrappers for lower-level code, and sometimes it gets quite abstract it seems.

Thanks for your reply. First let me apologize, though I mentioned Drupal 7, I did not intend to exclude D6. I somewhat understand that most of D6's CCK is now within D7's FieldUI and what not.