2 Replies Latest reply on Nov 2, 2007 12:55 PM by S3Indiana

    Discussion Thread Rating

      I thought this functionality was available in ClearspaceX 1.5 but can't find it.  How can I do rating of threads and/or enable status levels for users?  Thanks.

        • Re: Discussion Thread Rating

          hi jcorsello,

           

          You should be able to see the status level settings by going to the Admin Console --> People --> Settings --> Status Level Settings.  There isn't a rating settings page in the admin console, but now that I think about it, I'm guessing that when you installed ClearspaceX the defaults for ClearspaceX didn't get installed.  The following SQL should have been run at setup:

           

          -- Starting XSpace specific section

           

          INSERT INTO jiveProfileField (fieldID, name, description, isRequired, isFilterable, isSearchable, isVisible, isEditable, fieldType, idx) VALUES (1, 'Location', NULL, 0, 1, 1, 1, 1, 9, 0);

          INSERT INTO jiveProfileField (fieldID, name, description, isRequired, isFilterable, isSearchable, isVisible, isEditable, fieldType, idx) VALUES (2, 'Occupation', NULL, 0, 1, 1, 1, 1, 9, 1);

          INSERT INTO jiveProfileField (fieldID, name, description, isRequired, isFilterable, isSearchable, isVisible, isEditable, fieldType, idx) VALUES (3, 'Biography', NULL, 0, 0, 1, 1, 1, 6, 2);

          INSERT INTO jiveProfileField (fieldID, name, description, isRequired, isFilterable, isSearchable, isVisible, isEditable, fieldType, idx) VALUES (4, 'Expertise', NULL, 0, 0, 1, 1, 1, 6, 3);

          INSERT INTO jiveProfileField (fieldID, name, description, isRequired, isFilterable, isSearchable, isVisible, isEditable, fieldType, idx) VALUES (5, 'Homepage', NULL, 0, 0, 0, 1, 1, 10, 4);

           

          -- Default Ratings

          INSERT INTO jiveRatingType (score, description) VALUES (1, 'Poor');

          INSERT INTO jiveRatingType (score, description) VALUES (2, 'Below Average');

          INSERT INTO jiveRatingType (score, description) VALUES (3, 'Average');

          INSERT INTO jiveRatingType (score, description) VALUES (4, 'Above Average');

          INSERT INTO jiveRatingType (score, description) VALUES (5, 'Exceptional');

           

          -- Registered users are allowed to rate documents and messages

          INSERT INTO jiveUserPerm (objectType, objectID, userID, permissionType, permission) VALUES (17, -1, 0, 1, 25);

          INSERT INTO jiveUserPerm (objectType, objectID, userID, permissionType, permission) VALUES (17, -1, 0, 1, 6);

           

          -- Registered users are allowed to create documents and comments

          INSERT INTO jiveUserPerm (objectType, objectID, userID, permissionType, permission) VALUES (17, -1, 0, 1, 18);

          INSERT INTO jiveUserPerm (objectType, objectID, userID, permissionType, permission) VALUES (17, -1, 0, 1, 20);

           

          -- Registered users are allowed to edit documents

          INSERT INTO jiveUserPerm (objectType, objectID, userID, permissionType, permission) VALUES (17, -1, 0, 1, 15);

           

          -- anonymous users are allowed to view documents and comments and blogs

          INSERT INTO jiveUserPerm (objectType, objectID, userID, permissionType, permission) VALUES (17, -1, -1, 1, 14);

          INSERT INTO jiveUserPerm (objectType, objectID, userID, permissionType, permission) VALUES (17, -1, -1, 1, 16);

          INSERT INTO jiveUserPerm (objectType, objectID, userID, permissionType, permission) VALUES (17, -1, -1, 1, 60);

           

          -- Registered users are allowed to create recommendations

          INSERT INTO jiveUserPerm (objectType, objectID, userID, permissionType, permission) VALUES (17, -1, 0, 1, 22);

           

          -- Anonymous users are allowed to view the online status of other users

          INSERT INTO jiveUserPerm (objectType, objectID, userID, permissionType, permission) VALUES (17, -1, -1, 1, 56);

           

          -- A few necessary properties

          -- default filters

           

          INSERT INTO jiveStatLvlScen (scenarioID, i18nKey, code, points, enabled)

                  VALUES (1, 'stslvl.scen.message_added.text', 'messageAdded', 1, 1);

          INSERT INTO jiveStatLvlScen (scenarioID, i18nKey, code, points, enabled)

                  VALUES (2, 'stslvl.scen.answered_qstns.text', 'correctAnswerAdded', 4, 1);

          INSERT INTO jiveStatLvlScen (scenarioID, i18nKey, code, points, enabled)

                  VALUES (3, 'stslvl.scen.helpfulRespons.text', 'helpfulAnswerAdded', 2, 1);

          INSERT INTO jiveStatLvlScen (scenarioID, i18nKey, code, points, enabled)

                  VALUES (4, 'stslvl.scen.wiki_doc_added.text', 'documentAdded', 4, 1);

          INSERT INTO jiveStatLvlScen (scenarioID, i18nKey, code, points, enabled)

                  VALUES (5, 'stslvl.scen.blogPostAdded.text', 'blogpostAdded', 3, 1);

           

          -- Enable Private Messages

          INSERT INTO jiveProperty (name, propValue) VALUES ('privateMessages.enabled', 'true');

           

          -- Enable blog pings

          INSERT INTO jiveProperty (name, propValue) VALUES ('blogs.pings.enabled', 'true');

           

          -- Disable view of email addresses by default on users

          INSERT INTO jiveProperty (name, propValue) VALUES ('db.user.defaultEmailVisible', 'false');

          INSERT INTO jiveProperty (name, propValue) VALUES ('ldap.user.defaultEmailVisible', 'false');

           

           

          but IIRC, we had some problems with 1.5 where the defaults didn't get properly inserted.

           

          Cheers,

           

          AJ

          • Re: Discussion Thread Rating

            Is the issue of document ratings resolved in ClearspaceX 1.6.0???

             

            Message was edited by: S3Indiana