By jerry1970 on

Hi all,

I've read the Getting Started but didn't get an answer there.

We have a website about music with, most importantly, news items, concert reviews and interviews, and album reviews.

For the album reviews we want to build a database of artists (eg. "Pink Floyd"), albums (eg. "The Wall"), releases (eg. "2LP, EMI, 1981"), and reviews. A review is about a single release, and written by a single reviewer. Reviewers can only write, they are assigned a review by the Review Editor, who decides which reviews are published. When the Reviewer checks the Finished box, the Reviewers can no longer edit their reviews.
Right now, a dozen reviews are published frequently in one long article (to avoid people linking to a single review and according our policy to mix reviews of well-known with unknown bands). The Review Editor (who is also a Reviewer) decides which finished reviews are included. If this (multiple reviews in a single issue) is a big problem, we can abandon this policy.

We need a CMS so people can write news and interviews more easily (now done in PHP and HTML), but the reviews section is a pain in the ass. I am currently trying to find ways to do this in Joomla, but then I would have to write a lot of PHP code myself and still have no good link between our database and the Joomla articles. It's hard to add a dropdown to an article in the Album Reviews category so the Reviewer can select which Artist - Album - Release the review is about and leave that dropdown box out of articles in other categories.

Is Drupal a better choice for us? I have some experience with Joomla, not with Drupal yet.

All advice is much appreciated!

Thanks,
Jerry

Comments

anil614sagar’s picture

anil614sagar commented

Hi Jerry,

Drupal is a perfect CMS for your project. FYI, http://universalmusic.com/ is built on Drupal.

Cheers,
Anil Sagar,
Lead Drupal Developer,
Azri Soulutions,
http://azrisolutions.com/

composer_v’s picture

composer_v commented

Need more examples please. Universalmusic has full team working on the website to the the point where you can't recognize it as drupal. Even my chrome plugin can't recognize it. That means that it's been stripped down like crazy. So, my point is universalmusic is irrelevant. Anyone has better example of a website that can be manageable by one person? Thanks.

enzipher’s picture

enzipher commented

I agree. Drupal would handle your requirements. However, if you are not familiar with Drupal you may have some headache do look forward to trying to figuring out the logic of things. I would suggest you do a lot of research on modules that would fit, and how you can tie everything together. Sounds like you need some reference module at least to connect the Reviews with the reviewed content, probably Entity reference (http://drupal.org/project/entityreference). Check out drupalmodules.com for quick module look ups.

Cheers,

--

hook_world() is broken.

jerry1970’s picture

jerry1970 commented

The short time it takes for some people to reply here makes me very happy! :)

Thanks, this sounds very promising. I am a PHP programmer and analyst / architect and have experience reading other people's code. I no doubt will need some time to get into the logic of things, I realise that.

Thanks for the info!
Cheers

brutex’s picture

brutex commented

Another music online website with artists database likefm.org

Anthea21’s picture

Anthea21 commented

This is also what I'm looking for in terms of klingelton for everyone