none
Group Chat User Colors

    Question

  • I'm having trouble find a definite answer on User Colors within the OCS 2007 R2 Group Chat Client.

     

    I've installed the updates from KB 977338

    http://www.microsoft.com/downloads/details.aspx?familyid=E5924BF9-B042-4C53-B4A6-79C7E5C9749B&displaylang=en#filelist

    And following this excerpt from the New Features document to enable User Colors -

     

    You can choose to either display User Colors, or to display the default colors. If you disable User Colors, only the conversations in your client are affected.

    To turn user colors on or off

    1.   Open the Group Chat client.

    2.   On the Connect menu, click Preferences.

    3.   Click the User Colors tab, and select or clear the Display user colors check box.

    4.   Click OK.

     

    Would be fine except I have no User Colors Tab!

     

     

    I have installed all three updates for the Server, Admin Tool and Client and have rebooted (even through not necessary) the server and client.

    I also ran the Config tool on the server after running the update the upgrade the database schema and start the services. I restarted again after this step too.

    I have also seen this - http://support.microsoft.com/kb/974228 however playing with this Group Policy setting has had no effect either.

     

    Has anyone else managed to get this working?

    Can you post me a screen shot of this User Colors tab so I know where it should be?

     

    Wednesday, April 21, 2010 2:56 AM

Answers

  • Hi, Torquil ,any updates?

    On OCS 2007 R2 SQL Back End you have to run following SP:

    exec rtc.dbo.RtcRegisterCategoryDef 'userColors', false, 1024
    Best Regards!
    • Marked as answer by Ben-Shun Zhu Thursday, April 29, 2010 9:18 AM
    Monday, April 26, 2010 1:59 AM
  • Yup, got a fix from PSS which included that SQL comamand -

     

     

     

    1. Start the SQL Management Studio and connect to your OCS Back End server with the SQL admin account

    Note: If your OCS server is Standard version, then you can download and install the Microsoft SQL Server Management Studio Express first: 

    Microsoft SQL Server Management Studio Express http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

    2. Click New Query, and then run the following script, it will use store procedure RtcRegisterCategoryDef to add  custom presence category userColors (the store procedure and parameter are case sensitive):

    exec rtc.dbo.RtcRegisterCategoryDef 'userColors', false, 1024

    3. After running this script, we will be able to see the User Colors tab

     

     

    This also created an additional row in the rtc.dbo.CategroryDef table if anyone needs to confirm -

     

    CategoryID	Name				Private	QuotaTotalSize
    1		calendarData			False	64000
    2		contactCard			False	64000
    3		note				False	64000
    4		state				False	64000
    5		services			False	64000
    6		routing				True	64000
    7		legacyInterop			True	64000
    8		categoryPublicationManifest	True	64000
    9		alerts				False	64000
    10		conferenceProfileList		False	64000
    11		device				False	64000
    12		miscOptions			False	64000
    13		otherOptions			False	64000
    14		rccOptions			False	64000
    15		userInformation			False	64000
    16		userProperties			False	64000
    17		userColors			False	1024
    NULL		NULL				NULL	NULL

    Thanks to PSS for their help.


     

    • Marked as answer by Ben-Shun Zhu Thursday, April 29, 2010 9:18 AM
    Wednesday, April 28, 2010 12:58 AM

All replies

  • Hi, Torquil ,any updates?

    On OCS 2007 R2 SQL Back End you have to run following SP:

    exec rtc.dbo.RtcRegisterCategoryDef 'userColors', false, 1024
    Best Regards!
    • Marked as answer by Ben-Shun Zhu Thursday, April 29, 2010 9:18 AM
    Monday, April 26, 2010 1:59 AM
  • Yup, got a fix from PSS which included that SQL comamand -

     

     

     

    1. Start the SQL Management Studio and connect to your OCS Back End server with the SQL admin account

    Note: If your OCS server is Standard version, then you can download and install the Microsoft SQL Server Management Studio Express first: 

    Microsoft SQL Server Management Studio Express http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

    2. Click New Query, and then run the following script, it will use store procedure RtcRegisterCategoryDef to add  custom presence category userColors (the store procedure and parameter are case sensitive):

    exec rtc.dbo.RtcRegisterCategoryDef 'userColors', false, 1024

    3. After running this script, we will be able to see the User Colors tab

     

     

    This also created an additional row in the rtc.dbo.CategroryDef table if anyone needs to confirm -

     

    CategoryID	Name				Private	QuotaTotalSize
    1		calendarData			False	64000
    2		contactCard			False	64000
    3		note				False	64000
    4		state				False	64000
    5		services			False	64000
    6		routing				True	64000
    7		legacyInterop			True	64000
    8		categoryPublicationManifest	True	64000
    9		alerts				False	64000
    10		conferenceProfileList		False	64000
    11		device				False	64000
    12		miscOptions			False	64000
    13		otherOptions			False	64000
    14		rccOptions			False	64000
    15		userInformation			False	64000
    16		userProperties			False	64000
    17		userColors			False	1024
    NULL		NULL				NULL	NULL

    Thanks to PSS for their help.


     

    • Marked as answer by Ben-Shun Zhu Thursday, April 29, 2010 9:18 AM
    Wednesday, April 28, 2010 12:58 AM