SPECIAL OFFER: Only $69 for access to everything in OSTraining for 1 year! You save $75!  1
Join today and get access to 1,000's of books and videos. Learn WordPress, Drupal, Magento, Joomla and more! Sign up today!

Sophisticated Rating system

4 years 8 months ago #120353 by osbenji
Sophisticated Rating system was created by osbenji
Hi,

I need to build a somewhat sophisticated Rating system and i would need help in determining the best approach and modules to accomplish this. I explain here below the rating system i need, and i really appreciate any advice, construction guidelines, or modules i could use to accomplish this. Thank you so very much!

A. The Rating system:
- 8 industries
- 5 companies (per industry and different for each industry)
- 3 rating criterias: Quality, Innovation, Design
So the user is to choose a industry, then choose a company within than industry, and then perform 3 different ratings (Fivestar) on that company.

B. As for the layout, the simplest would be to have
- a drop-down field (for selecting the industry)
- a drop-down field (for selecting the company. given that each industry has different companies, this field refreshes based on the industry)
- 3 fivestar rating widgets

C. This rating tool should be available in 4 different languages.

D. The data of the rating system is to be stored in a spreadsheet which has the following structure:
- Column 1: Industry
- Column 2: Company
- Column 3: quality-rating result
- Column 4: innovation-rating result
- Column 5: design-rating result
- Column 6: total result (average of column 3, 4, 5)
- Column 7: user name (of the authentified user than did the rating)
- Column 8: user country (of the authentified user than did the rating)
Finally, i would need this data to be exportable to an excel file.

Thank you very much for your help!

Benjamin

Please Log in to join the conversation.

4 years 8 months ago #120382 by steve
Replied by steve on topic Sophisticated Rating system
Hi and welcome, osbenji. We're delighted to have you with us at OSTraining.

Parts A and B seem straightforward using Drupal field. It seems as if you've also identified the best module for this: Fivestar.

Things get trickier beyond that. Multi-lingual sites were **really** hard in Drupal 7, but substantially easier in Drupal 8: www.ostraining.com/blog/drupal/d8-multi-lingual/ The downside is that Drupal 8 has only just been released.

Part D ... can you explain more about this. By "spreadsheet", do you mean an online matrix where users can see the ratings? If so, how experienced are you with the Views module?

Please Log in to join the conversation.

4 years 8 months ago #120416 by osbenji
Replied by osbenji on topic Sophisticated Rating system
Hi Steve,

Thanks for your message.

Yes, basically the output needs to go into a matrix, but this matrix i need to be able to export it to a excel file.
So if i create a content type with the fields:
- industry (for example: term reference)
- company (for example: text)
- Quality (for example: fivestar widget)
- Innovation (for example: fivestar widget)
- Design (for example: fivestar widget)
i would also need the fields:
- average result (a calculation of the average of Quality - Innovation - Design)
- name (the username of the authentified user which rated this company)
- country (the country of the authentified user which rated this company)
This is the data for the matrix (spreadsheet).

Yes. i'am familiar with the Views module.
Basically my current solution is to create 8 tabs (quick tabs) corresponding to each industry, and have a grid view of the companies (content type company) in a way to displays for each company: name and the 3 fivestar rating widgets.
I guess my question is
How can i get those last 3 fields (average, username, country) into my matrix when the user performs the rating (3 ratings) of a company?

Thank you!!

B.

Please Log in to join the conversation.

4 years 8 months ago #120480 by steve
Replied by steve on topic Sophisticated Rating system
Hi osbenji

Views can do that for you. It has an export option so you can send the data to an Excel file: www.drupal.org/project/views_data_export

When it comes to add the 3 fields, you should be able to add them as 3 individual fields. Or am I missing something more complex in your data structure?
The following user(s) said Thank You: osbenji

Please Log in to join the conversation.

Join today and get access to 1,000's of books and videos. Learn WordPress, Drupal, Magento, Joomla and more! Sign up today!