shondalai.com Forum
Welcome, Guest
Recent activity
-
Maverick replied to the topic Total Reponses Figure (Number) Per Question.
July 27 at 3:03 am
If I count total number of votes for each answer in your first question then it shows the correct number. So I can't think of anything wrong in that. You can find and delete the response details which are not belong to the 18 responses given by the users with the following sqls. (please make sure only 18 rows in xxx_survey_responses table, otherwise what you are saying about "only 18 completed responses exist" goes somewhere wrong) Check if there are any rows: select * from xxx_survey_response_details where response_id not in (select id from xxx_survey_responses where survey_id = YOURSURVEYID) If any, delete them as these are somehow not deleted when you deleted responses (if any): delete from xxx_survey_response_details where response_id not in (select id from xxx_survey_responses where survey_id = YOURSURVEYID) Do this if you have only one survey as I have not added check for multiple surveys above. -
Robert Stones replied to the topic Total Reponses Figure (Number) Per Question.
July 26 at 6:55 pm
Maverick wrote: Ahh, ok got you what you are saying. Sorry for the misunderstanding. So you are asking for the number that you see below each question. Sorry abou the confusion. Thats a language error. it should read "Total votes" or "Total answers" instead of "Total responses" because it is the total number of answers given on that question. And since multiple choice questions have multiple answers selectable, the count will vary. So what the component displays is correct except the misleading language string. "Total Responses" is something applicable on entire report as the number of responses will not vary on question to question basis. To avoid confusion change the language string itself instead of changing any other code (languages/en-GB/en-GB.com_communitysurveys.ini). LBL_TOTAL_RESPONSES="Total responses" Mav, Thanks for the language string change, much appreciated and I will do that shortly. However, I still think we're not fully understanding each other, so I will try and explain with just the very first question in my survey. If you go to: Survey Results and you will see the very first question is about "How many persons does your Organisation employ?" As it says, there are 30 results - however the language labels it, there's still 30 in the system according to that. Then if you look at the pie chart result directly to the right hand side and hover over the various sections of the 'Pie', these also total 30. However, and this is the critical part one this first question for example in my survey doesn't have multiple choices that you allude to in your last reply, so why would it not say 18 responses and instead is saying 30. I can't having it saying 30 on the finished consolidated results, as current for e.g. I only have 18 and hence the pie charts have to correlate - be factful etc. I have cleaned various areas of the component backend, database as I've spoken about in previous posts above but something somewhere it STILL logging there been more actual true results than there should be... I only have 18 confirmed respondents and NONE pending. Regards, -
Maverick replied to the topic Total Reponses Figure (Number) Per Question.
July 26 at 6:26 pm
Ahh, ok got you what you are saying. Sorry for the misunderstanding. So you are asking for the number that you see below each question. Sorry abou the confusion. Thats a language error. it should read "Total votes" or "Total answers" instead of "Total responses" because it is the total number of answers given on that question. And since multiple choice questions have multiple answers selectable, the count will vary. So what the component displays is correct except the misleading language string. "Total Responses" is something applicable on entire report as the number of responses will not vary on question to question basis. To avoid confusion change the language string itself instead of changing any other code (languages/en-GB/en-GB.com_communitysurveys.ini). LBL_TOTAL_RESPONSES="Total responses" -
Robert Stones replied to the topic Total Reponses Figure (Number) Per Question.
July 26 at 5:20 pm
Maverick wrote: Pending responses can be viewed from the "View All Responses" link in your reports dashboard page. These are the responses users started entering but have not yet completed. You can see the status icon on that page. There is one possible solution to show only completed responses results in consolidated report by modifying code. But I feel its good to include everything. Users are already gave answers but some or the other reasons they forgot clicking finish button. So I believe it should include all. Hi Mav, Thanks for the reply. I have looked there and it has 18, again that's what I want in that sense but I CANNOT have the varying 'total responses' which you say include those who people haven't completed (more than likely when I was testing submissions before putting the survey fully live to respondents) as this will completely skew my academic dissertation report, of which I plan to utilise the 'Consolidated Report' to form the full bulk of my survey results. In the consolidated results page - the 'Total Responses' per question which is what's bugging me at present as for me it's the wrong figure I need, they do seem to correlate to the pie charts % and number of responses. Therefore, can you work with me please to carry out said hack to show 'Only completed responses in the consolidated report', it would be very much appreciated, as I'm 24 hours away from being able to start the survey results write-up, yet academically the figures are not currently tallying, which is why I'm seemingly being picky. I can provide you with temporary phpmyadmin access should it be required, I will make a full site and database backup prior to this, just in case there's a need to roll back. If it wasn't for my dissertation, I wouldn't mind but it has to be as right as possible in this instance? I look forward to hearing from you. Regards, -
Maverick replied to the topic Total Reponses Figure (Number) Per Question.
July 26 at 5:03 pm
Pending responses can be viewed from the "View All Responses" link in your reports dashboard page. These are the responses users started entering but have not yet completed. You can see the status icon on that page. There is one possible solution to show only completed responses results in consolidated report by modifying code. But I feel its good to include everything. Users are already gave answers but some or the other reasons they forgot clicking finish button. So I believe it should include all. -
Maverick replied to the topic Categories Not Displaying on Questions Layout Page.
July 26 at 4:59 pm
If the value is "Inherited" and the status shows "Allowed", that means the category should be allowed to show. It is pretty weired why it is not shown as Joomla permissions shown will work fine as is. I cannot understand the logic of explicitely making them allowed when global permissions are already allowing it. So the last guess, since there is no way I can see your site, is the categories may have not properly inherited the settings. The only possible situation for this is the categories are created before the component options are configured. In this case edit and save the category (even without doing any changes) will solve the issue. Can you try this? -
Mv93Z2mm3j4EoQ replied to the topic Categories Not Displaying on Questions Layout Page.
July 26 at 4:30 pm
Hi,I have one menu item: Questions Layout. I created three categories. The only thing I changed in each category was the name and description. All other items are set to their default values. The access level for each category is "public" by default. All settings on the permissions tab are set to their default values, which means that the public permission for "view question" is set to "inherited." The language of the category is set to "All." All of the settings described above match those of the menu item. Finally, Community Answers had been installed on a fresh install of Joomla.Everything is set to default, and the category settings match the menu item settings, which are also set to default. For the menu item, all I did was select "Questions Layout" as the menu type, gave it a name, and clicked "Save."Against this backdrop, I found a simple solution to the problem:SOLUTION: In order to view the category name in Questions Layouts view, I had to change the category's public permission for "view question" from "inherited" (the default value) to "allowed."I just don't understand why. It seems illogical that the question itself can be viewed by the public irrespective of whether this setting is set to "inherited" or "allowed", but the category name can only be viewed in Questions Layout view if the public permission for "view question" is set to "allowed." My knowledge of Joomla permission settings is limited. Perhaps someone with a deeper understanding of the way permissions work can make sense of this. -
Robert Stones replied to the topic Total Reponses Figure (Number) Per Question.
July 26 at 2:17 pm
Maverick wrote: There are two things you need to consider. 1. Completed responses2. Pending responses The count shown in your screenshot is total responses as there is no way to separate completed to the pending responses. But you can check status of each response in responses list page on the reports section. So I guess you can easily find where these extra responses came from. Mav, How can I located the 'Pending'responses you speak of then please? If you look at the new screenshot, all 18 of my expected responses that I ONLY want showing in the pie charts etc in the consolidated results, you will note that ALL 18 are ticked as 'Completed' and not pending? Regards, -
Maverick replied to the topic Total Reponses Figure (Number) Per Question.
July 26 at 1:50 pm
There are two things you need to consider. 1. Completed responses2. Pending responses The count shown in your screenshot is total responses as there is no way to separate completed to the pending responses. But you can check status of each response in responses list page on the reports section. So I guess you can easily find where these extra responses came from. -
Maverick replied to the topic Categories Not Displaying on Questions Layout Page.
July 26 at 1:46 pm
Can you please post screenshots of one of your catrgory edit page? Check the access level view question permission on your individual categories language of the category All these should match your menu item. Also if you have "Category" menu items, make sure you have set max level option of the menu item greater than 0. -
Robert Stones replied to the topic Total Reponses Figure (Number) Per Question.
July 26 at 10:44 am
Maverick wrote: If there is only one survey and you want to reset survey, just truncate that table and responses. If you want to know if there are any records exists for questions not in your survey and delete them using below sql. delete from xxx_survey_response_details where question_id not in (select id from xxx_survey_questions where survey_id = YOURSURVEYID) Hi Maverick, There is only one survey, although I do have a copy I keep and if the survey was ever updated in anyway, I delete the copy and make a fresh copy. I don't want to "Reset" the survey as that leads me to believe it will reset everything back to zero and I'd lose the 18 responses I actually need from tomorrow? I simply want to locate the orphan 'Total Responses' number which doesn't correlate properly as with every other area of the extension, since I did the above tweaks I did yesterday. Weirdly the very LAST 3 questions have the correct total responses figure of 18, as I know that I have 18 true survey submission responses. So it starts off at 30 for a few questions and then as the survey questions carry on through the survey, the total responses figure lessens till the last 3 end up with 18. You also mention in your above reply "If you want to know if there are any records exists for questions not in your survey and delete them using below sql." I'm pretty sure the remaining erroenous total response figures which are above the expected 18, are my previous test responses before I put the survey truly live for people to take and hence won't be about questions "not in my survey"? I look foward to hearing from you. Regards, -
Mv93Z2mm3j4EoQ replied to the topic Categories Not Displaying on Questions Layout Page.
July 26 at 7:39 am
UPDATE: I logged in the front end as the super administrator and was able to view the categories. Therefore, this would seem to be a permissions issue. I guess what's confusing to me is why the permissions by default would be such that a guest could view a question but not its category. TWO QUESTIONS: 1. Why would a guest be able to view a question (both listed at the bottom of Questions Layout view and when the user clicks on and views the individual question), but not be able to see the categories listed in the Questions Layout view? 2. How do I fix this so that guests can see the category names in Questions Layout view? Thank you. -
Mv93Z2mm3j4EoQ replied to the topic Categories Not Displaying on Questions Layout Page.
July 26 at 6:37 am
I echoed the following: $layout = default $category = JCategoryNode $params = {"question_layout":"_:default","theme":"default","question_avatar_size":"40","replies_ordering":"a.created","replies_ordering_dir":"asc","replies_limit":"5","show_title":"1","link_titles":"1","show_intro":"1","info_block_position":"0","show_category":"1","link_category":"1","show_author":"1","show_create_date":"1","show_tags":"1","social_sharing":"1","hide_category":"0","show_publishing_options":"1","show_question_options":"1","save_history":"0","history_limit":10,"category_layout":"_:default","show_category_heading_title_text":"1","show_category_title":"1","show_description":"1","show_description_image":"1","show_subcategory_content":"0","maxLevel":"-1","show_empty_categories":"0","show_no_questions":"1","show_subcat_desc":"1","show_cat_num_questions":"1","show_base_description":"1","maxLevelcat":"-1","show_empty_categories_cat":"0","show_subcat_desc_cat":"1","show_cat_num_questions_cat":"1","show_categories_footer":"1","list_avatar_size":"40","list_show_date":"created","date_format":"","show_pagination_limit":"1","list_show_reply_date":"1","list_show_reply_callout":"1","list_show_hits":"1","list_show_parent":"0","list_show_author":"1","default_editor":"tinymce","orderby_pri":"none","orderby_sec":"rdate","order_date":"published","list_show_ask_form":"1","show_pagination":"2","show_pagination_results":"1","show_category_list":"1","load_bootstrap_css":"1","layout":"default","show_feed_link":"1","feed_summary":"0","feed_show_readmore":"0","subscribe_status":"1","enable_bounties":"1","user_display_name":"name","profile_component":"none","avatar_component":"gravatar","points_component":"none","stream_component":"none","show_page_heading":null,"menu_text":1,"secure":0,"page_title":"Questions","page_description":null,"page_rights":null,"robots":null,"page_heading":"Questions","show_parent":false} -
Mv93Z2mm3j4EoQ replied to the topic Categories Not Displaying on Questions Layout Page.
July 26 at 6:31 am
I echoed a few more variables that appear in line 58 of the file described above. Here they are: I echoed the following:$layout = default$category = JCategoryNode$params = {"question_layout":"_:default","theme":"default","question_avatar_size":"40","replies_ordering":"a.created","replies_ordering_dir":"asc","replies_limit":"5","show_title":"1","link_titles":"1","show_intro":"1","info_block_position":"0","show_category":"1","link_category":"1","show_author":"1","show_create_date":"1","show_tags":"1","social_sharing":"1","hide_category":"0","show_publishing_options":"1","show_question_options":"1","save_history":"0","history_limit":10,"category_layout":"_:default","show_category_heading_title_text":"1","show_category_title":"1","show_description":"1","show_description_image":"1","show_subcategory_content":"0","maxLevel":"-1","show_empty_categories":"0","show_no_questions":"1","show_subcat_desc":"1","show_cat_num_questions":"1","show_base_description":"1","maxLevelcat":"-1","show_empty_categories_cat":"0","show_subcat_desc_cat":"1","show_cat_num_questions_cat":"1","show_categories_footer":"1","list_avatar_size":"40","list_show_date":"created","date_format":"","show_pagination_limit":"1","list_show_reply_date":"1","list_show_reply_callout":"1","list_show_hits":"1","list_show_parent":"0","list_show_author":"1","default_editor":"tinymce","orderby_pri":"none","orderby_sec":"rdate","order_date":"published","list_show_ask_form":"1","show_pagination":"2","show_pagination_results":"1","show_category_list":"1","load_bootstrap_css":"1","layout":"default","show_feed_link":"1","feed_summary":"0","feed_show_readmore":"0","subscribe_status":"1","enable_bounties":"1","user_display_name":"name","profile_component":"none","avatar_component":"gravatar","points_component":"none","stream_component":"none","show_page_heading":null,"menu_text":1,"secure":0,"page_title":"Questions","page_description":null,"page_rights":null,"robots":null,"page_heading":"Questions","show_parent":false} -
Mv93Z2mm3j4EoQ replied to the topic Categories Not Displaying on Questions Layout Page.
July 26 at 6:11 am
I'm trying to figure this out right now. Here's an update: When I open com_communityanswers/views/questions/tmpl/default.php and replace: echo JLayoutHelper::render($layout.'.category_list', array('category'=>$category, 'params'=>$params, 'maxlevel'=>1), '', array('debug' => false)); with echo 'hello world'; the phrase 'hello world' echoes out correctly. -
Mv93Z2mm3j4EoQ replied to the topic Categories Not Displaying on Questions Layout Page.
July 26 at 6:01 am
Hi, Thanks for the reply. I just double checked the menu type and "Show Category List" setting, and both are set up correctly: The menu type is "Questions Layout" and "Show Category List" is enabled, but the categories still do not appear. Thank you -
Maverick replied to the topic Categories Not Displaying on Questions Layout Page.
July 26 at 5:07 am
Make sure the following: 1. The menu item type you created is "Questions Layout" (for same as the one on demo).2. Option "Show Category List" is enabled under Shared Options tab of Community Answers Options. -
Maverick replied to the topic Total Reponses Figure (Number) Per Question.
July 26 at 5:01 am
If you want to reset survey, just truncate that table. If you want to know if there are any records exists for questions not in your survey and delete them using below sql. delete from xxx_survey_response_details where question_id not in (select id from xxx_survey_questions where survey_id = YOURSURVEYID) -
Consolidated Analytics created new topic Categories Not Displaying in Root.
July 26 at 2:24 am
Hi, I'm sure I'm missing something easy here, but the categories are not displaying on the Questions Layout home page. I just installed Community Answers a little while ago, added three categories, added a few sample questions, and created a link in my main menu to the Questions Layout page. In the demo there are categories listed above the textfield where the user is supposed to ask a question. On my site, however, the three categories that I created do not display. Below this area I can see the sample questions, but the categories above do not appear. I have tried going through the configuration options, but I can't seem to figure out which switch controls the display of the categories. I simply want the categories to display the way they do in the demo. Important Info: 1. I'm testing locally (localhost) so I do not have a site to look at. 2. I just installed the component a few hours ago. All of the permissions and configuration settings (other than bootstrap, which I had to enable manually) are set to there default values. Thank you! -
Robert Stones replied to the topic Total Reponses Figure (Number) Per Question.
July 25 at 5:02 pm
Mav, With regards to the survey_response_details table, I have 30 entries - which I know includes some orphans, as again there should only be currently 18 to match the actual response figure I know is correct, as I've been following them via email notifications when a new one comes in and keeping a record etc. How do I delete the relevant one's from survey_response_details, as I cannot see - unlike in the survey_response table that I utilised in the previous reply, any form of ability to check a select box and delete the particular records I need to, which would then again leave the correct 18? Regards,
Powered by CjForum